Re: stuck commits

2009-01-15 Thread Krishna Chandra Prajapati
Hi Scott, The configuration shows that you are using default mysql configuration with very few enhancement. The enhancement must depends on the size of physical memory available. innodb_buffer_pool_size268M It should be between 50% to 70% of your ram. innodb_additional_mem_pool_s

Re: stuck commits

2009-01-13 Thread Scott Edwards
On Tuesday 13 January 2009 07:23:52 am Krishna Chandra Prajapati wrote: > Hi Scott, > > I believe something wrong with innodb parameters. It should be optimum. In > your case it might be too high or too low. Take a look at log file size. > Please send your show variables and show status data to rea

Re: stuck commits

2009-01-12 Thread Krishna Chandra Prajapati
Hi Scott, I believe something wrong with innodb parameters. It should be optimum. In your case it might be too high or too low. Take a look at log file size. Please send your show variables and show status data to reach at conclusion. On Tue, Jan 13, 2009 at 3:35 AM, Scott Edwards wrote: > All

Re: stuck commits

2009-01-12 Thread Baron Schwartz
You didn't say much about your workload, tuning or table, but... Looks like you have a configuration problem, or slow disks, or InnoDB contention problems. You can get faster hardware, or make your log files or log buffer bigger (but first figure out whether they're too small!), or figure out wha