Lost connection to MySQL server?

Question

MySQL

Who faced such an unpleasant thing? Some tables in different databases began to fall out into the “Lost connection to MySQL server” error, and different tables from large to small, dismissed the reason for the refusal to allocate resources. Syslog shows error 11, Resource temporarily unavailable. Here is the full error log Updated mysql c 5.0 to 5.1 the problem remained. Debian Lenny Server.
Who faced? Tell me how to recover data?

Answer 1

>Please use mysql_upgrade to fix this error.

Answer 2

mysqladmin variables | grep timeout

Answer 3

and if you execute "REPAIR TABLE `cms_permissions`" - what happens?
in addition, lines 62-64 of your log clearly indicate that you have problems with mysql.* tables. you need to fix them first (mgyk:>Please use mysql_upgrade to fix this error.).

Answer 4

Have you tried mysqlcheck -a --auto-repair -c -e -o -r mysql?
Then mysql_upgrade.