…INNODB STATUS output and how to use this info to improve MySQL Performance. To start with …to avoid too many threads competing to enter innodb queue at the same time Innodb makes thread to sleep for some time before trying to…be 16K – page size, for full table scan or index scan read-ahead may be …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…to be fixed. How to optimize the program without compromising data integrity is a constant question. Relative to…MySQL. My main advantage: I have been able to avoid modifying any part of MySQL to…MySQL to do things like open a table…
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
…of MySQL Performance problems. Here is what you need to know about ORDER BY … LIMIT optimization to avoid…it is rare category large portion of table may be scanned to find 10 rows. So index on (…to watch for, if you do not have full where clause resolved by index is how many rows you need to scan to…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…to a temporary table; ALTER TABLE and OPTIMIZE TABLE always process tables containing foreign keys as if expand_fast_index_creation is OFF to avoid…full table rebuild on foreign key changes. So adding them back with a separate ALTER TABLE…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
…that are consuming most MySQL time and that’s how mk-query-digest groups…Full scan 7% yes, 92% no # QC Hit 78% yes, 21% no # Tmp table 2% yes, 97% no # Tmp table…know exactly what needs to be fixed first to make the greatest impact to this page…within a group so I would avoid the extra step, but then …
