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

+-------------------------+------------------------------+
| Variable_name  | Value  |
+-------------------------+------------------------------+
| innodb_version | 5.5.39  |
| protocol_version | 10   |
| slave_type_conversions |   |
| version  | 5.5.39-log  |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64  |
| version_compile_os | Linux  |
+-------------------------+------------------------------+

--查看系统变量
root@localhost[(none)]> show variables like '%general%';

+------------------+----------------------------+
| Variable_name | Value  |
+------------------+----------------------------+
| general_log | OFF  |
| general_log_file | /var/lib/mysql/suse11b.log |
+------------------+----------------------------+

--查看当前的通用日志，显示无日志文件
root@localhost[(none)]> system ls /var/lib/mysql/suse11b.log 

ls: cannot access /var/lib/mysql/suse11b.log: No such file or directory

--设置变量general_log以开启通用查询日志
root@localhost[(none)]> set @@global.general_log=1;

Query OK, 0 rows affected (0.00 sec)

--再次查看通用日志文件已存在
root@localhost[(none)]> system ls /var/lib/mysql/suse11b.log 
/var/lib/mysql/suse11b.log
root@localhost[(none)]> select * from tempdb.tb1; --执行查询

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

--查看通用日志文件内容
root@localhost[(none)]> system more /var/lib/mysql/suse11b.log
/usr/sbin/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:18:12 4 Query show variables like '%general%'
141003 16:18:55 4 Query select * from tempdb.tb1

b、更改通用查询日志位置

root@localhost[(none)]> exit