, grouping, table joins, subqueries (possibly)..
- Original Message - From: "Chris" <[EMAIL PROTECTED]>
To: "Ratheesh K J" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, September 27, 2006 12:50 PM
Subject: Re: Mysql Stat - Help required
Ratheesh K J wrote:
H
-
From: "Chris" <[EMAIL PROTECTED]>
To: "Ratheesh K J" <[EMAIL PROTECTED]>
Cc:
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
abou
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 no
Hlo,
I got this Stat of MySQL. I want to know is there something to worry about,
especially the number of temp tables.
Key Reads/Key Read Requests = 0.007094 (Cache hit = 99.992906%)
Key Writes/Key Write Requests = 0.239130
Connections/second = 8.741 (/hour = 31467.279)
KB received/second =