C:\mgr\sr90git\inm_sources_01\Database\install\sql\mariadb>echo "Setting environment for MariaDB 10.2 (x64)"
"Setting environment for MariaDB 10.2 (x64)"

C:\mgr\sr90git\inm_sources_01\Database\install\sql\mariadb>set MYSQL_HOME=C:\Program Files\MariaDB 10.2\data\

C:\mgr\sr90git\inm_sources_01\Database\install\sql\mariadb>set PATH=C:\Program Files\MariaDB 10.2\bin\;%NMSISNTDIR%\bin;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\inmtools\sybase_15.7\OCS-15_0\dll;C:\Program Files (x86)\IBM\RationalSDLC\common;C:\Program Files\RSA SecurID Token Common;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\IBM\RationalSDLC\ClearCase\bin;C:\Program Files (x86)\IBM\gsk8\lib;C:\Program Files (x86)\IBM\gsk8\bin;C:\Program Files (x86)\IBM\RationalSDLC\ClearCase\RemoteClient\cteapis;C:\Program Files (x86)\Calibre2\;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\Skype\Phone\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Git\cmd;C:\Program Files (x86)\Sennheiser\SoftphoneSDK\;C:\Program Files (x86)\We
bEx\Productivity Tools;C:\tools\drmemory\bin\

C:\mgr\sr90git\inm_sources_01\Database\install\sql\mariadb>mysql --max-allowed-packet=1G -h fies1udb32 -u mysql --password=mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 97758
Server version: 10.2.17-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> select @@profiling;
+-------------+
| @@profiling |
+-------------+
|           0 |
+-------------+
1 row in set (0.00 sec)

MariaDB [(none)]> set profiling=1;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE = 52974 AND NAME LIKE '%%/%%';
+-----------------------------------------+
| NAME                                    |
+-----------------------------------------+
| win_test/pms15miny1731binhistory#P#q175 |
+-----------------------------------------+
1 row in set (1.10 sec)

MariaDB [(none)]> show profiles;
+----------+------------+-------------------------------------------------------------------------------------------------+
| Query_ID | Duration   | Query                                                                                           |
+----------+------------+-------------------------------------------------------------------------------------------------+
|        1 | 1.10146659 | SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE = 52974 AND NAME LIKE '%%/%%' |
+----------+------------+-------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

MariaDB [(none)]> SHOW PROFILE FOR QUERY 1;
+--------------------------------+----------+
| Status                         | Duration |
+--------------------------------+----------+
| starting                       | 0.000039 |
| Waiting for query cache lock   | 0.000010 |
| init                           | 0.000008 |
| checking query cache for query | 0.008586 |
| checking permissions           | 0.000020 |
| Opening tables                 | 0.000050 |
| After opening tables           | 0.000010 |
| System lock                    | 0.000006 |
| Table lock                     | 0.000015 |
| init                           | 0.000039 |
| optimizing                     | 0.000037 |
| statistics                     | 0.000029 |
| preparing                      | 0.000033 |
| executing                      | 0.000008 |
| Filling schema table           | 0.253978 |
| converting HEAP to Aria        | 0.143984 |
| Filling schema table           | 0.618344 |
| executing                      | 0.000025 |
| Sending data                   | 0.075128 |
| end                            | 0.000029 |
| query end                      | 0.000010 |
| closing tables                 | 0.000007 |
| removing tmp table             | 0.000983 |
| closing tables                 | 0.000010 |
| Unlocking tables               | 0.000008 |
| freeing items                  | 0.000015 |
| updating status                | 0.000040 |
| cleaning up                    | 0.000020 |
+--------------------------------+----------+
28 rows in set (0.00 sec)

MariaDB [(none)]> set profiling=0;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> show index from INNODB_SYS_TABLES from INFORMATION_SCHEMA;
Empty set (0.00 sec)

