… making 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…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
….commanual Opened_table_definitionsblogpercona.commanual Opened_tablesblogpercona.commanual optimizer_prune_levelblogpercona.commanual optimizer_search_depthblogpercona.commanual optimizer_switchblogpercona.commanual partitionblogpercona.commanual performance_schemablogpercona.commanual…
Comment: Joining many tables in MySQL - optimizer_search_depth
April 23, 2012 By 8 Comments
… point of my blog post is what default value of optimizer_search_depth is impractical as 62! which is potential number of combinations… it needs to be lowered down significantly in the cases optimizer spends too much time choosing the plan. I’ve looked at playing with optimizer_prune_level variable which is another one available. The default…
Comment: Joining many tables in MySQL - optimizer_search_depth
April 23, 2012 By 8 Comments
… the 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…, the server should analyze the query and should determine the search depth based on some syntactic properties and knowledge of indexes. The…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…Would be interesting to play with read-ahead depth here. These settings mean there can be…index fragmentation, without having to run the OPTIMIZE? HT: Since OPTIMIZE rebuilds the whole table, it may…00 hash searches/s, 15979.01 non-hash searches/s HT: Strange, primary key equality searches should work…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… customers who do click analysis, site analytics, search engine marketing, online advertising, user behavior analysis, …still another reason to use InnoDB/XtraDB tables… Optimize For I/O It is pretty much inevitable…While I have not evaluated their technology in depth, I think it merits a good look….
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… pages to speed up row lookup replacing btree search with hash search. This section shows hash table size, number of… can check if your innodb_log_buffer_size is optimal – if you see more than 30% of log buffer…: our book has an updated, more complete, more in-depth explanation of SHOW INNODB OUTPUT…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… same components. Tagging, friends, queues, click tracking, search, paginated displays — we’ve seen these and… big gains. Schema, query, and index optimization Analyzing and optimizing a server’s table and index … our first rule. The customer determines the depth and complexity of the analysis we do….
Post: Percona Welcomes MySQL 5.6!
February 25, 2013 By Leave a Comment
… on the Innodb Full Text Search project was started over 6 years ago, in addition with many optimizer and replication features. We… advantage of MySQL 5.6′s features; create an in-depth upgrade plan; help design and deploy new applications to bring… 5.6 features, as well as Percona’s additions and optimizations. MySQL 5.6 rolls many improvements which previously existed only…
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
… works, new features in the query optimizer, the storage engine architecture, and so on…need full coverage of the breadth and depth of topics, not just the mad scientist … with NoSQL, geospatial functionality, cloud computing, Cluster, search, sharding, memcached, high availability, DevOps, Big Data,…
