… to MySQL 5.6. Now let’s take a look at the status counters. MySQL Status Counters These status counters were captured when performing….5 when compared to MySQL 5.5, and this does not make sense to me. Probably its due to a bug in how counter is… still improvement and changes needed in the optimizer’s cost estimation algorithm. MariaDB 5.5 expands the concept of MRR to improve the performance…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…is further extended to improve join performance. As I told you above, when table t1 would be joined to table t2, … 10; In-memory workload Now let’s see how effective are the join optimizations when the workload … to that of MySQL 5.5. MariaDB 5.5 is quite slow as compared to both MySQL 5.5 and MySQL …
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 5 Comments
…to be executed during EXPLAIN phase yet making it unusable to check the optimizer performance. Solution for this problem was to…few tables, – it is not clear how far from optimal plans do …MySQL 5.6 things are likely to get even better handling joins of many tables as optimizer heuristics are improved…
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… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
…how does it affect the response time ? – When we put a load to two nodes instead of three nodes, will it help to improve…to see an affect of having a side on the server. For example, the famous problem with DROP TABLE performance…
Post: Why not make a tool to improve existing configurations?
February 10, 2012 By 4 Comments
… popular MySQL Configuration Wizard have submitted feedback such as “I’d love to input my existing server settings and get suggestions on how to improve…. It turns out to be very subtle — perhaps too subtle to be done with any computer program, no matter how smart, because there… turn out to be dangerous. Every approach we considered carried a high risk of de-optimizing a server so it performs worse…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… much more convenient than trying to read from the dictionary directly to determine the contents of the view. mysql> select flexviews.get_sql…(), it but still provides improved performance during refresh by accessing summarized data. I hope this helps you understand how Flexviews can help you…
Post: How to Identify Bad Queries in MySQL
January 10, 2011 By 16 Comments
… to “can anything be improved for less than it costs not to improve it…, given the definition above, how do we find these…to the timestamp when the query executed, not merely the duration the query executed for, which has been available in MySQL…to find and diagnose the kinds of sub-second performance …
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…to deliver huge wins. If MySQL is actually badly configured, you can hurt its performance significantly. Correcting these mistakes can correspondingly improve performance…to improve the system’s performance dramatically, all things considered. More than configuration To…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…to the checks in that list, there are several others that can be performed with existing plugins, so there was no need to…to cause actual production downtime. Please download and try out the plugins, and help us improve…
