mysql pager 妙用！
喜欢看英文的可以去http://www.mysqlperformanceblog.com/2013/01/21/fun-with-the-mysql-pager-command/@Stephane Combaudon
分页显示。
mysql> pager less
PAGER set to 'less'
mysql> show engine innodb status\G
[...]
退出pager
mysql> pager
Default pager wasn't set, using stdout.
or
mysql> \n
PAGER set to stdout
一些其他的用法
mysql> pager cat > /dev/null
PAGER set to 'cat > /dev/null'
# Trying an execution plan
mysql> show tables;
11 rows in set (0.00 sec)
mysql> select * from t_s;
8 rows in set (0.00 sec)
这个不错
mysql> select * from t_s;
+---+---+
| a | b |
+---+---+
| 1 | 0 |
| 2 | 0 |
| 3 | 0 |
| 4 | 0 |
| 5 | 0 |
| 6 | 0 |
| 7 | 0 |
| 8 | 1 |
+---+---+
8 rows in set (0.00 sec)
mysql> pager md5sum
PAGER set to 'md5sum'
# Original query
mysql> select * from t_s;
5a75d0e7c3c5af75683e2a8152658b4a-
8 rows in set (0.00 sec)
mysql> update t_s set b=1 where a=1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1Changed: 1Warnings: 0
mysql> select * from t_s;
f9178450be750a1da67d8046c9658e50-
8 rows in set (0.00 sec)
上面两个查询不一样了？
mysql> pager grep Sleep | wc -l
PAGER set to 'grep Sleep | wc -l'
mysql> show processlist;
7
8 rows in set (0.00 sec)
mysql> pager awk -F '|' '{print $6}'| sort | uniq -c | sort -r
PAGER set to 'awk -F '|' '{print $6}'| sort | uniq -c | sort -r'
mysql> show processlist;
9Sleep
3
1Query
1Command
10 rows in set (0.00 sec)
页:
[1]