GreateSQL 8.0.32-25 sysbench 压测 出现性能抖动

还请再补充几个信息

1.  show variables like 'version_comment'; 结果
2.  show engine innodb status\G 结果
3. perf top结果
4. pidstat -p PID 1 100 结果，PID换成你的mysqld进程PID
5. 这个服务器上只跑一个mysqld实例进程，还是多个实例复用

yejr 发表于 2024-4-24 17:54
还请再补充几个信息

1.  show variables like 'version_comment'; 结果

1，
+-----------------+--------------------------------------------------+
| Variable_name   | Value                                            |
+-----------------+--------------------------------------------------+
| version_comment | GreatSQL, Release 25, Revision 79f57097e3f-gmssl |
+-----------------+--------------------------------------------------+


5、 服务器上只跑了MySQL

2、

*************************** 1. row ***************************
  Type: InnoDB
  Name:
Status:
=====================================
2024-04-24 19:18:16 139941251557120 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 3 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 955 srv_active, 0 srv_shutdown, 2629 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 121328
OS WAIT ARRAY INFO: signal count 255679
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 3800776
Purge done for trx's n < 3800019 undo n < 0 state: running
History list length 674
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421482828108040, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828092776, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828008824, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828093624, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828091928, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828091080, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828090232, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828089384, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828088536, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828087688, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828086840, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828085992, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828085144, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828084296, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828083448, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828082600, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828081752, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828080904, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828080056, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828079208, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828078360, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828077512, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828076664, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828075816, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828074968, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828074120, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828073272, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828072424, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828071576, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828070728, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828069880, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828069032, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828068184, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828067336, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828066488, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828065640, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828064792, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828063944, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828063096, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828062248, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828061400, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828060552, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828059704, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828058856, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828058008, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828057160, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828056312, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828055464, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828054616, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828053768, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828052920, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828052072, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828051224, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828050376, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828049528, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828048680, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828047832, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828046984, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828046136, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828045288, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828044440, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828043592, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828042744, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828041896, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828041048, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828040200, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828039352, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828038504, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828037656, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828036808, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828035960, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828035112, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828034264, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828033416, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828032568, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828031720, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828030872, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828030024, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828029176, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828028328, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828027480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828026632, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828025784, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828024936, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828024088, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828023240, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828022392, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828021544, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828020696, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828019848, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828019000, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828018152, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828017304, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828016456, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828015608, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828014760, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828013912, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828013064, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828012216, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828011368, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828010520, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828009672, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421482828007976, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 3800775, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
1 lock struct(s), heap size 1128, 0 row lock(s)
MySQL thread id 0, OS thread handle 139942091273984, query id 0 waiting for handler commit
TABLE LOCK table `mysql`.`gtid_executed` trx id 3800775 lock mode IX
---TRANSACTION 3800774, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 1128, 1 row lock(s)
MySQL thread id 1247, OS thread handle 139941252622080, query id 36510278 172.16.179.20 appuser updating
UPDATE sbtest78 SET k=k+1 WHERE id=393801
TABLE LOCK table `lizi`.`sbtest78` trx id 3800774 lock mode IX
RECORD LOCKS space id 100 page no 5427 n bits 144 index PRIMARY of table `lizi`.`sbtest78` trx id 3800774 lock_mode X locks rec but not gap
Record lock, heap no 4 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 80060249; asc    I;;
1: len 6; hex 0000000178f1; asc     x ;;
2: len 7; hex 82000000873af4; asc      : ;;
3: len 4; hex 8004187e; asc    ~;;
4: len 30; hex 35373232383730373033382d35313434313434303533302d363938343933; asc 57228707038-51441440530-698493; (total 120 bytes);
5: len 30; hex 37333233303136303632392d35373638303631303734392d323535323637; asc 73230160629-57680610749-255267; (total 60 bytes);

---TRANSACTION 3800773, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 1128, 1 row lock(s)
MySQL thread id 1237, OS thread handle 139942048777984, query id 36510277 172.16.179.20 appuser updating
UPDATE sbtest51 SET k=k+1 WHERE id=454004
TABLE LOCK table `lizi`.`sbtest51` trx id 3800773 lock mode IX
RECORD LOCKS space id 78 page no 6251 n bits 144 index PRIMARY of table `lizi`.`sbtest51` trx id 3800773 lock_mode X locks rec but not gap
Record lock, heap no 55 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 8006ed74; asc    t;;
1: len 6; hex 00000001826f; asc      o;;
2: len 7; hex 820000012829a2; asc     () ;;
3: len 4; hex 80103af9; asc   : ;;
4: len 30; hex 37323337353430303234322d34393230363733303032312d393031303037; asc 72375400242-49206730021-901007; (total 120 bytes);
5: len 30; hex 33383132353130353132332d31323834373333363831312d363138393332; asc 38125105123-12847336811-618932; (total 60 bytes);

---TRANSACTION 3800772, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 1128, 1 row lock(s)
MySQL thread id 1246, OS thread handle 139941782296320, query id 36510276 172.16.179.20 appuser updating
UPDATE sbtest42 SET k=k+1 WHERE id=224767
TABLE LOCK table `lizi`.`sbtest42` trx id 3800772 lock mode IX
RECORD LOCKS space id 42 page no 3111 n bits 144 index PRIMARY of table `lizi`.`sbtest42` trx id 3800772 lock_mode X locks rec but not gap
Record lock, heap no 38 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 80036dff; asc   m ;;
1: len 6; hex 000000002a45; asc     *E;;
2: len 7; hex 82000000a53712; asc      7 ;;
3: len 4; hex 80099fc4; asc     ;;
4: len 30; hex 30323930333637343935312d36373933323835323138342d393732373131; asc 02903674951-67932852184-972711; (total 120 bytes);
5: len 30; hex 34323432363738393630392d34383433313232353939362d323030323436; asc 42426789609-48431225996-200246; (total 60 bytes);

