Typical problem in MySQL Is contention. It can be measured in Performance Schema but with high overhead and also it does not cover every single mutex in Innodb. Lower overhead solution is to use SHOW ENGINE INNODB MUTEX. The example is below.
It is a little bit messy so I would suggest
-
We should report spins, waits, calls as separate metrics if they are available.
-
Many mutexes has different instances which is not very valueable. Ie we can go ahead and sum all REDO_RSEG values together to the same instance. We can also of course automatically enumerate instances but I do not think it is very valuable
mysql> SHOW ENGINE INNODB MUTEX;
+--------+-----------------------------+---------------------------------------------------+
| Type | Name | Status |
+--------+-----------------------------+---------------------------------------------------+
| InnoDB | SRV_SYS | spins=3500411239,waits=267487891,calls=1150977077 |
| InnoDB | LOCK_SYS | spins=2770124116,waits=52386148,calls=369741367 |
| InnoDB | FIL_SYSTEM | spins=1927887219,waits=32227483,calls=990239836 |
| InnoDB | TRX_SYS | spins=1190134826,waits=28696583,calls=193053443 |
| InnoDB | LOG_SYS | spins=873904266,waits=19456959,calls=154920419 |
| InnoDB | BUF_POOL_LRU_LIST | spins=305708888,waits=8253271,calls=37353349 |
| InnoDB | BUF_POOL_LRU_LIST | spins=303686238,waits=8143288,calls=37886754 |
| InnoDB | BUF_POOL_LRU_LIST | spins=298254804,waits=7984666,calls=36866000 |
| InnoDB | BUF_POOL_LRU_LIST | spins=259590882,waits=6765874,calls=35781678 |
| InnoDB | BUF_POOL_LRU_LIST | spins=259624966,waits=6685413,calls=36449305 |
| InnoDB | BUF_POOL_LRU_LIST | spins=251385823,waits=6523969,calls=34917332 |
| InnoDB | BUF_POOL_LRU_LIST | spins=250547147,waits=6512303,calls=35102085 |
| InnoDB | BUF_POOL_LRU_LIST | spins=244496236,waits=6372300,calls=32958490 |
| InnoDB | TRX | spins=165920974,waits=2861196,calls=143755919 |
| InnoDB | DICT_SYS | spins=112221188,waits=2454475,calls=31314656 |
| InnoDB | PURGE_SYS_PQ | spins=72430126,waits=1145907,calls=17977583 |
| InnoDB | IBUF | spins=48347207,waits=871004,calls=3355836 |
| InnoDB | SRV_SYS_TASKS | spins=85910398,waits=474202,calls=116252876 |
| InnoDB | REDO_RSEG | spins=15626173,waits=474098,calls=1182167 |
| InnoDB | REDO_RSEG | spins=15620277,waits=473794,calls=1147402 |
| InnoDB | REDO_RSEG | spins=15420310,waits=467224,calls=1106054 |
| InnoDB | REDO_RSEG | spins=15373199,waits=467202,calls=1078613 |
| InnoDB | REDO_RSEG | spins=15359871,waits=466547,calls=1104583 |
| InnoDB | REDO_RSEG | spins=15350008,waits=465970,calls=1067286 |
| InnoDB | REDO_RSEG | spins=15382183,waits=465887,calls=1136128 |
| InnoDB | REDO_RSEG | spins=15318755,waits=465148,calls=1089808 |
| InnoDB | REDO_RSEG | spins=15340558,waits=465029,calls=1085688 |
| InnoDB | REDO_RSEG | spins=15310407,waits=465002,calls=1171755 |
| InnoDB | REDO_RSEG | spins=15311401,waits=464833,calls=1087047 |
| InnoDB | REDO_RSEG | spins=15318492,waits=464527,calls=1100488 |
| InnoDB | REDO_RSEG | spins=15278457,waits=464286,calls=1055289 |
| InnoDB | REDO_RSEG | spins=15303151,waits=464190,calls=1066879 |
| InnoDB | REDO_RSEG | spins=15284608,waits=464064,calls=1071319 |
| InnoDB | REDO_RSEG | spins=15330035,waits=464005,calls=1161665 |
| InnoDB | REDO_RSEG | spins=15288952,waits=463422,calls=1097419 |
| InnoDB | REDO_RSEG | spins=15277615,waits=463369,calls=1122432 |
| InnoDB | REDO_RSEG | spins=15257972,waits=463027,calls=1084185 |
| InnoDB | REDO_RSEG | spins=15251323,waits=462994,calls=1131013 |
| InnoDB | REDO_RSEG | spins=15278678,waits=462866,calls=1107131 |
| InnoDB | REDO_RSEG | spins=15263930,waits=462553,calls=1093379 |
| InnoDB | REDO_RSEG | spins=15246888,waits=462507,calls=1072777 |
| InnoDB | REDO_RSEG | spins=15234577,waits=462476,calls=1060580 |
| InnoDB | REDO_RSEG | spins=15258912,waits=462334,calls=1089671 |
| InnoDB | REDO_RSEG | spins=15233874,waits=462266,calls=1121470 |
| InnoDB | REDO_RSEG | spins=15213876,waits=462053,calls=1066006 |
| InnoDB | REDO_RSEG | spins=15216512,waits=461914,calls=1065139 |
| InnoDB | REDO_RSEG | spins=15215638,waits=461326,calls=1075909 |
| InnoDB | REDO_RSEG | spins=15156706,waits=459742,calls=1092541 |
| InnoDB | REDO_RSEG | spins=15158825,waits=459520,calls=1146328 |
| InnoDB | REDO_RSEG | spins=15112832,waits=457651,calls=1149953 |
| InnoDB | BUF_POOL_FREE_LIST | spins=19147008,waits=311651,calls=8283743 |
| InnoDB | BUF_POOL_FREE_LIST | spins=19305540,waits=309198,calls=8543700 |
| InnoDB | BUF_POOL_FREE_LIST | spins=18896017,waits=305508,calls=8319354 |
| InnoDB | BUF_POOL_FREE_LIST | spins=18441546,waits=282556,calls=8539621 |
| InnoDB | BUF_POOL_FREE_LIST | spins=17802231,waits=281080,calls=8015209 |
| InnoDB | BUF_POOL_FREE_LIST | spins=17603942,waits=275037,calls=7992564 |
| InnoDB | BUF_POOL_FREE_LIST | spins=17332541,waits=273486,calls=7895483 |
| InnoDB | IBUF_PESSIMISTIC_INSERT | spins=8183904,waits=267410,calls=84911 |
| InnoDB | BUF_POOL_FREE_LIST | spins=15021782,waits=235659,calls=6893558 |
| InnoDB | FLUSH_LIST | spins=8930079,waits=216830,calls=2832488 |
| InnoDB | LOCK_SYS_WAIT | spins=5935897,waits=194925,calls=219719 |
| InnoDB | REDO_RSEG | spins=5342080,waits=156818,calls=492335 |
| InnoDB | FLUSH_LIST | spins=6813677,waits=150487,calls=2377616 |
| InnoDB | REDO_RSEG | spins=5096171,waits=150266,calls=475555 |
| InnoDB | REDO_RSEG | spins=5085579,waits=149903,calls=490663 |
| InnoDB | REDO_RSEG | spins=5072863,waits=149264,calls=460653 |
| InnoDB | REDO_RSEG | spins=5053561,waits=148982,calls=448409 |
| InnoDB | REDO_RSEG | spins=5063171,waits=148912,calls=447761 |
| InnoDB | REDO_RSEG | spins=5054505,waits=148830,calls=451434 |
| InnoDB | REDO_RSEG | spins=5055290,waits=148805,calls=511804 |
| InnoDB | REDO_RSEG | spins=5050772,waits=148712,calls=472890 |
| InnoDB | REDO_RSEG | spins=5045732,waits=148663,calls=460930 |
| InnoDB | REDO_RSEG | spins=5043975,waits=148544,calls=448090 |
| InnoDB | REDO_RSEG | spins=5038922,waits=148534,calls=445477 |
| InnoDB | REDO_RSEG | spins=5041281,waits=148490,calls=449476 |
| InnoDB | REDO_RSEG | spins=5026618,waits=148464,calls=459996 |
| InnoDB | REDO_RSEG | spins=5036396,waits=148430,calls=457941 |
| InnoDB | REDO_RSEG | spins=5030671,waits=148336,calls=451112 |
| InnoDB | REDO_RSEG | spins=5033599,waits=148333,calls=447780 |
| InnoDB | REDO_RSEG | spins=5040033,waits=148320,calls=461696 |
| InnoDB | REDO_RSEG | spins=5030396,waits=148263,calls=450691 |
| InnoDB | REDO_RSEG | spins=5027055,waits=148226,calls=509834 |
| InnoDB | REDO_RSEG | spins=5031222,waits=148150,calls=452321 |
| InnoDB | REDO_RSEG | spins=5026201,waits=148069,calls=478661 |
| InnoDB | REDO_RSEG | spins=5023842,waits=148011,calls=469608 |
| InnoDB | REDO_RSEG | spins=5025718,waits=147970,calls=450526 |
| InnoDB | REDO_RSEG | spins=5024063,waits=147941,calls=462225 |
| InnoDB | REDO_RSEG | spins=5027594,waits=147882,calls=448647 |
| InnoDB | REDO_RSEG | spins=5018911,waits=147865,calls=451132 |
| InnoDB | REDO_RSEG | spins=5014486,waits=147773,calls=466817 |
| InnoDB | REDO_RSEG | spins=5020818,waits=147760,calls=491528 |
| InnoDB | REDO_RSEG | spins=5012253,waits=147749,calls=470739 |
| InnoDB | REDO_RSEG | spins=5016553,waits=147746,calls=446532 |
| InnoDB | REDO_RSEG | spins=5022528,waits=147675,calls=451637 |
| InnoDB | REDO_RSEG | spins=5017647,waits=147668,calls=510209 |
| InnoDB | REDO_RSEG | spins=5015310,waits=147647,calls=505735 |
| InnoDB | REDO_RSEG | spins=5026094,waits=147631,calls=447058 |
| InnoDB | REDO_RSEG | spins=5014468,waits=147620,calls=461763 |
| InnoDB | REDO_RSEG | spins=5015414,waits=147608,calls=487644 |
| InnoDB | REDO_RSEG | spins=5011666,waits=147574,calls=444176 |
| InnoDB | REDO_RSEG | spins=5003262,waits=147433,calls=447693 |
| InnoDB | REDO_RSEG | spins=5009768,waits=147385,calls=495284 |
| InnoDB | REDO_RSEG | spins=5008209,waits=147356,calls=491539 |
| InnoDB | REDO_RSEG | spins=5007224,waits=147353,calls=510011 |
| InnoDB | REDO_RSEG | spins=5008434,waits=147331,calls=466573 |
| InnoDB | REDO_RSEG | spins=5010627,waits=147324,calls=473984 |
| InnoDB | REDO_RSEG | spins=5005185,waits=147308,calls=461726 |
| InnoDB | REDO_RSEG | spins=5004322,waits=147280,calls=445766 |
| InnoDB | REDO_RSEG | spins=5004583,waits=147277,calls=451037 |
| InnoDB | REDO_RSEG | spins=4996624,waits=147238,calls=456276 |
| InnoDB | REDO_RSEG | spins=4996747,waits=147228,calls=448720 |
| InnoDB | REDO_RSEG | spins=5003972,waits=147206,calls=446709 |
| InnoDB | REDO_RSEG | spins=4993807,waits=147195,calls=447935 |
| InnoDB | REDO_RSEG | spins=4992877,waits=147057,calls=446730 |
| InnoDB | REDO_RSEG | spins=4996315,waits=146984,calls=496389 |
| InnoDB | REDO_RSEG | spins=4991689,waits=146941,calls=488683 |
| InnoDB | REDO_RSEG | spins=4992033,waits=146918,calls=450508 |
| InnoDB | REDO_RSEG | spins=4989775,waits=146891,calls=468775 |
| InnoDB | REDO_RSEG | spins=4994315,waits=146846,calls=491008 |
| InnoDB | REDO_RSEG | spins=4979573,waits=146734,calls=444547 |
| InnoDB | REDO_RSEG | spins=4987601,waits=146627,calls=449461 |
| InnoDB | REDO_RSEG | spins=4985557,waits=146455,calls=503852 |
| InnoDB | REDO_RSEG | spins=4979875,waits=146435,calls=450950 |
| InnoDB | REDO_RSEG | spins=4967878,waits=146114,calls=447416 |
| InnoDB | REDO_RSEG | spins=4961927,waits=146085,calls=461316 |
| InnoDB | REDO_RSEG | spins=4916113,waits=144768,calls=465814 |
| InnoDB | FLUSH_LIST | spins=5604567,waits=129192,calls=1841249 |
| InnoDB | FLUSH_LIST | spins=5354980,waits=122332,calls=1747357 |
| InnoDB | LOG_FLUSH_ORDER | spins=4115154,waits=66946,calls=1686229 |
| InnoDB | FLUSH_LIST | spins=2160697,waits=43455,calls=1056246 |
| InnoDB | PAGE_CLEANER | spins=1087059,waits=34926,calls=41245 |
| InnoDB | BUF_BLOCK_MUTEX | spins=976252,waits=31396,calls=130710 |
| InnoDB | FLUSH_LIST | spins=1352045,waits=24891,calls=626464 |
| InnoDB | FILE_FORMAT_MAX | spins=759599,waits=23302,calls=728164 |
| InnoDB | FLUSH_LIST | spins=1049383,waits=20958,calls=316570 |
| InnoDB | FLUSH_LIST | spins=984943,waits=18797,calls=379497 |
| InnoDB | TRX | spins=22709,waits=439,calls=1809 |
| InnoDB | TRX | spins=20272,waits=413,calls=1637 |
| InnoDB | TRX | spins=19877,waits=388,calls=1624 |
| InnoDB | TRX | spins=18775,waits=380,calls=1543 |
| InnoDB | TRX | spins=19494,waits=375,calls=1586 |
| InnoDB | TRX | spins=18513,waits=355,calls=1565 |
| InnoDB | TRX | spins=17570,waits=334,calls=1505 |
| InnoDB | TRX | spins=17340,waits=329,calls=1531 |
| InnoDB | BUF_POOL_FLUSH_STATE | spins=16509,waits=171,calls=9629 |
| InnoDB | TRX | spins=7008,waits=112,calls=1075 |
| InnoDB | TRX | spins=6541,waits=98,calls=1033 |
| InnoDB | TRX | spins=6035,waits=92,calls=987 |
| InnoDB | BUF_POOL_FLUSH_STATE | spins=5590,waits=89,calls=2318 |
| InnoDB | TRX | spins=6043,waits=85,calls=1057 |
| InnoDB | TRX | spins=5939,waits=85,calls=1050 |
| InnoDB | TRX | spins=5973,waits=85,calls=1037 |
| InnoDB | BUF_POOL_FLUSH_STATE | spins=5039,waits=84,calls=1990 |
| InnoDB | BUF_POOL_FLUSH_STATE | spins=6566,waits=84,calls=3373 |
| InnoDB | BUF_POOL_FLUSH_STATE | spins=5647,waits=84,calls=2573 |
| InnoDB | TRX_POOL | spins=2630,waits=82,calls=176 |
| InnoDB | BUF_POOL_FLUSH_STATE | spins=2797,waits=43,calls=1728 |
| InnoDB | BUF_POOL_FLUSH_STATE | spins=2680,waits=42,calls=1567 |
| InnoDB | BUF_POOL_FLUSH_STATE | spins=2489,waits=38,calls=1544 |
| InnoDB | RW_LOCK_LIST | spins=1044,waits=34,calls=79 |
| InnoDB | SRV_INNODB_MONITOR | spins=122,waits=4,calls=5 |
| InnoDB | TRX_POOL_MANAGER | spins=45,waits=0,calls=51 |
| InnoDB | rwlock: dict0dict.cc:294 | waits=9 |
| InnoDB | rwlock: dict0dict.cc:294 | waits=5 |
| InnoDB | rwlock: dict0dict.cc:2673 | waits=113033816 |
| InnoDB | rwlock: dict0dict.cc:294 | waits=1 |
| InnoDB | rwlock: dict0dict.cc:2673 | waits=20 |
| InnoDB | rwlock: fil0fil.cc:1356 | waits=2 |
| InnoDB | rwlock: fil0fil.cc:1356 | waits=3154 |
| InnoDB | rwlock: trx0purge.cc:238 | waits=96 |
| InnoDB | rwlock: ibuf0ibuf.cc:575 | waits=10928996 |
| InnoDB | rwlock: dict0dict.cc:1184 | waits=62678 |
| InnoDB | rwlock: fil0fil.cc:1356 | waits=287744 |
| InnoDB | rwlock: log0log.cc:889 | waits=109193 |
| InnoDB | rwlock: btr0sea.cc:195 | waits=478245855 |
| InnoDB | rwlock: btr0sea.cc:195 | waits=9817649 |
| InnoDB | rwlock: btr0sea.cc:195 | waits=18 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=38811 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=38344 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=40090 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=40130 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=38972 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=39939 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=39964 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=39700 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=39186 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=39917 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=39518 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=40125 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=40374 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=40195 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=40011 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=41201 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=334979 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=46465 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=5533810 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=385885 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=208747 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=48204 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=192571 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=237714 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=49308 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=48972 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=52493 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=49051 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=49319 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=205644 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=51569 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=62837 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=38805 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=38659 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=38936 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=40551 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=40310 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=41528 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=41712 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=40201 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=40412 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=40384 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=40372 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=40414 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=40696 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=40269 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=40190 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=41850 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=34960 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=34035 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=34760 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=35177 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=34946 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=34924 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=36190 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=34959 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=38746 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=34936 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=36951 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=36331 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=38140 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=36952 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=38048 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=37505 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=29173 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=28959 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=29324 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=29730 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=30663 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=31838 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=28755 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=30440 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=30345 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=30682 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=31079 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=30549 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=31203 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=30523 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=29054 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=31998 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=31074 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=31086 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=31792 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=32587 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=31218 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=32143 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=32690 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=32169 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=32350 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=32739 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=32875 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=33421 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=32898 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=32547 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=33110 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=33908 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=29965 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=29969 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=31032 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=30499 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=30374 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=31068 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=31245 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=30974 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=31095 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=31463 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=31243 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=31380 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=31432 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=31398 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=31970 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=32429 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=35113 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=32723 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=33908 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=34156 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=33562 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=33822 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=33803 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=34242 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=34348 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=34268 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=34617 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=34841 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=34414 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=34327 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=34520 |
| InnoDB | rwlock: hash0hash.cc:353 | waits=46112 |
| InnoDB | sum rwlock: buf0buf.cc:1413 | waits=32692948 |
+--------+-----------------------------+---------------------------------------------------+
306 rows in set (0.04 sec)