…during installation. …query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856 introduced a regression in Percona Server for MySQL…MySQL client to abort the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL…be lost. Bug …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…during installation. …query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856 introduced a regression in Percona Server for MySQL…MySQL client to abort the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL…be lost. Bug …
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… my manually corrupted table I am getting: mysql> check table test; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> check table test; +———–+——-+———-+———-+ | Table | Op | Msg_type… id>250; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> insert ignore into test2 select * from test where id>300; Query OK, 573140 rows affected (7…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 5 Comments
… values(1,2); Query OK, 1 row affected (0.00 sec) mysql> select * from test_innodb; ERROR 2013 (HY000): Lost connection to MySQL server during query Recovering CREATE TABLE from .frm file for MyISAM Table We do not really need this that frequently but I decided to…
Comment: MySQL extensions for hosting
June 29, 2008 By 11 Comments
… does not exists # mysql -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2817 to server version: 5.0.51b…; Query OK, 1 row affected (0.00 sec) mysql> use foobar Database changed mysql> create table bbb SELECT * FROM aaa; ERROR 2013 (HY000): Lost connection to MySQL server during query
Comment: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 5 Comments
when I run this query to recover my data : mysql> insert into test_innodb values(1,2,3,4,5,6,7,8,9); it returns ERROR 2013 (HY000): Lost connection to MySQL server during query and no row recovered from .frm file
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…connection properly). This is happening 6 times every ten seconds. We need to…to look for later during query…query logs in the stock MySQL server are extremely limited, and for serious analysis it’s basically mandatory to use a server…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…to use the mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 868 Server…connection to it’s only peer, the default is to stop accepting queries to…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
…during the crash which might need to take care of or which may seriously affect MySQL Performance. MyISAM Corruption – If you’re writting to…up all allowed connections or run out of…totally lost. The safe approach it to reclone… MySQL server its caches (key_buffer, innodb_buffer_pool, query_cache…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…CONNECTIONS: 1 LOST_CONNECTIONS: 0 ACCESS_DENIED: 0 EMPTY_QUERIES: 0 1 row in set (0.00 sec) In this case CONNECTED…queries MySQL server ran with their times and run mk-query-digest with filter to only check queries from replication thread: mk-query…
