Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Through testing of our server, I have come to the conclusion that our server is somehow limiting usage per user to MySQL.

When I run mysqltuner.pl, the script pegs one of the processors for several minutes at a time. While this script is running (from Account X), Account X slows to a crawl. Requests to X's web assets are extremely slow. However, requests to other accounts' web assets (i.e. Accounts Y and Z) run quickly and mostly without delay.

Is it possible that there are some limiting mechanisms in place that are enforced via MySQL, CPanel, or some third-party tool?

share|improve this question

closed as off-topic by HopelessN00b, Ward, kasperd, Jenny D, RobM Feb 22 at 15:40

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

In MySQL, you can limit individual user accounts by:

  • Number of queries per hour
  • Number of updates per hour
  • Number of new connections per hour
  • Number of simultaneous connections

Given your description, it seems most likely it's #4 that's giving you trouble. Some long running query is blocking part of your connection pool.

Try this out:

 SELECT max_connections
 FROM mysql.user
 WHERE user = 'Account X';

MySQL's documentation on per user account limits is here.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.