MySQL Forums
Forum List  »  MyISAM

Closing tables very slow
Posted by: Jérémy Cabantous
Date: June 07, 2011 06:00AM

Hi everybody,

i have an issue with a myisam table, the insertions are very very slow.

My table looks like this :
CREATE TABLE `email_md5` (
`id_email_md5` int(11) NOT NULL AUTO_INCREMENT,
`md5` varchar(32) NOT NULL,
`id_email` int(10) unsigned DEFAULT NULL,
`id_profile` int(11) DEFAULT NULL,
PRIMARY KEY (`id_email_md5`),
FULLTEXT KEY `ik_md5` (`md5`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

I have a fulltext index on the field "email_md5".
When i have less then 2 millions records, everything works great but when it grows over 2 millions records the insertions are very slow (i.e i make an insertion of 200 000 records on each query. My insertion looks something like "INSERT INTO email_md5 (md5, id_email, id_profile) VALUES ('4356fb2763546983ac9e9c07e9ebd3c8', 2, 5), ('227bfac8255f4a9c57b9d86c05ee31ce', 52, 98), ...).

Actually, when i make a "show process list" during the process, it seems that the state "closing tables" is taking so much time. The insertion takes something like 120 seconds and the "closing tables" takes about 300 or 400 seconds !!!!!

I've made a research on the web but i didn't find any accurate answer.

Is anybody have an idea ? :)

Thanks a lot.

Options: ReplyQuote


Subject
Views
Written By
Posted
Closing tables very slow
8156
June 07, 2011 06:00AM
3209
June 08, 2011 10:16PM


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.