MariaDB [(none)]> SHOW ENGINE INNODB STATUS; +--------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Type | Name | Status | +--------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | InnoDB | | ===================================== 2023-05-16 12:08:48 0x7fa7f881f700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 57 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 358427 srv_active, 0 srv_shutdown, 80 srv_idle srv_master_thread log flush and writes: 358503 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 37337651 --Thread 140359304230656 has waited at ha_innodb.cc line 14402 for 0.00 seconds the semaphore: Mutex at 0x55be3a2e2bc0, Mutex DICT_SYS created /builddir/build/BUILD/mariadb-10.5.19/storage/innobase/dict/dict0dict.cc:1038, lock var 2 --Thread 140358994724608 has waited at ha_innodb.cc line 14402 for 0.00 seconds the semaphore: Mutex at 0x55be3a2e2bc0, Mutex DICT_SYS created /builddir/build/BUILD/mariadb-10.5.19/storage/innobase/dict/dict0dict.cc:1038, lock var 2 --Thread 140359245014784 has waited at ha_innodb.cc line 14402 for 0.00 seconds the semaphore: Mutex at 0x55be3a2e2bc0, Mutex DICT_SYS created /builddir/build/BUILD/mariadb-10.5.19/storage/innobase/dict/dict0dict.cc:1038, lock var 2 --Thread 140359233148672 has waited at ha_innodb.cc line 14402 for 0.00 seconds the semaphore: Mutex at 0x55be3a2e2bc0, Mutex DICT_SYS created /builddir/build/BUILD/mariadb-10.5.19/storage/innobase/dict/dict0dict.cc:1038, lock var 2 --Thread 140359160792832 has waited at ha_innodb.cc line 14402 for 0.00 seconds the semaphore: Mutex at 0x55be3a2e2bc0, Mutex DICT_SYS created /builddir/build/BUILD/mariadb-10.5.19/storage/innobase/dict/dict0dict.cc:1038, lock var 2 OS WAIT ARRAY INFO: signal count 1194622652 RW-shared spins 44315821, rounds 405011265, OS waits 3990325 RW-excl spins 417680980, rounds 821349188, OS waits 2866983 RW-sx spins 22503, rounds 176079, OS waits 3520 Spin rounds per wait: 9.14 RW-shared, 1.97 RW-excl, 7.82 RW-sx ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 2023-05-15 22:41:22 0x7fa7ed2f7700 Error in foreign key constraint of table `REDACTED`.`REDACTED`: Create table `REDACTED`.`REDACTED` with foreign key `REDACTED` constraint failed. Referenced table `REDACTED`.`REDACTED` not found in the data dictionary.------------------------ LATEST DETECTED DEADLOCK ------------------------ 2023-05-16 11:48:08 0x7fa7ee3fb700 *** (1) TRANSACTION: TRANSACTION 4835630080, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 10623082, OS thread handle 140359238285056, query id 1920042622 localhost REDACTED Update INSERT INTO `semaphore` (name, value, expire) VALUES ('variable_init', '1588848712646351585c5622.49587473', '1684230489.3781') *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3436912 page no 3 n bits 72 index PRIMARY of table "REDACTED"."REDACTED" trx id 4835630080 lock_mode X locks rec but not gap waiting Record lock, heap no 2 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 13; hex 7661726961626c655f696e6974; asc variable_init;; 1: len 6; hex 00012039dbb6; asc 9 ;; 2: len 7; hex 64000002031154; asc d T;; 3: len 30; hex 34383732383233383836343633353135383338656539302e353439383932; asc 4872823886463515838ee90.549892; (total 32 bytes); 4: len 8; hex 1ceb4e56d418d941; asc NV A;; *** (2) TRANSACTION: TRANSACTION 4835630081, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 10623081, OS thread handle 140359233419008, query id 1920042623 localhost REDACTED Update INSERT INTO REDACTED) *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 3436912 page no 3 n bits 72 index PRIMARY of table "REDACTED"."REDACTED" trx id 4835630081 lock mode S locks rec but not gap Record lock, heap no 2 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 13; hex 7661726961626c655f696e6974; asc variable_init;; 1: len 6; hex 00012039dbb6; asc 9 ;; 2: len 7; hex 64000002031154; asc d T;; 3: len 30; hex 34383732383233383836343633353135383338656539302e353439383932; asc 4872823886463515838ee90.549892; (total 32 bytes); 4: len 8; hex 1ceb4e56d418d941; asc NV A;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 3436912 page no 3 n bits 72 index PRIMARY of table "REDACTED"."semaphore" trx id 4835630081 lock_mode X locks rec but not gap waiting Record lock, heap no 2 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 13; hex 7661726961626c655f696e6974; asc variable_init;; 1: len 6; hex 00012039dbb6; asc 9 ;; 2: len 7; hex 64000002031154; asc d T;; 3: len 30; hex 34383732383233383836343633353135383338656539302e353439383932; asc 4872823886463515838ee90.549892; (total 32 bytes); 4: len 8; hex 1ceb4e56d418d941; asc NV A;; *** WE ROLL BACK TRANSACTION (2) ------------ TRANSACTIONS ------------ Trx id counter 4835902717 Purge done for trx's n:o < 4835902651 undo n:o < 0 state: running but idle History list length 28 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 375750544760448, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544730656, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544675328, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544683840, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544756192, ACTIVE 0 sec fetching rows mysql tables in use 4, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 10667221, OS thread handle 140359390750464, query id 1928704848 localhost REDACTED Sending data (REDACTED) Trx read view will not see trx with id >= 4835902643, sees < 4835902643 ---TRANSACTION 375750544751936, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544696608, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544692352, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544734912, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544671072, ACTIVE 0 sec fetching rows mysql tables in use 6, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 10667193, OS thread handle 140359314503424, query id 1928705388 localhost REDACTED Sending data (REDACTED) Trx read view will not see trx with id >= 4835902671, sees < 4835902671 ---TRANSACTION 375750544709376, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544781728, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544726400, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544722144, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544747680, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544705120, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544679584, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544743424, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544739168, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544688096, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544717888, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544700864, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544909408, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544883872, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544713632, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 375750544666816, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- Pending flushes (fsync) log: 0; buffer pool: 0 1257342778 OS file reads, 52181484 OS file writes, 43505390 OS fsyncs 3953.40 reads/s, 16253 avg bytes/read, 103.26 writes/s, 85.82 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 11732, seg size 11734, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 0.00 hash searches/s, 575283.05 non-hash searches/s --- LOG --- Log sequence number 13372141159240 Log flushed up to 13372141159240 Pages flushed up to 13371622678823 Last checkpoint at 13371622664017 0 pending log flushes, 0 pending chkp writes 40167142 log i/o's done, 74.46 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 2181038080 Dictionary memory allocated 35399496 Buffer pool size 129040 Free buffers 0 Database pages 129040 Old database pages 47614 Modified db pages 5910 Percent of dirty pages(LRU & free pages): 4.580 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0 Pages made young 153305223, not young 27173885591 218.79 youngs/s, 48136.05 non-youngs/s Pages read 1257250908, created 8175223, written 12008068 3953.40 reads/s, 11.98 creates/s, 28.81 writes/s Buffer pool hit rate 997 / 1000, young-making rate 0 / 1000 not 26 / 1000 Pages read ahead 30.07/s, evicted without access 25.09/s, Random read ahead 0.00/s LRU len: 129040, unzip_LRU len: 0 I/O sum[241251]:cur[10138], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 2 read views open inside InnoDB Process ID=0, Main thread ID=0, state: sleeping Number of rows inserted 61365824, updated 21474305, deleted 33608436, read 1935983350652 62.98 inserts/s, 38.21 updates/s, 17.49 deletes/s, 3823401.71 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 ============================ | +--------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec)