I am using Ubuntu 12.04 x64, currently with Mysql 5.5.28 (plus Galera, but I don't think this is related). I made some changes to my.cnf, but the changes were related to InnoDB settings (much more memory for buffer pools, flushes, concurrency threads, etc.).
After that, when I pressed service mysql restart , I can not enter the mysql console - I get the following error message:
Lost connection to MySQL server at 'reading initial communication packet', system error: 104
Sometimes the next attempt leads to console input, sometimes not, and I need to restart my SSH connection. What could be the problem and how to fix it?
EDIT: I noticed that most of the time after the system error: 104 , the following error occurs:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
After a few times, this usually starts. Unfortunately, this has not happened now, and syslog has:
Error in my_thread_global_end(): 2 threads didn't exit
Restarting SSH connection / MySQL server does not work. I can try restarting the server, but I will try to resolve this without this step. Its a test environment, so I want to find a better solution than restarting the whole server;)
source share