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]