…unused indexes that could be removed. Collecting data It’s quite easy to collect statistics about index usage in Percona Server…find the set of indexes in all_indexes, but not in used_indexes. These indexes (if our original index…
Post: Advanced index analysis with mk-index-usage
November 11, 2010 By 2 Comments
… indexes are used in more flexible ways. The default report just prints out ALTER statements for removing unused indexes… store the index usage into tables in a database, so you can query them with SQL. I… EXPLAIN and find out the index usage on the remote server, and store the results in my MySQL …
Comment: Unused indexes by single query
September 14, 2008 By 14 Comments
…unused indexes. This patch, like any patch, should probably only be used on a non-production server. A non-production server…server (you could dump the SQL general query log – which will be very large – and replay it on a non-production server…index, do some performance testing to find…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…much unusable. …in parent table `test/parent`, in index `PRIMARY`, the closest match we can find…in use 1, locked 0 MySQL thread id 8079, query id 728899 localhost root Sending data select sql…in queue 1 read views open inside InnoDB Main thread process no. 10099, id 88021936, state: waiting for server…
