Ratheesh K J wrote:
Hlo,
I got this Stat of MySQL. I want to know is there something to worry about,
especially the number of temp tables.
That looks like a sign of missing indexes.
Temporary tables shouldn't be created that often if your queries are
indexed properly, even though they're not showing up as "slow queries".
It'll be a pain but you could write a script to go through your queries
and 'explain' then and see which ones are using temp tables and see
whether they need additional indexes.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]