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
-
You MUST read the Babiato Rules before making your first post otherwise you may get permanent warning points or a permanent Ban.
Our resources on Babiato Forum are CLEAN and SAFE. So you can use them for development and testing purposes. If your are on Windows and have an antivirus that alerts you about a possible infection: Know it's a false positive because all scripts are double checked by our experts. We advise you to add Babiato to trusted sites/sources or disable your antivirus momentarily while downloading a resource. "Enjoy your presence on Babiato"
hi guys iam facing MySQL Query Limit Exceeded any solution
- Thread starter jilinjames
- Start date
Medw1311
Purple People Eater
Staff member
Administrator
Moderator
Babiato Lover
Trusted Seller
Trusted Uploader
- Jul 24, 2019
- 11,465
- 25,406
- 120
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.
Medw1311
Purple People Eater
Staff member
Administrator
Moderator
Babiato Lover
Trusted Seller
Trusted Uploader
- Jul 24, 2019
- 11,465
- 25,406
- 120
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
Medw1311
Purple People Eater
Staff member
Administrator
Moderator
Babiato Lover
Trusted Seller
Trusted Uploader
- Jul 24, 2019
- 11,465
- 25,406
- 120
Good advice but given the nature of his site I wouldn't say 30 queries per visitor per day is highly excessive.
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.
Medw1311
Purple People Eater
Staff member
Administrator
Moderator
Babiato Lover
Trusted Seller
Trusted Uploader
- Jul 24, 2019
- 11,465
- 25,406
- 120
iam facing this issue starts april bro i monitor using querie monitor but not exceeding, now install the Memcached plugin
I hope it will help you reduce some queries. If still issue, let us know in comments
Maybe these.
Theme Name:
Publisher
Theme Homepage:
http://betterstudio.com/
Plugin:
WP Rocket
WP Disable
Onesignal Free Web Push Notifications
Deblocker
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
