mysql日志文件

mysql> set global log_output='table';
Query OK, 0 rows affected (0.00 sec)

 

设置日志的输出到数据库中的表中。

mysql> select * from mysql.general_log;
+---------------------+------------------------------+-----------+-----------+--------------+--------------------------------------------------+
| event_time          | user_host                    | thread_id | server_id | command_type | argument                                         |
+---------------------+------------------------------+-----------+-----------+--------------+--------------------------------------------------+
| 2015-02-27 13:45:02 | root[root] @ localhost [::1] |         2 |         1 | Query        | show databases                                   |
| 2015-02-27 13:45:09 | root[root] @ localhost [::1] |         2 |         1 | Query        | SELECT DATABASE()                                |
| 2015-02-27 13:45:09 | root[root] @ localhost [::1] |         2 |         1 | Init DB      | information_schema                               |
| 2015-02-27 13:45:11 | root[root] @ localhost [::1] |         2 |         1 | Query        | show tables                                      |
| 2015-02-27 13:46:06 | root[root] @ localhost [::1] |         2 |         1 | Query        | desc tables                                      |
| 2015-02-27 13:46:23 | root[root] @ localhost [::1] |         2 |         1 | Query        | select * from tables where table_name='slow_log' |
| 2015-02-27 13:46:27 | root[root] @ localhost [::1] |         2 |         1 | Query        | SELECT DATABASE()                                |
| 2015-02-27 13:46:27 | root[root] @ localhost [::1] |         2 |         1 | Init DB      | mysql                                            |
| 2015-02-27 13:46:30 | root[root] @ localhost [::1] |         2 |         1 | Query        | show tables                                      |
| 2015-02-27 13:46:43 | root[root] @ localhost [::1] |         2 |         1 | Query        | select * from general_log                        |
+---------------------+------------------------------+-----------+-----------+--------------+--------------------------------------------------+
10 rows in set (0.00 sec)

SET GLOBAL log_output=FILE;设置日志文件保存到文件中

临时禁用日志

set global log_output='NONE';

清楚编号比40小的二进制日志文件

puge master logs to 'binlog.000040';