… you can see from the status counters above that both MySQL 5.6 and MariaDB 5.5 are reporting…1 SIMPLE nation eq_ref PRIMARY PRIMARY 4 dbt3.customer.c_nationkey 1 100.00…to MySQL 5.5 MRR clearly changes the access pattern to sequential, and hence InnoDB is able to do many read_aheads. Another thing to…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… that the disks are 4 5.4K disks in Software RAID5. Also note that the following changes were made on MySQL 5.6 config: optimizer… drops from 2534.41s down to under a minute. MySQL 5.6 has the smallest query time when the join_buffer_size is set to… read from disk 2.2G vs 5G. However, there is one number in MariaDB 5.5 that is quite large as compared to MySQL 5.6…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
…IX RECORD LOCKS space id 19 page no 4 n bits 80 index `age` of table `test`.`…results can change during a transaction, so there is no need to create locks to prevent that from happening. 2-…information: http://dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ…
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 6 Comments
…change I could bring optimization, and full query execution time to less than 50ms. Low values, such as 3,4…from Timour Katchaounov in MySQL mailing list archives I have some recollection that there were few main reasons for the decision to… compatibility. In MySQL 5.6 things are likely to get even …
Comment: MariaDB 5.3 is released as GA!
March 7, 2012 By 17 Comments
… 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/en/news… Added or Changed” section (e.g. 5.5.18, 5.5.17, 5.5.16, 5.5.14). Whilst the majority of them aren’t significant or liable to have…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking… Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly at what…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…to the database at all (use mysql -A in this case, to prevent it from getting field list from…changing…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
…to reality. Benchmarks, like sysbench or tpcc-mysql, start N threads and try to…to your Facebook profile or Wikipedia page, you expect to get response within second or two. How we should change the benchmark to… is far from being strict 0.5 sec, but 0.5 is the…fsb=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;b…
Comment: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
March 11, 2012 By 7 Comments
…mysql from 5.1.22 change autoincrement mod http://dev.mysql.com/doc/refman/5.1/en/innodb-auto-increment-…to add one row to your my.ini file. # =0 is traditional lock mode == > funcionality of auto_increment like before 5…’),(‘Romco’); select * from tab order by 1; 1 Peter 2 Oto 3 Jan 4 Romco ===> not …
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… MySQL 4.1 to 5.0 upgrade notes ? ? Furthermore if there were no good ideas how to make XA to…change to do with MySQL 4 also because 100% durable transactions are not required anyway and it would allow to…on MySQL 4.1 until MySQL has taken it away from you as already happened with MySQL 4.0. MySQL 5.0…
