|

MySQL log file quickly filling and growing large

While optimizing our MySQL server we noticed our mysqld.log was huge in size – 1GB+ – and it was filling every moment with the below message:

[Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'

Below article explains the issue
https://support.cpanel.net/hc/en-us/articles/16550190886935-MySQL-log-warning-mysql-native-password-is-deprecated-and-will-be-removed-in-a-future-release

But it seems there is no solution for it yet. We applied the workaround by setting log_error_verbosity to 1 from 2. Which is not ideal, since we will have less info on whats going on, but it was growing pretty rapidly and was pretty unbearable so we had to do it.

The topic was identified 8 months ago and still waiting for a fix

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *