MySQL Forums
Forum List  »  Performance

Re: Delete is very slow
Posted by: Arjen Lentz
Date: November 16, 2004 08:16AM

Aniceto Perez wrote:
> I have mySQL 4.1.7 installed in W2k SP4, etc, 512 M of RAM and Pentium IV HT 3.2 MB (equiv to 2
> CPU). I'm also a new user. I'm testing a 4 M register table with InnoDB and MyISAM. I find
> mySQL extremely slow. The table has 20 fields and 14 indexes, all RTREE. The DELETE operations are
> very very very slow. To DROP this table (InnoDB) has taken 10 hours.

InnoDB doesn't have R-Trees. It uses B-Trees.
Please check which storage engine you're using for this table and what type the indexes are?
SHOW CREATE TABLE ... gives a proper overview.
Thanks.

Regards, Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Remote expertise & maintenance for MySQL/MariaDB server environments.

Follow us at http://openquery.com/blog/ & http://twitter.com/openquery

Options: ReplyQuote


Subject
Views
Written By
Posted
4187
November 16, 2004 06:52AM
Re: Delete is very slow
2599
November 16, 2004 08:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.