… it unusable to check the optimizer performance. Solution for this problem was to use set optimizer_search_depth=0, rarely used option which as per manual will chose best value automatically. Making this change I could bring optimization… further I found the following explanation from Timour Katchaounov in MySQL mailing list archives I have some recollection that there were…
Comment: Joining many tables in MySQL - optimizer_search_depth
April 23, 2012 By 6 Comments
… so-called “greedy optimizer“, I did some experiments to determine what is a reasonable limit for the search depth (and the total number of tables) that can be optimized in reasonable time. I reached…! = 5040, while 8! = 40320. The worst-case complexity of MySQL‘s join optimizer is N!. The goal of this choice was to…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…referring to the amazing MySQL manual, especially the option and variable reference table…..commanual Opened_tablesblogpercona.commanual optimizer_prune_levelblogpercona.commanual optimizer_search_depthblogpercona.commanual optimizer_switchblogpercona.commanual partitionblogpercona.commanual …
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
…of the core MySQL developers to submit talks about what is new in MySQL, the MySQL roadmap for the …how replication works, new features in the query optimizer, the storage engine architecture, and so on. The… we need full coverage of the breadth and depth of topics, not just the mad scientist topics. …
Post: Tutorial Insights for Percona Live, London
August 24, 2011 By Leave a Comment
… their talks. Yoshinori Matsunobu Talk on Linux Hardware and Optimizations for MySQL at Oreilly MySQL Conference and Expo was phenomenal. I wrote about… NDB Cluster Tutorial which is full day in depth tutorial focused on NDB Cluster/MySQL Cluster technology which is rapidly gaining popularity…
Post: Working on "High Performance MySQL, Second Edition", how you can help?
August 31, 2007 By 20 Comments
… team and will be able to provide great in depth book on MySQL Performance topic to the market. Me and Vadim have… performance optimization for MySQL and other databases which gives a very important angle plus being author of large amount of popular MySQL tools… you think some MySQL Performance related things are not covered yet in MySQL manual or there is some interesting optimization trick you’re…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…, rows are the worst case for performance. Optimal mathematical performance requires operations on reduced sets. … mapping, it allows partitioning resources to any depth and distributing a query over that set of… which speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’s law …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… with vanilla MySQL, you will need to aggregate your data. What you want to do is aggregate in ways that optimize the…/XtraDB tables… Optimize For I/O It is pretty much inevitable: if you do this kind of data processing in MySQL, you… Infobright. While I have not evaluated their technology in depth, I think it merits a good look. I had…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… gains. Schema, query, and index optimization Analyzing and optimizing a server’s table and index… first rule. The customer determines the depth and complexity of the analysis we …
Post: MySQL 6.0 Subquery optimizations are published.
February 6, 2008 By 4 Comments
… brought to my attention the work Optimizer Team has done in MySQL 6.0 related to SubQuery Optimization. I am excited to see… bug sampling done by Optimizer Team 68% of reported issues are fixed (significantly improved) by changes in MySQL 6.0 which is… features as developers often able to go much more in depth and explain those boring details you can see omitted by…