MariaDB [(none)]> show indexes from INNODB_SYS_TABLES from INFORMATION_SCHEMA;
Empty set (0.00 sec)

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| db8000             |
| db8000_KBa         |
| dbpta1             |
| dxx_smoke          |
| information_schema |
| lin_sr90           |
| master             |
| mtdb_latest        |
| mtdb_previous      |
| mtdb_sr90          |
| mtdb_sr90_sp1      |
| mtdb_sr90_sp2      |
| mtdb_sr90_sp21     |
| mysql              |
| performance_schema |
| simbbms_ple        |
| simdb8000_hva      |
| simdb8000_hva_new  |
| simdb8000_san      |
| simdb8000_san_new  |
| simdb8000_shaakana |
| simfummar          |
| simkimmo           |
| simmanttila        |
| simmanttila_new    |
| simsan             |
| simshaakanavz      |
| win_sr90           |
| win_test           |
| zabbix             |
+--------------------+
30 rows in set (0.00 sec)

MariaDB [(none)]> select * from information_schema.schemata
    -> ;
+--------------+--------------------+----------------------------+------------------------+----------+
| CATALOG_NAME | SCHEMA_NAME        | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | SQL_PATH |
+--------------+--------------------+----------------------------+------------------------+----------+
| def          | db8000             | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | db8000_KBa         | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | dbpta1             | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | dxx_smoke          | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | information_schema | utf8                       | utf8_general_ci        | NULL     |
| def          | lin_sr90           | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | master             | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | mtdb_latest        | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | mtdb_previous      | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | mtdb_sr90          | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | mtdb_sr90_sp1      | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | mtdb_sr90_sp2      | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | mtdb_sr90_sp21     | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | mysql              | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | performance_schema | utf8                       | utf8_general_ci        | NULL     |
| def          | simbbms_ple        | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | simdb8000_hva      | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | simdb8000_hva_new  | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | simdb8000_san      | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | simdb8000_san_new  | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | simdb8000_shaakana | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | simfummar          | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | simkimmo           | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | simmanttila        | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | simmanttila_new    | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | simsan             | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | simshaakanavz      | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | win_sr90           | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | win_test           | utf8mb4                    | utf8mb4_bin            | NULL     |
| def          | zabbix             | utf8                       | utf8_bin               | NULL     |
+--------------+--------------------+----------------------------+------------------------+----------+
30 rows in set (0.00 sec)

MariaDB [(none)]> select * from FROM INFORMATION_SCHEMA.TABLES where table_name="INNODB_SYS_TABLES";
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM INFORMATION_SCHEMA.TABLES where table_name="INNODB_SYS_TABLES"' at line 1
MariaDB [(none)]> select * from INFORMATION_SCHEMA.TABLES where table_name="INNODB_SYS_TABLES";
+---------------+--------------------+-------------------+-------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------------+
| TABLE_CATALOG | TABLE_SCHEMA       | TABLE_NAME        | TABLE_TYPE  | ENGINE | VERSION | ROW_FORMAT | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | AUTO_INCREMENT | CREATE_TIME         | UPDATE_TIME | CHECK_TIME | TABLE_COLLATION | CHECKSUM | CREATE_OPTIONS | TABLE_COMMENT |
+---------------+--------------------+-------------------+-------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------------+
| def           | information_schema | INNODB_SYS_TABLES | SYSTEM VIEW | MEMORY |      11 | Fixed      |       NULL |           2091 |           0 |       133897185 |            0 |         0 |           NULL | 2018-09-10 12:48:15 | NULL        | NULL       | utf8_general_ci |     NULL | max_rows=64188 |               |
+---------------+--------------------+-------------------+-------------+--------+---------+------------+------------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------------+
1 row in set (0.00 sec)

MariaDB [(none)]> show global variables like "tmp_table_size";
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| tmp_table_size | 134217728 |
+----------------+-----------+
1 row in set (0.00 sec)

MariaDB [(none)]> show engine innodb;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
MariaDB [(none)]> show engine status innodb;
ERROR 1286 (42000): Unknown storage engine 'status'
MariaDB [(none)]> show engine innodb status;
+--------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Type   | Name | Status
                   |
