Open the general query log: record all query logs.The log path defaults to/var/lib/mysqlNext.The name defaults to "machine name.log"

vi/etc/my.cnf

[mysqld]

...

log

...

Open slow query log: record all slow query logs (the valve is 2 seconds in this example).

vi/etc/my.cnf

[mysqld]

...

log-slow-queries=/var/log/mysqlslowquery.log

long_query_time=2

.....