- 论坛徽章:
- 0
|
# ps auxww|grep mysql
mysql 51924 0.0 0.1 3464 1364 p0 I 4:01PM 0:00.01 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-file=/usr/local/db/my.cnf
[mysql]
tee=/usr/local/db/client.log
# pwd
/usr/local/db
# ll client.log
-rwxrwxr-x 1 mysql wheel 0 Nov 27 15:15 client.log
# /usr/local/etc/rc.d/mysql-server restart
Stopping mysql.
Waiting for PIDS: 52029.
Starting mysql.
# mysql -u root -p test
Enter password: xxx
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> select * from t1;
Empty set (0.00 sec)
mysql> desc t1;
+-------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id | int(11) | YES | | NULL | |
+-------+---------+------+-----+---------+-------+
1 row in set (0.00 sec)
mysql> insert into t1 values (10),(20),(30);
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> select * from t1;
+------+
| id |
+------+
| 10 |
| 20 |
| 30 |
+------+
3 rows in set (0.00 sec)
最后检查client.log
# ll client.log
-rwxrwxr-x 1 mysql wheel 0 Nov 27 15:15 client.log
大小还是0,没有变化
下面测试另一种方法:
mysql> tee client.log
Logging to file 'client.log'
mysql> select * from t1;
+------+
| id |
+------+
| 10 |
| 20 |
| 30 |
+------+
3 rows in set (0.00 sec)
mysql> exit
Bye
# ll client.log
-rwxrwxr-x 1 mysql wheel 126 Nov 27 16:09 client.log
这次有数据了
# cat client.log
mysql> select * from t1;
+------+
| id |
+------+
| 10 |
| 20 |
| 30 |
+------+
3 rows in set (0.00 sec)
mysql> exit |
|