MySQL 使用tee记录语句和输出日志

曾经终败给现在 2024-04-18 01:16 16阅读 0赞

在mysql命令行中，使用tee命令，可以记录语句和输出到指定文件。在debugging时会很有用。  
每执行一条语句，mysql都会讲执行结果刷新到指定文件。Tee功能只在交互模式生效。  
  
mysql> tee /tmp/20160908.log  
Logging to file '/tmp/20160908.log'  
mysql> show databases;  
ERROR 2006 (HY000): MySQL server has gone away  
No connection. Trying to reconnect...  
Connection id:    4  
Current database: test  
  
\+--------------------+  
| Database           |  
\+--------------------+  
| information\_schema |  
| mysql              |  
| performance\_schema |  
| test               |  
\+--------------------+  
4 rows in set (0.01 sec)  
  
mysql> use test  
Database changed  
mysql> show tables;  
\+--------------------+  
| Tables\_in\_test     |  
\+--------------------+  
| ADDSubscribers     |  
| Subscribers        |  
| dept               |  
| emp                |  
| t10                |  
| t2                 |  
| t5                 |  
| t50                |  
| t7                 |  
| test               |  
| tmp\_Subscribers\_01 |  
| tmp\_Subscribers\_02 |  
| tmp\_Subscribers\_03 |  
| version            |  
\+--------------------+  
14 rows in set (0.00 sec)  
  
mysql> select \* from emp;  
\+-------+--------+-----------+------+---------------------+------+------+--------+  
| empno | ename  | job       | mgr  | hiredate            | sal  | com  | deptno |  
\+-------+--------+-----------+------+---------------------+------+------+--------+  
|  7369 | SMITH  | CLERK     | 7902 | 1980-12-17 00:00:00 |  800 | NULL |     20 |  
|  7499 | ALLEN  | SALESMAN  | 7698 | 1981-02-20 00:00:00 | 1600 |  300 |     30 |  
|  7521 | WARD   | SALESMAN  | 7698 | 1981-02-22 00:00:00 | 1250 |  500 |     30 |  
|  7566 | JONES  | MANAGER   | 7839 | 1981-04-02 00:00:00 | 2975 | NULL |     20 |  
|  7654 | MARTIN | SALESMAN  | 7698 | 1981-09-28 00:00:00 | 1250 | 1400 |     30 |  
|  7698 | BLAKE  | MANAGER   | 7839 | 1981-05-01 00:00:00 | 2850 | NULL |     30 |  
|  7782 | CLARK  | MANAGER   | 7839 | 1981-06-09 00:00:00 | 2450 | NULL |     10 |  
|  7788 | SCOTT  | ANALYST   | 7566 | 1987-07-13 00:00:00 | 3000 | NULL |     20 |  
|  7839 | KING   | PRESIDENT | NULL | 1981-11-17 00:00:00 | 5000 | NULL |     10 |  
|  7844 | TURNER | SALESMAN  | 7698 | 1981-09-08 00:00:00 | 1500 |    0 |     30 |  
|  7876 | ADAMS  | CLERK     | 7788 | 1987-07-13 00:00:00 | 1100 | NULL |     20 |  
|  7900 | JAMES  | CLERK     | 7698 | 1981-12-03 00:00:00 |  950 | NULL |     30 |  
|  7902 | FORD   | ANALYST   | 7566 | 1981-12-03 00:00:00 | 3000 | NULL |     20 |  
|  7934 | MILLER | CLERK     | 7782 | 1982-01-23 00:00:00 | 1300 | NULL |     10 |  
\+-------+--------+-----------+------+---------------------+------+------+--------+  
14 rows in set (0.03 sec)  
  
使用notee命令来关闭日志记录  
mysql> notee  
Outfile disabled.  
  
查看生成的日志  
\[root@localhost fire\]\# cat /tmp/20160908.log   
mysql> show databases;  
ERROR 2006 (HY000): MySQL server has gone away  
No connection. Trying to reconnect...  
Connection id:    4  
Current database: test  
  
\+--------------------+  
| Database           |  
\+--------------------+  
| information\_schema |  
| mysql              |  
| performance\_schema |  
| test               |  
\+--------------------+  
4 rows in set (0.01 sec)  
  
mysql> use test  
Database changed  
mysql> show tables;  
\+--------------------+  
| Tables\_in\_test     |  
\+--------------------+  
| ADDSubscribers     |  
| Subscribers        |  
| dept               |  
| emp                |  
| t10                |  
| t2                 |  
| t5                 |  
| t50                |  
| t7                 |  
| test               |  
| tmp\_Subscribers\_01 |  
| tmp\_Subscribers\_02 |  
| tmp\_Subscribers\_03 |  
| version            |  
\+--------------------+  
14 rows in set (0.00 sec)  
  
