本帖最后由 asdmusic 于 2025-6-30 18:04 编辑
下面的是innodb类型
mysql> show processlist;
+----+-----------------+-----------+--------------+---------+------+----------------------------+------------------------------------------------------------------------------------------------------+---------+-----------+---------------+
| Id | User | Host | db | Command | Time | State | Info | Time_ms | Rows_sent | Rows_examined |
+----+-----------------+-----------+--------------+---------+------+----------------------------+------------------------------------------------------------------------------------------------------+---------+-----------+---------------+
| 5 | event_scheduler | localhost | NULL | Daemon | 1100 | Waiting on empty queue | NULL | 1099678 | 0 | 0 |
| 13 | root | localhost | NULL | Query | 0 | init | show processlist | 0 | 0 | 0 |
| 14 | root | localhost | Data_Monitor | Query | 0 | waiting for handler commit | INSERT INTO `ComObjectList1` VALUES (1,3198502171,3899309670,'DC440E8B-8B54-41EF-9B09-93BEC43FD71C', | 19 | 0 | 0 |
+----+-----------------+-----------+--------------+---------+------+----------------------------+------------------------------------------------------------------------------------------------------+---------+-----------+---------------+
3 rows in set (0.00 sec)
mysql> SHOW ENGINE INNODB STATUS\G
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
2025-07-01 01:58:33 140169210492672 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 9 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 47 srv_active, 0 srv_shutdown, 1086 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 25
OS WAIT ARRAY INFO: signal count 25
RW-shared spins 0, rounds 0, OS waits 0
RW-excl spins 0, rounds 0, OS waits 0
RW-sx spins 0, rounds 0, OS waits 0
Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 2552
Purge done for trx's n < 2550 undo n < 0 state: running but idle
History list length 34
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421645061148872, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421645061147176, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421645061146328, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 2550, ACTIVE (PREPARED) 0 sec
mysql tables in use 1, locked 1
1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1
MySQL thread id 14, OS thread handle 140169278875392, query id 638 localhost root waiting for handler commit
INSERT INTO `ComObjectList1` VALUES (1,1680897625,2339795195,'66F86EE4-FFEF-401B-AD9F-608A55665FE9','9E840A11-EEB5-4E1D-AD28-E4D629CCF955',3,1610809347,'IP4640.DALimiter._DALimiter.rstGetInPatientDALimiterList','[in,out] SAFEARRAY(VARIANT)* ParameterSet','',1,'IDispatch',7,0,1,'')
TABLE LOCK table `Data_Monitor`.`ComObjectList1` trx id 2550 lock mode IX
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
ibuf aio reads:, log i/o's:
Pending flushes (fsync) log: 1; buffer pool: 0
1090 OS file reads, 2313 OS file writes, 1347 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 30.46 writes/s, 19.75 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
insert 0, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 276707, node heap has 0 buffer(s)
Hash table size 276707, node heap has 0 buffer(s)
Hash table size 276707, node heap has 0 buffer(s)
Hash table size 276707, node heap has 0 buffer(s)
Hash table size 276707, node heap has 0 buffer(s)
Hash table size 276707, node heap has 0 buffer(s)
Hash table size 276707, node heap has 0 buffer(s)
Hash table size 276707, node heap has 0 buffer(s)
0.00 hash searches/s, 31.22 non-hash searches/s
---
LOG
---
Log sequence number 21348395
Log buffer assigned up to 21348395
Log buffer completed up to 21348395
Log written up to 21348395
Log flushed up to 21348385
Added dirty pages up to 21348395
Pages flushed up to 20461353
Last checkpoint at 20461353
Log minimum file id is 0
Log maximum file id is 0
Modified age no less than 887042
Checkpoint age 887042
Max checkpoint age 1806958592
1498 log i/o's done, 22.67 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 0
Dictionary memory allocated 558401
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 64085
Database pages 1443
Old database pages 0
Modified db pages 713
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 1058, created 389, written 593
0.00 reads/s, 0.73 creates/s, 4.47 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 1443, unzip_LRU len: 0
I/O sum[1208]:cur[48], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 8191
Buffer pool size, bytes 134201344
Free buffers 8083
Database pages 108
Old database pages 0
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 103, created 5, written 57
0.00 reads/s, 0.10 creates/s, 0.10 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 108, unzip_LRU len: 0
I/O sum[151]:cur[6], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 8191
Buffer pool size, bytes 134201344
Free buffers 8079
Database pages 112
Old database pages 0
Modified db pages 55
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 110, created 2, written 42
0.00 reads/s, 0.00 creates/s, 0.73 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 112, unzip_LRU len: 0
I/O sum[151]:cur[6], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 8191
Buffer pool size, bytes 134201344
Free buffers 8096
Database pages 95
Old database pages 0
Modified db pages 48
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 95, created 0, written 7
0.00 reads/s, 0.00 creates/s, 0.73 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 95, unzip_LRU len: 0
I/O sum[151]:cur[6], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 8191
Buffer pool size, bytes 134201344
Free buffers 7870
Database pages 321
Old database pages 0
Modified db pages 241
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 223, created 102, written 108
0.00 reads/s, 0.21 creates/s, 0.73 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 321, unzip_LRU len: 0
I/O sum[151]:cur[6], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 8191
Buffer pool size, bytes 134201344
Free buffers 8122
Database pages 69
Old database pages 0
Modified db pages 45
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 67, created 2, written 38
0.00 reads/s, 0.00 creates/s, 0.73 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 69, unzip_LRU len: 0
I/O sum[151]:cur[6], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 8191
Buffer pool size, bytes 134201344
Free buffers 8132
Database pages 59
Old database pages 0
Modified db pages 0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 58, created 1, written 30
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 59, unzip_LRU len: 0
I/O sum[151]:cur[6], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 8191
Buffer pool size, bytes 134201344
Free buffers 7887
Database pages 304
Old database pages 0
Modified db pages 124
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 114, created 190, written 177
0.00 reads/s, 0.10 creates/s, 0.73 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 304, unzip_LRU len: 0
I/O sum[151]:cur[6], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 8191
Buffer pool size, bytes 134201344
Free buffers 7816
Database pages 375
Old database pages 0
Modified db pages 200
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 288, created 87, written 134
0.00 reads/s, 0.31 creates/s, 0.73 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 375, unzip_LRU len: 0
I/O sum[151]:cur[6], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
1 RW transactions active inside InnoDB
Process ID=13037, Main thread ID=140167974336256 , state=sleeping
Number of rows inserted 355, updated 0, deleted 0, read 0
5.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Number of system rows inserted 968, updated 517, deleted 431, read 7045
4.89 inserts/s, 0.11 updates/s, 5.55 deletes/s, 5.78 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
1 row in set (0.00 sec)
SELECT SQL_TEXT, ROWS_AFFECTED, TIMER_WAIT / 1000000000000 AS time_sec, ROWS_AFFECTED / (TIMER_WAIT / 1000000000000) AS rows_per_sec FROM performance_schema.events_statements_history WHERE SQL_TEXT LIKE '%INSERT%' AND ROWS_AFFECTED > 0 ORDER BY TIMER_START DESC LIMIT 10;
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+----------+--------------+
| SQL_TEXT | ROWS_AFFECTED | time_sec | rows_per_sec |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+----------+--------------+
| INSERT INTO `ComObjectList1` VALUES (1,3549973875,1354721761,'176BFB8D-D8E5-4A2B-8745-6D7EB79FB6AB','212ABBE9-BCD6-4F90-A340-0EDC5256531E',0,1610809344,'OP0013.FeeKindTree._FeeKindTree.rstGetFeeKindTreeByFlag','[in,out] SAFEARRAY(VARIANT)* ParameterSet','',1,'IDispatch',7,0,1,'') | 1 | 0.2991 | 3.3433 |
| INSERT INTO `ComObjectList1` VALUES (1,1423743161,2393951217,'E8CF1FF6-DB42-42AF-9757-4A7B11BF1BBF','62206861-2D36-4499-A9E6-C61F1B9DA5A0',5,1610809350,'IP4626.ExecDAREQ._ExecDAREQ.lUpdateDAListReturnMediHideFlag','[in,out] SAFEARRAY(VARIANT)* ParameterSet','',1,'IDispatch',7,0,1,'') | 1 | 0.3072 | 3.2551 |
| INSERT INTO `ComObjectList1` VALUES (1,1423734969,2393951086,'E8CF1FF6-DB42-42AF-9757-4A7B11BF1BBF','62206861-2D36-4499-A9E6-C61F1B9DA5A0',4,1610809349,'IP4626.ExecDAREQ._ExecDAREQ.blnUpdateExecStatus','[in,out] SAFEARRAY(VARIANT)* ParameterSet','',1,'IDispatch',7,0,1,'') | 1 | 0.3551 | 2.8164 |
| INSERT INTO `ComObjectList1` VALUES (1,1423726777,2393950955,'E8CF1FF6-DB42-42AF-9757-4A7B11BF1BBF','62206861-2D36-4499-A9E6-C61F1B9DA5A0',3,1610809348,'IP4626.ExecDAREQ._ExecDAREQ.blnSetNurseFlagByExecDA','[in,out] SAFEARRAY(VARIANT)* ParameterSet','',1,'IDispatch',7,0,1,'') | 1 | 0.2474 | 4.0422 |
| INSERT INTO `ComObjectList1` VALUES (1,1423718585,2393950693,'E8CF1FF6-DB42-42AF-9757-4A7B11BF1BBF','62206861-2D36-4499-A9E6-C61F1B9DA5A0',2,1610809346,'IP4626.ExecDAREQ._ExecDAREQ.lngSaveExecDABatchList','[in,out] SAFEARRAY(VARIANT)* ParameterSet','',1,'IDispatch',7,0,1,'') | 1 | 0.2930 | 3.4135 |
| INSERT INTO `ComObjectList1` VALUES (1,1423710393,2393950562,'E8CF1FF6-DB42-42AF-9757-4A7B11BF1BBF','62206861-2D36-4499-A9E6-C61F1B9DA5A0',1,1610809345,'IP4626.ExecDAREQ._ExecDAREQ.lngConfirmPrandialDA','[in,out] SAFEARRAY(VARIANT)* ParameterSet','',1,'IDispatch',7,0,1,'') | 1 | 0.3975 | 2.5160 |
| INSERT INTO `ComObjectList1` VALUES (1,1423702201,2393950431,'E8CF1FF6-DB42-42AF-9757-4A7B11BF1BBF','62206861-2D36-4499-A9E6-C61F1B9DA5A0',0,1610809344,'IP4626.ExecDAREQ._ExecDAREQ.lngDepartmentPrint','[in,out] SAFEARRAY(VARIANT)* ParameterSet','',1,'IDispatch',7,0,1,'') | 1 | 0.3499 | 2.8583 |
| INSERT INTO `ComObjectList1` VALUES (1,589799461,3760090748,'34313006-A081-4A36-82FD-96BF66E55657','357247AB-7615-41CB-B8EA-20D0BEB3B5DF',11,1610809358,'IP4626.ExecDA._ExecDA.rstGetDetailByExecDAID','[in,out] SAFEARRAY(VARIANT)* ParameterSet','',1,'IDispatch',7,0,1,'') | 1 | 0.3555 | 2.8131 |
| INSERT INTO `ComObjectList1` VALUES (1,589791269,3760090617,'34313006-A081-4A36-82FD-96BF66E55657','357247AB-7615-41CB-B8EA-20D0BEB3B5DF',10,1610809357,'IP4626.ExecDA._ExecDA.rstGetByExecDAID','[in,out] SAFEARRAY(VARIANT)* ParameterSet','',1,'IDispatch',7,0,1,'') | 1 | 0.3613 | 2.7676 |
| INSERT INTO `ComObjectList1` VALUES (1,589783077,3760090486,'34313006-A081-4A36-82FD-96BF66E55657','357247AB-7615-41CB-B8EA-20D0BEB3B5DF',9,1610809356,'IP4626.ExecDA._ExecDA.rstGetExecDAByExecStatus','[in,out] SAFEARRAY(VARIANT)* ParameterSet','',1,'IDispatch',7,0,1,'') | 1 | 0.2915 | 3.4304 |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------+----------+--------------+
10 rows in set (0.01 sec)
|