… in MySQL */ reclength=max(file->min_record_length(table_options),reclength); if (info_length+(ulong) create_fields.elements*FCOMP+288+ n_length+int_length+com_length > 65535L… rem0types.h */ #define REC_MAX_N_FIELDS (1024 – 1) #define REC_MAX_N_USER_FIELDS (REC_MAX_N_FIELDS – DATA_N_SYS_COLS * 2…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…max_connectionsblogpercona.commanual max_delayed_threadsblogpercona.commanual max_error_countblogpercona.commanual max_heap_table_sizeblogpercona.commanual max_insert_delayed_threadsblogpercona.commanual max_join_sizeblogpercona.commanual max_length…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…as permanent and temporary. There is a max_heap_table_size variable which allows …tables: mysql> select sum(data_length+index_length) from information_schema.tables where engine=’memory’; +——————————-+ | sum(data_length+index_length) | +——————————-+ | 126984 | …
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which should … Row_format: Compact Rows: 278987416 Avg_row_length: 75 Data_length: 20975714304 Max_data_length: 0 Index_length: 9047113728 Data_free: 6291456 Auto_increment: NULL Create…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… unique pages the query accessed, the length of time query waited for row …:10 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 …data about the underlying tables involved and the query execution plan used by MySQL…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…char(0) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 mysql> show table status like “%bool%” \G *************************** 1. row …format: Fixed Rows: 2097152 Avg_row_length: 11 Data_length: 23068672 Max_data_length: 3096224743817215 Index_length: 1024 Data_free: 0 Auto_increment: …
Post: How much space does empty Innodb table take ?
December 16, 2008 By 7 Comments
…will see Free space will remain at zero as Data_length is small: mysql> show table status like “test_innodb” \G *************************** 1. … 10 Row_format: Compact Rows: 1069 Avg_row_length: 199 Data_length: 212992 Max_data_length: 0 Index_length: 360448 Data_free: 0 Auto_increment: NULL Create_…
Comment: Finding out largest tables on MySQL Server
October 6, 2008 By 27 Comments
…seconds). ######### mysql> SELECT concat(table_schema,’.',table_name),concat(round(table_rows/1000000,2),’M') rows,concat(round(data_length/(1024… Row_format: Compact Rows: 14898977 Avg_row_length: 150 Data_length: 2237661184 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… 10 Row_format: Compact Rows: 4195067 Avg_row_length: 29 Data_length: 125452288 Max_data_length: 0 Index_length: 278839296 Data_free: 1838153728 Auto_increment: 4587468 Create_…index as the clustered one. References: Peter’s post MySQL bug #57583 MySQL bug #49120 Fast Index Creation page in Percona …
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
… same steps: Load data InfiniDB supports MySQL‘s LOAD DATA statement and it’s own colxml / cpimport utilities. As LOAD DATA is more familiar…: 10 Row_format: Dynamic Rows: 2000 Avg_row_length: 0 Data_length: 0 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time…
