hi! >>>>> "Arjen" == Arjen Lentz <[email protected]> writes:
Arjen> Hi Arjen> On 10/03/2010, at 9:29 PM, [email protected] wrote: >> ----------------------------------------------------------------------- >> WORKLOG TASK >> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- >> =- >> TASK...........: Index usage tracker >> CREATION DATE..: Wed, 10 Mar 2010, 11:29 >> SUPERVISOR.....: Bothorsen >> >> >> DESCRIPTION: >> >> What indexes are needed is often easy to find. What is more >> difficult is to find >> which indexes are not used at all. >> >> Thus some statistics about the index usage would be nice. >> >> I think Percona has already something like this done some time ago. >> And big O >> has similar functionality. Arjen> For appropriate credit: it comes from the Google patches, released by Arjen> Mark Callaghan. Arjen> It's in the Percona and OurDelta 5.0 builds. Arjen> SHOW INDEX STATISTICS, or more useful the INDEX_STATISTICS table in Arjen> information_schema. Arjen> More useful since then it can be LEFT JOINed onto the other infoschema Arjen> tables that know which indexes exist, thus easily identifying unused Arjen> ones. Arjen> For reference on what the table shows, see the patch - easy to find in Arjen> the lp:ourdelta repo. Arjen> Let's not just reinvent from scratch please. The patches are already in MariaDB 5.2 since some time ago. I have updated the worklog accordingly. Regards, Monty _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