---TRANSACTION 3800771, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 1128, 1 row lock(s)
MySQL thread id 1234, OS thread handle 139941243037440, query id 36510275 172.16.179.20 appuser updating
UPDATE sbtest1 SET k=k+1 WHERE id=1323453
TABLE LOCK table `lizi`.`sbtest1` trx id 3800771 lock mode IX
RECORD LOCKS space id 5 page no 18163 n bits 144 index PRIMARY of table `lizi`.`sbtest1` trx id 3800771 lock_mode X locks rec but not gap
Record lock, heap no 74 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 801431bd; asc   1 ;;
1: len 6; hex 00000000cd29; asc      );;
2: len 7; hex 81000000980444; asc       D;;
3: len 4; hex 8003bcb1; asc     ;;
4: len 30; hex 30313838383038393836302d36383137353736393435312d373432373139; asc 01888089860-68175769451-742719; (total 120 bytes);
5: len 30; hex 30383538333335313430352d36383634363332333537362d303931303138; asc 08583351405-68646323576-091018; (total 60 bytes);

---TRANSACTION 3800770, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 1128, 1 row lock(s)
MySQL thread id 1241, OS thread handle 139941245699840, query id 36510274 172.16.179.20 appuser updating
UPDATE sbtest45 SET k=k+1 WHERE id=570526
TABLE LOCK table `lizi`.`sbtest45` trx id 3800770 lock mode IX
RECORD LOCKS space id 52 page no 7847 n bits 144 index PRIMARY of table `lizi`.`sbtest45` trx id 3800770 lock_mode X locks rec but not gap
Record lock, heap no 69 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 8008b49e; asc     ;;
1: len 6; hex 000000005cd8; asc     \ ;;
2: len 7; hex 81000000a22b18; asc      + ;;
3: len 4; hex 80093992; asc   9 ;;
4: len 30; hex 39393239383931393031372d37363932343739353333372d363537393137; asc 99298919017-76924795337-657917; (total 120 bytes);
5: len 30; hex 39303939353335333831352d31393633393035343139382d343034383135; asc 90995353815-19639054198-404815; (total 60 bytes);

---TRANSACTION 3800769, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 1128, 1 row lock(s)
MySQL thread id 1236, OS thread handle 139942450759424, query id 36510272 172.16.179.20 appuser updating
UPDATE sbtest22 SET k=k+1 WHERE id=857186
TABLE LOCK table `lizi`.`sbtest22` trx id 3800769 lock mode IX
RECORD LOCKS space id 21 page no 11774 n bits 144 index PRIMARY of table `lizi`.`sbtest22` trx id 3800769 lock_mode X locks rec but not gap
Record lock, heap no 58 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 800d1462; asc    b;;
1: len 6; hex 00000013ee70; asc      p;;
2: len 7; hex 01000001651acd; asc     e  ;;
3: len 4; hex 800a068d; asc     ;;
4: len 30; hex 35393735333435393435312d37363434333030323537342d373339323831; asc 59753459451-76443002574-739281; (total 120 bytes);
5: len 30; hex 36363830363331363631392d32333334353237383832352d363334373538; asc 66806316619-23345278825-634758; (total 60 bytes);

---TRANSACTION 3800768, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 1128, 1 row lock(s)
MySQL thread id 1249, OS thread handle 139942719260416, query id 36510266 172.16.179.20 appuser updating
UPDATE sbtest44 SET k=k+1 WHERE id=201576
TABLE LOCK table `lizi`.`sbtest44` trx id 3800768 lock mode IX
RECORD LOCKS space id 9 page no 2793 n bits 144 index PRIMARY of table `lizi`.`sbtest44` trx id 3800768 lock_mode X locks rec but not gap
Record lock, heap no 61 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 80031368; asc    h;;
1: len 6; hex 000000002748; asc     'H;;
2: len 7; hex 820000019917dc; asc        ;;
3: len 4; hex 800092df; asc     ;;
4: len 30; hex 31383739333636393235312d32373233353135363439342d363232323530; asc 18793669251-27235156494-622250; (total 120 bytes);
5: len 30; hex 34393234363935373635302d33343137363132373134332d383637393335; asc 49246957650-34176127143-867935; (total 60 bytes);

---TRANSACTION 3800767, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 1128, 1 row lock(s)
MySQL thread id 1243, OS thread handle 139941247829760, query id 36510261 172.16.179.20 appuser updating
UPDATE sbtest83 SET k=k+1 WHERE id=1363276
TABLE LOCK table `lizi`.`sbtest83` trx id 3800767 lock mode IX
RECORD LOCKS space id 80 page no 18709 n bits 144 index PRIMARY of table `lizi`.`sbtest83` trx id 3800767 lock_mode X locks rec but not gap
Record lock, heap no 39 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 8014cd4c; asc    L;;
1: len 6; hex 000000020a3b; asc      ;;;
2: len 7; hex 820000014f2dae; asc     O- ;;
3: len 4; hex 801d830b; asc     ;;
4: len 30; hex 34333432333732353335302d31373636323232343131352d343532353239; asc 43423725350-17662224115-452529; (total 120 bytes);
5: len 30; hex 31333632313339323436332d38323537343131353533342d343730333337; asc 13621392463-82574115534-470337; (total 60 bytes);

---TRANSACTION 3800766, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 1128, 1 row lock(s)
MySQL thread id 1239, OS thread handle 139942049310464, query id 36510250 172.16.179.20 appuser updating
UPDATE sbtest99 SET k=k+1 WHERE id=840667
TABLE LOCK table `lizi`.`sbtest99` trx id 3800766 lock mode IX
RECORD LOCKS space id 91 page no 11548 n bits 144 index PRIMARY of table `lizi`.`sbtest99` trx id 3800766 lock_mode X locks rec but not gap
Record lock, heap no 37 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 800cd3db; asc     ;;
1: len 6; hex 00000001baa0; asc       ;;
2: len 7; hex 820000008f02d8; asc        ;;
3: len 4; hex 80130bd9; asc     ;;
4: len 30; hex 34383035303731333636342d38303932363838343338372d373531303132; asc 48050713664-80926884387-751012; (total 120 bytes);
5: len 30; hex 38343534353535333938362d36373435373839313032322d363430323835; asc 84545553986-67457891022-640285; (total 60 bytes);

---TRANSACTION 3800765, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 1128, 1 row lock(s)
MySQL thread id 1245, OS thread handle 139921686992640, query id 36510243 172.16.179.20 appuser updating
UPDATE sbtest59 SET k=k+1 WHERE id=626340
TABLE LOCK table `lizi`.`sbtest59` trx id 3800765 lock mode IX
RECORD LOCKS space id 61 page no 8612 n bits 144 index PRIMARY of table `lizi`.`sbtest59` trx id 3800765 lock_mode X locks rec but not gap
Record lock, heap no 38 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 80098ea4; asc     ;;
1: len 6; hex 000000019ac8; asc       ;;
2: len 7; hex 82000001860f88; asc        ;;
3: len 4; hex 801d59c1; asc   Y ;;
4: len 30; hex 33373137343739303031372d30393831333535343033342d363938373232; asc 37174790017-09813554034-698722; (total 120 bytes);
5: len 30; hex 32333337333939383936392d39373233373930363330342d323834373339; asc 23373998969-97237906304-284739; (total 60 bytes);

---TRANSACTION 3800764, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 1128, 1 row lock(s)
MySQL thread id 1244, OS thread handle 139942048245504, query id 36510235 172.16.179.20 appuser updating
UPDATE sbtest40 SET k=k+1 WHERE id=1319374
TABLE LOCK table `lizi`.`sbtest40` trx id 3800764 lock mode IX
RECORD LOCKS space id 53 page no 18108 n bits 144 index PRIMARY of table `lizi`.`sbtest40` trx id 3800764 lock_mode X locks rec but not gap
Record lock, heap no 10 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 801421ce; asc   ! ;;
1: len 6; hex 00000000cb34; asc      4;;
2: len 7; hex 81000000b40b0c; asc        ;;
3: len 4; hex 8016cc69; asc    i;;
4: len 30; hex 30303338303131393537372d39313438313335353637362d383633383236; asc 00380119577-91481355676-863826; (total 120 bytes);
5: len 30; hex 39383830383036323535362d39303637303130303732332d383935373932; asc 98808062556-90670100723-895792; (total 60 bytes);

---TRANSACTION 3800763, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 1128, 1 row lock(s)
MySQL thread id 1240, OS thread handle 139942452344576, query id 36510205 172.16.179.20 appuser updating
UPDATE sbtest71 SET k=k+1 WHERE id=1600301
TABLE LOCK table `lizi`.`sbtest71` trx id 3800763 lock mode IX
RECORD LOCKS space id 84 page no 21956 n bits 144 index PRIMARY of table `lizi`.`sbtest71` trx id 3800763 lock_mode X locks rec but not gap
Record lock, heap no 33 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 80186b2d; asc   k-;;
1: len 6; hex 000000022a7c; asc     *|;;
2: len 7; hex 81000000ea2568; asc      %h;;
3: len 4; hex 800dd2a6; asc     ;;
4: len 30; hex 32333432363939363132322d37363238393532343433392d353337343538; asc 23426996122-76289524439-537458; (total 120 bytes);
5: len 30; hex 30303435303738343933352d38393835383231313135302d313738363335; asc 00450784935-89858211150-178635; (total 60 bytes);

---TRANSACTION 3800762, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
2 lock struct(s), heap size 1128, 1 row lock(s)
MySQL thread id 1248, OS thread handle 139941254219520, query id 36510188 172.16.179.20 appuser updating
UPDATE sbtest91 SET k=k+1 WHERE id=541984
TABLE LOCK table `lizi`.`sbtest91` trx id 3800762 lock mode IX
RECORD LOCKS space id 59 page no 7456 n bits 144 index PRIMARY of table `lizi`.`sbtest91` trx id 3800762 lock_mode X locks rec but not gap
Record lock, heap no 70 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 80084520; asc   E ;;
1: len 6; hex 000000014d39; asc     M9;;
2: len 7; hex 82000000ca0cec; asc        ;;
3: len 4; hex 8012ecb8; asc     ;;
4: len 30; hex 38353134313636303237362d34363238313730383735322d363735363037; asc 85141660276-46281708752-675607; (total 120 bytes);
5: len 30; hex 36363334393936303730322d32363130323735383537332d373833353031; asc 66349960702-26102758573-783501; (total 60 bytes);

