question Re: mysql log cleanup on a Hive server in Support Questions

mysql log cleanup on a Hive server

MikeB — Wed, 08 Dec 2021 16:32:51 GMT

I have a Hive server in my cluster running a MySQL instance. The logfile /var/run/mysqld/mysqld.log is getting really large and I need to figure out the proper way to prune it.

The server it's running on is CentOS 7. Can I just 'cat /dev/null > mysqld.log' to clear it out, or are there other considerations? Can I get away with simply stopping the MySQL instance briefly to delete or 'zero out' the file, or do I need to stop all the services on that Hive master node in Ambari?

Please advise if you can.

Thanks,

Mike

Re: mysql log cleanup on a Hive server

PranavM — Wed, 08 Dec 2021 21:18:06 GMT

Hi @MikeB

Make sure you are not running anything on the cluster at the time when you are cleaning up the MySQL log file.

1. Stop the MySQL service.

2. Remove the log file.

3. You can add this parameter in the my.cnf which will limit the size of the MySQL logs on that node.

____

# relay log restrictions

relay-log-space-limit=1G

____

This will limit the new mysqld logs to be of max 1Gb.

Re: mysql log cleanup on a Hive server

rpathak — Wed, 08 Dec 2021 21:22:23 GMT

Please check official mysql documentation as well.

https://dev.mysql.com/doc/refman/5.7/en/log-file-maintenance.html

Re: mysql log cleanup on a Hive server

DianaTorres — Thu, 16 Dec 2021 19:52:54 GMT

@MikeB Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks.