… of resources system has will place a limit on amount of queries system can ran…take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat … COMMIT_TRANSACTIONS: 181243 ROLLBACK_TRANSACTIONS: 0 DENIED_CONNECTIONS: 0 LOST_CONNECTIONS: 0 ACCESS_DENIED: 0 EMPTY_QUERIES:…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…referring to the amazing MySQL manual, especially the option and variable reference table…._typeblogpercona.commanual Compressionblogpercona.commanual concurrent_insertblogpercona.commanual connect_timeoutblogpercona.commanual Connectionsblogpercona.commanual consoleblogpercona.commanual core_…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 7 Comments
… to another, something went wrong and they lost the ibdata1 file, where all the table …and good internet connectivity, I fired up an Ubuntu 10.04 EC2 instance, installed MySQL and provided …ID order by spaceid limit 1;”` if [ "a$CURRENT_SPACEID" == "a" ]; then exit fi CURRENT_TABLENAME=`mysql -u root …
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
… 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… Duplicates: 100 Warnings: 0 mysql> insert ignore into test2 select * from test limit 300; ERROR 2013 (HY000): Lost connection to MySQL server during query As…
Post: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
…_TRANSACTIONS: 0 DENIED_CONNECTIONS: 0 LOST_CONNECTIONS: 0 ACCESS_DENIED: 0 EMPTY_QUERIES: 0 1 row in set (0.00 sec) mysql> select * from… DENIED_CONNECTIONS: 0 LOST_CONNECTIONS: 0 ACCESS_DENIED: 0 EMPTY_QUERIES: 70748 and INDEX/TABLE statistics: mysql> select * from information_schema.index_STATISTICS limit 10…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…the boot output has been lost, but in many cases … | Variable_name | Value | +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | |…log output. The stock MySQL server’s limitation of one-second granularity…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
…and also can use up all allowed connections or run out of memory ( myisam_…Innodb dictionary may cause MySQL to fail with wierd error messages. In MySQL 4.1 … well as some of updates totally lost. The safe approach it to reclone …you might run select 1 from _table_ limit 1 for each table or any other …