---TRANSACTION 3800758, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
6 lock struct(s), heap size 1128, 3 row lock(s), undo log entries 2
MySQL thread id 1235, OS thread handle 139941248894720, query id 36510181 172.16.179.20 appuser updating
DELETE FROM sbtest34 WHERE id=898854
TABLE LOCK table `lizi`.`sbtest34` trx id 3800758 lock mode IX
TABLE LOCK table `lizi`.`sbtest68` trx id 3800758 lock mode IX
TABLE LOCK table `lizi`.`sbtest22` trx id 3800758 lock mode IX
RECORD LOCKS space id 21 page no 21432 n bits 144 index PRIMARY of table `lizi`.`sbtest22` trx id 3800758 lock_mode X locks rec but not gap
Record lock, heap no 66 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 8017d5e2; asc     ;;
1: len 6; hex 00000039feb6; asc    9  ;;
2: len 7; hex 02000000910ca5; asc        ;;
3: len 4; hex 8017110c; asc     ;;
4: len 30; hex 37333536303737393636342d38393931333538383735392d323433333231; asc 73560779664-89913588759-243321; (total 120 bytes);
5: len 30; hex 39373339383839343136362d35363536393039373831302d343030333039; asc 97398894166-56569097810-400309; (total 60 bytes);

RECORD LOCKS space id 93 page no 21099 n bits 144 index PRIMARY of table `lizi`.`sbtest68` trx id 3800758 lock_mode X locks rec but not gap
Record lock, heap no 7 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 801776b2; asc   v ;;
1: len 6; hex 00000039feb6; asc    9  ;;
2: len 7; hex 02000000910cd6; asc        ;;
3: len 4; hex 80150733; asc    3;;
4: len 30; hex 35333930363139333537372d36363230313337373739322d383434333430; asc 53906193577-66201377792-844340; (total 120 bytes);
5: len 30; hex 33353035343631303039312d30343134333730353136342d343737363139; asc 35054610091-04143705164-477619; (total 60 bytes);

