MySQL: Log Management: overview

MySQL supports a variety of system logs and provides comprehensive system errors, events, and business logic recording, tracking, diagnosis, and query functions!

Log Type	Information written Log
The Error Log	Problems encountered starting, running, or stoppingMysqld
The general query log	Established client connections and statements received ed from Clients
The binary log	All statements that change data (also used for replication)
The slow query log	All queries that took moreLong_query_timeSeconds to execute or didn't use Indexes