InnoDB: Warning: a long semaphore wait:
--Thread 140099740215040 has waited at dict0dict.cc line 984 for 241.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 140112042125056 has waited at dict0dict.cc line 1138 for 241.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140099740215040 has waited at dict0dict.cc line 984 for 241.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140112042125056 has waited at dict0dict.cc line 1138 for 241.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140099748607744 has waited at dict0stats_bg.cc line 418 for 238.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140111804172032 has waited at dict0dict.cc line 1138 for 229.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140111805708032 has waited at ha_innodb.cc line 15244 for 226.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140111805400832 has waited at dict0dict.cc line 1138 for 218.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140111634355968 has waited at dict0dict.cc line 1138 for 215.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140111635277568 has waited at row0ins.cc line 1875 for 214.00 seconds the semaphore:
S-lock on RW-latch at 0x55bec2501a20 '&dict_operation_lock'
a writer (thread id 140099757000448) has reserved it in mode  exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file row0purge.cc line 772
Last time write locked in file srv0srv.cc line 2837
Holder thread 0 file not yet reserved line 0
InnoDB: Warning: semaphore wait:
--Thread 140111631898368 has waited at dict0dict.cc line 1138 for 198.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140111632512768 has waited at dict0dict.cc line 1138 for 197.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140109377697536 has waited at dict0load.cc line 2279 for 195.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140109377083136 has waited at dict0load.cc line 2279 for 190.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140109377390336 has waited at dict0dict.cc line 1138 for 190.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140109376468736 has waited at dict0dict.cc line 1138 for 185.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140109376161536 has waited at dict0dict.cc line 1138 for 185.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140109375547136 has waited at dict0dict.cc line 1138 for 183.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140109376775936 has waited at dict0dict.cc line 1138 for 181.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140109374932736 has waited at dict0dict.cc line 1138 for 175.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140108245145344 has waited at dict0dict.cc line 1138 for 174.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140108244838144 has waited at dict0dict.cc line 1138 for 173.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140108243302144 has waited at dict0dict.cc line 1138 for 168.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140108244530944 has waited at dict0dict.cc line 1138 for 167.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140108244223744 has waited at dict0dict.cc line 1138 for 165.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140108242994944 has waited at dict0dict.cc line 1138 for 163.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140105988392704 has waited at dict0dict.cc line 1138 for 157.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140105988085504 has waited at dict0dict.cc line 1138 for 153.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140105987471104 has waited at dict0dict.cc line 1138 for 146.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140105986856704 has waited at dict0dict.cc line 1138 for 136.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140105986549504 has waited at dict0dict.cc line 1138 for 130.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: Warning: semaphore wait:
--Thread 140111804479232 has waited at dict0dict.cc line 1138 for 121.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
InnoDB: Pending reads 0, writes 0

