Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : more sockets more load

[psycash]

i have a big mysql problem how can i resolve this..

netstat active unix socket output;
MySQL 4.1.21 (standart-log)

Active UNIX domain sockets (servers and established)
Proto RefCnt Flags Type State I-Node PID/Program name Path
unix 2 [ ACC ] STREAM LISTENING 13354 3704/dbus-daemon-1 /var/run/dbus/system_bus_socket
unix 2 [ ACC ] STREAM LISTENING 8746763 7151/mysqld /var/lib/mysql/mysql.sock
unix 10 [ ] DGRAM 9578 2802/syslogd /dev/log
unix 2 [ ACC ] STREAM LISTENING 9936 2919/acpid /var/run/acpid.socket
unix 2 [ ] DGRAM 4483 1287/udevd @udevd
unix 2 [ ACC ] STREAM LISTENING 11522 3316/pure-authd /var/run/ftpd.sock
unix 3 [ ] STREAM CONNECTED 17570411 - /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17570410 -
unix 4 [ ] STREAM CONNECTED 17570312 - /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17570303 -
unix 3 [ ] STREAM CONNECTED 17570240 - /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17570237 -
unix 3 [ ] STREAM CONNECTED 17558204 - /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17558202 -
unix 3 [ ] STREAM CONNECTED 17542331 - /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17558202 -
unix 3 [ ] STREAM CONNECTED 17542331 - /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17542330 816/httpd
unix 2 [ ] DGRAM 17542301 1760/netstat
unix 3 [ ] STREAM CONNECTED 17542270 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17542269 846/httpd
unix 3 [ ] STREAM CONNECTED 17542252 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17542251 810/httpd
unix 4 [ ] STREAM CONNECTED 17542242 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17542241 1411/httpd
unix 3 [ ] STREAM CONNECTED 17542203 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17542202 1688/httpd
unix 3 [ ] STREAM CONNECTED 17542185 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17542180 1703/httpd
unix 3 [ ] STREAM CONNECTED 17542163 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17542162 1425/httpd
unix 3 [ ] STREAM CONNECTED 17542186 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17542154 1693/httpd
unix 3 [ ] STREAM CONNECTED 17542188 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17542033 874/httpd
unix 3 [ ] STREAM CONNECTED 17541795 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17541762 1708/httpd
unix 3 [ ] STREAM CONNECTED 17541660 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17541595 824/httpd
unix 3 [ ] STREAM CONNECTED 17541624 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17541590 1100/httpd
unix 3 [ ] STREAM CONNECTED 17541587 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17541586 1700/httpd
unix 3 [ ] STREAM CONNECTED 17541431 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17541430 1671/httpd
unix 3 [ ] STREAM CONNECTED 17541334 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17541333 1687/httpd
unix 3 [ ] STREAM CONNECTED 17541309 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17541308 1681/httpd
unix 3 [ ] STREAM CONNECTED 17541281 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17541280 992/httpd
unix 3 [ ] STREAM CONNECTED 17541230 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17541229 1689/httpd
unix 3 [ ] STREAM CONNECTED 17540927 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17540926 1424/httpd
unix 3 [ ] STREAM CONNECTED 17540757 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17540756 1690/httpd
unix 3 [ ] STREAM CONNECTED 17540748 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17540747 1396/httpd
unix 3 [ ] STREAM CONNECTED 17540664 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17540663 807/httpd
unix 3 [ ] STREAM CONNECTED 17540548 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17540530 1709/httpd
unix 3 [ ] STREAM CONNECTED 17540525 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17540524 811/httpd
unix 3 [ ] STREAM CONNECTED 17540191 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17540190 1694/httpd
unix 3 [ ] STREAM CONNECTED 17540160 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17540159 839/httpd
unix 3 [ ] STREAM CONNECTED 17540037 7151/mysqld /var/lib/mysql/mysql.sock
unix 3 [ ] STREAM CONNECTED 17540021 825/httpd

top
top - 16:30:00 up 1 day,  1:28,  1 user,  load average: 7.64, 9.02, 8.83
Tasks: 270 total,  13 running, 256 sleeping,   0 stopped,   1 zombie
Cpu(s): 75.6% us,  7.2% sy,  0.0% ni, 13.9% id,  2.5% wa,  0.2% hi,  0.6% si
Mem:   2071220k total,  1989812k used,    81408k free,    20716k buffers
Swap:  1052248k total,      128k used,  1052120k free,   737704k cached

i reinstall mysql always because of this problem. i tired so much. please help me.