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