RECORD LOCKS space id 12 page no 12345 n bits 144 index PRIMARY of table `lizi`.`sbtest34` trx id 3800758 lock_mode X locks rec but not gap
Record lock, heap no 43 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 800db726; asc    &;;
1: len 6; hex 000000008d28; asc      (;;
2: len 7; hex 810000016315c8; asc     c  ;;
3: len 4; hex 800c8951; asc    Q;;
4: len 30; hex 31383337393137343936342d32353030323535303839302d353033383637; asc 18379174964-25002550890-503867; (total 120 bytes);
5: len 30; hex 31343235363138333238302d31303834303539393131362d383334303739; asc 14256183280-10840599116-834079; (total 60 bytes);

---TRANSACTION 3800756, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
6 lock struct(s), heap size 1128, 3 row lock(s), undo log entries 3
MySQL thread id 1242, OS thread handle 139921685395200, query id 36510187 172.16.179.20 appuser update
INSERT INTO sbtest41 (id, k, c, pad) VALUES (1679476, 857577, '61225357370-51683908086-35941203903-24704724970-53798807695-10360345529-64002115980-42999889334-51970750166-82500059307', '81470977623-16404845401-83803123365-88853492177-21368212154')
TABLE LOCK table `lizi`.`sbtest41` trx id 3800756 lock mode IX
TABLE LOCK table `lizi`.`sbtest75` trx id 3800756 lock mode IX
TABLE LOCK table `lizi`.`sbtest43` trx id 3800756 lock mode IX
RECORD LOCKS space id 44 page no 23051 n bits 144 index PRIMARY of table `lizi`.`sbtest43` trx id 3800756 lock_mode X locks rec but not gap
Record lock, heap no 42 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 8019a375; asc    u;;
1: len 6; hex 00000039feb4; asc    9  ;;
2: len 7; hex 01000001c1234d; asc      #M;;
3: len 4; hex 800da3e2; asc     ;;
4: len 30; hex 36333439333735323534322d34373434393330383236312d383732333236; asc 63493752542-47449308261-872326; (total 120 bytes);
5: len 30; hex 35353032323030303832362d36333439323533303638322d313538303837; asc 55022000826-63492530682-158087; (total 60 bytes);

RECORD LOCKS space id 68 page no 4526 n bits 144 index PRIMARY of table `lizi`.`sbtest75` trx id 3800756 lock_mode X locks rec but not gap
Record lock, heap no 48 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 80050188; asc     ;;
1: len 6; hex 00000039feb4; asc    9  ;;
2: len 7; hex 01000001c1237e; asc      #~;;
3: len 4; hex 8010f994; asc     ;;
4: len 30; hex 38363034383932313033352d34373630343134313438382d333933373932; asc 86048921035-47604141488-393792; (total 120 bytes);
5: len 30; hex 31363739393735393936302d30363335343437313230342d333839383437; asc 16799759960-06354471204-389847; (total 60 bytes);

RECORD LOCKS space id 14 page no 23041 n bits 144 index PRIMARY of table `lizi`.`sbtest41` trx id 3800756 lock_mode X locks rec but not gap
Record lock, heap no 3 PHYSICAL RECORD: n_fields 6; compact format; info bits 32
0: len 4; hex 8019a074; asc    t;;
1: len 6; hex 00000039feb4; asc    9  ;;
2: len 7; hex 01000001c12414; asc      $ ;;
3: len 4; hex 800fc8e5; asc     ;;
4: len 30; hex 30373136313131313239302d39343537363339313238352d333838343432; asc 07161111290-94576391285-388442; (total 120 bytes);
5: len 30; hex 35363832393332323636312d38393736323733323636382d383235363831; asc 56829322661-89762732668-825681; (total 60 bytes);

---TRANSACTION 3800754, ACTIVE 0 sec inserting
mysql tables in use 1, locked 1
6 lock struct(s), heap size 1128, 3 row lock(s), undo log entries 4
MySQL thread id 1238, OS thread handle 139942719792896, query id 36510177 172.16.179.20 appuser update
INSERT INTO sbtest62 (id, k, c, pad) VALUES (1909723, 1195121, '57521883432-25787287305-81586963732-13662688159-19147192073-34279303487-77282197699-88491015675-13905195929-31307234875', '91300910225-46991423818-64372859782-44018231724-99316703238')
TABLE LOCK table `lizi`.`sbtest62` trx id 3800754 lock mode IX
TABLE LOCK table `lizi`.`sbtest30` trx id 3800754 lock mode IX
TABLE LOCK table `lizi`.`sbtest47` trx id 3800754 lock mode IX
RECORD LOCKS space id 36 page no 5445 n bits 144 index PRIMARY of table `lizi`.`sbtest47` trx id 3800754 lock_mode X locks rec but not gap
Record lock, heap no 64 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 800607a7; asc     ;;
1: len 6; hex 00000039feb2; asc    9  ;;
2: len 7; hex 02000001aa1524; asc       $;;
3: len 4; hex 8004ba67; asc    g;;
4: len 30; hex 39383636353435313534302d30343032353231313230332d363230333739; asc 98665451540-04025211203-620379; (total 120 bytes);
5: len 30; hex 33343539363637333130362d35363732373030333837342d383135353032; asc 34596673106-56727003874-815502; (total 60 bytes);

RECORD LOCKS space id 33 page no 5915 n bits 144 index PRIMARY of table `lizi`.`sbtest30` trx id 3800754 lock_mode X locks rec but not gap
Record lock, heap no 7 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 80068d74; asc    t;;
1: len 6; hex 00000039feb2; asc    9  ;;
2: len 7; hex 02000001aa1555; asc       U;;
3: len 4; hex 8019f322; asc    ";;
4: len 30; hex 37363234313933323136312d31393436313533333934392d353739353033; asc 76241932161-19461533949-579503; (total 120 bytes);
5: len 30; hex 38343030373535333535372d38373730363336383238342d353531343735; asc 84007553557-87706368284-551475; (total 60 bytes);

RECORD LOCKS space id 64 page no 26195 n bits 144 index PRIMARY of table `lizi`.`sbtest62` trx id 3800754 lock_mode X locks rec but not gap
Record lock, heap no 8 PHYSICAL RECORD: n_fields 6; compact format; info bits 0
0: len 4; hex 801d23db; asc   # ;;
1: len 6; hex 00000039feb2; asc    9  ;;
2: len 7; hex 02000001aa1616; asc        ;;
3: len 4; hex 80123c71; asc   <q;;
4: len 30; hex 35373532313838333433322d32353738373238373330352d383135383639; asc 57521883432-25787287305-815869; (total 120 bytes);
5: len 30; hex 39313330303931303232352d34363939313432333831382d363433373238; asc 91300910225-46991423818-643728; (total 60 bytes);

--------
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: complete io for buf page (write thread)
Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 1, 2, 1] ,
ibuf aio reads:, log i/o's:
Pending flushes (fsync) log: 0; buffer pool: 39913
307852 OS file reads, 49637150 OS file writes, 5875312 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 22416.11 writes/s, 11329.02 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 45464 merges
merged operations:
insert 0, delete mark 45479, delete 2
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 49937047, node heap has 0 buffer(s)
Hash table size 49937047, node heap has 0 buffer(s)
Hash table size 49937047, node heap has 0 buffer(s)
Hash table size 49937047, node heap has 0 buffer(s)
Hash table size 49937047, node heap has 0 buffer(s)
Hash table size 49937047, node heap has 0 buffer(s)
Hash table size 49937047, node heap has 0 buffer(s)
Hash table size 49937047, node heap has 0 buffer(s)
0.00 hash searches/s, 233674.78 non-hash searches/s
---
LOG
---
Log sequence number          81248467734
Log buffer assigned up to    81248467734
Log buffer completed up to   81248467734
Log written up to            81248467734
Log flushed up to            81248467734
Added dirty pages up to      81248467734
Pages flushed up to          75969385646
Last checkpoint at           75825754803
Log minimum file id is       376
Log maximum file id is       403
Modified age no less than    5245488495
Checkpoint age               5422712931
Max checkpoint age           5422668288
40750307 log i/o's done, 8557.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 0
Dictionary memory allocated 1980683
Buffer pool size   12319264
Buffer pool size, bytes 201838821376
Free buffers       9302520
Database pages     3016744
Old database pages 1113439
Modified db pages  1277276
Pending reads      0
Pending writes: LRU 0, flush list 16, single page 0
Pages made young 17795992, not young 749766
55020.90 youngs/s, 0.00 non-youngs/s
Pages read 167735, created 3018771, written 6909323
0.00 reads/s, 19.89 creates/s, 11842.25 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 46 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 3016744, unzip_LRU len: 0
I/O sum[3773776]:cur[43992], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   1539908
Buffer pool size, bytes 25229852672
Free buffers       1162016
Database pages     377892
Old database pages 139475
Modified db pages  160637
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2233972, not young 70874
6976.28 youngs/s, 0.00 non-youngs/s
Pages read 21653, created 378112, written 867541
0.00 reads/s, 3.56 creates/s, 1498.50 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 48 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 377892, unzip_LRU len: 0
I/O sum[471722]:cur[5499], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   1539908
Buffer pool size, bytes 25229852672
Free buffers       1159770
Database pages     380138
Old database pages 140304
Modified db pages  161031
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2240690, not young 75962
6946.00 youngs/s, 0.00 non-youngs/s
Pages read 20876, created 380116, written 870841
0.00 reads/s, 1.48 creates/s, 1496.72 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 43 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 380138, unzip_LRU len: 0
I/O sum[471722]:cur[5499], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   1539908
Buffer pool size, bytes 25229852672
Free buffers       1159345
Database pages     380563
Old database pages 140461
Modified db pages  161486
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2243298, not young 70165
6845.66 youngs/s, 0.00 non-youngs/s
Pages read 21352, created 380915, written 872323
0.00 reads/s, 3.27 creates/s, 1501.17 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 45 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 380563, unzip_LRU len: 0
I/O sum[471722]:cur[5499], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   1539908
Buffer pool size, bytes 25229852672
Free buffers       1155581
Database pages     384327
Old database pages 141850
Modified db pages  163348
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2269697, not young 257075
7023.77 youngs/s, 0.00 non-youngs/s
Pages read 21879, created 384501, written 885249
0.00 reads/s, 1.48 creates/s, 1538.87 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 41 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 384327, unzip_LRU len: 0
I/O sum[471722]:cur[5499], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   1539908
Buffer pool size, bytes 25229852672
Free buffers       1163040
Database pages     376868
Old database pages 139097
Modified db pages  159402
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2220297, not young 70413
6975.68 youngs/s, 0.00 non-youngs/s
Pages read 20041, created 377188, written 859796
0.00 reads/s, 1.78 creates/s, 1501.47 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 49 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 376868, unzip_LRU len: 0
I/O sum[471722]:cur[5499], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   1539908
Buffer pool size, bytes 25229852672
Free buffers       1178773
Database pages     361135
Old database pages 133289
Modified db pages  153321
Pending reads      0
Pending writes: LRU 0, flush list 7, single page 0
Pages made young 2134479, not young 71835
6568.70 youngs/s, 0.00 non-youngs/s
Pages read 22180, created 361072, written 829739
0.00 reads/s, 1.48 creates/s, 1369.96 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 57 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 361135, unzip_LRU len: 0
I/O sum[471722]:cur[5499], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   1539908
Buffer pool size, bytes 25229852672
Free buffers       1157959
Database pages     381949
Old database pages 140972
Modified db pages  160186
Pending reads      0
Pending writes: LRU 0, flush list 9, single page 0
Pages made young 2245875, not young 63369
6905.92 youngs/s, 0.00 non-youngs/s
Pages read 19339, created 382861, written 868035
0.00 reads/s, 2.37 creates/s, 1452.19 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 50 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 381949, unzip_LRU len: 0
I/O sum[471722]:cur[5499], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   1539908
Buffer pool size, bytes 25229852672
Free buffers       1166036
Database pages     373872
Old database pages 137991
Modified db pages  157865
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2207684, not young 70073
6778.87 youngs/s, 0.00 non-youngs/s
Pages read 20415, created 374006, written 855799
0.00 reads/s, 4.45 creates/s, 1483.36 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 38 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 373872, unzip_LRU len: 0
I/O sum[471722]:cur[5499], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
17 RW transactions active inside InnoDB
Process ID=26044, Main thread ID=139942730315520 , state=checking free log space
Number of rows inserted 201610691, updated 3641872, deleted 1820935, read 759359072
6369.88 inserts/s, 12740.42 updates/s, 6370.21 deletes/s, 2656145.95 reads/s
Number of system rows inserted 9543, updated 1890, deleted 6882, read 999999
10.33 inserts/s, 0.33 updates/s, 16.99 deletes/s, 18.66 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================