+--------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| InnoDB |      |
=====================================
2018-09-10 12:56:32 0x7f9a9b55b700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 49 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 227947 srv_active, 0 srv_shutdown, 130586 srv_idle
srv_master_thread log flush and writes: 358529
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 4489248
OS WAIT ARRAY INFO: signal count 7829583
RW-shared spins 0, rounds 7378353, OS waits 1572950
RW-excl spins 0, rounds 76848592, OS waits 446805
RW-sx spins 2231287, rounds 43267771, OS waits 853310
Spin rounds per wait: 7378353.00 RW-shared, 76848592.00 RW-excl, 19.39 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 51454546
Purge done for trx's n:o < 51454542 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421797819918128, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819917304, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819908240, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819916480, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819903296, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819904944, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819904120, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819893408, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819902472, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819901648, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819900824, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819892584, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819891760, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819890936, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819890112, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819889288, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819915656, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819914008, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819913184, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819912360, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819910712, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819909888, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819909064, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819907416, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819906592, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819905768, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819900000, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819895056, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819894232, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819911536, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819899176, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819898352, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819897528, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819896704, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819895880, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421797819888464, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
--------
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] , aio writes: [0, 0, 0, 0] ,
 ibuf aio reads:, log i/o's:, sync i/o's:
Pending flushes (fsync) log: 0; buffer pool: 0
649011 OS file reads, 5544254 OS file writes, 1137004 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 7.31 writes/s, 3.84 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 21315, seg size 21317, 13449 merges
merged operations:
 insert 76, delete mark 8918652, delete 58747
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 4781323, node heap has 24 buffer(s)
Hash table size 4781323, node heap has 430 buffer(s)
Hash table size 4781323, node heap has 32 buffer(s)
Hash table size 4781323, node heap has 640 buffer(s)
Hash table size 4781323, node heap has 283 buffer(s)
Hash table size 4781323, node heap has 80 buffer(s)
Hash table size 4781323, node heap has 289 buffer(s)
Hash table size 4781323, node heap has 339 buffer(s)
19.59 hash searches/s, 30.69 non-hash searches/s
---
LOG
---
Log sequence number 143623678063
Log flushed up to   143623678063
Pages flushed up to 143623678063
Last checkpoint at  143623678054
0 pending log flushes, 0 pending chkp writes
2833086 log i/o's done, 1.61 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 19808649216
Dictionary memory allocated 1743342995
Buffer pool size   1179648
Free buffers       579166
Database pages     598365
Old database pages 221125
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 29038, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 438405, created 159960, written 2172348
0.00 reads/s, 0.00 creates/s, 3.92 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: 598365, 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   65536
Free buffers       32287
Database pages     33133
Old database pages 12249
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 1807, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24285, created 8848, written 144395
0.00 reads/s, 0.00 creates/s, 0.29 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: 33133, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   65536
Free buffers       32082
Database pages     33326
Old database pages 12305
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 1666, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24521, created 8805, written 77581
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: 33326, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   65536
Free buffers       32417
Database pages     33001
Old database pages 12187
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 1615, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24366, created 8635, written 167099
0.00 reads/s, 0.00 creates/s, 0.29 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: 33001, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   65536
Free buffers       32069
Database pages     33360
Old database pages 12333
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 1716, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24346, created 9014, written 86644
0.00 reads/s, 0.00 creates/s, 0.04 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: 33360, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   65536
Free buffers       32126
Database pages     33290
Old database pages 12308
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 1672, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24369, created 8921, written 98117
0.00 reads/s, 0.00 creates/s, 0.22 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: 33290, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   65536
Free buffers       31945
Database pages     33472
Old database pages 12353
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 1576, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24620, created 8852, written 187415
0.00 reads/s, 0.00 creates/s, 0.61 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: 33472, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   65536
Free buffers       32105
Database pages     33319
Old database pages 12300
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 1606, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24292, created 9027, written 135922
0.00 reads/s, 0.00 creates/s, 0.24 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: 33319, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   65536
Free buffers       32158
Database pages     33256
Old database pages 12294
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 1566, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24271, created 8985, written 76172
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: 33256, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 8
Buffer pool size   65536
Free buffers       31997
Database pages     33424
Old database pages 12341
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 1563, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24571, created 8853, written 183918
0.00 reads/s, 0.00 creates/s, 0.35 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: 33424, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 9
Buffer pool size   65536
Free buffers       32186
Database pages     33237
Old database pages 12289
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 1723, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24487, created 8750, written 91228
0.00 reads/s, 0.00 creates/s, 0.08 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: 33237, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 10
Buffer pool size   65536
Free buffers       32079
Database pages     33341
Old database pages 12327
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 1507, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24490, created 8851, written 190353
0.00 reads/s, 0.00 creates/s, 0.65 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: 33341, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 11
Buffer pool size   65536
Free buffers       32166
Database pages     33254
Old database pages 12295
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 1626, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24481, created 8773, written 100362
0.00 reads/s, 0.00 creates/s, 0.18 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: 33254, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 12
Buffer pool size   65536
Free buffers       32200
Database pages     33225
Old database pages 12284
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 1608, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24073, created 9152, written 111175
0.00 reads/s, 0.00 creates/s, 0.29 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: 33225, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 13
Buffer pool size   65536
Free buffers       32307
Database pages     33103
Old database pages 12230
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 1673, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24058, created 9045, written 84307
0.00 reads/s, 0.00 creates/s, 0.12 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: 33103, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 14
Buffer pool size   65536
Free buffers       32118
Database pages     33295
Old database pages 12310
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 1493, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24445, created 8850, written 81993
0.00 reads/s, 0.00 creates/s, 0.06 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: 33295, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 15
Buffer pool size   65536
Free buffers       32455
Database pages     32972
Old database pages 12186
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 1525, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24136, created 8836, written 175484
0.00 reads/s, 0.00 creates/s, 0.49 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: 32972, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 16
Buffer pool size   65536
Free buffers       32083
Database pages     33344
Old database pages 12328
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 1520, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24089, created 9255, written 75727
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: 33344, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 17
Buffer pool size   65536
Free buffers       32386
Database pages     33013
Old database pages 12206
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 1576, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 24505, created 8508, written 104456
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: 33013, 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
Process ID=1685, Main thread ID=140302271801088, state: sleeping
Number of rows inserted 8148324, updated 3973015, deleted 8634671, read 8230123182
0.35 inserts/s, 0.57 updates/s, 0.00 deletes/s, 39.31 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 27
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.62 sec)

