The MySQL error log is an essential part of database server performance monitoring. Whenever something goes wrong or performance degrades, the Error Logs are usually the first place we look to start troubleshooting.
The MySQL Error Log is one of three related log types:
- The Error Log: It contains information about errors that occur while the server is running (as well as server start and stop events).
- The General Query Log: This is a general record of what mysqld is doing (connect, disconnect, queries).
- The Slow Query Log: It consists of “slow” SQL statements as defined in the long_query_time global variable.
You can enable error log monitoring to allow Monyog to keep an eye on your MySQL Error Log, and notify you when something goes awry. Moreover, Monyog combines the General Query, Slow Query and Error logs in a single view for both network and cloud servers. For example, in the …[Read more]