Bug #3055 innodb_flush_log_at_trx_commit value incorrectly set from gui
Submitted: 3 Mar 2004 3:22 Modified: 3 Mar 2004 4:08
Reporter: John Martin Email Updates:
Status: Closed Impact on me:
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.0.1a OS:Windows (WinXP)
Assigned to: Bugs System CPU Architecture:Any

[3 Mar 2004 3:22] John Martin
When setting the "Flush Logs at:" property to "Write to Log and flush every second" on the InnonDB Parameters tab, actually saves the text from the dropdown instead of the values (0, 1 or 2).

This bug prevents the db from restarting do to the configuration error.

How to repeat:
- Start mySQLAdministrator
- Click on Startup Variables
- Click on InnoDB Parameters
- Select "Write to Log and flush every second"
- Click Apply changes
- View my.cnf file and search for the tag innodb_flush_log_at_trx_commit
[3 Mar 2004 4:08] Ulrich Bayer
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at

Additional info:

Thanks, the fix will be in the next release. We have reworked the whole startup variables code quite a bit.