Code: Select all
> show full processlist;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR:
Can't connect to the server
mysql> show full processlist;
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR:
Can't connect to the server
mysql> AbortedCode: Select all
# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@localhost www]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 126087 mysql 18 0 1405m 426m 3264 S 39.4 21.3 5:37.76 mysqld
under 'top' I showed a load of server load of 30, the machine was 1 CPU so that is pretty crazy to see. In the future how can I avoid this? Should I just tell mysql to use less memory? Should I run smaller queries? Is it unavoidable with these types of queries?