MySQL uses tee to record statements and output logs
From the mysql command line, you can record statements and output to a specified file using the tee command. It can be very useful in debugging.
Each time a statement is executed, mysql refreshes the execution result to the specified file. The Tee feature takes effect only in interactive mode.
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.01sec)
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 | 1600 | 30 |
| | 7521 | WARD | SALESMAN | 7698 | 1981-02-22 00:00:00 | 1250 | 1250 | 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)
Use the notee command to turn off logging
Mysql > notee
Outfile disabled.
View the generated log
[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.01sec)
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 | 1600 | 30 |
| | 7521 | WARD | SALESMAN | 7698 | 1981-02-22 00:00:00 | 1250 | 1250 | 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
When mysql is called, you can log all logs for this login session using the-- tee parameter.
[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)
View the generated log
[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)
