ourdelta-developers team mailing list archive

[Arjen Lentz <arjen@xxxxxxxxxxxxx>]

Hi Vadim

On 14/10/2009, at 2:54 PM, Vadim Tkachenko wrote:
> Can InnoDB actually increase log_files automatically (i.e. from  
> default 5M to 50M ) ?

That'd be nice, if possible.
But also in some cases you'd want to reduce it, if someone previously  
set up something much too big.


> In current way it will cause a lot of confusing, you set 1000M, but  
> system still runs on 5M


It'll give the warning in errorlog/syslog, which is better than the  
current behaviour of aborting - that hinders progress even for new  
installations.

If you can do a resize up and down, that'd be excellent!


Cheers,
Arjen.
-- 
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Exceptional Services for MySQL at a fixed budget.

Follow our blog at http://openquery.com/blog/
OurDelta: enhanced builds for MySQL @ http://ourdelta.org

-- 
Feature req: innodb_log_file_size smarter on startup
https://bugs.launchpad.net/bugs/303124
You received this bug notification because you are a member of OurDelta-
developers, which is the registrant for OurDelta.

Status in OurDelta - Builds for MySQL,MariaDB: Fix Committed
Status in Patches for MySQL by Percona: Confirmed

Bug description:
Feature request:
On InnoDB startup, check whether the iblog files exist, and what size they are.
Feed that size back into the innodb_log_file_size, regardless of what it was.
If it was different, you can write a warning to errorlog, but no error/abort.

This little tweak would allow us to increase the default log file size, without breaking existing installations.