mysql时间函数使用 MySQL中开启和使用通用查询日志的实例jrs看球网直播吧_低调看直播体育app软件下载_低调看体育直播(4/7)

root@localhost[(none)]> show variables like 'log_output';

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_output | TABLE |
+---------------+-------+

--发布查询
root@localhost[(none)]> select * from tempdb.tb1;

+------+------+
| id | val |
+------+------+
| 1 | jack |
+------+------+

root@localhost[(none)]> system more /tmp/suse11b.log

mysqld, Version: 5.5.39-log (MySQL Community Server (GPL)). started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time  Id Command Argument
141003 16:30:03 1 Query show variables like '%gener%'
141003 16:30:09 1 Query select count(*) from tempdb.tb1
141003 16:31:00 1 Query show variables like 'log_output'
141003 17:00:48 1 Query set global log_output='TABLE' #通用查询日志输出到文件仅仅记录到全局变量的修改

--mysql.general_log记录了通用查询日志的信息
root@localhost[(none)]> desc mysql.general_log;

+--------------+------------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default  | Extra  |
+--------------+------------------+------+-----+-------------------+-----------------------------+
| event_time | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| user_host | mediumtext | NO | | NULL  |  |
| thread_id | int(11) | NO | | NULL  |  |
| server_id | int(10) unsigned | NO | | NULL  |  |
| command_type | varchar(64) | NO | | NULL  |  |
| argument | mediumtext | NO | | NULL  |  |
+--------------+------------------+------+-----+-------------------+-----------------------------+

--从通用查询日志表里查看通用查询日志的内容
root@localhost[(none)]> select thread_id,command_type,argument from mysql.general_log;