How to view SQL executed by MySQL.

Sometimes when the program is updated, the database load suddenly comes up, or the number of concurrent doubled. This time if with show full processlist; There is no full SQL at all. How to see what SQL is causing it, on the Internet to check the information, there are several methods.

1. Log Slow logs:

Long_query_time = 1

Log_slow_queries =/tmp/mysql-slow.log

2. View the bin Log

Mysqlbinlog mysql-bin.000042 |grep "Table_map" > Xyq.sql

3. Each line of instructions that MySQL executes can be recorded.

Log =/tmp/mysql.log

How to view SQL executed by MySQL.