MySQL Log Management Learning notes

SHOW GLOBAL VARIABLES like '%log% '

Error log: Information in the server startup or shutdown process

Error message during server run

Information generated when the event Scheduler runs an event

Information generated from the server process when it is started from the server

Log_error

Log_warnings

General Query log:

General_log

General_log_file

log_output={table| file| Noen}

Slow query log: Query time exceeds a specified time log

Long_query_time specified time-out

log_slow_query={on| OFF}

Slow_query_log

Slow_query_log_file

Start slow query log: SET GLOBAL slow_query_log=1;

The change log file must edit the configuration file and restart the server, simply hit

Open and close to operate directly

Binary log: Any operation that causes or may cause changes to the database (DDL,DML)

；

Replication, Instant Point recovery

Binary log format:

Statement based: statement

Row-based: row

Mixing mode: Mixed

Binary Log events:

Time of Generation

Relative position

Binary log files:

Index file

Binary log files

To view the binary log files that are currently in use

Mysql>show MASTER STATUS;

To view supported binary log files

Mysql>show BINARY LOGS;

viewing binary log files

Mysql>show BINLOG EVENT in ' binary log

File name ' [from POS];

Clear the previous log file

Mysql>purge BINARY LOGS to ' log file '

Manual scrolling of binary log files

Mysql>flush LOGS;

Mysqlbinlog: Tool to read statements from binary logs:

--start-datetime

--stop-datetime

--start-position

--stop-position

Relay log: From the server, copy from the binary log file of the primary server and

To the event, and save the log file as

Transaction log: The transactional storage engine is used to ensure atomicity, consistency, isolation,

Durability.

Innodb_flush_log_at_trx_commit:

0: Synchronize every second and perform a disk flush operation

1: Each thing synchronizes and performs a disk flush operation

2: Everything is synchronized, no disk flush operation is performed

Storage Engine:

MyISAM:. frm. MYD. MYI

Does not support things, only table locks are supported, foreign keys are not supported, support B

Tree index, fulltext Index, spatial index, support table compression

InnoDB:. frm. ibd

Support for things, row-level locks, support for B-tree indexes, clustered indexes,

Adaptive hash index, table space, raw disk device (bare device)

This article is from the "Godben" blog, make sure to keep this source http://godben.blog.51cto.com/8919725/1695170

MySQL Log Management Learning notes