… – “Opening Tables“. As Innodb has to recompute the stats first time it opens the table this can take significant amount of time. Plus worst of all there is serialization in the table cache and only one table can be opened at the time as…
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 5 Comments
…tables and it took the server 12 seconds to update all the tables‘ statistics. Luckily, this can be controlled with Percona Server with the variable innodb_stats…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…the table all queries have to be invalidated from the query cache… which can take a lot of time…the cache after table update invalidated a lot of items. Frankly if you improve query cache manageability and make stats available this can…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
…the current stable release in the 5.5 series. All of Percona’s software is open-source and free, all the details of the release can…TIME doesn’t respect QUERY_RESPONSE_TIME_STATS . #855312 (Oleg Tsarev). The mysqldump option –innodb-optimize-keys did not work correctly with tables where the first…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… get much more stats from MySQL and it would be great…tables and other tricks we use when such need arises but we still can… still open. Well may be this is remainder of wild first …the work is going on and it just takes time to get them all fixed. 5. Do not forget about the roots. MySQL has gained its…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
…the current stable release in the 5.1 series. All of Percona’s software is open-source and free, all the details of the release can…TIME doesn’t respect QUERY_RESPONSE_TIME_STATS . #855312 (Oleg Tsarev). The mysqldump option –innodb-optimize-keys did not work correctly with tables where the first…
