jilinjames
Active member
my MySQL Query Limit 150,000 and traffic very low daily under 5000 any solution for this because every day 5 more time website down please help
hi guys iam facing MySQL Query Limit Exceeded any solution
- Thread starter jilinjames
- Start date
-
Welcome to Original Babiato! All Resource are Free and No downloading Limit.. Join Our Official Telegram Channel For updates Bypass All the resource restrictions/Password/Key? Read here! Read Before submitting Resource Read here! Support Our Work By Donating Click here!
- Dec 1, 2018
- 24,049
- 27,329
- 120
jilinjames
Active member
jilinjames
Active member
madroots
Active member
- Jan 23, 2020
- 215
- 127
- 43
Hosting provider might limit SQL queries, but its usually really enough for anyone.
You dont need another hosting provider. You need to optimize SQL load.
jilinjames
Active member
jilinjames
Active member
- Dec 1, 2018
- 24,049
- 27,329
- 120
madroots
Active member
- Jan 23, 2020
- 215
- 127
- 43
There are methods to count queries on single load. There are acceptable values and unacceptable values.
There is a way to reduce queries brutally.
I assume you are running wordpress.
You need following:
1. https://querymonitor.com/ - plugin, for monitoring queries.
-You need to know what plugins are causing overloading. You will also find out whether overloading is happening at all.
2. Plugin will add monitor panel on top of your wordpress admin/website page when logged in, so you can see what plugins are causing this and what plugins to get rid of!
3. https://wordpress.org/plugins/memcached-is-your-friend/ - plugin to reduce sql queries by caching them.
-Memcache is awesome caching system used by large companies such as google and facebook to reduce, merge sql queries. Must have. This is plugin for wordpress. Just install and you should see much less queries on second load.
Both plugins are free
There is a way to reduce queries brutally.
I assume you are running wordpress.
You need following:
1. https://querymonitor.com/ - plugin, for monitoring queries.
-You need to know what plugins are causing overloading. You will also find out whether overloading is happening at all.
2. Plugin will add monitor panel on top of your wordpress admin/website page when logged in, so you can see what plugins are causing this and what plugins to get rid of!
3. https://wordpress.org/plugins/memcached-is-your-friend/ - plugin to reduce sql queries by caching them.
-Memcache is awesome caching system used by large companies such as google and facebook to reduce, merge sql queries. Must have. This is plugin for wordpress. Just install and you should see much less queries on second load.
Both plugins are free
- Dec 1, 2018
- 24,049
- 27,329
- 120
Good advice but given the nature of his site I wouldn't say 30 queries per visitor per day is highly excessive.
madroots
Active member
- Jan 23, 2020
- 215
- 127
- 43
It must be much more then 30 per day. SQL limit are set for an hour-not for a day. They limit SQL queries per hour!
He should optimize queries thats for sure.
- Dec 1, 2018
- 24,049
- 27,329
- 120
jilinjames
Active member
iam facing this issue starts april bro i monitor using querie monitor but not exceeding, now install the Memcached plugin
madroots
Active member
- Jan 23, 2020
- 215
- 127
- 43
I hope it will help you reduce some queries. If still issue, let us know in comments
jilinjames
Active member
Maybe these.
Theme Name:
Publisher
Theme Homepage:
http://betterstudio.com/
Plugin:
WP Rocket
WP Disable
Onesignal Free Web Push Notifications
Deblocker
modman9
Active member
- May 7, 2020
- 108
- 112
- 43
Is it a vps server with openlitespeed installed?(then other method)
If not kindly check your php configuration, .htaccess file /php.ini file ,then look for
max_input_vars = xxxx; <INSIDE php.ini file
php_value max_input_vars xxxx < INSIDE .htaccess file
change xxxx to your desired value = or > 5000 (default)
save apply clear cache and check, if not solve you can try to increase the value more and then check, though i would recommend to use any plugin like wordfence,cerber to check the GET/POST requests in the traffic if something is malacious.
If not kindly check your php configuration, .htaccess file /php.ini file ,then look for
max_input_vars = xxxx; <INSIDE php.ini file
php_value max_input_vars xxxx < INSIDE .htaccess file
change xxxx to your desired value = or > 5000 (default)
save apply clear cache and check, if not solve you can try to increase the value more and then check, though i would recommend to use any plugin like wordfence,cerber to check the GET/POST requests in the traffic if something is malacious.
Similar threads