MariaDB [(none)]> show engine heap status;
Empty set (0.00 sec)

MariaDB [(none)]> show engine memory status;
Empty set (0.00 sec)

MariaDB [(none)]> show engine aria status;
Empty set (0.00 sec)

MariaDB [(none)]> show global variables like "aria_pagecache_buffer_size";
+----------------------------+-----------+
| Variable_name              | Value     |
+----------------------------+-----------+
| aria_pagecache_buffer_size | 134217728 |
+----------------------------+-----------+
1 row in set (0.00 sec)

MariaDB [(none)]> SHOW VARIABLES LIKE 'aria_pagecache%';
+-------------------------------+-----------+
| Variable_name                 | Value     |
+-------------------------------+-----------+
| aria_pagecache_age_threshold  | 300       |
| aria_pagecache_buffer_size    | 134217728 |
| aria_pagecache_division_limit | 100       |
| aria_pagecache_file_hash_size | 512       |
+-------------------------------+-----------+
4 rows in set (0.00 sec)

MariaDB [(none)]> SHOW VARIABLES LIKE 'max_heap_table_size';
+---------------------+-----------+
| Variable_name       | Value     |
+---------------------+-----------+
| max_heap_table_size | 134217728 |
+---------------------+-----------+
1 row in set (0.00 sec)

MariaDB [(none)]> SHOW VARIABLES LIKE 'tmp_table_size';
+----------------+-----------+
| Variable_name  | Value     |
+----------------+-----------+
| tmp_table_size | 134217728 |
+----------------+-----------+
1 row in set (0.00 sec)

MariaDB [(none)]> show variables like "Created_tmp%";
Empty set (0.00 sec)

MariaDB [(none)]> show global variables like "Created_tmp%";
Empty set (0.00 sec)

