"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
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 [mailto:[EMA
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
