…InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb…InnoDB, PARTITION p10 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */ Also, I ran 5 instances of iiBench simultaneously to simulate 5…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… have a few questions: 1. Will the Percona Toolkit version just released work for regular community MySQL 5.5.23 or does it… on what is happening here? It seems as if MySQL 5.5 has been getting much slower (in terms of qps) with… across the board to everyone? Have some updates made to INNOdb tables really slowed down mySQL as measured by qps, in…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… point to consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous” IO in Linux… another question I was asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important?”, and it seems…-requests=0 –num-threads=$numthreads –rand-init=on –file-num=1 –file-extra-flags=direct –file-fsync-freq=0 –file-io…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
… INNODB STATUS: —TRANSACTION 72C, ACTIVE 755 sec 4 lock struct(s), heap size 1248, 3 row lock(s), undo log entries 1… create locks to prevent that from happening. 2- innodb_locks_unsafe_for_binlog = 1. Disables the gap locks except for foreign-key… good source of information: http://dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… plugin. MariaDB 5.3 isn’t the only exciting thing, however. MariaDB 5.3 is based on MySQL 5.1, but MariaDB 5.5 will be based on MySQL 5.5, so it will inherit… to partitioning, and the addition of multiple InnoDB buffer pools. Best of all, MariaDB 5.5 might be here pretty soon — I caught…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 9 Comments
… 76882 102672 76832 Innodb_data_read 1.84G 1.89G 1.53G 1.89G 1.53G Innodb_data_reads 120552 123872 100551 103011 77213 Innodb_pages_read 120548 123868 100551 123592 100566 Innodb_rows_read 799239 914146 912318 914146 912318 Select_scan 1 1 1 1 1 Sort_scan 1 1 1 1 1 As you can see from the status counters above that both MySQL 5.6 and MariaDB 5.5 are reporting high numbers for Innodb…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…/ join_buffer_size=6M & read_rnd_buffer_size=6M MariaDB 5.5 MariaDB 5.5 w/ join_buffer_size=6M & mrr_buffer_size=6M… Innodb_pages_read 329115 355323 143808 358308 144798 144881 Innodb_rows_read 4127318 6718351 6611675 6707882 5479445 5527245 Select_scan 1 1 1 1 1 1 Sort_scan 1 1 1 1 1 1 The first obvious improvement is shown by the high numbers of Innodb_buffer_pool_read…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking… Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly at what… WHERE condition defined as: l_partkey = x and l_quantity >= 1 and l_quantity = 1 and l_quantity
Comment: MariaDB 5.3 is released as GA!
March 7, 2012 By 17 Comments
Unfortunately that’s not true Henrik. Take for example the InnoDB plugin that has changed frequently throughout a release. http://www… within MySQL 5.5 GA we’ve gone from InnoDB plugin version 1.1.4->1.1.8. Also, take a look at the changes in 5.5 from here: http://dev.mysql.com/doc/refman/5.5…
Post: Percona Server 5.5.21-25.1 released!
March 29, 2012 By 8 Comments
… is glad to announce the release of Percona Server 5.5.21-25.1 on March 30, 2012 (Downloads are available here and… details of the release can be found in the 5.5.21-25.1 milestone at Launchpad. We are doing another release based… corruption regression introduced in 5.5.18-23.0. Bug fixed #915814 (Alexey Kopytov). Fixed InnoDB compilation warnings on CentOS 5. Bug fixed #962940…