=====================================
2019-08-23 10:46:54 7f6b897ff700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 25 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 6162 srv_active, 0 srv_shutdown, 1631 srv_idle
srv_master_thread log flush and writes: 7792
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 14085
--Thread 140099740215040 has waited at dict0dict.cc line 984 for 241.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140112042125056 has waited at dict0dict.cc line 1138 for 241.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140099748607744 has waited at dict0stats_bg.cc line 418 for 238.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140111804172032 has waited at dict0dict.cc line 1138 for 229.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140111805708032 has waited at ha_innodb.cc line 15244 for 226.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140111805400832 has waited at dict0dict.cc line 1138 for 218.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140111634355968 has waited at dict0dict.cc line 1138 for 215.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140111635277568 has waited at row0ins.cc line 1875 for 214.00 seconds the semaphore:
S-lock on RW-latch at 0x55bec2501a20 '&dict_operation_lock'
a writer (thread id 140099757000448) has reserved it in mode  exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file row0purge.cc line 772
Last time write locked in file srv0srv.cc line 2837
Holder thread 0 file not yet reserved line 0
--Thread 140111631898368 has waited at dict0dict.cc line 1138 for 198.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140111632512768 has waited at dict0dict.cc line 1138 for 197.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140109377697536 has waited at dict0load.cc line 2279 for 195.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140109377083136 has waited at dict0load.cc line 2279 for 190.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140109377390336 has waited at dict0dict.cc line 1138 for 190.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140109376468736 has waited at dict0dict.cc line 1138 for 185.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140109376161536 has waited at dict0dict.cc line 1138 for 185.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140109375547136 has waited at dict0dict.cc line 1138 for 183.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140109376775936 has waited at dict0dict.cc line 1138 for 181.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140109374932736 has waited at dict0dict.cc line 1138 for 175.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140108245145344 has waited at dict0dict.cc line 1138 for 174.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140108244838144 has waited at dict0dict.cc line 1138 for 173.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140108243302144 has waited at dict0dict.cc line 1138 for 168.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140108244530944 has waited at dict0dict.cc line 1138 for 167.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140108244223744 has waited at dict0dict.cc line 1138 for 165.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140108242994944 has waited at dict0dict.cc line 1138 for 163.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140105988392704 has waited at dict0dict.cc line 1138 for 157.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140105988085504 has waited at dict0dict.cc line 1138 for 153.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140105987471104 has waited at dict0dict.cc line 1138 for 146.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140105986856704 has waited at dict0dict.cc line 1138 for 136.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140105986549504 has waited at dict0dict.cc line 1138 for 130.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
--Thread 140111804479232 has waited at dict0dict.cc line 1138 for 121.00 seconds the semaphore:
Mutex at 0x7f6e5b0112e8 '&dict_sys->mutex', lock var 1
Last time reserved by thread 140099757000448 in file not yet reserved line 0, waiters flag 1
OS WAIT ARRAY INFO: signal count 14555
Mutex spin waits 384225, rounds 686768, OS waits 7130
RW-shared spins 7390, rounds 193926, OS waits 6114
RW-excl spins 1428, rounds 39994, OS waits 615
Spin rounds per wait: 1.79 mutex, 26.24 RW-shared, 28.01 RW-excl
------------------------
LATEST DETECTED DEADLOCK
------------------------
2019-08-23 10:06:03 7f6e5271d700
*** (1) TRANSACTION:
TRANSACTION 24109136709, ACTIVE 0 sec starting index read
mysql tables in use 2, locked 2
LOCK WAIT 5 lock struct(s), heap size 1184, 4 row lock(s)
MySQL thread id 14669, OS thread handle 0x7f6e60768700, query id 1473436 localhost pxxxxxxx_admin Sending data
UPDATE `cron_schedule` AS `current`
 LEFT JOIN `cron_schedule` AS `existing` ON existing.job_code = current.job_code AND (existing.executed_at > UTC_TIMESTAMP() - INTERVAL 1 DAY OR existing.executed_at IS NULL) AND existing.status = 'running'
