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. _______________________________________________ Mailing list: https://launchpad.net/~ourdelta-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~ourdelta-developers More help : https://help.launchpad.net/ListHelp

