June 19, 2013

Comment: Connecting orphaned .ibd files

…; > > ERROR 2006 (HY000): MySQL server has gone away > No connection. Trying to reconnect… > Connection id: 3 > Current database: database > 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 ‘/tmp/mysql.sock’ (61) > ERROR

Comment: SystemTap - DTrace for Linux ?

… same problems. 1. The client session will be disconnected (MySQL server has gone away) after the SystemTap script is started or terminated. test@localhost… set (0.00 sec) test@localhost [(none)]>select now(); ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect… Connection id: 7 Current…

Comment: COUNT(*) vs COUNT(col)

… row in set (0.23 sec) mysql> select count(*) from wp_comments; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect… Connection id: 2 Current database: test +———-+ | count(*) | +———-+ | 230120 | +———-+ 1 row in set (1.19 sec) mysql