… actually traded my other talk, “MySQL 5.6 improvements from InnoDB internals prospective,” with Oracle’s Sunny Bains and his talk, MySQL 5.6: What’s New in InnoDB. Sunny honestly knows more about InnoDB internals than I do. There are going to… the few engineers in the world who knows everything about InnoDB. If you seriously work with MySQL, then you should not…
Post: Percona Live MySQL Conference and Expo 2013: It feels like 2007 again
March 21, 2013 By Leave a Comment
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… innodb_lru_scan_depth to a value similar to innodb_io_capacity. They should have made LRU page flushing a function of innodb…_free_margin. I did a lot of work for the innodb_fast_free_list option to fix the stalls and that…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… innodb_lru_scan_depth to a value similar to innodb_io_capacity. They should have made LRU page flushing a function of innodb…_free_margin. I did a lot of work for the innodb_fast_free_list option to fix the stalls and that…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release is the current GA (Generally… pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with… were not printed to stderr directly. Because of that all InnoDB error or diagnostic messages are never printed by xtrabackup_56…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
…, there is another issue in InnoDB transaction processing that notably affects MySQL performance – for every transaction InnoDB creates a read view and… direct malloc() call, but rather goes through the InnoDB heap layer – so InnoDB allocates heap area and then creates requested block(s…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… can create. If you try setting the storage engine to InnoDB however, you will get an error message! The exact error…’t create table ‘test.t’ (errno: 139)”. This is because InnoDB has a hard limit of 1,000 columns. This is the code from ha_innodb.cc that enforces that limit: if (form->s->fields > 1000…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 30, 2013 By 10 Comments
… to http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-internals.html there are some caching settings to play…: “Table cache_policies specifies whether to use InnoDB as the data store of memcached (innodb_only), or to use the traditional memcached… key in memory, it searches for the value in an InnoDB table.” I’d like to see the results with all…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… this apply to the MySQL innodb memcache? i.e. will the cache being delete off innodb table after 12hours or they remain… a comparison between performance of 5.6 memcached innodb write/read vs 5.6 innodb write/read with no memcached layer? Currently…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
… that I never was able to get good results with InnoDB compression. Usually it was worse than without compression. So far… I’ve seen only one specific use case useful with InnoDB compression: i.e. you have a separate table with TEXT… big performance hit. That’s why Facebook has their own InnoDB compression, which is available in MySQL 5.6. So we…
Comment: How to recover table structure from InnoDB dictionary
May 8, 2013 By 4 Comments
1) innodb_file_per_table is OFF by default, which means all … how to do it http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:start . The biggest challenge…_id for each table – http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:advanced_techniques#recovering_the…
