I have checked the queries. They look quite ok. We have a lot lot of CREATE
TEMPORARY TABLE running every second.
How else can tmp tables be created? What is the exact relation between
missing index and tmp tables being created. Do you mean to say in sorting?
----- Original Message -----
From: "Chris" <[EMAIL PROTECTED]>
To: "Ratheesh K J" <[EMAIL PROTECTED]>
Cc: <mysql@lists.mysql.com>
Sent: Wednesday, September 27, 2006 12:50 PM
Subject: Re: Mysql Stat - Help required
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]
