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:[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 < 20040701000000 And another mysql> select count(*) from mytab where change > 20040701000000 Would like to mention, the table is 240 million records and 78GB (MYD) I've been waiting forever to get any output. Moreover the server is frozen. No response to the ssh client and I am not even able to login the console - the server is FROZEN. Has anyone experienced this kind of load. The hardware is not an issue - it is a dual processor, 1GB RAM etc. Suggections? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
