mysql tee记录日_详解MySQL的tee功能并利用其记录相关操作

分手后的思念是犯贱 2022-10-31 04:03 17阅读 0赞

MySQL> \\T mysql\_result.log

Logging to file 'mysql\_result.log'

mysql> tee mysql\_result.log

Logging to file 'mysql\_result.log'

mysql> show databases;

\+--------------------+

| Database           |

\+--------------------+

| information\_schema |

| mysql              |

| postfix            |

| test               |

| ucenter            |

| wordpress          |

| zabbix             |

\+--------------------+

7 rows in set (0.00 sec)

mysql> show processlist;

\+----+------+-----------+---------+---------+------+-------+------------------+

\+----+------+-----------+---------+---------+------+-------+------------------+

\+----+------+-----------+---------+---------+------+-------+------------------+

2 rows in set (0.01 sec)

mysql> \\q

Bye

\[root@ www.linuxidc.com ~\]\# cat mysql\_result.log

mysql> tee mysql\_result.log

mysql> show databases;

\+--------------------+

| Database           |

\+--------------------+

| information\_schema |

| mysql              |

| postfix            |

| test               |

| ucenter            |

| wordpress          |

| zabbix             |

\+--------------------+

7 rows in set (0.00 sec)

mysql> show processlist;

\+----+------+-----------+---------+---------+------+-------+------------------+

\+----+------+-----------+---------+---------+------+-------+------------------+

\+----+------+-----------+---------+---------+------+-------+------------------+

2 rows in set (0.01 sec)

mysql> \\q

\[root@ www.linuxidc.com ~\]\# mysql --tee=mysql\_result.log

Logging to file 'mysql\_result.log'

Welcome to the MySQL monitor.  Commands end with ; or \\g.

Your MySQL connection id is 6

Server version: 5.1.45 Source distribution

Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.

mysql> show engines;

\+------------+---------+------------------------------------------------------------+--------------+------+------------+

\+------------+---------+------------------------------------------------------------+--------------+------+------------+

| CSV        | YES     | CSV storage engine                                         | NO           | NO   | NO         |

| MRG\_MYISAM | YES     | Collection of identical MyISAM tables                      | NO           | NO   | NO         |

| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance     | NO           | NO   | NO         |

| InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |

| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables  | NO           | NO   | NO         |

\+------------+---------+------------------------------------------------------------+--------------+------+------------+

6 rows in set (0.00 sec)

mysql> \\q

Bye

\[root@ www.linuxidc.com ~\]\# mysqladmin shutdown

\[root@ www.linuxidc.com ~\]\# vim /usr/local/mysql/etc/my.cnf

\[client\]

tee             = /tmp/mysql\_result.log

\[root@ www.linuxidc.com ~\]\# /usr/local/mysql/bin/mysqld\_safe --defaults-file=/usr/local/mysql/etc/my.cnf --datadir=/data/mysql/data --user=mysql &

\[1\] 2620

\[root@ www.linuxidc.com ~\]\# 120731 20:28:30 mysqld\_safe Logging to '/data/mysql/data/tech.err'.

120731 20:28:30 mysqld\_safe Starting mysqld daemon with databases from /data/mysql/data

\[root@ www.linuxidc.com ~\]\# mysql

Logging to file '/tmp/mysql\_result.log'

Welcome to the MySQL monitor.  Commands end with ; or \\g.

Your MySQL connection id is 1

Server version: 5.1.45 Source distribution

Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.![0b1331709591d260c1c78e86d0c51c18.png][]

[0b1331709591d260c1c78e86d0c51c18.png]: /images/20221024/a01c741a7e214a3387e032cad69ecb73.png

mysql tee记录日_详解MySQL的tee功能并利用其记录相关操作

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

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

相关 OP-TEE的安装

相关 linux tee命令

相关 tee命令

相关 mysql tee记录日_详解MySQL的tee功能并利用其记录相关操作

相关 mysql记录用户操作_怎么利用mysql的audit审计功能记录用户操作信息 | 学步园

相关利用mysql的TRIGGER 同步更新相关记录

相关【Linux】tee命令

相关 linux tee 命令详解

相关 Linux tee命令