Quoting [EMAIL PROTECTED]:
hello
I have a box with CentOS 4 kernel 2.6.9-11 with vpopmail 5.4.9 courier-imap
4.0.2 with courier-authlib 0.55 and mysql 4.1.7
A few days ago, I have a very messages like this in my errors logs:
vmysql: error creating table 'limits': MySQL server has gone away, referer:
http://admin.mario.com.sv/cgi-bin/qmailadmin/com/addlistusernow
And the same time my load cpu usage is like this:
top - 11:35:14 up 1:00, 1 user, load average: 124.26, 93.93, 49.86
Tasks: 612 total, 46 running, 566 sleeping, 0 stopped, 0 zombie
Cpu(s): 16.0% us, 83.3% sy, 0.0% ni, 0.3% id, 0.2% wa, 0.0% hi, 0.2% si
Mem: 2075016k total, 1421640k used, 653376k free, 322820k buffers
Swap: 4192924k total, 0k used, 4192924k free, 213040k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3882 vpopmail 19 0 4136 1004 732 R 13.1 0.0 0:01.69 vdelivermail
4157 vpopmail 19 0 4616 1004 732 R 10.8 0.0 0:01.52 vdelivermail
4866 vpopmail 18 0 3768 1004 732 D 9.5 0.0 0:00.29 vdelivermail
4777 vpopmail 18 0 4240 1004 732 D 9.2 0.0 0:00.28 vdelivermail
4800 vpopmail 18 0 3968 1020 740 D 9.2 0.0 0:00.28 vdelivermail
4829 vpopmail 18 0 3748 1020 740 D 9.2 0.0 0:00.28 vdelivermail
4847 vpopmail 18 0 3372 1016 740 D 9.2 0.0 0:00.28 vdelivermail
4861 vpopmail 18 0 5088 1004 732 D 9.2 0.0 0:00.28 vdelivermail
4874 vpopmail 18 0 4588 1004 732 D 9.2 0.0 0:00.28 vdelivermail
4876 vpopmail 18 0 4776 1004 732 D 9.2 0.0 0:00.28 vdelivermail
4877 vpopmail 18 0 4752 1004 732 D 9.2 0.0 0:00.28 vdelivermail
5022 vpopmail 18 0 3404 1020 740 D 9.2 0.0 0:00.28 vdelivermail
5043 vpopmail 18 0 4004 1004 732 D 9.2 0.0 0:00.28 vdelivermail
4746 vpopmail 18 0 3392 1004 732 D 8.9 0.0 0:00.27 vdelivermail
4797 vpopmail 18 0 3892 1016 740 D 8.9 0.0 0:00.27 vdelivermail
4819 vpopmail 18 0 4912 1004 732 D 8.9 0.0 0:00.27 vdelivermail
4839 vpopmail 18 0 3992 1004 732 D 8.9 0.0 0:00.27 vdelivermail
3657 vpopmail 18 0 4636 1020 740 D 8.2 0.0 0:01.74 vdelivermail
5042 vpopmail 18 0 3960 1004 732 R 7.9 0.0 0:00.24 vdelivermail
3609 vpopmail 18 0 4180 1020 740 D 6.9 0.0 0:01.81 vdelivermail
3364 vpopmail 18 0 3760 1004 732 D 6.6 0.0 0:01.80 vdelivermail
3487 vpopmail 24 0 3808 1004 732 R 6.6 0.0 0:01.71 vdelivermail
3665 vpopmail 18 0 3652 1020 740 D 6.6 0.0 0:01.79 vdelivermail
3715 vpopmail 18 0 4580 1020 740 R 6.6 0.0 0:01.70 vdelivermail
4490 vpopmail 19 0 4688 1004 732 R 6.6 0.0 0:01.01 vdelivermail
5064 vpopmail 18 0 4120 1004 732 R 6.6 0.0 0:00.20 vdelivermail
3314 vpopmail 18 0 4888 1004 732 D 6.2 0.0 0:01.79 vdelivermail
3681 vpopmail 18 0 4228 1020 740 D 6.2 0.0 0:01.77 vdelivermail
4609 vpopmail 18 0 4632 1020 740 D 6.2 0.0 0:00.79 vdelivermail
4681 vpopmail 18 0 3408 1004 732 D 6.2 0.0 0:00.81 vdelivermail
4762 vpopmail 18 0 4432 1004 732 D 6.2 0.0 0:00.28 vdelivermail
4784 vpopmail 17 0 4764 1020 740 D 6.2 0.0 0:00.28 vdelivermail
5066 vpopmail 18 0 4576 1004 732 R 6.2 0.0 0:00.19 vdelivermail
4531 vpopmail 18 0 3784 1004 732 D 5.9 0.0 0:01.08 vdelivermail
4627 vpopmail 18 0 4796 1016 740 D 5.9 0.0 0:01.08 vdelivermail
3809 vpopmail 18 0 3964 1020 740 R 5.6 0.0 0:01.77 vdelivermail
3934 vpopmail 18 0 3232 1004 732 R 4.9 0.0 0:01.74 vdelivermail
4372 vpopmail 18 0 3652 1016 740 D 4.9 0.0 0:00.80 vdelivermail
3915 vpopmail 18 0 3244 1020 740 D 4.3 0.0 0:01.72 vdelivermail
3490 vpopmail 18 0 3124 1020 740 R 3.9 0.0 0:01.63 vdelivermail
3539 vpopmail 18 0 3400 1072 800 D 3.9 0.1 0:01.71 vdelivermail
3883 vpopmail 18 0 3412 1020 740 D 3.9 0.0 0:01.20 vdelivermail
4091 vpopmail 18 0 4408 1004 732 D 3.9 0.0 0:01.62 vdelivermail
I want to know how to see how many connections has mysql server in a
specific moment?
The best way to find out is to use the mysqladmin command:
mysqladmin -uroot processlist
or the mysql command:
mysql -uroot -e "show processlist"
and
What should do i for solve this problem?
You can set the "max_connections" parameter in your my.cnf to a reasonable
value. This can limit the amount of connections coming into the server to
possibly avoid unpleasant situations. This is not an ideal solution, but at
least an error code would be delivered back to the application indicating "Too
many connections."
Partha Dutta
Senior Consultant
MySQL Inc.
Thanks in advance
Mario
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]