Loading...

MySQL Log System

Created2025-06-09|Updated2026-06-15|databasemysql

|Word Count:220|Reading Time:1mins

MySQL Log System

MySQL provides a comprehensive logging system that allows you to record and analyze database activity. The system includes the following components:

General Log: This is the main log file that records all database activity. It is written to disk and can be accessed using the SHOW LOGS statement.
Error Log: This log file records errors that occur during database operations. It is written to disk and can be accessed using the SHOW ERRORS statement.
Slow Query Log: This log file records slow queries that take longer than a specified threshold to execute. It is written to disk and can be accessed using the SHOW SLOWLOG statement.
Binary Log: This log file records all database activity in binary format. It is written to disk and can be accessed using the SHOW BINARY LOGS statement.

Log File Format

The log file format is a tab-separated text file that contains the following columns:

Column	Description
Time	The timestamp of the log entry.
User	The username of the user who executed the query.
Host	The hostname of the server where the query was executed.
Database	The name of the database where the query was executed.
Command	The SQL command that was executed.
Error	The error message associated with the query, if any.
Time	The time taken to execute the query, in seconds.

Author: Chris Wen

Link: https://wenyupeng.github.io/2025/06/09/database/mysql/08-log-file/

Copyright Notice: All articles on this blog are licensed under CC BY-NC-SA 4.0 unless otherwise stated.

Related Articles

Docker Compose Install Mysql

Installing Mysql using Docker Compose12345678910111213141516version: '3'services: mysql: image: mysql:8.0.18 container_name: mysql8 environment: - MYSQL_ROOT_PASSWORD=root# - TZ=Asia/Shanghai volumes: - ./log:/var/log/mysql - ./data:/var/lib/mysql - ./conf/conf.d:/etc/mysql/conf.d # - /etc/localtime:/etc/localtime:ro ports: - 3306:3306 restart: always

MySQL Data Types

MySQL Data TypesThis chapter provides a structured overview of MySQL data types, including numeric, string, temporal, and other specialized types. Understanding these types is essential for esigning efficient and reliable database schemas. Numeric TypesInteger TypesMySQL provides several integer types (e.g., TINYINT, INT, BIGINT) to store whole numbers. Historically, these types allowed an optional display width (M). Key points: The display width (M) defines the minimum display width, not t...

MySQL Functions

MySQL FunctionsMySQL provides a wide range of built-in functions that can be used to perform various operations on data. These functions can be categorized into several types, including string functions, numeric functions, date and time functions, and aggregate functions. String FunctionsString functions are used to manipulate and analyze string data. Some common string functions include: CONCAT(): Concatenates two or more strings. COMPARE(): Compares two strings and returns 0 if they are eq...

MySQL Installation Guide

MySQL Basic InformationMySQL is an open-source relational database management system (RDBMS) that uses Structured Query Language (SQL) for managing and manipulating data. It is widely used for web applications, data warehousing, and various other applications due to its reliability, performance, and ease of use. MySQL ArchitectureMySQL follows a client-server architecture, where the MySQL server manages the database and handles client requests. The server consists of several components, inclu...

Join QueryA JOIN query is used to combine rows from two or more tables based on a related column between them. There are several types of JOINs in MySQL, including INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN. INNER JOINThe INNER JOIN returns only the rows that have matching values in both tables.1234SELECT columnsFROM table1INNER JOIN table2ON table1.common_column = table2.common_column; LEFT JOINThe LEFT JOIN returns all rows from the left table and the matched rows from the right...

MySQL Transaction

TransactionA transaction in MySQL is a sequence of one or more SQL operations that are executed as a single unit of work. Transactions ensure that either all operations are completed successfully or none of them are applied, maintaining the integrity of the database. This is particularly important in scenarios where multiple operations need to be performed together, such as transferring funds between accounts. DDL (Data Definition Language) statements like CREATE, ALTER, and DROP are not par...

Loading Database