"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
ailto:[EMAIL PROTECTED]
Sent: Tuesday, 20 July 2004 5:52 AM
To: [EMAIL PROTECTED]
Subject: query locking up the system
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 > 2004
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
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 million records and 78GB (MYD)
I've been waiting forever to get any output