SET `current`.`status` = 'running'
WHERE (current.schedule_id = '12115867') AND (current.status = 'pending') AND (existing.schedule_id IS NULL)
*** (1) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 909992 page no 705 n bits 240 index `PRIMARY` of table `pxxxxxxx_magento2`.`cron_schedule` trx table locks 1 total table locks 2  trx id 24109136709 lock mode S locks rec but not gap waiting lock hold time 0 wait time before grant 0
*** (2) TRANSACTION:
TRANSACTION 24109136707, ACTIVE 0 sec fetching rows
mysql tables in use 1, locked 1
1361 lock struct(s), heap size 177704, 143443 row lock(s)
MySQL thread id 14670, OS thread handle 0x7f6e5271d700, query id 1473434 localhost pxxxxxxx_admin updating
DELETE FROM `cron_schedule` WHERE (status = 'pending') AND (job_code in ('indexer_reindex_all_invalid', 'indexer_update_all_views', 'indexer_clean_all_changelogs')) AND (created_at < '2019-08-16 15:06:02')
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 909992 page no 705 n bits 240 index `PRIMARY` of table `pxxxxxxx_magento2`.`cron_schedule` trx table locks 1 total table locks 2  trx id 24109136707 lock_mode X lock hold time 0 wait time before grant 0
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 909992 page no 442 n bits 272 index `PRIMARY` of table `pxxxxxxx_magento2`.`cron_schedule` trx table locks 1 total table locks 2  trx id 24109136707 lock_mode X waiting lock hold time 0 wait time before grant 0
*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 24109292327
Purge done for trx's n:o < 24109291104 undo n:o < 0 state: running but idle
History list length 16
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 24109291585, not started
MySQL thread id 21065, OS thread handle 0x7f6cf793d700, query id 2096560 localhost exxxxxxxx_mg1 Opening tables
INSERT INTO `customer_visitor` (`customer_id`, `session_id`, `last_visit_at`) VALUES (NULL, 'xxxxxxxxxxxxxxxx', '2019-08-23 15:44:38')
---TRANSACTION 24109291570, not started
MySQL thread id 21059, OS thread handle 0x7f6cf7a1e700, query id 2096520 localhost exxxxxxxx_mg1
---TRANSACTION 24109291563, not started
MySQL thread id 21053, OS thread handle 0x7f6d7e0dc700, query id 2096489 localhost oxxxxxx_mage Opening tables
INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES ('xxxxxxxxxxxxxxxx', '2019-08-23 15:44:11', '2019-08-23 15:44:11', '0', '1')
---TRANSACTION 24109291560, not started
MySQL thread id 21052, OS thread handle 0x7f6d7e208700, query id 2096482 localhost oxxxxxx_mage Opening tables
INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES ('xxxxxxxxxxxxxxxx', '2019-08-23 15:44:09', '2019-08-23 15:44:09', '0', '1')
---TRANSACTION 24109291556, not started
MySQL thread id 21050, OS thread handle 0x7f6d7e253700, query id 2096470 localhost nxxxxxxx_mg3 Opening tables
INSERT INTO `mg_log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES ('xxxxxxxxxxxxxxxx', '2019-08-23 15:44:07', '2019-08-23 15:44:07', '0', '1')
---TRANSACTION 24109291554, not started
MySQL thread id 21049, OS thread handle 0x7f6d7e127700, query id 2096463 localhost exxxxxxxx_mg1 Opening tables
INSERT INTO `customer_visitor` (`customer_id`, `session_id`, `last_visit_at`) VALUES (NULL, 'xxxxxxxxxxxxxxxx', '2019-08-23 15:44:06')
---TRANSACTION 24109291542, not started
MySQL thread id 21042, OS thread handle 0x7f6d7e2e9700, query id 2096397 localhost oxxxxxx_mage2 Opening tables
INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES ('xxxxxxxxxxxxxxxx', '2019-08-23 15:44:00', '2019-08-23 15:44:00', '0', '1')
---TRANSACTION 24109291540, not started
MySQL thread id 21036, OS thread handle 0x7f6dc185c700, query id 2096388 localhost cxxxxxxxx_mage Opening tables
SHOW FULL COLUMNS FROM `wp_wfTrafficRates`
---TRANSACTION 24109291532, not started
MySQL thread id 21037, OS thread handle 0x7f6d7e37f700, query id 2096286 localhost exxxxxxxx_mg1
---TRANSACTION 24109291527, not started
MySQL thread id 21035, OS thread handle 0x7f6dc1a1e700, query id 2096222 localhost lxxxxxxx_store Opening tables
INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES ('xxxxxxxxxxxxxxxx', '2019-08-23 15:43:53', '2019-08-23 15:43:53', '0', '1')
---TRANSACTION 24109291529, not started
MySQL thread id 21034, OS thread handle 0x7f6dc18a7700, query id 2096379 localhost cxxxxxxxx_mage Waiting for query cache lock
INSERT INTO `wp_wfHits` (`ctime`, `statusCode`, `isGoogle`, `IP`, `userID`, `URL`, `referer`, `UA`, `jsRun`) VALUES ('1566575033.765895', '301', '0', 'xxxxxxxxxxxxxxxx', '0', 'xxxxxxxxxxxxxxxx', '', 'xxxxxxxxxxxxxxxx', '')
---TRANSACTION 24109291478, not started
MySQL thread id 21033, OS thread handle 0x7f6dc18f2700, query id 2096105 localhost oxxxxxx_mage2 Opening tables
INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES ('xxxxxxxxxxxxxxxx', '2019-08-23 15:43:51', '2019-08-23 15:43:51', '0', '1')
---TRANSACTION 0, not started
MySQL thread id 21024, OS thread handle 0x7f6dc1a69700, query id 2095995 localhost nxxxxxxx_mg2
SHOW TABLE STATUS LIKE 'mg_core_resource'
---TRANSACTION 0, not started
MySQL thread id 21020, OS thread handle 0x7f6dc1aff700, query id 2095977 localhost nxxxxxxx_bgrx1
SHOW TABLE STATUS LIKE 'bgrx_core_resource'
---TRANSACTION 24109291401, not started
MySQL thread id 21015, OS thread handle 0x7f6e4815b700, query id 2095961 localhost oxxxxxx_mage Opening tables
INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES ('xxxxxxxxxxxxxxxx', '2019-08-23 15:43:37', '2019-08-23 15:43:37', '0', '1')
---TRANSACTION 24109291397, not started
MySQL thread id 21014, OS thread handle 0x7f6e480c5700, query id 2095951 localhost lxxxxxxx_store Opening tables
INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES ('xxxxxxxxxxxxxxxx', '2019-08-23 15:43:36', '2019-08-23 15:43:36', '0', '1')
---TRANSACTION 24109291378, not started
MySQL thread id 21008, OS thread handle 0x7f6e481f1700, query id 2095912 localhost cxxxxxxxx_mage Waiting for table level lock
SELECT option_value FROM wp_options WHERE option_name = 'acm_server_settings' LIMIT 1
---TRANSACTION 24109291376, not started
MySQL thread id 21004, OS thread handle 0x7f6e4823c700, query id 2095913 localhost cxxxxxxxx_mage Waiting for query cache lock
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('xxxxxxxxxxxxxxxx', '1567179808', 'no') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
---TRANSACTION 24109291362, not started
MySQL thread id 21002, OS thread handle 0x7f6e482d2700, query id 2095760 localhost cxxxxxxxx_admin Opening tables
SELECT MAX(attackLogTime) FROM wp_wfHits
---TRANSACTION 24109291350, not started
MySQL thread id 21001, OS thread handle 0x7f6e48368700, query id 2095729 localhost exxxxxxxx_mg1
---TRANSACTION 24109291310, not started
MySQL thread id 20999, OS thread handle 0x7f6e4831d700, query id 2095672 localhost oxxxxxx_mage Opening tables
INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES ('xxxxxxxxxxxxxxxx', '2019-08-23 15:43:19', '2019-08-23 15:43:19', '0', '1')
---TRANSACTION 24109291291, not started
MySQL thread id 20997, OS thread handle 0x7f6e483b3700, query id 2095673 localhost cxxxxxxxx_admin Opening tables
SELECT MAX(attackLogTime) FROM wp_wfHits
---TRANSACTION 24109291238, not started
MySQL thread id 20991, OS thread handle 0x7f6e5263c700, query id 2095552 localhost lxxxxxxx_store Opening tables
INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES ('xxxxxxxxxxxxxxxx', '2019-08-23 15:43:16', '2019-08-23 15:43:16', '0', '1')
---TRANSACTION 24109291230, not started
MySQL thread id 20989, OS thread handle 0x7f6e52768700, query id 2095537 localhost cxxxxxxxx_admin Opening tables
SELECT MAX(attackLogTime) FROM wp_wfHits
---TRANSACTION 24109291197, not started getting list of referencing foreign keys
MySQL thread id 20986, OS thread handle 0x7f6e52687700, query id 2095478 localhost exxxxxxxx_mg1 Opening tables
UPDATE `theme` SET `parent_id` = NULL, `theme_path` = 'Magento/blank', `theme_title` = 'Magento Blank', `preview_image` = 'xxxxxxxxxxxxxxxx.jpeg', `is_featured` = '0', `area` = 'frontend', `type` = '0', `code` = 'Magento/blank' WHERE (theme_id='1')
---TRANSACTION 24109291161, not started
MySQL thread id 20983, OS thread handle 0x7f6e607b3700, query id 2095438 localhost cxxxxxxxx_admin System lock
SELECT MAX(attackLogTime) FROM wp_wfHits
---TRANSACTION 24109291157, not started
MySQL thread id 20982, OS thread handle 0x7f6e52510700, query id 2095394 localhost lxxxxxxx_store Opening tables
INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES ('xxxxxxxxxxxxxxxx', '2019-08-23 15:43:05', '2019-08-23 15:43:05', '0', '1')
---TRANSACTION 24109291166, not started
MySQL thread id 20981, OS thread handle 0x7f6e5271d700, query id 2095430 localhost cxxxxxxxx_admin Waiting for query cache lock
update wp_wfHits set jsRun=1 where id=3288227
---TRANSACTION 24109291960, not started
MySQL thread id 20970, OS thread handle 0x7f6e5255b700, query id 2096946 localhost jxxxxxxx_wp1 Opening tables
SELECT t.translation_id, t.element_id, t.language_code, t.source_language_code, t.trid, t.element_type
                                    FROM wp_icl_translations t
                                JOIN wp_term_taxonomy tax
                                        ON t.element_id = tax.term_taxonomy_id
                                                AND t.element_type = CONCAT('tax_', tax.taxonomy)
                                    JOIN wp_icl_translations tridt
                                      ON tridt.element_type = t.element_type
                                      AND tridt.trid = t.trid
                                    WHERE  tridt.trid = (SELECT trid FROM wp_icl_translations t
                                JOIN wp_term_taxonomy tax
                                        ON t.element_id = tax.term_taxonomy_id
                                                AND t.element_type = CONCAT('tax_', tax.taxonomy) WHERE elemen
---TRANSACTION 24109291026, not started
MySQL thread id 20964, OS thread handle 0x7f6e5b914700, query id 2095132 localhost nxxxxxxx_live Waiting for query cache lock
INSERT INTO `wp_wfHits` (`ctime`, `statusCode`, `isGoogle`, `IP`, `userID`, `URL`, `referer`, `UA`, `jsRun`) VALUES ('1566574973.555457', '200', '0', 'xxxxxxxxxxxxxxxx', '0', 'xxxxxxxxxxxxxxxx', 'xxxxxxxxxxxxxxxx', 'xxxxxxxxxxxxxxxx', '')
---TRANSACTION 24109291001, not started
mysql tables in use 1, locked 0
MySQL thread id 20948, OS thread handle 0x7f6e607fe700, query id 2095095 localhost nxxxxxxx_attend
SELECT option_value FROM wp_options WHERE option_name = 'updraft_backup_history' LIMIT 1
---TRANSACTION 24108878595, not started
MySQL thread id 1, OS thread handle 0x7f6e60894700, query id 0 Waiting for requests
---TRANSACTION 24109292326, ACTIVE 11 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s)
MySQL thread id 20995, OS thread handle 0x7f6e5247a700, query id 2097375 localhost nxxxxxxx_live updating
UPDATE `wp_options` SET `option_value` = '1566575233' WHERE `option_name` = 'xxxxxxxxxxxxxxxx'
Trx #rec lock waits 3 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
------- TRX HAS BEEN WAITING 11 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 7344 page no 63 n bits 360 index `option_name` of table `nxxxxxxx_live`.`wp_options` trx table locks 1 total table locks 3  trx id 24109292326 lock_mode X waiting lock hold time 11 wait time before grant 0
------------------
---TRANSACTION 24109292316, ACTIVE 100 sec
mysql tables in use 1, locked 1
4 lock struct(s), heap size 1184, 3 row lock(s), undo log entries 1
MySQL thread id 20978, OS thread handle 0x7f6e525a6700, query id 2097345 localhost jxxxxxxx_wp1 Waiting for query cache lock
INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('xxxxxxxxxxxxxxxx', 'xxxxxxxxxxxxxxxx', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`)
Trx #rec lock waits 1 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 24109292139, ACTIVE 112 sec
mysql tables in use 2, locked 2
12 lock struct(s), heap size 2936, 230 row lock(s), undo log entries 1
MySQL thread id 21073, OS thread handle 0x7f6cb437f700, query id 2097158 localhost exxxxxxxx_mg1 Waiting for query cache lock
UPDATE `cron_schedule` AS `current`
 LEFT JOIN `cron_schedule` AS `existing` ON existing.job_code = current.job_code AND (existing.executed_at > UTC_TIMESTAMP() - INTERVAL 1 DAY OR existing.executed_at IS NULL) AND existing.status = 'running'
