… Barracuda file format only ENABLES new features that require an on-disk format change. Unless you create tables that use compression, or unless your table takes advantage of the new DYNAMIC row format (where… between enabling the default Antelope format and the new Barracuda format. I know you’re not using compression for this test. (And it…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…_fact’G *************************** 1. row *************************** Name: ontime_fact Engine: InnoDB Version: 10 Row_format: Compact Rows: 6697533 Avg_row_length: 241 Data… compression that RLE techniques provide. I have not loaded InnoDB compressed tables yet but since InnoDB compression …
Post: Innodb row size limitation
April 7, 2011 By 12 Comments
… two rows on a page. If you’re using compression, however, you can store a single row on a page. If your row has variable length columns and the complete row size… approaches you can take to solve this: Upgrade to Barracuda format This is probably the simplest approach, and as Barracuda only…
Post: INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine
May 24, 2008 By Leave a Comment
… posts ourselves about its fast index creation capabilities and the compressed row format, and how that affects performance. One of the nice things… | +—————————————-+ The _CMP tables show statistics about compression; they contain a lot of useful information about compression, decompression, memory management, fragmentation etc. Beware…
Comment: Detailed review of Tokutek storage engine
May 5, 2009 By 21 Comments
It would be nice to compare InnoDB compressed row format with TokuDB.
Comment: Interested to learn about New Innodb Plugin Performance ?
May 24, 2008 By 2 Comments
[...] which Innobase released at the MySQL conference last month. We’ve written posts ourselves about its fast index creation capabilities and the compressed row format, and how that affects performance. One of the nice [...]
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…format_checkblogpercona.commanual innodb_file_format…row_lock_time_maxblogpercona.commanual Innodb_row_lock_waitsblogpercona.commanual Innodb_rows_deletedblogpercona.commanual Innodb_rows_insertedblogpercona.commanual Innodb_rows_readblogpercona.commanual Innodb_rows…slave_compressed_…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…very different compression ratio. As Innodb indexes are not prefix compressed they have very good compression potential….to build indexes by sorting rather by row by row insertions as it currently does …does it uses dynamic or static record format ? (static record format for sort used by MyISAM may…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… –skip-column-names –quick –silent –no-auto-rehash –compress $* SELECT CONCAT( ‘# Time: ‘, DATE_FORMAT(start_time, ‘%y%m%d %H:%i:%s…_time), ‘ Lock_time: ‘, TIME_TO_SEC(lock_time), ‘ Rows_sent: ‘, rows_sent, ‘ Rows_examined: ‘, rows_examined, CHAR(10), ‘SET timestamp=’, UNIX_TIMESTAMP(start_time…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… on a relatively weak machine. [mysqld] server_id=1 binlog_format=ROW log_bin=mysql-bin wsrep_cluster_address=gcomm:// wsrep_provider…_locks use GCC atomic builtins 120619 13:21:17 InnoDB: Compressed tables use zlib 1.2.3 120619 13:21:17… buffer pool 120619 13:21:18 InnoDB: highest supported file format is Barracuda. 120619 13:21:18 InnoDB: Waiting for the…
