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? and What should do i for solve this problem? Thanks in advance Mario -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
