Hi, I'm using a db with few tables, one of which is reported below:
CREATE TABLE `keywords` (
`keyword` varchar(128) NOT NULL default '',
`codice` varchar(16) NOT NULL default '',
`timestamp` int(11) NOT NULL default '0',
`soundekw` varchar(32) NOT NULL default '',
PRIMARY KEY (`keyword`,`codice`),
KEY `codice` (`codice`)
) TYPE=InnoDB |
My problem is that after having inserted more than 2-3 times roughly 700000 records
in it, every operation such as
DELETE from keywords;
or
SELECT count(*) from keywords;
slows to a crawl: it takes 15 minutes or so to complete.
Sometimes I even have to dump, zap, recreate and reimport the db.
My system is redhat linux 7.2, Mysql-Max 3.23.46 (official rpm) on a Dual PIII 550,
256 MB ram, Raid 1 on a Mylex Raid card and the following configuration for Innodb:
innodb_data_home_dir = /home/share/innodb/
innodb_data_file_path = ibdata1:512M
set-variable = innodb_mirrored_log_groups=1
innodb_log_group_home_dir = /home/share/innodb/log/
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=5M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=0
innodb_log_arch_dir = /home/share/innodb/log/
innodb_log_archive=1
set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_additional_mem_pool_size=2M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
I know this configurations doesn't look aggressive at all, but it shouldn't even lead
to such a slow-down.
Can anyone help me please?
Thanks,
Nico
---------------------------------------------------------------------
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
