Type	Name	Status
InnoDB		
=====================================
2021-09-09 13:30:23 0x7f7873687700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 10 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 1 srv_active, 0 srv_shutdown, 4389 srv_idle
srv_master_thread log flush and writes: 4390
----------
SEMAPHORES
----------
------------
TRANSACTIONS
------------
Trx id counter 26658257013
Purge done for trx's n:o < 26658164266 undo n:o < 0 state: running
History list length 40414
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION (0x7f9efb490a30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb48f930), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb48c630), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb48a430), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb489330), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb488230), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb487130), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb486030), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb484f30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb483e30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb482d30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb481c30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb480b30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb47fa30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb47e930), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb47d830), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb47c730), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb479430), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb478330), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb477230), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb476130), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb475030), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb473f30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb472e30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb47b630), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb47a530), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb471d30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb470c30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb46fb30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb46ea30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb46d930), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb46c830), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb46b730), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb46a630), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb467330), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb465130), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb466230), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb468430), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb469530), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb464030), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb462f30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb461e30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb460d30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb45fc30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb45eb30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb45da30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb45c930), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb453030), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb451f30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb450e30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb44fd30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb44ec30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb455230), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb45b830), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb45a730), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb459630), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb458530), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb457430), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb454130), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb456330), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb44db30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb44ca30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb44b930), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb44a830), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb446430), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb445330), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb443130), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb444230), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb449730), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb447530), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb448630), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb442030), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb440f30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb43fe30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb43ed30), ACTIVE 269 sec starting index read
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 64935, OS thread handle 140157876987648, query id 1013688 localhost root Creating sort index
SELECT *****
Trx read view will not see trx with id >= 26658256976, sees < 26658256616
---TRANSACTION (0x7f9efb43dc30), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb43cb30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb43ba30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb43a930), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb439830), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb438730), ACTIVE 285 sec fetching rows
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 64411, OS thread handle 140157876680448, query id 1011579 localhost root Sending data
SELECT *******
Trx read view will not see trx with id >= 26658256976, sees < 26658256616
---TRANSACTION (0x7f9efb436530), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb437630), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb435430), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb42ff30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb42ee30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb42bb30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb42aa30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb434330), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb433230), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb432130), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb431030), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb42dd30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb42cc30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb429930), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb428830), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb427730), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb426630), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb425530), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb424430), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb423330), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb421130), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb420030), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb41ef30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb41de30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb41ab30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb41cd30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb41bc30), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb422230), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb419a30), ACTIVE 383 sec fetching rows
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 63407, OS thread handle 140157878523648, query id 1007431 localhost sitewordpress Sending data
SELECT opti****
Trx read view will not see trx with id >= 26658256957, sees < 26658256616
---TRANSACTION 26658256956, ACTIVE 384 sec inserting
mysql tables in use 1, locked 1
1 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 63406, OS thread handle 140157874837248, query id 1007425 localhost sitewordpress Update
INSERT INTO `wp****
---TRANSACTION (0x7f9efb418930), ACTIVE 386 sec starting index read
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 63403, OS thread handle 140157871458048, query id 1007292 localhost sitewordpress Statistics
SELECT ****
Trx read view will not see trx with id >= 26658256936, sees < 26658256616
---TRANSACTION (0x7f9efb417830), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb416730), not started estimating records in index range
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb411230), ACTIVE 408 sec starting index read
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 63397, OS thread handle 140157884360448, query id 1006345 localhost sitewordpress Sending data
SELECT ****
Trx read view will not see trx with id >= 26658256854, sees < 26658256616
---TRANSACTION (0x7f9efb40f030), ACTIVE 405 sec starting index read
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 63396, OS thread handle 140157876066048, query id 1006346 localhost sitewordpress Sending data
SELECT ****
Trx read view will not see trx with id >= 26658256867, sees < 26658256616
---TRANSACTION (0x7f9efb40df30), ACTIVE 408 sec starting index read
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 63391, OS thread handle 140320753342208, query id 1006194 localhost sitewordpress Sending data
SELECT ****
Trx read view will not see trx with id >= 26658256854, sees < 26658256616
---TRANSACTION (0x7f9efb40ac30), ACTIVE 459 sec fetching rows
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 63364, OS thread handle 140320754263808, query id 1005089 localhost sitewordpress Creating sort index
SELECT ****
Trx read view will not see trx with id >= 26658256661, sees < 26658256616
---TRANSACTION 26658256616, ACTIVE 470 sec inserting
mysql tables in use 1, locked 1
1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 4549
MariaDB thread id 63274, OS thread handle 140320754878208, query id 1004648 localhost sitewordpress Update
INSERT INTO wp_****
---TRANSACTION (0x7f9efb414530), ACTIVE 584 sec starting index read
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 59645, OS thread handle 140157873301248, query id 988562 localhost sitewordpress Creating sort index
SELECT ****
Trx read view will not see trx with id >= 26658256229, sees < 26658256229
---TRANSACTION (0x7f9efb401330), ACTIVE 586 sec fetching rows
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 59497, OS thread handle 140320753956608, query id 987714 localhost sitewordpress Creating sort index
SELECT ****
Trx read view will not see trx with id >= 26658256229, sees < 26658256229
---TRANSACTION (0x7f9efb40bd30), ACTIVE 687 sec fetching rows
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 58831, OS thread handle 140157878830848, query id 982205 localhost sitewordpress Creating sort index
SELECT ****
Trx read view will not see trx with id >= 26658255806, sees < 26658255806
---TRANSACTION (0x7f9efb403530), ACTIVE 743 sec fetching rows
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 58798, OS thread handle 140157889275648, query id 979685 localhost sitewordpress Creating sort index
SELECT ****
Trx read view will not see trx with id >= 26658255490, sees < 26658255490
---TRANSACTION (0x7f9efb407930), ACTIVE 747 sec fetching rows
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 58797, OS thread handle 140157873608448, query id 979491 localhost sitewordpress Sending data
SELECT ****
Trx read view will not see trx with id >= 26658255458, sees < 26658255458
---TRANSACTION (0x7f9efb415630), ACTIVE 762 sec fetching rows
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 58784, OS thread handle 140157884974848, query id 979038 localhost sitewordpress Creating sort index
SELECT ****
Trx read view will not see trx with id >= 26658255339, sees < 26658255339
---TRANSACTION (0x7f9efb406830), ACTIVE 795 sec fetching rows
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 57953, OS thread handle 140157884667648, query id 975046 localhost sitewordpress Sending data
SELECT ****
Trx read view will not see trx with id >= 26658255164, sees < 26658255164
---TRANSACTION (0x7f9efb412330), ACTIVE 805 sec fetching rows
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 57547, OS thread handle 140157885282048, query id 973228 localhost sitewordpress Sending data
SELECT e****
Trx read view will not see trx with id >= 26658255101, sees < 26658255100
---TRANSACTION (0x7f9efb410130), ACTIVE 867 sec fetching rows
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 55718, OS thread handle 140157880366848, query id 963536 localhost sitewordpress Creating sort index
SELECT ****
Trx read view will not see trx with id >= 26658254774, sees < 26658254774
---TRANSACTION (0x7f9efb408a30), ACTIVE 904 sec fetching rows
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 54561, OS thread handle 140157875758848, query id 958041 localhost sitewordpress Sending data
SELECT ****
Trx read view will not see trx with id >= 26658254582, sees < 26658254582
---TRANSACTION (0x7f9efb404630), ACTIVE 924 sec fetching rows
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 54257, OS thread handle 140157872379648, query id 955816 localhost sitewordpress Sending data
SELECT *********
Trx read view will not see trx with id >= 26658254491, sees < 26658254491
---TRANSACTION (0x7f9efb3ff130), ACTIVE 1050 sec fetching rows
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 54208, OS thread handle 140157871150848, query id 952917 localhost sitewordpress Sending data
SELECT *******
Trx read view will not see trx with id >= 26658254016, sees < 26658254016
---TRANSACTION (0x7f9efb402430), not started estimating records in index range
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f9efb409b30), ACTIVE 1451 sec fetching rows
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 46902, OS thread handle 140157888968448, query id 911246 localhost sitewordpress Sending data
SELECT ******
Trx read view will not see trx with id >= 26658252037, sees < 26658252037
---TRANSACTION (0x7f9efb400230), ACTIVE 1568 sec fetching rows
mysql tables in use 3, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 45088, OS thread handle 140157886510848, query id 901560 localhost sitewordpress Creating sort index
SELECT e********
Trx read view will not see trx with id >= 26658251695, sees < 26658251695
---TRANSACTION (0x7f9efb40ce30), ACTIVE 382 sec starting index read
mysql tables in use 1, locked 0
0 lock struct(s), heap size 1128, 0 row lock(s)
MariaDB thread id 1940, OS thread handle 140320742852352, query id 1007464 localhost externe_app Statistics
SELECT d********
Trx read view will not see trx with id >= 26658256960, sees < 26658256616
--------
FILE I/O
--------
Pending flushes (fsync) log: 0; buffer pool: 0
8892871 OS file reads, 71435 OS file writes, 69093 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 4306, free list len 857859, seg size 862166, 268935 merges
merged operations:
 insert 6523, delete mark 63103775, delete 6290526
discarded operations:
 insert 0, delete mark 0, delete 0
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 108975058808867
Log flushed up to   108975058808867
Pages flushed up to 108963591442933
Last checkpoint at  108963591442896
0 pending log flushes, 0 pending chkp writes
43353 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 161094828032
Dictionary memory allocated 957449880
Buffer pool size   9716400
Free buffers       1607688
Database pages     7234302
Old database pages 2670454
Modified db pages  3164828
Percent of dirty pages(LRU & free pages): 35.793
Max dirty pages percent: 90.000
Pending reads 0
Pending writes: LRU 0, flush list 57
Pages made young 2981991, not young 511731836
0.00 youngs/s, 0.00 non-youngs/s
Pages read 8891562, created 3665, written 19641
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 999 / 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: 7234302, unzip_LRU len: 3755032
I/O sum[0]:cur[1], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
28 read views open inside InnoDB
Process ID=0, Main thread ID=0, state: sleeping
Number of rows inserted 95430, updated 13801, deleted 870, read 508071231
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 13517.65 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 0
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================