MariaDB [(none)]> show global status like "Created_tmp%";
+-------------------------+---------+
| Variable_name           | Value   |
+-------------------------+---------+
| Created_tmp_disk_tables | 470374  |
| Created_tmp_files       | 5       |
| Created_tmp_tables      | 1210966 |
+-------------------------+---------+
3 rows in set (0.00 sec)

MariaDB [(none)]> show global status like "Created_tmp%";
+-------------------------+---------+
| Variable_name           | Value   |
+-------------------------+---------+
| Created_tmp_disk_tables | 470386  |
| Created_tmp_files       | 5       |
| Created_tmp_tables      | 1210996 |
+-------------------------+---------+
3 rows in set (0.00 sec)

MariaDB [(none)]> show global status like "Created_tmp%";
+-------------------------+---------+
| Variable_name           | Value   |
+-------------------------+---------+
| Created_tmp_disk_tables | 470388  |
| Created_tmp_files       | 5       |
| Created_tmp_tables      | 1211003 |
+-------------------------+---------+
3 rows in set (0.00 sec)

MariaDB [(none)]> show global status like "Created_tmp%";
+-------------------------+---------+
| Variable_name           | Value   |
+-------------------------+---------+
| Created_tmp_disk_tables | 470396  |
| Created_tmp_files       | 5       |
| Created_tmp_tables      | 1211024 |
+-------------------------+---------+
3 rows in set (0.00 sec)

MariaDB [(none)]> show global status like "Created_tmp%";
+-------------------------+---------+
| Variable_name           | Value   |
+-------------------------+---------+
| Created_tmp_disk_tables | 470638  |
| Created_tmp_files       | 5       |
| Created_tmp_tables      | 1211710 |
+-------------------------+---------+
3 rows in set (0.00 sec)

MariaDB [(none)]> show global status like "Created_tmp%";
+-------------------------+---------+
| Variable_name           | Value   |
+-------------------------+---------+
| Created_tmp_disk_tables | 470664  |
| Created_tmp_files       | 5       |
| Created_tmp_tables      | 1211773 |
+-------------------------+---------+
3 rows in set (0.00 sec)

MariaDB [(none)]> explain SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE = 52974 AND NAME LIKE '%%/%%';
+------+-------------+-------------------+------+---------------+------+---------+------+------+-------------+
| id   | select_type | table             | type | possible_keys | key  | key_len | ref  | rows | Extra       |
+------+-------------+-------------------+------+---------------+------+---------+------+------+-------------+
|    1 | SIMPLE      | INNODB_SYS_TABLES | ALL  | NULL          | NULL | NULL    | NULL | NULL | Using where |
+------+-------------+-------------------+------+---------------+------+---------+------+------+-------------+
1 row in set (0.00 sec)

MariaDB [(none)]> select count(*) from INNODB_SYS_TABLES;
ERROR 1046 (3D000): No database selected
MariaDB [(none)]> select count(*) from INFORMATION_SCHEMA.INNODB_SYS_TABLES;
+----------+
| count(*) |
+----------+
|   234440 |
+----------+
1 row in set (0.99 sec)

MariaDB [(none)]> set max_heap_table_size=536870912;
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> set tmp_table_size=536870912;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> show global status like "Created_tmp%";
+-------------------------+---------+
| Variable_name           | Value   |
+-------------------------+---------+
| Created_tmp_disk_tables | 471323  |
| Created_tmp_files       | 5       |
| Created_tmp_tables      | 1213368 |
+-------------------------+---------+
3 rows in set (0.00 sec)

MariaDB [(none)]> show global status like "Created_tmp%";
+-------------------------+---------+
| Variable_name           | Value   |
+-------------------------+---------+
| Created_tmp_disk_tables | 471324  |
| Created_tmp_files       | 5       |
| Created_tmp_tables      | 1213372 |
+-------------------------+---------+
3 rows in set (0.00 sec)

MariaDB [(none)]> show global status like "Created_tmp%";
+-------------------------+---------+
| Variable_name           | Value   |
+-------------------------+---------+
| Created_tmp_disk_tables | 471326  |
| Created_tmp_files       | 5       |
| Created_tmp_tables      | 1213381 |
+-------------------------+---------+
3 rows in set (0.00 sec)

