运维倒计时

orzdba 监控获取/输出全解

2019-11-06  本文已影响0人  Darui30

orzdba好用的不要不要的

threads
------threads------
 run  con  cre  cac|
   0    0    0    0|
 200  202    0    0|
 201  202    0    0|
 201  202    0    0|
 201  202    0    0|
innodb_hit
        -Hit%-
|     lor    hit|
|       0 100.00|
|  385098  98.00|
|  392831  98.01|
innodb_rows
---innodb rows status---
  ins   upd   del   read|
    0     0     0      0|
 1717  3430  1718 715111|
 1728  3439  1723 717916|
innodb_data
-----innodb data status----
 reads writes  read written|
     0      0      0      0|
  8220   5043 128.4m 106.3m|
  8091   5139 126.4m 108.6m|
  8089   5148 126.4m 109.3m|
innodb_log
--innodb log--
fsyncs written|
     0       0|
  1701    3.9m|
  1708    4.1m|
  1716    3.9m|
innodb_status

获取方式:show engine innodb status

  his --log(byte)--  read ---query---
 list uflush  uckpt  view inside  que|
  566     1k  891.9m  191     4   193|
  757     2k  894.9m  189     5   194|
  529     3k  898.0m  193     3   194|
  427    503  880.6m  190     1   193|


---
LOG
(Innodb 事务日志相关信息,包括当前的日志序列号(Log sequence number),已经刷新同步到那个序列号,最近的check point到那个序列号了。除此之外,还显示了系统从启动到现在已经做了多少次check point,多少次日志刷新。)
---
(注:小括号为官方解释。)
Log sequence number 2560255(当前的日志序列号)
Log flushed up to   2560255(刷新到日志重做日志文件的lsn)
Pages flushed up to 2560255(写入磁盘的脏页的lsn。记录在checkpoint中)
Last checkpoint at 2560246(刷新到磁盘的lsn)

 --------------
 ROW OPERATIONS
 --------------
 2 queries inside InnoDB, 0 queries in queue
 2 read views open inside InnoDB
 Main thread process no. 7969, id 1191348544, state: sleeping
 Number of rows inserted 287921794, updated 733493588, deleted 30775703, read 2351464150250
 5.10 inserts/s, 29.38 updates/s, 0.02 deletes/s, 51322.87 reads/s

上一篇 下一篇

猜你喜欢

热点阅读