… after MySQL 5.0.3 and has a more compact representation for nulls and variable-length fields than REDUNDANT. Using InnoDB’s new Barracuda file format (available since InnoDB plugin 1.1 or MySQL 5.5) you can now… that is the same value of the InnoDB page size of 16KB? As the fine MySQL manual states: This setting may still…
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 7 Comments
An InnoDB table statistics is used for JOIN optimizations and helping the MySQL optimizer choose the appropriate index for a query. If… on it? The 2 instances below are documented from the MySQL and InnoDB plugin‘s manual: Metadata commands like SHOW INDEX, SHOW TABLE… Server with the variable innodb_stats_auto_update (from MySQL Community 5.1.17 a similar variable exist called innodb_stats_on_metadata…
Post: Percona Server 5.1 with Galera replication
July 14, 2011 By 2 Comments
… is Percona Server, so I made port of Galera from MySQL/InnoDB-plugin to Percona Server 5.1.57. Right now it is…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_change_bufferingblogpercona.commanual innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency_ticketsblogpercona.commanual innodb_data_file_pathblogpercona.commanual Innodb_data_fsyncsblogpercona.commanual innodb…
Post: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
April 29, 2009 By 12 Comments
… innodb versions around. There is MySQL 5.0 version which did not get significant changes for around 2 years now. There is Innodb Plugin which has significant architectural changes such as new storage format, compression and fast index build. Innodb plugin 1.0.3… status as future Innodb code base. Now I’m confused – if Innodb Plugin is not taking place of default Innodb in MySQL 5.4 will…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
… all new Innodb Development is going with Innodb Plugin which is separate from Innodb included default MySQL. Why is not this part of stock MySQL 5.1 ? I guess because MySQL 5…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… the defaults between MySQL 5.5 and MySQL 5.6 and innodb_old_blocks_time immediately came to mind. The InnoDB plugin introduced innodb_old_blocks_time to help control the behavior of the new split LRU mechanism which was implemented in the plugin…
Post: Great work Innodb Team
November 30, 2009 By 8 Comments
… now. Innodb plugin documentation now seems to be merged with MySQL Documentation which makes it much more usable and Innodb Plugin is shipped with MySQL 5… Percona were reworked and included in the plugin during latest months. We can also see Innodb Plugin 1.0.5 is named Release… public release and probably 4 years since the work on Innodb plugin features such as compression or Online index creation has started…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… | 0 | 9 | | PLUGIN_DIR | /mnt/nfs/dist/5.5.30/lib/plugin/ | /mnt/nfs/dist/5.6.10/lib/plugin/ | | SYNC_RELAY_LOG… | | INNODB_PURGE_BATCH_SIZE | 20 | 300 | | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE…
Post: Blob Storage in Innodb
February 9, 2010 By 13 Comments
… (used in before Innodb plugin and named “Antelope” in Innodb Plugin and XtraDB) Innodb would try to fit the whole row onto Innodb page. At least… in REDUNDANT (MySQL 4.1 and below) and COMPACT (MySQL 5.0 and above) format and the fix comes with Innodb Plugin in “Barracuda” format and ROW_FORMAT=DYNAMIC. In this format Innodb…