MariaDB [(none)]> show global status like "Created_tmp%";
+-------------------------+---------+
| Variable_name           | Value   |
+-------------------------+---------+
| Created_tmp_disk_tables | 471327  |
| Created_tmp_files       | 5       |
| Created_tmp_tables      | 1213385 |
+-------------------------+---------+
3 rows in set (0.00 sec)

MariaDB [(none)]> show global status like "Created_tmp%";
+-------------------------+---------+
| Variable_name           | Value   |
+-------------------------+---------+
| Created_tmp_disk_tables | 471330  |
| Created_tmp_files       | 5       |
| Created_tmp_tables      | 1213391 |
+-------------------------+---------+
3 rows in set (0.00 sec)

MariaDB [(none)]> set profiling=1;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE = 52974 AND NAME LIKE '%%/%%';
+-----------------------------------------+
| NAME                                    |
+-----------------------------------------+
| win_test/pms15miny1731binhistory#P#q175 |
+-----------------------------------------+
1 row in set (0.94 sec)

MariaDB [(none)]> show profiles;
+----------+------------+-------------------------------------------------------------------------------------------------+
| Query_ID | Duration   | Query                                                                                           |
+----------+------------+-------------------------------------------------------------------------------------------------+
|        1 | 1.10146659 | SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE = 52974 AND NAME LIKE '%%/%%' |
|        2 | 0.94333337 | SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE = 52974 AND NAME LIKE '%%/%%' |
+----------+------------+-------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

MariaDB [(none)]> SHOW PROFILE FOR QUERY 2;
+--------------------------------+----------+
| Status                         | Duration |
+--------------------------------+----------+
| starting                       | 0.000037 |
| Waiting for query cache lock   | 0.000025 |
| init                           | 0.000009 |
| checking query cache for query | 0.000079 |
| checking permissions           | 0.000012 |
| Opening tables                 | 0.000050 |
| After opening tables           | 0.000010 |
| System lock                    | 0.000007 |
| Table lock                     | 0.000014 |
| init                           | 0.000038 |
| optimizing                     | 0.000029 |
| statistics                     | 0.000028 |
| preparing                      | 0.000032 |
| executing                      | 0.000009 |
| Filling schema table           | 0.853100 |
| executing                      | 0.000026 |
| Sending data                   | 0.088881 |
| end                            | 0.000032 |
| query end                      | 0.000010 |
| closing tables                 | 0.000008 |
| removing tmp table             | 0.000792 |
| closing tables                 | 0.000011 |
| Unlocking tables               | 0.000008 |
| freeing items                  | 0.000015 |
| updating status                | 0.000049 |
| cleaning up                    | 0.000023 |
+--------------------------------+----------+
26 rows in set (0.00 sec)

MariaDB [(none)]> set profiling=0;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> set profiling=1;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE = 52974 AND NAME LIKE '%%/%%';
+-----------------------------------------+
| NAME                                    |
+-----------------------------------------+
| win_test/pms15miny1731binhistory#P#q175 |
+-----------------------------------------+
1 row in set (0.85 sec)

MariaDB [(none)]> show profiles;
+----------+------------+-------------------------------------------------------------------------------------------------+
| Query_ID | Duration   | Query                                                                                           |
+----------+------------+-------------------------------------------------------------------------------------------------+
|        1 | 1.10146659 | SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE = 52974 AND NAME LIKE '%%/%%' |
|        2 | 0.94333337 | SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE = 52974 AND NAME LIKE '%%/%%' |
|        3 | 0.85380770 | SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE = 52974 AND NAME LIKE '%%/%%' |
+----------+------------+-------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)

