On Mon, Jul 19, 2004 at 07:52:01PM -0000, Aman Raheja wrote: > 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.
If the query is not using an index, it will do full table scan and take a very long time. > 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. Sounds like an operating system or configuration problem. Running a big query against MySQL shouldn't affect a modern operating system's ability to multitask like that. > Has anyone experienced this kind of load. I'm not sure what "kind" of "load" you have yet. This sounds very odd. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
