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

I got a big problem, I guess it's something like a dos attack but I am not sure.

Since this morning, my database is very slow and gives me 7/10 times a too many connections error or tries to login with www-data user (as following up of the too many connections error?).

I tried to locate the issue by mysql command line with 'show fullprocess list' but it gives me just one response back and that 'me'.

What can I do about this? The websites are still running ok, but mysql is overused I guess.

share|improve this question

...If you have the PROCESS privilege, you can see all threads. Otherwise, you can see only your own threads...

share|improve this answer

Could be that you just need to increase the max_connections in my.cnf(usually located at /etc/my.cnf or /etc/mysql/my.cnf) then restart your mysql server, you could try the next value for a start:

share|improve this answer
What is a normal connection limit for mysql? it's for 100 now. I optimized some queries which did already a great job – user968898 Jun 21 '12 at 9:28
The default is 100 but it might need to be increased on some of the servers, this is a normal practice. – Logic Wreck Jun 21 '12 at 10:24

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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