Create 2nd user to avoid MySql "max_questions" (4 posts)

  1. titanas
    Posted 9 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.

  2. MichaelH
    Posted 9 years ago #

    Anything here help?


    Or create another wp-config.php file with the 2nd and 3rd user though not to sure how to implement that.

  3. titanas
    Posted 9 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.

  4. MichaelH
    Posted 9 years ago #

    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!).

Topic Closed

This topic has been closed to new replies.

About this Topic