Lately, I have been getting many warnings on my MySQL Server, getting into some crashes and restarting.
I looked at the status of MySQL and found the logs stating,
mysql.service: Main process exited, code=killed, status=9/KILL
To analyse this correctly, I looked at the MySQL logs at /var/log/mysql directory.
However, log rotation was enabled, compressing the previous log files.
To read all of these files means I will have to extract each one and then open them.
But there is a better way, using the command zcat
To use this command, you need to pass on the path of the gzip file as the argument.
zcat /var/log/mysql/error.log.1.gz
![](https://i0.wp.com/www.anubhavranjan.me/wp-content/uploads/2023/06/MySQL-Error-Log.png?resize=500%2C94&ssl=1)