MySQL Forums
Forum List  »  Performance

Delete is very slow
Posted by: Aniceto Perez
Date: November 16, 2004 06:52AM

Hi

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.

This is an abstract of my.ini

[mysqld]
basedir=c:/mysql
datadir=f:/mydata/data
memlock
skip-locking
key_buffer = 128M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size= 16M
thread_concurrency = 8
log-bin
server-id = 1
innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 128M
innodb_data_file_path = ibdata1:10M:autoextend
innodb_file_io_threads = 4
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 8M
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

Thanks you
Aniceto Perez

Options: ReplyQuote


Subject
Views
Written By
Posted
Delete is very slow
4432
November 16, 2004 06:52AM
2716
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.