titanas
Member
Posted 7 years ago #
How can i implement (if possible) a second DB user into the script so i can avoid the: User xxx has exceeded the 'max_questions' resource (current value: 50000) error? My hosting company can't change the limit.
After exceeding the limit and waiting for an hour for the reset, wordpress is unable to recongnise the DB again.
Anything here help?
http://wordpress.org/support/topic/39167
Or create another wp-config.php file with the 2nd and 3rd user though not to sure how to implement that.
titanas
Member
Posted 7 years ago #
nah.. i've already reduced the number of posts in the first page.. but i don't know how to select half quries from one and half from the other user and put them all together.
Other ideas:
1. Contact host and have them increase limit.
2. Get a new host.
3. Deactivate plugins that might be database hogs.
4. Create several database users then modify wp-dp.php and use a random choice of users to execute the mysql_connect (yeah I know easier said than done!).