Sydney Puente <sydneypuente <at> yahoo.com> writes:
>
> I am currently inserting about 10 rows (2 varchar 50 fields ) a sec into
modern 4 processor RH 5.x box using
> perl Net::Mysql from another box of similar spec.
> This is rather less than expected. I suspect I could push the inserts from
the source box much faster than that.
What table type are you inserting into? If it is an older version of innodb and
you have an autoinc key, you might be running into the global autoinc lock issue
(bug?) <http://dev.mysql.com/doc/refman/5.0/en/innodb-auto-increment-handling.html>
Another option is to have multiple threads doing the inserts.
>
> And that it is the target box that is the problem. Top reveals it has a load
average of 2 to 3.
What about your iostat figures? Are you bound by your disk i/o?
