also how often do you issue a commit. batching the inserts inside a transaction might help.
On Fri, Jun 13, 2008 at 6:53 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > 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. > > > -- Thanks Alex http://alexlurthu.wordpress.com
