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
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.
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
:[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 2004070100
Would