GET /v{version}/instance/{instanceId}/performance/innodbstatus HTTP 1.1
HOST: rds.bj.baidubce.com
Content-Type: application/json
Authorization: authorization string

GET /v1/instance/rds-uXaqeGet/performance/innodbstatus HTTP 1.1
HOST: rds.bj.baidubce.com
Content-Type:application/json
Authorization: bce-auth-v1/f81d3b34e48048fbb2634dc7882d7e21/2017-11-21T04:17:29Z/3600/host/74c506f68c65e26c633bfa104c863fffac5190fdec1ec24b7c03eb5d67d2e1de

HTTP/1.1 200 OK
x-bce-request-id: 7869616F-7A68-6977-656E-406261696475
Content-Type:application/json
{
  "datetime" : "2017-11-20 10:09:13",
  "name" : "",
  "type" : "InnoDB",
  "status" : "=====================================2017-11-20 10:09:13 0x7f13d7788700 INNODB MONITOR OUTPUT=====================================Per second averages calculated from the last 13 seconds-----------------BACKGROUND THREAD-----------------srv_master_thread loops: 87238 srv_active, 0 srv_shutdown, 581538 srv_idlesrv_master_thread log flush and writes: 668770----------SEMAPHORES----------OS WAIT ARRAY INFO: reservation count 6OS WAIT ARRAY INFO: signal count 6RW-shared spins 0, rounds 8, OS waits 4RW-excl spins 0, rounds 0, OS waits 0RW-sx spins 0, rounds 0, OS waits 0Spin rounds per wait: 8.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx------------TRANSACTIONS------------Trx id counter 3333Purge done for trx's n:o < 0 undo n:o < 0 state: running but idleHistory list length 0LIST OF TRANSACTIONS FOR EACH SESSION:---TRANSACTION 421198760466256, not started0 lock struct(s), heap size 1136, 0 row lock(s)---TRANSACTION 421198760467168, not started0 lock struct(s), heap size 1136, 0 row lock(s)--------FILE I/O--------I/O thread 0 state: waiting for i/o request (insert buffer thread)I/O thread 1 state: waiting for i/o request (log thread)I/O thread 2 state: waiting for i/o request (read thread)I/O thread 3 state: waiting for i/o request (read thread)I/O thread 4 state: waiting for i/o request (read thread)I/O thread 5 state: waiting for i/o request (read thread)I/O thread 6 state: waiting for i/o request (read thread)I/O thread 7 state: waiting for i/o request (read thread)I/O thread 8 state: waiting for i/o request (read thread)I/O thread 9 state: waiting for i/o request (read thread)I/O thread 10 state: waiting for i/o request (write thread)I/O thread 11 state: waiting for i/o request (write thread)I/O thread 12 state: waiting for i/o request (write thread)I/O thread 13 state: waiting for i/o request (write thread)I/O thread 14 state: waiting for i/o request (write thread)I/O thread 15 state: waiting for i/o request (write thread)I/O thread 16 state: waiting for i/o request (write thread)I/O thread 17 state: waiting for i/o request (write thread)Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's:Pending flushes (fsync) log: 0; buffer pool: 0243 OS file reads, 402693 OS file writes, 15 OS fsyncs0.00 reads/s, 0 avg bytes/read, 0.85 writes/s, 0.00 fsyncs/s-------------------------------------INSERT BUFFER AND ADAPTIVE HASH INDEX-------------------------------------Ibuf: size 1, free list len 0, seg size 2, 0 mergesmerged operations: insert 0, delete mark 0, delete 0discarded operations: insert 0, delete mark 0, delete 0Hash table size 138389, node heap has 0 buffer(s)Hash table size 138389, node heap has 0 buffer(s)Hash table size 138389, node heap has 0 buffer(s)Hash table size 138389, node heap has 0 buffer(s)Hash table size 138389, node heap has 0 buffer(s)Hash table size 138389, node heap has 0 buffer(s)Hash table size 138389, node heap has 0 buffer(s)Hash table size 138389, node heap has 0 buffer(s)0.00 hash searches/s, 0.00 non-hash searches/s---LOG---Log sequence number 2526566Log flushed up to 2526566Pages flushed up to 2526566Last checkpoint at 25265570 pending log flushes, 0 pending chkp writes15 log i/o's done, 0.00 log i/o's/second----------------------BUFFER POOL AND MEMORY----------------------Total large memory allocated 549715968Dictionary memory allocated 116177Buffer pool size 32764Free buffers 32514Database pages 250Old database pages 0Modified db pages 0Pending reads 0Pending writes: LRU 0, flush list 0, single page 0Pages made young 0, not young 00.00 youngs/s, 0.00 non-youngs/sPages read 212, created 38, written 4026700.00 reads/s, 0.00 creates/s, 0.85 writes/sBuffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/sLRU len: 250, unzip_LRU len: 0I/O sum[0]:cur[0], unzip sum[0]:cur[0]--------------ROW OPERATIONS--------------0 queries inside InnoDB, 0 queries in queue0 read views open inside InnoDBProcess ID=9073, Main thread ID=139723013109504, state: sleepingNumber of rows inserted 41808581, updated 0, deleted 0, read 41808589107.22 inserts/s, 0.00 updates/s, 0.00 deletes/s, 107.22 reads/s----------------------------END OF INNODB MONITOR OUTPUT============================"
}