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
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
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
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