…_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory usage diagnostics. Bugs…#65077 from the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…, a set of databases, or specific tables; you can also configure the slave … plenty of other MySQL and OS-level status variables that you might want to …-running queries in the output of SHOW PROCESSLIST that might be a sign …that in the MySQL world, except maybe MyISAM files on top of a clustered …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…show_statusblogpercona.commanual Com_show_storage_enginesblogpercona.commanual Com_show_table_statusblogpercona.commanual Com_show_tablesblogpercona.commanual Com_show_triggersblogpercona.commanual Com_show_variablesblogpercona.commanual Com_show…
Post: How much space does empty Innodb table take ?
December 16, 2008 By 7 Comments
… very small Innodb tables – they will take much more space than MyISAM. So .ibd file we get in case of table having no… to it. Now it is very interesting – SHOW TABLE STATUS does not seems to show everything: CREATE TABLE `test_innodb` ( `i` int(10) unsigned NOT… inaccurate for small tables. For example it will show 16K as average row size for table with one row: mysql> show table status like “test_innodb…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…` bit(1) NOT NULL ) ENGINE=MyISAM mysql> show table status like ‘bbool’ \G *************************** 1. row *************************** Name: bbool Engine: MyISAM Version: 10 Row_format: Fixed Rows… see how things look for MyISAM for same tables: mysql> show table status like “%bool%” \G *************************** 1. row *************************** Name: bbool Engine: MyISAM Version: 10 Row_format…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
…MYISAM: mysql> show index from antest; +——–+————+———-+————–+————-+———–+————-+———-+——–+——+————+———+ | Table…
Post: Innodb Table Locks
July 31, 2012 By 4 Comments
… in SHOW ENGINE INNODB STATUS you might be confused and rightfully so as Innodb table locking is a bit more complicated than traditional MyISAM table… story. Explicitly locking tables on MySQL level will prevent tables from being accessed and will not show up in SHOW ENGINE INNODB STATUS. It is…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 5 Comments
… table test_myisam USE_FRM; +——————+——–+———-+———-+ | Table | Op | Msg_type | Msg_text | +——————+——–+———-+———-+ | test.test_myisam | repair | status | OK | +——————+——–+———-+———-+ 1 row in set (0.00 sec) mysql> show…
Post: The MySQL optimizer, the OS cache, and sequential versus random I/O
April 28, 2008 By 17 Comments
…’s take a look at the tables. mysql> show table status like ‘fact’\G *************************** 1. row *************************** Name: fact Engine: MyISAM Rows: 147045493 Avg_row_length…_length: 17217646764 Index_length: 11993816064 mysql> show table status like ‘dim1′\G *************************** 1. row *************************** Name: dim1 Engine: MyISAM Rows: 453193 Avg_row_length: 122…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… is not how it happens in practice. mysql> show global status like “key%”; +————————+———+ | Variable_name | Value | +————————+———+ | Key_… MyISAM tables may not scale proportionally with table size, even when all data fits in memory MEMORY temporary tables…
