… the second blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. This blog post….o_custkey 1 100.00 Using where 1 SIMPLE nation eq_ref PRIMARY PRIMARY 4 dbt3.customer.c_nationkey 1 100.00 1 SIMPLE lineitem…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL…4 5.4K disks in Software RAID5. Also note that the following changes were made on MySQL… 6707882 5479445 5527245 Select_scan 1 1 1 1 1 1 Sort_scan 1 1 1 1 1 1 The first obvious improvement is …
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… way this blog post is aimed at a new optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6… WHERE condition defined as: l_partkey = x and l_quantity >= 1 and l_quantity = 1 and l_quantity
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… the problem and giving extra motivation to MySQL to fix it. Few months later I blogged about this problem with more performance… this post as MySQL 5.0 is junk in terms of performance and you should stay on MySQL 4.1 until MySQL has taken it away from you as already happened with MySQL 4.0. MySQL 5.0 can offer…
Post: MySQL Server Upgrade
August 11, 2006 By 9 Comments
Today I’ve upgraded MySQL Server on the host running MySQL Performance Blog. MySQL 4.1.12 was running here for well over a year before… yet works with MySQL 5.0. Second – I know my applications designed to work with MySQL 4.1, they avoid queries which MySQL 4.1 does not optimize well and so MySQL 5.0 will likely reduce…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… send me email pointing to his article published on Jays Blog (Come on Marten, it is time for you to get… documented (sometimes) limitations. I’m saying about Prepared Statements in MySQL 4.1 which came without query cache support but even worse not… in MySQL 4.1 but you still could not run (and still can’t) most of your Oracle/DB2/MS SQL Queries on MySQL…
Post: MySQL End Of Life (EOL) Policy
August 22, 2008 By 6 Comments
… example MySQL 4.1 had end of its Active Lifecycle in the end of 2006. and indeed Latest MySQL 4.1 available for the public is 4.1… of MySQL 4.1 are followed we’ll soon see stop in MySQL community releases of MySQL 5.0 most likely before MySQL 5.1 will proven MySQL… whenever you’re MySQL customer or community user. Shameless Plug: I guess hundreds of Percona customers are reading this blog so I…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
… popular hosting provider’s datacenter. This application is a popular blogging service, running on a generic midrange Dell-class server. The… 6.1 sdj1 0.7 4.3 196.9 0.0 0.1 34.0 23% 0 7.1 sdj1 0.4 1.7 123.4 0.0 0.2 204.0 22% 0 8.1 sdj1 0.4 0.1 8.3…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…. I decided to write a blog post about these infinite loop of binary log statements in MySQL Replication. To explain what they… (mysql 3 and mysql 4) and the new events (with server-id 1) are also replicated. Step 4: the event with server-id 2 on mysql 4… position on the active master (mysql 1) is changed to the position returned by SHOW MASTER STATUS on mysql 4 (this position will increase…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
…’s seriously limiting MySQL in core use cases (links: part 1, 2, 3). This post is about the way MySQL handles connections, allocating one thread per connection to the server. MySQL is… are more details in this blog post by Mark, and two followup blog posts from Tim Cook (1, 2). Thanks for the great…
