We're eager to announce a
Settings button for every MySQL server. This means you can set values for some of the variables, from the web interface. The UI is simple and user-friendly, and we’re sure this will improve access and flexibility for our customers' servers. We want to showcase this new feature, using the innodb_flush_log_at_trx_commit variable:
There are 2 recommended options for this variable.
- The safest option. But a lot more disk write operations.
- The fastest option. It reduces write-load a lot, but you can lose 1 second of data if there is a power failure or kernel crash.
In most web app situations, it is acceptable to set this variable to 2. But if you are handling critical or sensitive data the value should be 1.
You can now set this value using the web interface.