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';