SET `current`.`status` = 'running'
WHERE (current.schedule_id = '11163886') AND (current.status = 'pending') AND (existing.schedule_id IS NULL)
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 24109292091, ACTIVE 114 sec
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1
MySQL thread id 20992, OS thread handle 0x7f6e524c5700, query id 2097077 localhost nxxxxxxx_live Waiting for query cache lock
DELETE FROM `wp_options` WHERE `option_name` = 'xxxxxxxxxxxxxxxx'
Trx #rec lock waits 1 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 24109291566, ACTIVE 158 sec
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 21054, OS thread handle 0x7f6d7e091700, query id 2096495 localhost oxxxxxx_mag3 Waiting for query cache lock
INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES ('xxxxxxxxxxxxxxxx', '2019-08-23 15:44:16', '2019-08-23 15:44:16', '0', '1')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 24109291528, ACTIVE 180 sec
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 21032, OS thread handle 0x7f6dc193d700, query id 2096240 localhost cxxxxxxxx_mage Waiting for query cache lock
INSERT INTO wp_wfTrafficRates (eMin, IP, hitType, hits) VALUES (FLOOR(UNIX_TIMESTAMP() / 60), 'xxxxxxxxxxxxxxxx', 'hit', @wfcurrenthits := 1) ON DUPLICATE KEY UPDATE hits = IF(@wfcurrenthits := hits + 1, hits + 1, hits + 1)
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 24109291390, ACTIVE 200 sec
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 21012, OS thread handle 0x7f6e48110700, query id 2095937 localhost oxxxxxx_mage2 Waiting for query cache lock
INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES ('xxxxxxxxxxxxxxxx', '2019-08-23 15:43:34', '2019-08-23 15:43:34', '0', '1')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 24109291381, ACTIVE 204 sec
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 21009, OS thread handle 0x7f6e481a6700, query id 2095919 localhost oxxxxxx_mage2 Waiting for query cache lock
INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES ('xxxxxxxxxxxxxxxx', '2019-08-23 15:43:30', '2019-08-23 15:43:30', '0', '1')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 24109291377, ACTIVE 207 sec
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 21003, OS thread handle 0x7f6e48287700, query id 2095879 localhost cxxxxxxxx_mage Waiting for query cache lock
INSERT INTO wp_wfTrafficRates (eMin, IP, hitType, hits) VALUES (FLOOR(UNIX_TIMESTAMP() / 60), 'xxxxxxxxxxxxxxxx', 'hit', @wfcurrenthits := 1) ON DUPLICATE KEY UPDATE hits = IF(@wfcurrenthits := hits + 1, hits + 1, hits + 1)
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 24109291354, ACTIVE 214 sec inserting
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 21000, OS thread handle 0x7f6e483fe700, query id 2095737 localhost oxxxxxx_mage2 update
INSERT INTO `report_viewed_product_index` (`visitor_id`,`customer_id`,`product_id`,`store_id`,`added_at`) VALUES ('590754', NULL, '4064', '1', '2019-08-23 15:43:20') ON DUPLICATE KEY UPDATE visitor_id = VALUES(`visitor_id`), customer_id = VALUES(`customer_id`), p
roduct_id = VALUES(`product_id`), store_id = VALUES(`store_id`), added_at = VALUES(`added_at`)
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 24109291240, ACTIVE 218 sec
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 20990, OS thread handle 0x7f6e5b9f5700, query id 2095555 localhost exxxxxxxx_mg1 Waiting for query cache lock
INSERT INTO `customer_visitor` (`customer_id`, `session_id`, `last_visit_at`) VALUES (NULL, 'xxxxxxxxxxxxxxxx', '2019-08-23 15:43:16')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 24109291227, ACTIVE 223 sec
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 20988, OS thread handle 0x7f6e60849700, query id 2095525 localhost oxxxxxx_mage Waiting for query cache lock
INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES ('xxxxxxxxxxxxxxxx', '2019-08-23 15:43:11', '2019-08-23 15:43:11', '0', '1')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 24109291223, ACTIVE 224 sec
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1
MySQL thread id 20985, OS thread handle 0x7f6e5b87e700, query id 2095518 localhost nxxxxxxx_live Waiting for query cache lock
DELETE FROM `wp_options` WHERE `option_name` = 'xxxxxxxxxxxxxxxx'
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 24109291171, ACTIVE 228 sec
mysql tables in use 1, locked 1
2 lock struct(s), heap size 360, 1 row lock(s), undo log entries 1
MySQL thread id 20984, OS thread handle 0x7f6e527fe700, query id 2095437 localhost axxxxxx_mageuser Waiting for query cache lock
UPDATE `springbot_cron_queue` SET `method` = 'tasks:deliverEventLog', `args` = 'xxxxxxxxxxxxxxxx', `store_id` = '3', `command_hash` = 'xxxxxxxxxxxxxxxx', `queue` = 'listener', `priority` = '5', `attempts` = '1', `run_at` = '2019-08-23 15:43:06', `locked_at` = '2019-08-23 15:43:06', `locked_by` = '29228', `error` = NULL, `next_run_at` = '2019-08-23 15:44:06', `created_at` = '2019-08-23 10:41:06' WHERE (id='13429190')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 24109291154, ACTIVE 230 sec
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 20980, OS thread handle 0x7f6e5b8c9700, query id 2095382 localhost nxxxxxxx_mg3 Waiting for query cache lock
INSERT INTO `mg_log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES ('xxxxxxxxxxxxxxxx', '2019-08-23 15:43:04', '2019-08-23 15:43:04', '0', '1')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 24109291151, ACTIVE 230 sec
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 20972, OS thread handle 0x7f6e5b9aa700, query id 2095376 localhost cxxxxxxxx_mage Waiting for query cache lock
INSERT INTO wp_wfTrafficRates (eMin, IP, hitType, hits) VALUES (FLOOR(UNIX_TIMESTAMP() / 60), 'xxxxxxxxxxxxxxxx', 'hit', @wfcurrenthits := 1) ON DUPLICATE KEY UPDATE hits = IF(@wfcurrenthits := hits + 1, hits + 1, hits + 1)
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 24109291115, ACTIVE 232 sec
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 20977, OS thread handle 0x7f6e527b3700, query id 2095308 localhost pxxxxxxx_admin Waiting for query cache lock
INSERT INTO `cron_schedule` (`job_code`, `status`, `created_at`, `scheduled_at`) VALUES ('indexer_reindex_all_invalid', 'pending', '2019-08-23 15:43:02', '2019-08-23 15:46:00')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 24109291110, ACTIVE 233 sec
mysql tables in use 2, locked 2
781 lock struct(s), heap size 95784, 19907 row lock(s), undo log entries 1
MySQL thread id 20975, OS thread handle 0x7f6e5b95f700, query id 2095279 localhost pxxxxxxx_admin Waiting for query cache lock
UPDATE `cron_schedule` AS `current`
 LEFT JOIN `cron_schedule` AS `existing` ON existing.job_code = current.job_code AND (existing.executed_at > UTC_TIMESTAMP() - INTERVAL 1 DAY OR existing.executed_at IS NULL) AND existing.status = 'running'
SET `current`.`status` = 'running'
WHERE (current.schedule_id = '12116519') AND (current.status = 'pending') AND (existing.schedule_id IS NULL)
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 24109291104, ACTIVE 233 sec
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 20974, OS thread handle 0x7f6e526d2700, query id 2095262 localhost hxxxxxx_admin Waiting for query cache lock
INSERT INTO `tblsessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES ('xxxxxxxxxxxxxxxx', '206.198.225.32', 1566574981, '__ci_last_regenerate|i:1566574981;')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 24109291060, ACTIVE 236 sec
mysql tables in use 1, locked 1
3 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1
MySQL thread id 20968, OS thread handle 0x7f6e60768700, query id 2095182 localhost jxxxxxxx_wp1 Waiting for query cache lock
UPDATE `wp_options` SET `option_value` = '' WHERE `option_name` = 'rewrite_rules'
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
---TRANSACTION 24109291052, ACTIVE 237 sec
mysql tables in use 1, locked 1
1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1
MySQL thread id 20969, OS thread handle 0x7f6e525f1700, query id 2095171 localhost lxxxxxxx_store Waiting for query cache lock
INSERT INTO `log_visitor` (`session_id`, `first_visit_at`, `last_visit_at`, `last_url_id`, `store_id`) VALUES ('xxxxxxxxxxxxxxxx', '2019-08-23 15:42:57', '2019-08-23 15:42:57', '0', '1')
Trx #rec lock waits 0 #table lock waits 0
Trx total rec lock wait time 0 SEC
Trx total table lock wait time 0 SEC
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
 ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
