Support » Fixing WordPress » Create 2nd user to avoid MySql “max_questions”

  • 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.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Anything here help?

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

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Create 2nd user to avoid MySql “max_questions”’ is closed to new replies.