Have a bit of a mystery here that I hope somebody can help with.
I've just got a new server that I'm using as a dedicated MySQL server.
In terms of hardware it's pretty much identical, if not slightly
superior to an existing server already in production use.
It's having a real struggle processing INSERT statements to InnoDB
tables; it's maxing out at around 100 inserts per second, even with very
simple two column tables (inserts into MyISAM tables run fine).
Meanwhile, the original server can happily process around 1000
inserts/sec into an identical table.
The MySQL configuration of the two databases is identical, except for
the tablespace file size (the new server has a larger tablespace
defined), and the InnoDB logs (again, new server has larger logs).
Can anybody suggest an area of investigation as to the cause?
This email may contain confidential information and is intended for the recipient(s) only.
If an addressing or transmission error has misdirected this email, please notify the
author by replying to this email. If you are not the intended recipient(s) disclosure,
distribution, copying or printing of this email is strictly prohibited and you should
destroy this mail. Information or opinions in this message shall not be treated as neither
given nor endorsed by the company. Neither the company nor the sender accepts any
responsibility for viruses or other destructive elements and it is your responsibility to
scan any attachments.