compress

mysql56> status
--------------
/usr/mysql/5.6.23/bin/mysql  Ver 14.14 Distrib 5.6.23, for Linux (x86_64) using  EditLine wrapper

Connection id:          4
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.6.23-log Source distribution
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:            /usr/mysql/5.6.23/data/mysql.sock
Protocol:               Compressed
Uptime:                 5 min 10 sec

Threads: 1  Questions: 11  Slow queries: 0  Opens: 70  Flush tables: 1  Open tables: 63  Queries per second avg: 0.035
--------------

mysql56> pager cat > /dev/null
PAGER set to 'cat > /dev/null'

mysql56> SELECT * FROM t1; -- これはバッファプールに載ってない
1000000 rows in set (8.83 sec)

mysql56> SELECT * FROM t1;
1000000 rows in set (6.87 sec)

mysql56> SELECT * FROM t1;
1000000 rows in set (6.75 sec)

plain

mysql56> status
--------------
/usr/mysql/5.6.23/bin/mysql  Ver 14.14 Distrib 5.6.23, for Linux (x86_64) using  EditLine wrapper

Connection id:          5
Current database:       d1
Current user:           root@localhost
SSL:                    Not in use
Current pager:          cat > /dev/null
Using outfile:          ''
Using delimiter:        ;
Server version:         5.6.23-log Source distribution
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:            /usr/mysql/5.6.23/data/mysql.sock
Uptime:                 7 min 52 sec

Threads: 1  Questions: 28  Slow queries: 6  Opens: 73  Flush tables: 1  Open tables: 66  Queries per second avg: 0.059

mysql56> SELECT * FROM t1; -- 再起動はしてないのでバッファプールに既に載ってる
1000000 rows in set (1.29 sec)

mysql56> SELECT * FROM t1;
1000000 rows in set (1.29 sec)

mysql56> SELECT * FROM t1;
1000000 rows in set (1.30 sec)