…: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 32768 Data_free: 0 Auto_increment: NULL Create_time… Rows: 1069 Avg_row_length: 199 Data_length: 212992 Max_data_length: 0 Index_length: 360448 Data_free: 0 Auto_increment: NULL Create_time: 2008-12… free: 0 kB 1 row in set (0.00 sec) When at certain point you will see Innodb Free space to become non zero: mysql…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…char(0) default NULL, `c8` char(0) default NULL, `c9` char(0) default NULL, `c10` char(0) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 mysql… Compact Rows: 2097405 Avg_row_length: 37 Data_length: 78233600 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: 2008-04…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…0.000002 | | statistics | 0.000005 | | preparing | 0.000006 | | executing | 0.000001 | | Sorting result | 0.000002 | | Sending data | 0.000040 | | end | 0.000003 | | query end | 0.000002 | | closing tables | 0.000003 | | freeing…
Comment: Finding out largest tables on MySQL Server
October 6, 2008 By 27 Comments
… | 2.08G | 0.00G | 2.08G | 0.00 | +———————————————-+——–+——-+——-+————+———+ 10 rows in set (0.15 sec) mysql> show table… Avg_row_length: 150 Data_length: 2237661184 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…=latin1 COMMENT=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_… Compact Rows: 6697533 Avg_row_length: 241 Data_length: 1616904192 Max_data_length: 0 Index_length: 539279360 Data_free: 4194304 Auto_increment: NULL Create_…
Comment: Blob Storage in Innodb
February 10, 2010 By 13 Comments
…: Compact Rows: 1 Avg_row_length: 1589248 Data_length: 1589248 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: 2010-02… (0.00 sec) mysql> alter table comptest row_format=compressed; Query OK, 1 row affected (0.62 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> show…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
…: 226918400 Block count: 3630694400 Reserved block count: 0 Free blocks: 3616208434 Free inodes: 226918374 First block: 0 Block size: 4096 Fragment size: 4096 Reserved… is probably not needed for partition you store MySQL data on, as chances are MySQL server is only one doing writes on this…
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
… Rows: 8048913 Avg_row_length: 252 Data_length: 2030206088 Max_data_length: 4294967295 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2006…_format: Dynamic Rows: 8048913 Avg_row_length: 0 Data_length: 0 Max_data_length: NULL Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: NULL Update… file: -rw-rw—- 1 mysql mysql 19 Nov 12 11:31 requests_061111.ARM -rw-rw—- 1 mysql mysql 984628803 Nov 12 11:29…
Post: Getting History of Table Sizes in MySQL
December 8, 2010 By 13 Comments
…, DATA_LENGTH, INDEX_LENGTH, DATA_FREE, AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES; I put it to the cron to run nightly as: 1 0 * * * mysql -u root -e “INSERT INTO stats.tables SELECT DATE(NOW()),TABLE_SCHEMA,TABLE_NAME,ENGINE,TABLE_ROWS,DATA_LENGTH,INDEX_LENGTH,DATA_FREE…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…related to multithreading–deadlocks, data races, starvations etc–have … much introduction, especially to the MySQL server developers. The Valgrind Memcheck…) ==9090== by 0x6B39223: fsp_fill_free_list (fsp0fsp.c:1455) ==9090== …S:112) ==9090== Location 0x6e29da8 is 0 bytes inside global var “srv_…
