[vpsFree.cz: community-list] mysql problem

Ahoj chlapci, ten patecni vypadek/presun vps mi nejak rozbil mysql. Chtel bych poprosit o info, jak to opravit, pokud s tim mate nekdo nejakou zkusenost. Situace je nasledujici: Pri nekterych requestech (je to nahodne, 10 requestu ok, 11 zfailuje) dojde ke bude k chybe pri pripojeni, nebo ke ztrate spojeni. V logu vidim nasledujici: bud: OperationalError: (2013, "Lost connection to MySQL server at 'reading initial communication packet', system error: 104") nebo: OperationalError: (2003, "Can't connect to MySQL server on '83.167.228.14' (111)") nebo: OperationalError: (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)") mysql vypada, ze bezi normalne: netstat -tupan | grep mysql tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 26693/mysqld ps ax | grep mysql 12488 ? S 0:04 /bin/sh /usr/bin/mysqld_safe 26869 ? Sl 0:02 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/msa.err --pid-file=/var/lib/mysql/msa.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 socket vypada ok: ls -la /var/run/mysqld/ total 8 drwxr-xr-x 2 mysql mysql 4096 Aug 5 15:32 . drwxr-xr-x 20 root root 4096 Aug 5 10:46 .. srwxrwxrwx 1 mysql mysql 0 Aug 5 15:32 mysqld.sock Kdyz zkusim mysql restartovat, dostanu nasledujici: /etc/init.d/mysql restart Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld. Checking for corrupt, not cleanly closed and upgrade needing tables.. msa:.../home/dsimek > ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) .... v logu pri startu vidim toto: Aug 5 10:26:33 msa /etc/mysql/debian-start[30658]: Upgrading MySQL tables if necessary. Aug 5 10:26:33 msa /etc/mysql/debian-start[30664]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Aug 5 10:26:33 msa /etc/mysql/debian-start[30664]: Looking for 'mysql' as: /usr/bin/mysql Aug 5 10:26:33 msa /etc/mysql/debian-start[30664]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Aug 5 10:26:33 msa /etc/mysql/debian-start[30664]: This installation of MySQL is already upgraded to 5.1.63, use --force if you still need to run mysql_upgrade Aug 5 10:26:33 msa /etc/mysql/debian-start[30672]: Checking for insecure root accounts. Aug 5 10:26:33 msa /etc/mysql/debian-start[30677]: Triggering myisam-recover for all MyISAM tables Diky za jakykoliv tip. Dusan