Skip to content

Instantly share code, notes, and snippets.

@yoku0825
Created April 2, 2015 02:22
Show Gist options
  • Save yoku0825/ec413e4009820fb2f8ae to your computer and use it in GitHub Desktop.
Save yoku0825/ec413e4009820fb2f8ae to your computer and use it in GitHub Desktop.
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)
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)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment