i_s/output_format.txt

   1
   2 8         7         6         5         4         3         2         1
   3 09876543210987654321098765432109876543210987654321098765432109876543210987654321
   4
   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
  10
  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%
  13 ...
  14 TOTAL         |hh:mm:ss  10.0%|100.00% 100.00% 100.00% 100.00% 100.00%
  15
  16
  17 root@localhost [(none)]> show create table information_Schema.global_status\G
  18 *************************** 1. row ***************************
  19        Table: GLOBAL_STATUS
  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)
  25
  26
  27 Standard output is in the format:
  28
  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%
  32
  33
  34 # keys used for calculating delta values
  35 my @delta_keys = qw(
  36         Aborted_clients
  37         Com_select
  38         Created_tmp_disk_tables
  39         Created_tmp_tables
  40         Innodb_buffer_pool_read_requests
  41         Innodb_buffer_pool_reads
  42         Innodb_data_read
  43         Innodb_data_written
  44         Innodb_log_waits
  45         Key_read_requests
  46         Key_reads
  47         Qcache_hits
  48         Questions
  49         Table_locks_immediate
  50         Table_locks_waited
  51         Threads_created
  52         Uptime
  53     );
  54
  55 # Add more values if using extended output.
  56 push @delta_keys, qw (
  57         Com_insert
  58         Com_insert_select
  59         Com_delete
  60         Com_delete_multi
  61         Com_update
  62         Com_update_multi
  63         Com_replace
  64         Com_replace_select
  65         Qcache_lowmem_prunes
  66 ) if $extended_output;
  67
  68
  69
  70 thread_cache_size
  71 max_connections