Hello All I'm desperate. Since two days my Server crashed several times. This is what happens : The Webserver ist not responding any more. If i'm lucky i can still log in. System load ist 90+(!!!) rapidly increasing. Top shows a LOT of mysql processes all eating CPU like hell. There are also a lot of httpd processes, but that's like it should be. If i stop apache, mysql-process minimise too. When i start Apache back up, Mysql starts eating all my CPU again. When i restart mysql, problem goes away and everything runs smooth for a while. All i can find in error files is that there are a lot of errors in the form : 030625 19:53:57 Aborted connection 23394 to db: 'abc' user: 'xyz' host: `localhost' (Got timeout reading communication packets) 030625 19:53:57 Aborted connection 23457 to db: 'abc' user: 'xyz' host: `localhost' (Got timeout reading communication packets) 030625 19:53:57 Aborted connection 23458 to db: 'abc' user: 'xyz' host: `localhost' (Got timeout reading communication packets) at least Ten per Second.
All logs are not showing anything unusual. To me the situation locks like the Socket is blocked and only a restart can free the mysql Connection. Can anyone advice? What can i Do? I am absolutely clueless..... If i can provide anything else to solve the issue? just mail me. Please Help :-( Sebastian Here are some Facts about the System The System runs with stupid SUSE Linux 7.2 and is a dual 1200 P3 with 1GB of Memory and plenty of Disc Space. Since Suse uses a different Version System than everyone else in the world i can hardly tell which version runs. xyz:/etc # mysql -V mysql Ver 11.15 Distrib 3.23.37, for suse-linux (i686) # rpm -q mysql mysql-3.23.37-58 Apache apache_1.3.27 PHP 4.3.2 my.cnf ---------------------8<-------------------------- port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking set-variable = key_buffer=96M set-variable = max_allowed_packet=8M set-variable = table_cache=512 set-variable = sort_buffer=8192K set-variable = net_buffer_length=64K set-variable = myisam_sort_buffer_size=64M set-variable = max_connections=200 log-bin server-id = 1 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash --------------------->8-------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