MariaDB [(none)]> SHOW PROFILE FOR QUERY 3;
+--------------------------------+----------+
| Status                         | Duration |
+--------------------------------+----------+
| starting                       | 0.000043 |
| Waiting for query cache lock   | 0.000043 |
| init                           | 0.000012 |
| checking query cache for query | 0.000155 |
| checking permissions           | 0.000017 |
| Opening tables                 | 0.000090 |
| After opening tables           | 0.000014 |
| System lock                    | 0.000010 |
| Table lock                     | 0.000019 |
| init                           | 0.000047 |
| optimizing                     | 0.000037 |
| statistics                     | 0.000036 |
| preparing                      | 0.000041 |
| executing                      | 0.000013 |
| Filling schema table           | 0.759816 |
| executing                      | 0.000033 |
| Sending data                   | 0.092401 |
| end                            | 0.000033 |
| query end                      | 0.000011 |
| closing tables                 | 0.000007 |
| removing tmp table             | 0.000814 |
| closing tables                 | 0.000011 |
| Unlocking tables               | 0.000009 |
| freeing items                  | 0.000015 |
| updating status                | 0.000049 |
| cleaning up                    | 0.000033 |
+--------------------------------+----------+
26 rows in set (0.00 sec)

MariaDB [(none)]> create temporary table xxx as SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE '%%/%%';
ERROR 1046 (3D000): No database selected
MariaDB [(none)]> use INFORMATION_SCHEMA
Database changed
MariaDB [INFORMATION_SCHEMA]> create temporary table xxx as SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE '%%/%%';
ERROR 1044 (42000): Access denied for user 'mysql'@'%' to database 'information_schema'
MariaDB [INFORMATION_SCHEMA]> use db8000
Database changed
MariaDB [db8000]> create temporary table xxx as SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE '%%/%%';
Query OK, 234435 rows affected (2.50 sec)
Records: 234435  Duplicates: 0  Warnings: 0

MariaDB [db8000]> show profiles;
+----------+------------+-------------------------------------------------------------------------------------------------------------+
| Query_ID | Duration   | Query                                                                                                       |
+----------+------------+-------------------------------------------------------------------------------------------------------------+
|        1 | 1.10146659 | SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE = 52974 AND NAME LIKE '%%/%%'             |
|        2 | 0.94333337 | SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE = 52974 AND NAME LIKE '%%/%%'             |
|        3 | 0.85380770 | SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE = 52974 AND NAME LIKE '%%/%%'             |
|        4 | 0.00011375 | create temporary table xxx as SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE '%%/%%' |
|        5 | 0.00024326 | SELECT DATABASE()                                                                                           |
|        6 | 0.00010175 | create temporary table xxx as SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE '%%/%%' |
|        7 | 0.00035053 | SELECT DATABASE()                                                                                           |
|        8 | 2.50520792 | create temporary table xxx as SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE '%%/%%' |
+----------+------------+-------------------------------------------------------------------------------------------------------------+
8 rows in set (0.00 sec)

MariaDB [db8000]> SHOW PROFILE FOR QUERY 8;
+------------------------------+----------+
| Status                       | Duration |
+------------------------------+----------+
| starting                     | 0.000121 |
| checking permissions         | 0.000010 |
| checking permissions         | 0.000011 |
| Opening tables               | 0.000097 |
| After opening tables         | 0.000011 |
| System lock                  | 0.000007 |
| Table lock                   | 0.000014 |
| init                         | 0.000043 |
| creating table               | 0.487287 |
| After create                 | 0.000029 |
| System lock                  | 0.000009 |
| Table lock                   | 0.000007 |
| After create                 | 0.000013 |
| optimizing                   | 0.000022 |
| statistics                   | 0.000027 |
| preparing                    | 0.000029 |
| executing                    | 0.000009 |
| Filling schema table         | 0.845461 |
| executing                    | 0.000026 |
| Sending data                 | 1.170813 |
| Waiting for query cache lock | 0.000031 |
| Sending data                 | 0.000020 |
| Unlocking tables             | 0.000109 |
| end                          | 0.000012 |
| query end                    | 0.000013 |
| closing tables               | 0.000008 |
| removing tmp table           | 0.000847 |
| closing tables               | 0.000011 |
| Unlocking tables             | 0.000009 |
| freeing items                | 0.000012 |
| updating status              | 0.000050 |
| cleaning up                  | 0.000039 |
+------------------------------+----------+
32 rows in set (0.00 sec)

MariaDB [db8000]>