On Wed, Sep 25, 2002 at 11:33:37PM +0300, Gergely Imre wrote: > > hi all > > i've mysql 2.32.52 installed, and there is a table with nearly 2.000.000 > records in it (4 field/record). i have 256megs of RAM, and the linux > version is RedHat 7.3. i do a simple delete, like: > > delete from foo_db where foo>10; (this is around 15.000 record) > > and after 30 minutes, still nothing. the load is over 2, minimal disk > activity. the filesize is around 300MByte. what could be wrong with this? > why is it so slow?
Is foo indexed? Do you have a large key_buffer? What does "EXPLAIN SELECT * FROM foo_db WHERE foo > 10" say? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 50 days, processed 1,069,481,946 queries (244/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
