MariaDB [(none)]> SELECT @@SQL_MODE, @@GLOBAL.SQL_MODE; +-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+ | @@SQL_MODE | @@GLOBAL.SQL_MODE | +-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+ | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | +-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+ MariaDB [zabbix]> CREATE TABLE t (a VARCHAR(10000), b VARCHAR(10000), -> c VARCHAR(10000), d VARCHAR(10000), e VARCHAR(10000), -> f VARCHAR(10000), g VARCHAR(6000)) ENGINE=InnoDB CHARACTER SET latin1; ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs MariaDB [zabbix]> SHOW TABLE STATUS IN zabbix; +----------------------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------+----------+----------------+---------+------------------+-----------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | Max_index_length | Temporary | +----------------------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------+----------+----------------+---------+------------------+-----------+ | acknowledges | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 49152 | 0 | NULL | 2020-04-14 15:35:47 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | actions | InnoDB | 10 | Dynamic | 5 | 3276 | 16384 | 0 | 32768 | 0 | NULL | 2020-02-18 15:21:56 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | alerts | InnoDB | 10 | Compact | 294 | 445 | 131072 | 0 | 131072 | 0 | NULL | 2019-10-04 12:39:21 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | application_discovery | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | application_prototype | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | application_template | InnoDB | 10 | Compact | 159 | 103 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:11 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | applications | InnoDB | 10 | Compact | 425 | 115 | 49152 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:06 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | auditlog | InnoDB | 10 | Dynamic | 2091 | 101 | 212992 | 0 | 229376 | 0 | NULL | 2020-03-17 14:35:26 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | auditlog_details | InnoDB | 10 | Compact | 43 | 381 | 16384 | 0 | 16384 | 0 | NULL | 2020-05-07 16:28:05 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | autoreg_host | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2019-09-19 08:52:44 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | conditions | InnoDB | 10 | Compact | 6 | 2730 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:07 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | config | InnoDB | 10 | Dynamic | 1 | 16384 | 16384 | 0 | 32768 | 0 | NULL | 2020-05-07 16:28:05 | 2020-05-07 16:28:05 | NULL | utf8_bin | NULL | | | 0 | N | | config_autoreg_tls | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2019-09-19 08:52:44 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | corr_condition | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | corr_condition_group | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | corr_condition_tag | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2018-12-04 12:45:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | corr_condition_tagpair | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2018-12-04 12:45:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | corr_condition_tagvalue | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2018-12-04 12:45:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | corr_operation | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | correlation | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2018-12-04 12:45:04 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | dashboard | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:13 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | dashboard_user | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:13 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | dashboard_usrgrp | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:13 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | dbversion | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2018-12-04 12:45:05 | 2020-05-07 16:28:11 | NULL | utf8_bin | NULL | | | 0 | N | | dchecks | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2020-02-18 15:21:55 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | dhosts | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:11 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | drules | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:06 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | dservices | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:11 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | escalations | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 49152 | 0 | NULL | 2018-12-04 12:45:03 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | event_recovery | InnoDB | 10 | Compact | 4430 | 48 | 212992 | 0 | 229376 | 4194304 | NULL | 2018-12-04 12:45:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | event_suppress | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 49152 | 0 | NULL | 2018-12-04 12:45:14 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | event_tag | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | events | InnoDB | 10 | Compact | 9017 | 234 | 2113536 | 0 | 1507328 | 5242880 | NULL | 2018-12-04 12:45:03 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | expressions | InnoDB | 10 | Compact | 10 | 1638 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:10 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | functions | InnoDB | 10 | Compact | 1602 | 81 | 131072 | 0 | 180224 | 0 | NULL | 2018-12-04 12:45:08 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | globalmacro | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-03-17 14:35:31 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | globalvars | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2018-12-04 12:45:03 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | graph_discovery | InnoDB | 10 | Compact | 101 | 162 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:11 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | graph_theme | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:01 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | graphs | InnoDB | 10 | Compact | 274 | 239 | 65536 | 0 | 65536 | 0 | NULL | 2020-04-03 17:05:45 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | graphs_items | InnoDB | 10 | Compact | 787 | 124 | 98304 | 0 | 98304 | 0 | NULL | 2018-12-04 12:45:08 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | group_discovery | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:05 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | group_prototype | InnoDB | 10 | Compact | 7 | 2340 | 16384 | 0 | 49152 | 0 | NULL | 2018-12-04 12:45:05 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | history | InnoDB | 10 | Compact | 1828508 | 69 | 127041536 | 0 | 51494912 | 5242880 | NULL | 2018-12-04 12:45:02 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | history_log | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2018-12-04 12:45:03 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | history_str | InnoDB | 10 | Compact | 3029 | 86 | 262144 | 0 | 98304 | 0 | NULL | 2018-12-04 12:45:02 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | history_text | InnoDB | 10 | Compact | 169913 | 346 | 58802176 | 0 | 5259264 | 6291456 | NULL | 2018-12-04 12:45:03 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | history_uint | InnoDB | 10 | Compact | 2206273 | 297 | 655376384 | 0 | 226541568 | 24117248 | NULL | 2018-12-04 12:45:02 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | host_discovery | InnoDB | 10 | Dynamic | 2 | 8192 | 16384 | 0 | 32768 | 0 | NULL | 2019-08-20 15:26:24 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | host_inventory | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2019-10-04 12:39:21 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | host_tag | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2019-04-02 09:48:28 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | hostmacro | InnoDB | 10 | Compact | 292 | 168 | 49152 | 0 | 16384 | 0 | NULL | 2020-03-17 14:35:31 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | hosts | InnoDB | 10 | Compact | 96 | 682 | 65536 | 0 | 98304 | 0 | NULL | 2018-12-04 12:45:05 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | hosts_groups | InnoDB | 10 | Compact | 82 | 199 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:08 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | hosts_templates | InnoDB | 10 | Compact | 103 | 159 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:08 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | housekeeper | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2018-12-04 12:45:03 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | hstgrp | InnoDB | 10 | Compact | 13 | 1260 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:44:59 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | httpstep | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:06 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | httpstep_field | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:13 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | httpstepitem | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:06 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | httptest | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 65536 | 0 | NULL | 2018-12-04 12:45:06 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | httptest_field | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:13 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | httptestitem | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:07 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | icon_map | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:09 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | icon_mapping | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:09 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | ids | InnoDB | 10 | Compact | 36 | 455 | 16384 | 0 | 0 | 0 | NULL | 2018-12-04 12:45:02 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | images | InnoDB | 10 | Compact | 144 | 11036 | 1589248 | 0 | 16384 | 4194304 | NULL | 2018-12-04 12:45:03 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | interface | InnoDB | 10 | Dynamic | 6 | 2730 | 16384 | 0 | 32768 | 0 | NULL | 2020-03-17 14:35:26 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | interface_discovery | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:11 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | interface_snmp | InnoDB | 10 | Dynamic | 2 | 8192 | 16384 | 0 | 0 | 0 | NULL | 2020-03-17 14:35:26 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | item_application_prototype | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | item_condition | InnoDB | 10 | Compact | 242 | 203 | 49152 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:11 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | item_discovery | InnoDB | 10 | Compact | 950 | 103 | 98304 | 0 | 114688 | 0 | NULL | 2020-02-18 15:21:55 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | item_preproc | InnoDB | 10 | Compact | 737 | 111 | 81920 | 0 | 49152 | 0 | NULL | 2019-04-02 09:48:28 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | item_rtdata | InnoDB | 10 | Dynamic | 457 | 143 | 65536 | 0 | 0 | 0 | NULL | 2019-08-20 15:26:24 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | items | InnoDB | 10 | Dynamic | 2413 | 658 | 1589248 | 0 | 491520 | 4194304 | NULL | 2020-05-07 16:28:10 | 2020-05-07 16:28:10 | NULL | utf8_bin | NULL | | | 0 | N | | items_applications | InnoDB | 10 | Compact | 2290 | 64 | 147456 | 0 | 212992 | 0 | NULL | 2018-12-04 12:45:08 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | lld_macro_path | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 16384 | 0 | NULL | 2019-04-02 09:48:28 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | lld_override | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2020-05-07 16:28:06 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | lld_override_condition | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2020-05-07 16:28:07 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | lld_override_opdiscover | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-05-07 16:28:07 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | lld_override_operation | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2020-05-07 16:28:07 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | lld_override_ophistory | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-05-07 16:28:08 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | lld_override_opinventory | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-05-07 16:28:10 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | lld_override_opperiod | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-05-07 16:28:07 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | lld_override_opseverity | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-05-07 16:28:08 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | lld_override_opstatus | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-05-07 16:28:07 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | lld_override_optag | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2020-05-07 16:28:08 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | lld_override_optemplate | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 49152 | 0 | NULL | 2020-05-07 16:28:10 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | lld_override_optrends | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-05-07 16:28:08 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | maintenance_tag | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:14 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | maintenances | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2018-12-04 12:44:59 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | maintenances_groups | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:10 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | maintenances_hosts | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:10 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | maintenances_windows | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:10 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | mappings | InnoDB | 10 | Compact | 820 | 99 | 81920 | 0 | 49152 | 0 | NULL | 2018-12-04 12:45:08 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | media | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:08 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | media_type | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 16384 | 0 | NULL | 2020-05-07 16:28:05 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | media_type_message | InnoDB | 10 | Dynamic | 15 | 1092 | 16384 | 0 | 16384 | 0 | NULL | 2020-02-18 15:21:55 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | media_type_param | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2019-10-04 12:39:21 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | module | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-02-18 15:21:56 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | opcommand | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:07 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | opcommand_grp | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:07 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | opcommand_hst | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:07 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | opconditions | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:07 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | operations | InnoDB | 10 | Compact | 10 | 1638 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:07 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | opgroup | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:07 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | opinventory | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2018-12-04 12:45:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | opmessage | InnoDB | 10 | Compact | 8 | 2048 | 16384 | 0 | 16384 | 0 | NULL | 2020-02-18 15:21:55 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | opmessage_grp | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:07 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | opmessage_usr | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:07 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | optemplate | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:07 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | problem | InnoDB | 10 | Compact | 29 | 564 | 16384 | 0 | 49152 | 5242880 | NULL | 2018-12-04 12:45:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | problem_tag | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | profiles | InnoDB | 10 | Compact | 305 | 214 | 65536 | 0 | 65536 | 0 | NULL | 2018-12-04 12:45:11 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | proxy_autoreg_host | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2019-09-19 08:52:44 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | proxy_dhistory | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | 1 | 2019-04-02 09:48:28 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | proxy_history | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | 1 | 2020-04-28 14:19:10 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | regexps | InnoDB | 10 | Compact | 5 | 3276 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:02 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | rights | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:09 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | screen_user | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:05 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | screen_usrgrp | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:05 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | screens | InnoDB | 10 | Compact | 12 | 1365 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:05 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | screens_items | InnoDB | 10 | Compact | 50 | 327 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:05 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | scripts | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 49152 | 0 | NULL | 2018-12-04 12:45:07 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | service_alarms | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:11 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | services | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2020-04-03 17:05:45 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | services_links | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:09 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | services_times | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:09 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | sessions | InnoDB | 10 | Compact | 2295 | 114 | 262144 | 0 | 196608 | 0 | NULL | 2018-12-04 12:45:11 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | slides | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:06 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | slideshow_user | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:06 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | slideshow_usrgrp | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:06 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | slideshows | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:05 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | sysmap_element_trigger | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:13 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | sysmap_element_url | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:10 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | sysmap_shape | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:13 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | sysmap_url | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:10 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | sysmap_user | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:10 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | sysmap_usrgrp | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:10 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | sysmaps | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 65536 | 0 | NULL | 2018-12-04 12:45:09 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | sysmaps_elements | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 81920 | 0 | NULL | 2018-12-04 12:45:09 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | sysmaps_link_triggers | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:09 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | sysmaps_links | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 49152 | 0 | NULL | 2018-12-04 12:45:09 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | tag_filter | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | task | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | task_acknowledge | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2018-12-04 12:45:13 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | task_check_now | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 0 | 0 | NULL | 2018-12-04 12:45:13 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | task_close_problem | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2018-12-04 12:45:13 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | task_data | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2020-02-18 15:21:56 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | task_remote_command | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2018-12-04 12:45:13 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | task_remote_command_result | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2018-12-04 12:45:13 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | task_result | InnoDB | 10 | Dynamic | 0 | 0 | 32768 | 0 | 16384 | 0 | NULL | 2020-02-18 15:21:56 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | timeperiods | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2018-12-04 12:45:02 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | trends | InnoDB | 10 | Compact | 526188 | 80 | 42549248 | 0 | 0 | 7340032 | NULL | 2018-12-04 12:45:03 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | trends_uint | InnoDB | 10 | Compact | 1112455 | 82 | 91832320 | 0 | 0 | 8388608 | NULL | 2018-12-04 12:45:03 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | trigger_depends | InnoDB | 10 | Compact | 443 | 110 | 49152 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:08 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | trigger_discovery | InnoDB | 10 | Compact | 80 | 204 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:11 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | trigger_tag | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:12 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | triggers | InnoDB | 10 | Compact | 1081 | 287 | 311296 | 0 | 147456 | 0 | NULL | 2020-05-07 16:28:11 | 2020-05-07 16:28:11 | NULL | utf8_bin | NULL | | | 0 | N | | users | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 16384 | 0 | NULL | 2020-02-18 15:21:55 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | users_groups | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 32768 | 0 | NULL | 2018-12-04 12:45:07 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | usrgrp | InnoDB | 10 | Compact | 5 | 3276 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:00 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | valuemaps | InnoDB | 10 | Compact | 75 | 218 | 16384 | 0 | 16384 | 0 | NULL | 2018-12-04 12:45:00 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | widget | InnoDB | 10 | Compact | 5 | 3276 | 16384 | 0 | 16384 | 0 | NULL | 2019-08-20 15:26:25 | NULL | NULL | utf8_bin | NULL | | | 0 | N | | widget_field | InnoDB | 10 | Compact | 9 | 1820 | 16384 | 0 | 98304 | 0 | NULL | 2018-12-04 12:45:13 | NULL | NULL | utf8_bin | NULL | | | 0 | N | +----------------------------+--------+---------+------------+---------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------+----------+----------------+---------+------------------+-----------+ 166 rows in set (0.020 sec)