Aman Raheja [EMAIL PROTECTED] wrote:
Has anyone experienced this kind of load.
The hardware is not an issue - it is a dual processor, 1GB RAM etc.
Suggections?
Tell us your MySQL server version, OS version, describe the structure of the table
and if possible show EXPLAIN SELECT on the
On Mon, Jul 19, 2004 at 07:52:01PM -, Aman Raheja wrote:
Hello
I executed a query on my server
mysql select count(*) from mytab where change 2004070100
And another
mysql select count(*) from mytab where change 2004070100
Would like to mention, the table is 240
Aman,
I agree with Jeremy, it sounds like you don't have an index, but the chances
are with a table that large and only 1GB or RAM there could be some heavy
disk action happening.
Could you post the CREATE TABLE and your my.cnf..
Lachlan
-Original Message-
From: Aman Raheja