check for iostat to see if the disk is heavly used.
On 6/13/08, Ian Simpson <[EMAIL PROTECTED]> wrote: > > Hi Alex, > > Configurations are identical, other than the differences I initially > mentioned. I've diffed both the configuration files and the output of > SHOW VARIABLES on both servers. > > I've contacted my hosting provider to ask about the RAID settings. > > Variable_name: innodb_flush_log_at_trx_commit > Value: 1 > Variable_name: sync_binlog > Value: 0 > Variable_name: innodb_locks_unsafe_for_binlog > Value: OFF > > Thanks > > -- > Ian Simpson > > On Fri, 2008-06-13 at 17:43 +0530, Alex Arul Lurthu wrote: > > 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 > > 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.