MySQLTuner does not work

[Nirjonadda]

We do run MySQLTuner but this does not completed. Please can you let me know that how can fix this issue?

[mathieu-aubin]

Try this.. maybe

• Stop your sql instance
• Rotate or empty the log file at /var/log/mysqld.log
• Restart your sql server
• Try again

I believe your GIGANTIC logfile is giving you issues. Probably your sql instance logs are set to some high verbosity logging which results in big log files. Also, it could be that there are never any log file rotation being done on the actual file - which means your logfiles contains everything from the initial start of the instance, whenever the machine was created.

To rotate your logs automatically and thus keep them relevant and of a decent size on a daily or, even, weekly/monthly basis, check out logrotate

Hope this helps. Also, check if there is a skip-log option of some sort (i have no idea)

[jmrenouard]

Hi,

First as @mathieu-aubin says implementing a log rotation can be nice.

Maybe a control other file size greater than 200 Mb can be nice with a message advising implementing a log rotation strategy can be good.

BR,

[grooverdan]

closed via:
938b434#diff-126d6c210bc4ad821cc428b8034b177003fc7171ac178088fdf6ce91cb787867R1301

Last 30k line are read.

[jmrenouard]

Fell free to reopen if needed