How to Access MySQL Error Logs?

In this blogpost you will see the root cause of slowdowns, crashes, or other unexpected behaviour in MySQL which can be determined by analysing its error logs. I'm using Ubuntu system on which the default location for the MySQL is /var/log/mysql/error.log. These error logs are most easily read with the less/more program, a command line utility that allows you to view files but not edit them:

Command:

sudo less /var/log/mysql/error.log
sudo more /var/log/mysql/error.log

If MySQL isn’t behaving as expected, you can obtain more information about the source of the trouble by running this command and diagnosing the error based on the log’s contents.

That's all in this post. If you liked this blog and interested in knowing more about MySQL, Please Like, Follow, Share & Subscribe to imjhachandan.com