Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » Sporadically slow MyISAM inserts
Sporadically slow MyISAM inserts [message #1572] Sat, 04 August 2007 16:40 Go to previous message
gjuk is currently offline gjuk
Messages: 2
Registered: August 2007
Junior Member
I have a simple MyISAM table (8 fields; 22 bytes per row plus c. 40 bytes of index per row). Currently, the table has several million rows - and I run frequent bulk inserts, each of a few few hundred thousand rows. Typically, it inserts c. 5000 rows per second, but occasionally a row takes 5-60 seconds to insert. This happens perhaps every 2,000-20,000 rows or so. I notice that the IO wait in Linux 'top' command can go as high as 90% during the insert process, so guess it's to do with disk writing. Is there any buffer which could help?
Thanks!

[Updated on: Sat, 04 August 2007 16:41]

Report message to a moderator
[Message index]

Read Message
Read Message
Read Message
Read Message
Previous Topic:Optimizing a search query
Next Topic:Restore of Database Backup
Goto Forum:

  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Thu Jul 9 22:01:33 EDT 2009

Total time taken to generate the page: 0.03877 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.