Over the decades we have been reading the MySQL error log from the server system file, if there are any issues in MySQL or any unknown restart happened , generally we look at the mysql error log.
By default MySQL error log can be found in the default path
/var/log/mysqld.log , or it can be explicitly configured
using the variable
Few drawbacks using MySQL error log as FILE
- Possibility of missing genuine errors while reading lengthy information.
- Filtering of errors for the particular date and timeframes.
- Cannot provide the DB server access to developers because of fear of mishandling DB servers.
To overcome the above issues , from MySQL …[Read more]