Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

2 Answers

http://dev.mysql.com/doc/refman/5.1/en/show-processlist.html

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

share|improve this answer
add comment

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:

max_connections=1000
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
add comment

Your Answer

 
discard

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.