Log MySQL-executed SQL

Compare Oracle features to learn MySQL always find highlights

The ability to log mining in Oracle allows you to find all the records that have been executed;

MySQL also provides 3 methods {validated, I will record specific practices}

Method 1:{Verified}

Record all of MySQL's records
Open/ETC/MY.CNF
Add below [mysqld]
Log =/mnt/mydata/sql.log

Restart MySQL
View/mnt/mydata/sql.log File

Method 2:{temporarily not verified}

Check the SQL syntax for slow query:
Log_slow_queries =/var/log/mysql/mysql-slow.log
Long_query_time = 2 (more than 2 seconds of SQL syntax is recorded, it is also a way to set a short point to record the error.)

Method 3:{temporarily not verified}

Set MySQL replication with Binlog:

Log_bin =/var/log/mysql/mysql-bin.log (this file is to be seen with the Mysqlbinlog solution,
Mysqlbinlog mysql-bin.000042| grep "T_ABC" | grep "Column Value"
MySQL will write all the insert/update/delete syntax in this (but the syntax may be different from what you think), which is the log file to write to slave

Log MySQL-executed SQL