WordPress: ‘exceeded max_questions’ Database Error Solution | Array

WordpressThis solution does work however, your ISP database managers don’t want you to know it!
(your welcome, by the way)

Why is that?
- They like to keep you at your limit (usually 75K Queries per hour, or worse 50K)
- They’ll charge you $ if you want to increase that to 150K (per month for that matter)
- This solution actually gives you the equivalent of 225K per hour (that is a shit load!)
and best of all, YOUR IN CONTROL

What is this exactly?
Good Question, it is a way to swap user logins when you exceed the 75K queries (automatically behind the scenes – set it and forget it), thus enabling your site to keep functioning rather than getting that nasty error codes (500, or ‘exceeded max_questions’ or database can not connect) when you’ve used too man database resources. It is called a 3 User Array (for inquiring minds)

How does it work?
Instead of the default of 1 login (in your config.php file), it can choose between 3 (or more if you’d like)

Will it get me in trouble?
Not sure, but so far so good!

What should I be aware of?
All 3 database logins must use the same password, or it won’t work

How do I start?
- Log into your SQL Database menu located usually in your account on your ISP
- Create 2 more logins using the same password first!
- write each down, the login names and the 1 password

IMPORTANT!!
Please make a backup copy of your config.php file first – just in case – for some reason it doesn’t work or the server has some sort of restriction…….do it now!
____________________

Notes:
Please note: that the script was pulled from advisor code sites after a rather extensive search. I did try 4 variations that were reported, but this version was the only working one (that truly worked). Do not email me on coding advice as I would be able to help you on this one.

The portion that says “DB_USER“, may be listed differently in your WordPress config.php file, if so then use their term

__________________________

OK get started!

1- open your config.php file and edit in text editor

2- Scroll down to the spot that says:

define(‘DB_NAME’, ‘yourdatabasename’);

3- now paste in this right below it so it looks like this: (should also be right “above” the “define(‘DB_PASSWORD’,” code)

define(‘DB_NAME’, ‘yourdatabasename’);

/** MySQL database username */
//Add as many users as you like
$database_user_array[] = “username 1 goes here”;
$database_user_array[] = “username 2 goes here”;
$database_user_array[] = “username 3 goes here”;

$database_user = $database_user_array[ rand( 0, ( sizeof($database_user_array) -1 ) ) ];

define(‘DB_USER’, $database_user);

 

4- Make sure you of course swapped out the parts that say:

yourdatabasename
username 1 goes here
username 2 goes here
username 3 goes here

with the correct names from your database details

5- SAVE and RE-upload to root

That’s it – now test and enjoy your freedom!

FINAL NOTE:
Please note- you should still take actions to keep your site manageable and optimized to prevent ever getting past your limit. In the end, its a solution to a faster site

Related Posts Plugin for WordPress, Blogger...

About Michael Bohatch - SimpleInbound

Michael Bohatch has been involved with SEO and Inbound Marketing since its inception. Michael provides professional services that combine his experience in Web Analytics, SEM, SEO and Inbound Marketing for a comprehensive strategic approach to web optimization. SimpleInbound.com is an advice blog where he documents some of his findings and advises others on industry updates.
This entry was posted in Technical Aids, Wordpress and tagged , , , , , , . Bookmark the permalink.
If you would like to stay current on our Inbound Marketing Techniques, make sure to:
Subscribe to the RSS Feed!

One Response to WordPress: ‘exceeded max_questions’ Database Error Solution | Array

  1. That resolved our issue, thanks for the tip!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>