… “innochecksum” and starting the server and trying: > use database; > desc bad_table; > > 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…
Comment: SystemTap - DTrace for Linux ?
August 31, 2011 By 17 Comments
… problems. 1. The client session will be disconnected (MySQL server has gone away) after the SystemTap script is started or terminated. test@localhost…) test@localhost [(none)]>select now(); ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect… Connection id: 7 Current database…
Comment: How much memory can MySQL use in the worst case?
January 21, 2012 By 17 Comments
… of figuring these things out does not seem to have gone away. Also many other RDBMSes try to predefine a certain size… the server suddenly going into swap and dying, or the kernel OOM killer killing a suddenly growing mysqld would go away. The… configuration and mysqld “jumping” into swap, or just killing the server I’d _much_ prefer to be able to limit this…
Post: How to track down the source of Aborted_connects
August 23, 2008 By 19 Comments
Yesterday I helped someone who was seeing a lot of “server has gone away” error messages on his website. While investigating this problem… but really weren’t. The biggest measurable sign was [percona@server ~]$ mysqladmin ext | grep Abort | Aborted_clients | 14835 | | Aborted_connects | 15598… did was look for packet loss between the database server and the web server; the network appeared to be working fine. With…
Comment: Percona XtraDB Cluster reference architecture with HaProxy
December 18, 2012 By 63 Comments
…: If you are running into the ‘MySQL server has gone away‘ problem, you should change the “timeout server” and “timeout client” values in the… cilent 3601s … etc backend pxc-back timeout server 3601s … etc backend pxc-onenode-back timeout server 3601s … etc — Again, just make sure…
Comment: Percona XtraDB Cluster reference architecture with HaProxy
January 28, 2013 By 63 Comments
… for being late on that one. For haproxy and mysql server has gone away: this is usually timeout/maxconn mismatch on either haproxy…
Comment: Percona XtraDB Cluster reference architecture with HaProxy
November 28, 2012 By 63 Comments
… large bulk of queries (reads and writes) causes ‘MySQL server has gone away‘, but really mysqld process is alive. Error log does not…
Comment: Percona XtraDB Cluster reference architecture with HaProxy
November 13, 2012 By 63 Comments
… : in proc 5 session 233461088 caused an error: MySQL server has gone away just after the session has closed. Not all pt-log…
Comment: Watch out for your CRON jobs
October 14, 2009 By 19 Comments
…. On other hand if MySQL server goes away or connection is closed the GET_LOCK lock is gone while lock on local file…
Comment: COUNT(*) vs COUNT(col)
April 25, 2007 By 45 Comments
…> select count(*) from wp_comments; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect… Connection id: 2 Current database…
