…data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free…indexes. This allows parallel processing of individual tables when rebuilding the index. Percona XtraBackup…. Bugs Fixed: innobackupex is using SHOW MASTER STATUS to obtain binlog file and position….
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…`) ON DELETE CASCADE Trying to add in child table, in index `par_ind` tuple: DATA TUPLE: 2 fields; 0: len 4; hex… TABLES was used. In addition to Innodb specific information, there is generic statement information which is visible in SHOW PROCESSLIST showed in SHOW INNODB STATUS… searches/s This section shows insert buffer and adaptive hash status. First line shows status of insert buffer – segment size and free list as well…
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
… own. As we populate table we will see Free space will remain at zero as Data_length is small: mysql> show table status like “test_innodb… at certain point you will see Innodb Free space to become non zero: mysql> show table status like “test_innodb” \G *************************** 1. row *************************** Name…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…show table status like “%bool%” \G *************************** 1. row *************************** Name: bbool Engine: InnoDB Version: 10 Row_format: Compact Rows: 2097405 Avg_row_length: 37 Data…_length: 11 Data_length: 23068672 Max_data_length: 3096224743817215 Index_length: 1024 Data_free: 0 Auto_…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
…show table status like “m4″ \G *************************** 1. row *************************** Name: m4 Engine: MEMORY Version: 10 Row_format: Fixed Rows: 5000000 Avg_row_length: 129 Data_length: 685609952 Max_data_length: 948528873 Index_length: 0 Data_free: 0 Auto_increment:…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… used 10mil row table which would look as following in terms of data and index size: mysql> show table status like “sbtest” \G ***************************… 10000060 Avg_row_length: 224 Data_length: 2247098368 Max_data_length: 0 Index_length: 1460322304 Data_free: 7340032 Auto_increment: 10000001 …
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…SHOW TABLE STATUS LIKE ‘t’\G *************************** 1. row *************************** Name: t Engine: InnoDB Version: 10 Row_format: Compact Rows: 4195067 Avg_row_length: 29 Data_length: 125452288 Max_data_length: 0 Index_length: 278839296 Data_free: 1838153728 Auto_…
Comment: Finding out largest tables on MySQL Server
October 6, 2008 By 27 Comments
…show table status like ‘table‘ \G *************************** 1. row *************************** Name: table Engine: InnoDB Version: 10 Row_format: Compact Rows: 14898977 Avg_row_length: 150 Data… InnoDB free: 4021248 kB 1 row in set (0.06 sec) ######## I have ran your query and the show table status…
Post: How much memory Innodb locks really take ?
July 13, 2006 By 11 Comments
…show table status like “sample” \G; *************************** 1. row *************************** Name: sample Engine: InnoDB Version: 10 Row_format: Compact Rows: 1638757 Avg_row_length: 61 Data_length: 100253696 Max_data_length: 0 Index_length: 128974848 Data_free: 0 Auto_…
