…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…
Comment: Joining many tables in MySQL - optimizer_search_depth
April 23, 2012 By 8 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: 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 …buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent …index fragmentation, without having to run the OPTIMIZE? HT: Since OPTIMIZE rebuilds the whole table, it may…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
… “cluster” even on the current hardware for several years. Replication Optimization People often get scared with the fact replication is single thread and often becomes bottleneck so they are using various optimizations including tricky prefetch approaches suggested by YouTube. Interesting enough this…. Summary: So am I denying all MySQL industry practices (which we also covered in a great depth in our book) ? Not really…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… 1148250464, thread declared inside InnoDB 442 mysql tables in use 1, locked 0 MySQL thread id 8079, query id 728899… 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: To UUID or not to UUID ?
March 13, 2007 By 28 Comments
…completely separate problem which can be fixed in MySQL 5.1 Data Clustering This again applies …not, especially if you do not have technical depth to understand all implications and assumptions. I …binary compression. Plus they should be stored in optimized sort order to minimize how random they are …
Comment: InnoDB Flushing: a lot of memory and slow disk
April 1, 2011 By 57 Comments
… the problem! 
) Well, Adaptive Flushing is yet far from optimal in MySQL 5.5, and if it’s not matching your workload… also shorter, and your TPS drops will be smaller in depth.. – and will give you a kind of “throttling” solution if…
Comment: InnoDB Flushing: a lot of memory and slow disk
April 1, 2011 By 57 Comments
… the problem! ) Well, Adaptive Flushing is yet far from optimal in MySQL 5.5, and if it’s not matching your workload… also shorter, and your TPS drops will be smaller in depth.. – and will give you a kind of “throttling” solution if…
Comment: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… the problem! ) Well, Adaptive Flushing is yet far from optimal in MySQL 5.5, and if it’s not matching your workload… also shorter, and your TPS drops will be smaller in depth.. – and will give you a kind of “throttling” solution if…
