3 09876543210987654321098765432109876543210987654321098765432109876543210987654321
5 pstop v0.0.19 uptime ....
6 Active Query Information by User
7 --- Queries --- |-- InnoDB --| |
8 Totl Ins Upd Del|wr MB/s rd|Conn Act|Con/s Abrt/s ../s
9 9999 9999 9999 9999|111.1 111.1|9999 999|999.9 999.9
11 user_name |QueryTim %age||Select Insert Update Delete Other
12 xxxxxxxxxx |hh:mm:ss 10.0%|100.00% 100.00% 100.00% 100.00% 100.00%
14 TOTAL |hh:mm:ss 10.0%|100.00% 100.00% 100.00% 100.00% 100.00%
17 root@localhost [(none)]> show create table information_Schema.global_status\G
18 *************************** 1. row ***************************
20 Create Table: CREATE TEMPORARY TABLE `GLOBAL_STATUS` (
21 `VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '',
22 `VARIABLE_VALUE` varchar(1024) DEFAULT NULL
23 ) ENGINE=MEMORY DEFAULT CHARSET=utf8
24 1 row in set (0.01 sec)
27 Standard output is in the format:
29 key read misses -innodb- table qcache ------ theads ----- IO MB/s tmp dsk
30 qps innodb myisam log wait locks hits conn actv crea abrt rd wr tables
31 9999 99.99% 99.99% 99999999 99.99% 999.9% 9999 9999 9999 9999 999 999 99.99%
34 # keys used for calculating delta values
38 Created_tmp_disk_tables
40 Innodb_buffer_pool_read_requests
41 Innodb_buffer_pool_reads
55 # Add more values if using extended output.
56 push @delta_keys, qw (
66 ) if $extended_output;