How many types of logs are there in MySQL?
|Log Type||Information Written to Log|
|Error log||Problems encountered starting, running, or stopping mysqld|
|General query log||Established client connections and statements received from clients|
|Binary log||Statements that change data (also used for replication)|
Which SQL command do you use to force MySQL to start new log files? You can force MySQL to start using new log files by using mysqladmin flush-logs or by using the SQL command FLUSH LOGS. If you are using MySQL Version 3.21 you must use mysqladmin refresh.
What is audit log in MySQL? When installed, the audit plugin enables MySQL Server to produce a log file containing an audit record of server activity. The log contents include when clients connect and disconnect, and what actions they perform while connected, such as which databases and tables they access.
How do I delete a MySQL log file?
- Step 1: Check binary logs size under the dump directory.
- Step 2:Connect DB and show MySQL binary logs.
- Step 3: Remove old Binary logs.