Re: Insertion takes very very long time

[Bill Karwin]

Questions:

- Did you use autocommit on the slow system? This would cause a transaction to be committed and data flushed to disk after every row you insert.

- Is the datadir for the MySQL instance on a local drive? I'm asking because you mention that you have multiple systems with MySQL. Some people try to put the datadir on a network-accessed filesystem (aka mapped drive). This is not recommended. Network filesystems are much slower than local drives. As well as being subject to outages, vulnerable to security problems, and can also result in contention problems if two MySQL instances attempt to write to the same data files.

- Likewise I'd ask if the datadir is on a real hard drive, not a flash drive, USB drive, zip disk, CD-RW, etc. Those interfaces can be much slower than ATA, SCSI, or firewire interfaces.

- What else is running on the system where the database is so slow? Could it just be an issue of too many software apps competing for I/O resources?

Regards,
Bill K.