Please check if the my.cnf configurations to be the same. What are your configuration parameters in terms of innodh flush log trx commit , bin logging, sync binlog and innodb unsafe for binlog ?
If the systems have raid, check if the BBWC is enabled on the new host and WB is enabled. On Fri, Jun 13, 2008 at 5:02 PM, Ian Simpson <[EMAIL PROTECTED]> wrote: > Hi list, > > 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? > > Thanks, > -- > Ian Simpson > > 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. -- Thanks Alex http://alexlurthu.wordpress.com
