… systems and so acquire different feeling about percentage of cases when disk would be the problem… in MySQL Instance without getting in too much trouble with backups etc – because Sphinx is doing all search … to show search results which does not require too much IO capacity or high in memory fit. …
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… page – This graph will contain the percentage of dirty pages in the InnoDB buffer pool. This value …the initial run. Later I will change them in searching for optimal values. innodb_file_per_table = …line in MySQL 5.5.8. But, finally, let me show the result I got running Percona Server in optimized…
Post: How (not) to find unused indexes
October 16, 2009 By 2 Comments
… of time it is searching in is too wide. Side Note: In some texts you’ll see…percentage, since this value is not fixed in MySQL and can be a much wider window (15-60%) depending on the circumstances. In… find someway to parse and EXPLAIN all results, then subtract the indexes that were mentioned…
