Subject: Re: Can I measure the use of index?
For the record mariadb also has table and index statistics. Including
statistics on temporary tables.
On Mon, Oct 15, 2012 at 8:34 PM, Lixun Peng pengli...@gmail.com
wrote:
Hi,
If you are using Percona Server, you can use this query
Afternoon
Somebody knows how can I log or measure the index use ?
Thanks
Carlos
Am 15.10.2012 17:24, schrieb Carlos Eduardo Caldi:
Afternoon
Somebody knows how can I log or measure the index use ?
explain select whatever from table where bla=value
signature.asc
Description: OpenPGP digital signature
I want to count how many time one index was used during a day, do you now how
to log it to count?
Date: Mon, 15 Oct 2012 17:27:54 +0200
From: h.rei...@thelounge.net
To: mysql@lists.mysql.com
Subject: Re: Can I measure the use of index?
Am 15.10.2012 17:24, schrieb Carlos Eduardo
On Mon, Oct 15, 2012 at 11:24 AM, Carlos Eduardo Caldi
ce_ca...@hotmail.com wrote:
Somebody knows how can I log or measure the index use ?
http://www.percona.com/doc/percona-toolkit/2.1/pt-index-usage.html
- Perrin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi,
If you are using Percona Server, you can use this query:
SELECT DISTINCT s.table_schema,
s.table_name,
s.index_name
FROM information_schema.statistics `s`
LEFT JOIN information_schema.index_statistics indxs
ON ( s.table_schema =
For the record mariadb also has table and index statistics. Including
statistics on temporary tables.
On Mon, Oct 15, 2012 at 8:34 PM, Lixun Peng pengli...@gmail.com wrote:
Hi,
If you are using Percona Server, you can use this query:
SELECT DISTINCT s.table_schema,