yejr 发表于 2024-4-24 17:54
还请再补充几个信息

1.  show variables like 'version_comment'; 结果

4、perftop




3、
Linux 3.10.0-1160.114.2.el7.x86_64 (m-node1)         04/24/2024         _x86_64_        (96 CPU)

07:19:45 PM   UID       PID    %usr %system  %guest    %CPU   CPU  Command
07:19:46 PM  2801     26044  739.00  124.00    0.00  863.00    22  mysqld
07:19:47 PM  2801     26044 1351.00  235.00    0.00 1586.00    22  mysqld
07:19:48 PM  2801     26044  477.00   76.00    0.00  553.00    22  mysqld
07:19:49 PM  2801     26044  899.00  190.00    0.00 1089.00    24  mysqld
07:19:50 PM  2801     26044  806.00  182.00    0.00  988.00    24  mysqld
07:19:51 PM  2801     26044  590.00  128.00    0.00  718.00    24  mysqld
07:19:52 PM  2801     26044 1383.00  244.00    0.00 1627.00    24  mysqld
07:19:53 PM  2801     26044 1376.00  262.00    0.00 1638.00    24  mysqld
07:19:54 PM  2801     26044  822.00  147.00    0.00  969.00    24  mysqld
07:19:55 PM  2801     26044  961.39  160.40    0.00 1121.78    24  mysqld
07:19:56 PM  2801     26044 1386.00  238.00    0.00 1624.00    24  mysqld
07:19:57 PM  2801     26044 1376.00  232.00    0.00 1608.00     5  mysqld
07:19:58 PM  2801     26044 1295.00  212.00    0.00 1507.00     5  mysqld
07:19:59 PM  2801     26044   79.00   26.00    0.00  105.00     4  mysqld
07:20:00 PM  2801     26044 1372.00  234.00    0.00 1606.00     4  mysqld
07:20:01 PM  2801     26044 1377.00  236.00    0.00 1613.00     4  mysqld
07:20:02 PM  2801     26044 1223.00  209.00    0.00 1432.00     4  mysqld
07:20:03 PM  2801     26044  137.00   53.00    0.00  190.00     4  mysqld
07:20:04 PM  2801     26044 1382.00  240.00    0.00 1622.00     4  mysqld
07:20:05 PM  2801     26044 1376.00  238.00    0.00 1614.00     4  mysqld
07:20:06 PM  2801     26044 1382.00  237.00    0.00 1619.00     4  mysqld
07:20:07 PM  2801     26044   39.00   21.00    0.00   60.00     4  mysqld
07:20:08 PM  2801     26044 1335.00  229.00    0.00 1564.00     4  mysqld
07:20:09 PM  2801     26044 1348.51  237.62    0.00 1586.14    20  mysqld
07:20:10 PM  2801     26044 1369.00  223.00    0.00 1592.00    20  mysqld
07:20:11 PM  2801     26044  419.00   81.00    0.00  500.00    20  mysqld
07:20:12 PM  2801     26044  942.00  187.00    0.00 1129.00    20  mysqld
07:20:13 PM  2801     26044 1370.00  232.00    0.00 1602.00    20  mysqld
07:20:14 PM  2801     26044  642.00  106.00    0.00  748.00    20  mysqld
07:20:15 PM  2801     26044  240.00   52.00    0.00  292.00    20  mysqld
07:20:16 PM  2801     26044 1150.00  215.00    0.00 1365.00    20  mysqld
07:20:17 PM  2801     26044  270.00   99.00    0.00  369.00    39  mysqld
07:20:18 PM  2801     26044 1370.00  247.00    0.00 1617.00    39  mysqld
07:20:19 PM  2801     26044 1379.00  248.00    0.00 1627.00    32  mysqld

