You’ve already read it in What’s new in 5.7 (So Far) — the MySQL server now has new-and-improved supported for syslog (on unix-like systems) and EventLog (on Windows). In the next few paragraphs, we’ll take a look at what they are, what has changed, and how they can make your life easier.
The MySQL server supplies information in two main ways:
- The client will receive a reply to every statement. If
everything goes right, then we’ll see a simple OK for success, or
a result set for
SELECT,SHOW, etc.; and even a successful statement may be qualified by a set of warnings or notices. If the statement fails for some reason then we’ll receive an error regarding the failure. - On the server, we’ll see a variety of logs depending on the server configuration. Queries exceeding a certain execution …