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 =
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
-
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
, grouping, table joins, subqueries (possibly)..
- 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