mysql> select \* from emp;  
\+-------+--------+-----------+------+---------------------+------+------+--------+  
| empno | ename  | job       | mgr  | hiredate            | sal  | com  | deptno |  
\+-------+--------+-----------+------+---------------------+------+------+--------+  
|  7369 | SMITH  | CLERK     | 7902 | 1980-12-17 00:00:00 |  800 | NULL |     20 |  
|  7499 | ALLEN  | SALESMAN  | 7698 | 1981-02-20 00:00:00 | 1600 |  300 |     30 |  
|  7521 | WARD   | SALESMAN  | 7698 | 1981-02-22 00:00:00 | 1250 |  500 |     30 |  
|  7566 | JONES  | MANAGER   | 7839 | 1981-04-02 00:00:00 | 2975 | NULL |     20 |  
|  7654 | MARTIN | SALESMAN  | 7698 | 1981-09-28 00:00:00 | 1250 | 1400 |     30 |  
|  7698 | BLAKE  | MANAGER   | 7839 | 1981-05-01 00:00:00 | 2850 | NULL |     30 |  
|  7782 | CLARK  | MANAGER   | 7839 | 1981-06-09 00:00:00 | 2450 | NULL |     10 |  
|  7788 | SCOTT  | ANALYST   | 7566 | 1987-07-13 00:00:00 | 3000 | NULL |     20 |  
|  7839 | KING   | PRESIDENT | NULL | 1981-11-17 00:00:00 | 5000 | NULL |     10 |  
|  7844 | TURNER | SALESMAN  | 7698 | 1981-09-08 00:00:00 | 1500 |    0 |     30 |  
|  7876 | ADAMS  | CLERK     | 7788 | 1987-07-13 00:00:00 | 1100 | NULL |     20 |  
|  7900 | JAMES  | CLERK     | 7698 | 1981-12-03 00:00:00 |  950 | NULL |     30 |  
|  7902 | FORD   | ANALYST   | 7566 | 1981-12-03 00:00:00 | 3000 | NULL |     20 |  
|  7934 | MILLER | CLERK     | 7782 | 1982-01-23 00:00:00 | 1300 | NULL |     10 |  
\+-------+--------+-----------+------+---------------------+------+------+--------+  
14 rows in set (0.03 sec)  
  
mysql> notee  
  
当调用mysql时，使用--tee参数，可以记录这个登录会话的全部日志。  
\[root@localhost ~\]\# mysql -uroot -p --tee=/tmp/20160908\_02.log  
Logging to file '/tmp/20160908\_02.log'  
Enter password:  
Welcome to the MySQL monitor.  Commands end with ; or \\g.  
Your MySQL connection id is 5  
Server version: 5.6.31-77.0-log Percona Server (GPL), Release 77.0, Revision 5c1061c  
  
Copyright (c) 2009-2016 Percona LLC and/or its affiliates  
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.  
  
Oracle is a registered trademark of Oracle Corporation and/or its  
affiliates. Other names may be trademarks of their respective  
owners.  
  
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.  
  
mysql> use test  
Reading table information for completion of table and column names  
You can turn off this feature to get a quicker startup with -A  
  
Database changed  
mysql> select \* from test;  
\+------+-------+  
| id   | name  |  
\+------+-------+  
|   10 | neo   |  
|   20 | John  |  
|   30 | Lucy  |  
|   40 | Larry |  
|   50 | Lilly |  
\+------+-------+  
5 rows in set (0.04 sec)  
  
查看生成的日志  
\[root@localhost fire\]\# cat /tmp/20160908\_02.log   
Welcome to the MySQL monitor.  Commands end with ; or \\g.  
Your MySQL connection id is 5  
Server version: 5.6.31-77.0-log Percona Server (GPL), Release 77.0, Revision 5c1061c  
  
Copyright (c) 2009-2016 Percona LLC and/or its affiliates  
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.  
  
Oracle is a registered trademark of Oracle Corporation and/or its  
affiliates. Other names may be trademarks of their respective  
owners.  
  
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.  
  
mysql> use test  
Reading table information for completion of table and column names  
You can turn off this feature to get a quicker startup with -A  
  
Database changed  
mysql> select \* from test;  
\+------+-------+  
| id   | name  |  
\+------+-------+  
|   10 | neo   |  
|   20 | John  |  
|   30 | Lucy  |  
|   40 | Larry |  
|   50 | Lilly |  
\+------+-------+  
5 rows in set (0.04 sec)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2124680/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2124680/