Bug #17369 Can't connect to local MySQL server through socket
Submitted: 14 Feb 2006 10:26 Modified: 14 Feb 2006 12:10
Reporter: edson fernando Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version: OS:Linux (RedHat Enterprise Linux)
Assigned to: CPU Architecture:Any

[14 Feb 2006 10:26] edson fernando
Description:
My error log is  with these errors:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)

this error occurs periodically.

My server: P4 3.2 - 1GB RAM
MySQL: 4.0.25-standard
php: 4.3.11
kernel: 2.4.21-37.ELsmp

How to repeat:
'top' statistics during these times: 

337 processes: 328 sleeping, 5 running, 4 zombie, 0 stopped 
CPU states: cpu user nice system irq softirq iowait idle 
total 76.5% 0.0% 21.5% 0.3% 1.5% 0.0% 0.0% 
cpu00 75.3% 0.0% 21.1% 0.7% 2.7% 0.0% 0.0% 
cpu01 77.7% 0.0% 21.8% 0.0% 0.3% 0.0% 0.0% 
Mem: 1024892k av, 943480k used, 81412k free, 0k shrd, 165028k buff 
660504k actv, 150092k in_d, 20860k in_c 
Swap: 2040212k av, 182916k used, 1857296k free 324684k cached 

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND 
4622 mysql 25 0 294M 157M 1592 R 17.4 15.7 0:01 1 mysqld 
4616 mysql 25 0 294M 157M 1592 R 12.9 15.7 0:02 0 mysqld 
4549 mysql 25 0 294M 157M 1592 R 10.7 15.7 0:01 1 mysqld 
4666 mysql 25 0 294M 157M 1592 S 10.7 15.7 0:01 0 mysqld 
4664 mysql 25 0 294M 157M 1592 S 10.3 15.7 0:01 0 mysqld 
4674 mysql 25 0 294M 157M 1592 S 7.3 15.7 0:00 0 mysqld 
4426 mysql 24 0 294M 157M 1592 S 6.6 15.7 0:03 0 mysqld 
4729 kboing 20 0 0 0 0 Z 1.8 0.0 0:00 0 cartao.cgi <defunct> 
12330 mysql 25 0 294M 157M 1592 R 0.3 15.7 5:54 0 mysqld 
3945 root 15 0 1360 1360 884 R 0.3 0.1 0:00 0 top 
4126 nobody 15 0 5260 4164 2352 S 0.2 0.4 0:00 1 httpd 
4202 nobody 15 0 5176 4080 2356 S 0.2 0.3 0:00 0 httpd 
3951 nobody 15 0 5196 4112 2356 S 0.1 0.4 0:00 0 httpd 
3977 nobody 15 0 5224 4128 2360 S 0.1 0.4 0:00 0 httpd 
3984 nobody 15 0 5252 4172 2380 S 0.1 0.4 0:00 1 httpd 
4053 nobody 15 0 5220 4128 2360 S 0.1 0.4 0:00 0 httpd 
4066 nobody 15 0 5220 4136 2360 S 0.1 0.4 0:00 0 httpd 
4108 nobody 15 0 5164 4068 2360 S 0.1 0.3 0:00 0 httpd 

In some forums, people had increased the memory RAM to 2GB, but the problem continues.

please, helpe me!
[14 Feb 2006 12:10] Valeriy Kravchuk
We're sorry, but the bug system is not the appropriate forum for 
asking help on using MySQL products. Your problem is not the result 
of a bug.

Support on using our products is available both free in our forums
at http://forums.mysql.com and for a reasonable fee direct from our
skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.