…. How blobs are stored in Innodb ? This depends on 3 factors. Blob size; Full row size and Innodb row format. But before we look into… specified and compression for normal data and index pages is not enabled. If you’re interested to learn more about Innodb row format check out this page in Innodb docs: It is worth to note I…
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
… to Barracuda file format using new InnoDB plugin recently released by Oracle. First thing I’ve tried was DYNAMIC row format. After 3,5… row format InnoDB was able to keep an entire PRIMARY index in memory (TEXT and BLOB fields are stored off-page in this format… optimizations and I’ve tried to convert this table using COMPRESSED row format. This time conversion took 1,5 hours and results were…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
… tables: 19693 sec, for compressed tables: 38278 sec. Compressed tables are create as: ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8, with …compressed tables CPU utilization is 7%. Obviously we have some mutex serialization problem. Analyzing SHOW INNODB STATUS (SEMAPHORES) for workload with compression…
Comment: Blob Storage in Innodb
February 10, 2010 By 13 Comments
… table status like “comptest” \G *************************** 1. row *************************** Name: comptest Engine: InnoDB Version: 10 Row_format: Compressed Rows: 1 Avg_row_length: 32768 Data_length: 32768 Max_data… Checksum: NULL Create_options: row_format=COMPRESSED Comment: 1 row in set (0.00 sec) In this this is highly compressible long blob gets some…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…compression ratio. As Innodb indexes are not prefix compressed they have very good compression potential. I also would like to see some stats about compressed…uses dynamic or static record format ? (static record format for sort used by…least MySQL 5.1 with row level replication readily available. …
Post: Innodb row size limitation
April 7, 2011 By 11 Comments
… InnoDB storing 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
… capabilities and the compressed row format, and how that affects performance. One of the nice things they added in this InnoDB release is INFORMATION…_SCHEMA (INNODB%) | +—————————————-+ | INNODB_CMP | | INNODB_CMP_RESET | | INNODB_CMPMEM | | INNODB_CMPMEM_RESET | | INNODB_LOCK_WAITS | | INNODB_LOCKS | | INNODB_TRX | +—————————————-+ The _CMP tables show statistics about compression; they…
Comment: INSERT ON DUPLICATE KEY UPDATE and REPLACE INTO
December 30, 2011 By 15 Comments
Juan, just make your log table InnoDb too, to get rid of the table locks. Use something like “ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8″ if you need it to use less disk space.
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Innodb_row_lock_timeblogpercona.commanual Innodb_row_lock_time_avgblogpercona.commanual Innodb_row_lock_time_maxblogpercona.commanual Innodb_row_lock_waitsblogpercona.commanual Innodb_rows_deletedblogpercona.commanual Innodb_rows_insertedblogpercona.commanual Innodb_rows…compressed…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…’G *************************** 1. row *************************** Name: ontime_fact Engine: InnoDB Version: 10 Row_format: Compact Rows: 6697533 Avg_row_length: 241 Data_…excellent compression that RLE techniques provide. I have not loaded InnoDB compressed tables yet but since InnoDB compression is …