56841 OS file reads, 221959 OS file writes, 25419 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 1, free list len 5003, seg size 5005, 454 merges
merged operations:
 insert 403, delete mark 156, delete 64
discarded operations:
 insert 0, delete mark 0, delete 0
0.00 hash searches/s, 0.24 non-hash searches/s
---
LOG
---
Log sequence number 4846171927662
Log flushed up to   4846171927662
Pages flushed up to 4846171927662
Last checkpoint at  4846170214490
Max checkpoint age    434154333
Checkpoint age target 420587011
Modified age          0
Checkpoint age        1713172
0 pending log writes, 0 pending chkp writes
105998 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 11245977600; in additional pool allocated 0
Total memory allocated by read views 10632
Internal hash tables (constant factor + variable factor)
    Adaptive hash index 219873568       (169996472 + 49877096)
    Page hash           1107208 (buffer pool 0 only)
    Dictionary cache    66199552        (42500624 + 23698928)
    File system         21340304        (812272 + 20528032)
    Lock system         26683392        (26563016 + 120376)
    Recovery system     0       (0 + 0)
Dictionary memory allocated 23698928
Buffer pool size        655350
Buffer pool size, bytes 10737254400
Free buffers            601971
Database pages          50330
Old database pages      18773
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 39, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 48866, created 1464, written 113161
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 50330, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size        65535
Buffer pool size, bytes 1073725440
Free buffers            60122
Database pages          5108
Old database pages      1905
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 5033, created 75, written 14572
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 5108, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size        65535
Buffer pool size, bytes 1073725440
Free buffers            60222
Database pages          5013
Old database pages      1870
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 7, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 4873, created 140, written 5689
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 5013, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size        65535
Buffer pool size, bytes 1073725440
Free buffers            60236
Database pages          4982
Old database pages      1859
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 4868, created 114, written 7558
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 4982, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size        65535
Buffer pool size, bytes 1073725440
Free buffers            59891
Database pages          5338
Old database pages      1990
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 2, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 5098, created 240, written 17945
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 5338, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size        65535
Buffer pool size, bytes 1073725440
Free buffers            60131
Database pages          5097
Old database pages      1900
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 5, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 4892, created 205, written 17102
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 5097, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size        65535
Buffer pool size, bytes 1073725440
Free buffers            60178
Database pages          5043
Old database pages      1881
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 4905, created 138, written 6651
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 5043, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size        65535
Buffer pool size, bytes 1073725440
Free buffers            60398
Database pages          4835
Old database pages      1804
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 4625, created 210, written 13786
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 4835, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size        65535
Buffer pool size, bytes 1073725440
Free buffers            60392
Database pages          4851
Old database pages      1810
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 8, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 4731, created 120, written 12661
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 4851, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 8
Buffer pool size        65535
Buffer pool size, bytes 1073725440
Free buffers            59920
Database pages          5308
Old database pages      1979
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 11, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 5127, created 181, written 13360
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 5308, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 9
Buffer pool size        65535
Buffer pool size, bytes 1073725440
Free buffers            60481
Database pages          4755
Old database pages      1775
Modified db pages       0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 3, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 4714, created 41, written 3837
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 4755, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
21 RW transactions active inside InnoDB
0 RO transactions active inside InnoDB
21 out of 1000 descriptors used
Main thread process no. 14095, id 140099757000448, state: enforcing dict cache limit
Number of rows inserted 69198, updated 67721, deleted 6330, read 121008940
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 273.35 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
============================