Menu
When I query the version of my MySQL server (SELECT VERSION()) it returns "5.7.16-log". What does that "-log" stand for?
It's the standard download of the community edition.
443
Getting Started with MySQL Logs To view and modify MySQL system and status variables, go to the Database menu and select the Server Variables command from it. Alternatively, you can see the main configuration file my. cnf.
To disable or enable the general query log or change the log file name at runtime, use the global general_log and general_log_file system variables. Set general_log to 0 (or OFF ) to disable the log or to 1 (or ON ) to enable it.
http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_version says:
version
The version number for the server. The value might also include a suffix indicating server build or configuration information.
-logindicates that one or more of the general log, slow query log, or binary log are enabled.-debugindicates that the server was built with debugging support enabled.
I think it's weird that they decided to mash together those three indicators of the runtime configuration, but it probably dates back to very early days of MySQL. Perhaps at the time it was easier to append strings to the version variable than to introduce multiple indicator variables.
101
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