07:20:19 PM   UID       PID    %usr %system  %guest    %CPU   CPU  Command
07:20:20 PM  2801     26044 1381.00  250.00    0.00 1631.00    32  mysqld
07:20:21 PM  2801     26044 1117.82  197.03    0.00 1314.85    32  mysqld
07:20:22 PM  2801     26044 1365.00  225.00    0.00 1590.00    32  mysqld
07:20:23 PM  2801     26044 1361.00  237.00    0.00 1598.00    32  mysqld
07:20:24 PM  2801     26044  832.00  173.00    0.00 1005.00    32  mysqld
07:20:25 PM  2801     26044  570.00  124.00    0.00  694.00    32  mysqld
07:20:26 PM  2801     26044 1381.00  258.00    0.00 1639.00    32  mysqld
07:20:27 PM  2801     26044 1348.00  237.00    0.00 1585.00    32  mysqld
07:20:28 PM  2801     26044 1054.00  223.00    0.00 1277.00    32  mysqld
07:20:29 PM  2801     26044  848.00  180.00    0.00 1028.00    32  mysqld
07:20:30 PM  2801     26044 1385.00  269.00    0.00 1654.00    32  mysqld
07:20:31 PM  2801     26044 1364.00  261.00    0.00 1625.00    32  mysqld
07:20:32 PM  2801     26044 1074.00  195.00    0.00 1269.00    32  mysqld
07:20:33 PM  2801     26044  288.00   65.00    0.00  353.00    32  mysqld
07:20:34 PM  2801     26044 1348.51  231.68    0.00 1580.20    32  mysqld
07:20:35 PM  2801     26044 1351.00  224.00    0.00 1575.00    32  mysqld
07:20:36 PM  2801     26044 1328.00  221.00    0.00 1549.00    32  mysqld
07:20:37 PM  2801     26044   42.00   13.00    0.00   55.00    32  mysqld
07:20:38 PM  2801     26044  802.00  137.00    0.00  939.00    32  mysqld
07:20:39 PM  2801     26044 1102.00  194.00    0.00 1296.00    18  mysqld
07:20:40 PM  2801     26044 1393.00  277.00    0.00 1670.00    18  mysqld
07:20:41 PM  2801     26044 1041.00  189.00    0.00 1230.00    18  mysqld
07:20:42 PM  2801     26044  336.00   80.00    0.00  416.00    18  mysqld
07:20:43 PM  2801     26044 1390.00  258.00    0.00 1648.00    18  mysqld
07:20:44 PM  2801     26044 1385.00  265.00    0.00 1650.00    18  mysqld
07:20:45 PM  2801     26044 1380.00  255.00    0.00 1635.00    18  mysqld
07:20:46 PM  2801     26044  183.00   64.00    0.00  247.00    18  mysqld
07:20:47 PM  2801     26044 1198.00  201.00    0.00 1399.00    18  mysqld
07:20:48 PM  2801     26044 1342.57  234.65    0.00 1577.23    18  mysqld
07:20:49 PM  2801     26044 1371.00  227.00    0.00 1598.00    18  mysqld
07:20:50 PM  2801     26044 1353.00  225.00    0.00 1578.00    18  mysqld
07:20:51 PM  2801     26044 1357.00  222.00    0.00 1579.00    18  mysqld
07:20:52 PM  2801     26044  320.00   56.00    0.00  376.00    25  mysqld
07:20:53 PM  2801     26044 1033.00  181.00    0.00 1214.00    25  mysqld

