New answers tagged percona
Percona themselves have written a tool for this very purpose - it's called pt-index-usage and is to be found here. From the DESCRIPTION: This tool connects to a MySQL database server, reads through a query log, and uses EXPLAIN to ask MySQL how it will use each query. When it is finished, it prints out a report on indexes that the queries didn’t ...
File: libraries/dbi/DBIMysqli.class.php 138 public function connect( before return link you can run query: 223 $link->query("SET SESSION wait_timeout = 600"); 224 return $link; This would set any session to mysql db from phpmyadmin with wait_timeout = 600.
Top 50 recent answers are included