Enable MySQL logging by default

Any reason we have mysql logging disabled on default Hestia install? I guess this should be ENABLED by default for new installs… or atleast if advanced sysadmins can have an install ‘switch’ to enable it by default.

What logs?

log_error is enabled by default:

log_error=/var/log/mysql/error.log

If you talk about general_log, it SHOULDN’T be enabled by default, enabling this log is a performance killer so it should be only activated when you want to test, check or debug some issues with your DBs.

2 Likes

I also think that it shouldn’t be enabled by default. It’s enabled when needed for a limited time.

No, the error log is NOT enabled by default… thats why this post.

Just to confirm, mysql error log is enabled in all available config files: hestiacp/install/deb/mysql/my-small.cnf at 0599d144faa4d91d20f11057eb374ba6246fff98 · hestiacp/hestiacp · GitHub

@mehargags could you please specify, which exact log do you mean?