…dirty page – This graph will contain the percentage of dirty pages in the InnoDB buffer pool. This value is … the initial run. Later I will change them in searching for optimal values. innodb_file_per_table = true …_max_dirty_pages_pct value. As you saw in the results above, 50 and 70 are not good …
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… deal with different systems and so acquire different feeling about percentage of cases when disk would be the problem. However it… is doing all search heavy lifting we only need to insert new data and fetch few rows to show search results which does not require too much IO capacity or high in memory fit. For large number…
Post: How (not) to find unused indexes
October 16, 2009 By 2 Comments
… the window of time it is searching in is too wide. Side Note: In some texts you’ll see people …to quote this as an exact percentage, since this value is not fixed in MySQL and can be a much… and then find someway to parse and EXPLAIN all results, then subtract the indexes that were mentioned from …