07:20:53 PM   UID       PID    %usr %system  %guest    %CPU   CPU  Command
07:20:54 PM  2801     26044  880.00  159.00    0.00 1039.00    25  mysqld
07:20:55 PM  2801     26044   10.00   15.00    0.00   25.00    25  mysqld
07:20:56 PM  2801     26044  488.00  118.00    0.00  606.00    25  mysqld
07:20:57 PM  2801     26044 1381.00  276.00    0.00 1657.00     9  mysqld
07:20:58 PM  2801     26044 1379.00  279.00    0.00 1658.00     9  mysqld
07:20:59 PM  2801     26044  140.00   66.00    0.00  206.00    30  mysqld
07:21:00 PM  2801     26044 1231.68  236.63    0.00 1468.32    30  mysqld
07:21:01 PM  2801     26044 1361.00  252.00    0.00 1613.00    30  mysqld
07:21:02 PM  2801     26044 1380.00  264.00    0.00 1644.00    30  mysqld
07:21:03 PM  2801     26044 1355.00  230.00    0.00 1585.00    30  mysqld
07:21:04 PM  2801     26044 1364.00  235.00    0.00 1599.00    30  mysqld
07:21:05 PM  2801     26044 1365.00  226.00    0.00 1591.00    30  mysqld
07:21:06 PM  2801     26044  116.00   27.00    0.00  143.00    30  mysqld
07:21:07 PM  2801     26044 1097.00  185.00    0.00 1282.00    30  mysqld
07:21:08 PM  2801     26044 1345.00  229.00    0.00 1574.00    30  mysqld
07:21:09 PM  2801     26044 1227.00  211.00    0.00 1438.00    30  mysqld
07:21:10 PM  2801     26044 1313.00  228.00    0.00 1541.00    30  mysqld
07:21:11 PM  2801     26044 1142.57  234.65    0.00 1377.23    30  mysqld
07:21:12 PM  2801     26044  242.00   78.00    0.00  320.00    30  mysqld
07:21:13 PM  2801     26044 1367.00  257.00    0.00 1624.00    30  mysqld
07:21:14 PM  2801     26044 1388.00  284.00    0.00 1672.00    30  mysqld
07:21:15 PM  2801     26044 1382.00  260.00    0.00 1642.00    30  mysqld
07:21:16 PM  2801     26044  228.00   77.00    0.00  305.00    30  mysqld
07:21:17 PM  2801     26044 1151.00  206.00    0.00 1357.00    13  mysqld
07:21:18 PM  2801     26044 1367.00  239.00    0.00 1606.00    13  mysqld
07:21:19 PM  2801     26044 1369.00  232.00    0.00 1601.00    22  mysqld
07:21:20 PM  2801     26044  658.00  112.00    0.00  770.00    22  mysqld
07:21:21 PM  2801     26044 1338.00  220.00    0.00 1558.00    22  mysqld
07:21:22 PM  2801     26044 1369.00  219.00    0.00 1588.00    22  mysqld
07:21:23 PM  2801     26044 1358.42  217.82    0.00 1576.24    22  mysqld
07:21:24 PM  2801     26044   40.00   14.00    0.00   54.00    22  mysqld
07:21:25 PM  2801     26044  427.00   78.00    0.00  505.00    22  mysqld
Average:     2801     26044 1023.64  186.98    0.00 1210.62     -  mysqld

mabai 发表于 2024-4-24 19:21
yejr 发表于 2024-4-24 17:54
还请再补充几个信息

https://gitee.com/GreatSQL/Great ... /GreatSQL-8.0.32-25

请先改用Linux Generic版本，而不使用国密版本再观察下。

此外，把MGR、VIP等也都先停掉，只单纯测试单机单实例场景，排除一些额外的干扰因素。

yejr 发表于 2024-4-25 10:10
https://gitee.com/GreatSQL/GreatSQL/releases/tag/GreatSQL-8.0.32-25

请先改用Linux Generic版本，而 ...

已经改为了 非国密版 并且 关闭mgr和vip


select @@version;
+-----------+
| @@version |
+-----------+
| 8.0.32-25 |
+-----------+
1 row in set (0.00 sec)


目前压单机 greatsql  1

6thds   偶发 tps & qps 为0
性能也会有波动，比如 突然从几千的tps降为几百或者几十都有



持续一段时间后



vmstat -S m 1 100




perf top




64thds 时候频繁出现tps & qps 为0的情况


vmstat


perf top

mabai 发表于 2024-4-25 11:18

在我之前的测试中，绝没出现过这么大幅度和这么频繁的波动，有可能是测试机环境或CPU、内存等原因导致的

请尝试用sysbench测试CPU、内存tps，看看是否也存在抖动

yejr 发表于 2024-4-25 15:42
在我之前的测试中，绝没出现过这么大幅度和这么频繁的波动，有可能是测试机环境或CPU、内存等原因导致的
...

我也压测了一下，不过机器没这位兄弟配置高，总体下来也没出现性能抖动的情况

机器配置：16C32G    硬盘SSD：500G
参数：ibf：16G numa=on
压测命令：
sysbench --db-driver=mysql --threads=16 --events=0 --tables=10 --table_size=10000000 --mysql-host=10.xx.xx.80 --mysql-port=3306 --mysql-db=sysbench_test --mysql-user=root --mysql-password='Test@2023' --time=600 --report-interval=1 oltp_read_write run

驭无殇1998 发表于 2024-4-29 15:02
我也压测了一下，不过机器没这位兄弟配置高，总体下来也没出现性能抖动的情况

机器配置：16C32G ...

是呢，所以我也挺郁闷的，只能先用各种排除法了

yejr 发表于 2024-4-29 16:03
是呢，所以我也挺郁闷的，只能先用各种排除法了

我后面也出现性能抖动的情况了，可能是压测的数据量太大了导致的

机器配置：16C32G    硬盘SSD：500G
参数：ibf：16G numa=on
压测命令：
sysbench --db-driver=mysql --threads=128 --events=0 --tables=10 --table_size=100000000 --mysql-host=10.xx.xx.80 --mysql-port=3306 --mysql-db=sysbench_test --mysql-user=root --mysql-password='Test@2023' --time=600 --report-interval=1 oltp_read_write run


tps跟qps都在跳动，短暂变为0。不过我的压测数据量大，应该是机器撑不住了