Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.5(EOL), 10.0(EOL), 10.1(EOL)
Description
My test schema has 2400 tables/views, each has 446 columns, so there are 1070400 columns total, which is somewhat extreme, but still isn't completely unrealistic. When I try to connect to the schema with the client with auto-rehash (default), it takes forever – I can't say how long because I cannot wait till it's done. I've seen it take 6+ hours and counting.
Processlist on the server claims that the client is connected, like this (connection 660):
+-----+-----------------+-----------------+------+---------+-------+------------------------+------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+-----+-----------------+-----------------+------+---------+-------+------------------------+------------------+----------+
|
| 2 | event_scheduler | localhost | NULL | Daemon | 33621 | Waiting on empty queue | NULL | 0.000 |
|
| 660 | root | localhost:52934 | test | Sleep | 0 | | NULL | 0.000 |
|
| 667 | root | localhost:53057 | NULL | Query | 0 | init | show processlist | 0.000 |
|
+-----+-----------------+-----------------+------+---------+-------+------------------------+------------------+----------+
|
However, the client does not return the prompt.
Some experiments with different number of tables and columns show that the performance quickly deteriorates when the number of objects increases. Processing every table takes longer than the previous one. I won't say it grows exponentially, but the function is not pretty. Most of the time is spent in completion_hash_update. The most important factor is the number of columns.
Attached is a reduced version of the same schema, it has 80 tables, 240 views, 446 columns each, so it's 142720 columns. It takes around 40 min on my machine with a release 10.1 server/client to finish building the hash.
Below is the excerpt from the general log, pretty much unabridged, because the server was left idle. For first tables/views processing time was roughly 0.1 sec, for last ones – almost 20 sec. each.
Memory consumption also grows, but not extremely. CPU usage remains 100% during the process.
On my initial bigger schema processing time per table reaches 50+ seconds and keeps growing by the time I have to interrupt the process.
160731 19:35:07 10 Connect root@localhost as anonymous on test
|
10 Query show databases
|
10 Query show tables
|
10 Field List table0_innodb_armscii8
|
10 Field List table0_innodb_ascii
|
160731 19:35:08 10 Field List table0_innodb_big5
|
10 Field List table0_innodb_binary
|
10 Field List table0_innodb_cp1250
|
10 Field List table0_innodb_cp1251
|
10 Field List table0_innodb_cp1256
|
10 Field List table0_innodb_cp1257
|
10 Field List table0_innodb_cp850
|
10 Field List table0_innodb_cp852
|
10 Field List table0_innodb_cp866
|
10 Field List table0_innodb_cp932
|
160731 19:35:09 10 Field List table0_innodb_dec8
|
10 Field List table0_innodb_eucjpms
|
10 Field List table0_innodb_euckr
|
10 Field List table0_innodb_gb2312
|
160731 19:35:10 10 Field List table0_innodb_gbk
|
10 Field List table0_innodb_geostd8
|
10 Field List table0_innodb_greek
|
10 Field List table0_innodb_hebrew
|
160731 19:35:11 10 Field List table0_innodb_hp8
|
10 Field List table0_innodb_keybcs2
|
10 Field List table0_innodb_koi8r
|
160731 19:35:12 10 Field List table0_innodb_koi8u
|
10 Field List table0_innodb_latin1
|
160731 19:35:13 10 Field List table0_innodb_latin2
|
10 Field List table0_innodb_latin5
|
160731 19:35:14 10 Field List table0_innodb_latin7
|
10 Field List table0_innodb_macce
|
160731 19:35:15 10 Field List table0_innodb_macroman
|
10 Field List table0_innodb_sjis
|
160731 19:35:16 10 Field List table0_innodb_swe7
|
10 Field List table0_innodb_tis620
|
160731 19:35:17 10 Field List table0_innodb_ucs2
|
10 Field List table0_innodb_ujis
|
160731 19:35:18 10 Field List table0_innodb_utf16
|
160731 19:35:19 10 Field List table0_innodb_utf16le
|
10 Field List table0_innodb_utf32
|
160731 19:35:20 10 Field List table0_innodb_utf8
|
160731 19:35:21 10 Field List table0_innodb_utf8mb4
|
160731 19:35:22 10 Field List table0_myisam_armscii8
|
10 Field List table0_myisam_ascii
|
160731 19:35:23 10 Field List table0_myisam_big5
|
160731 19:35:24 10 Field List table0_myisam_binary
|
160731 19:35:25 10 Field List table0_myisam_cp1250
|
10 Field List table0_myisam_cp1251
|
160731 19:35:26 10 Field List table0_myisam_cp1256
|
160731 19:35:27 10 Field List table0_myisam_cp1257
|
160731 19:35:28 10 Field List table0_myisam_cp850
|
160731 19:35:29 10 Field List table0_myisam_cp852
|
160731 19:35:30 10 Field List table0_myisam_cp866
|
160731 19:35:31 10 Field List table0_myisam_cp932
|
160731 19:35:32 10 Field List table0_myisam_dec8
|
160731 19:35:33 10 Field List table0_myisam_eucjpms
|
160731 19:35:34 10 Field List table0_myisam_euckr
|
160731 19:35:35 10 Field List table0_myisam_gb2312
|
160731 19:35:36 10 Field List table0_myisam_gbk
|
160731 19:35:37 10 Field List table0_myisam_geostd8
|
160731 19:35:39 10 Field List table0_myisam_greek
|
160731 19:35:40 10 Field List table0_myisam_hebrew
|
160731 19:35:41 10 Field List table0_myisam_hp8
|
160731 19:35:43 10 Field List table0_myisam_keybcs2
|
160731 19:35:44 10 Field List table0_myisam_koi8r
|
160731 19:35:46 10 Field List table0_myisam_koi8u
|
160731 19:35:47 10 Field List table0_myisam_latin1
|
160731 19:35:49 10 Field List table0_myisam_latin2
|
160731 19:35:50 10 Field List table0_myisam_latin5
|
160731 19:35:52 10 Field List table0_myisam_latin7
|
160731 19:35:54 10 Field List table0_myisam_macce
|
160731 19:35:56 10 Field List table0_myisam_macroman
|
160731 19:35:58 10 Field List table0_myisam_sjis
|
160731 19:35:59 10 Field List table0_myisam_swe7
|
160731 19:36:01 10 Field List table0_myisam_tis620
|
160731 19:36:03 10 Field List table0_myisam_ucs2
|
160731 19:36:05 10 Field List table0_myisam_ujis
|
160731 19:36:07 10 Field List table0_myisam_utf16
|
160731 19:36:09 10 Field List table0_myisam_utf16le
|
160731 19:36:11 10 Field List table0_myisam_utf32
|
160731 19:36:13 10 Field List table0_myisam_utf8
|
160731 19:36:16 10 Field List table0_myisam_utf8mb4
|
160731 19:36:18 10 Field List view_table0_innodb_armscii8_0
|
160731 19:36:22 10 Field List view_table0_innodb_armscii8_1
|
160731 19:36:26 10 Field List view_table0_innodb_armscii8_2
|
160731 19:36:30 10 Field List view_table0_innodb_ascii_0
|
160731 19:36:33 10 Field List view_table0_innodb_ascii_1
|
160731 19:36:37 10 Field List view_table0_innodb_ascii_2
|
160731 19:36:41 10 Field List view_table0_innodb_big5_0
|
160731 19:36:46 10 Field List view_table0_innodb_big5_1
|
160731 19:36:50 10 Field List view_table0_innodb_big5_2
|
160731 19:36:54 10 Field List view_table0_innodb_binary_0
|
160731 19:36:59 10 Field List view_table0_innodb_binary_1
|
160731 19:37:03 10 Field List view_table0_innodb_binary_2
|
160731 19:37:08 10 Field List view_table0_innodb_cp1250_0
|
160731 19:37:13 10 Field List view_table0_innodb_cp1250_1
|
160731 19:37:18 10 Field List view_table0_innodb_cp1250_2
|
160731 19:37:23 10 Field List view_table0_innodb_cp1251_0
|
160731 19:37:28 10 Field List view_table0_innodb_cp1251_1
|
160731 19:37:33 10 Field List view_table0_innodb_cp1251_2
|
160731 19:37:39 10 Field List view_table0_innodb_cp1256_0
|
160731 19:37:44 10 Field List view_table0_innodb_cp1256_1
|
160731 19:37:49 10 Field List view_table0_innodb_cp1256_2
|
160731 19:37:54 10 Field List view_table0_innodb_cp1257_0
|
160731 19:37:59 10 Field List view_table0_innodb_cp1257_1
|
160731 19:38:05 10 Field List view_table0_innodb_cp1257_2
|
160731 19:38:10 10 Field List view_table0_innodb_cp850_0
|
160731 19:38:16 10 Field List view_table0_innodb_cp850_1
|
160731 19:38:21 10 Field List view_table0_innodb_cp850_2
|
160731 19:38:27 10 Field List view_table0_innodb_cp852_0
|
160731 19:38:33 10 Field List view_table0_innodb_cp852_1
|
160731 19:38:39 10 Field List view_table0_innodb_cp852_2
|
160731 19:38:44 10 Field List view_table0_innodb_cp866_0
|
160731 19:38:50 10 Field List view_table0_innodb_cp866_1
|
160731 19:38:55 10 Field List view_table0_innodb_cp866_2
|
160731 19:39:01 10 Field List view_table0_innodb_cp932_0
|
160731 19:39:07 10 Field List view_table0_innodb_cp932_1
|
160731 19:39:13 10 Field List view_table0_innodb_cp932_2
|
160731 19:39:19 10 Field List view_table0_innodb_dec8_0
|
160731 19:39:25 10 Field List view_table0_innodb_dec8_1
|
160731 19:39:31 10 Field List view_table0_innodb_dec8_2
|
160731 19:39:37 10 Field List view_table0_innodb_eucjpms_0
|
160731 19:39:45 10 Field List view_table0_innodb_eucjpms_1
|
160731 19:39:51 10 Field List view_table0_innodb_eucjpms_2
|
160731 19:39:58 10 Field List view_table0_innodb_euckr_0
|
160731 19:40:04 10 Field List view_table0_innodb_euckr_1
|
160731 19:40:10 10 Field List view_table0_innodb_euckr_2
|
160731 19:40:17 10 Field List view_table0_innodb_gb2312_0
|
160731 19:40:23 10 Field List view_table0_innodb_gb2312_1
|
160731 19:40:29 10 Field List view_table0_innodb_gb2312_2
|
160731 19:40:35 10 Field List view_table0_innodb_gbk_0
|
160731 19:40:41 10 Field List view_table0_innodb_gbk_1
|
160731 19:40:48 10 Field List view_table0_innodb_gbk_2
|
160731 19:40:54 10 Field List view_table0_innodb_geostd8_0
|
160731 19:41:02 10 Field List view_table0_innodb_geostd8_1
|
160731 19:41:09 10 Field List view_table0_innodb_geostd8_2
|
160731 19:41:17 10 Field List view_table0_innodb_greek_0
|
160731 19:41:24 10 Field List view_table0_innodb_greek_1
|
160731 19:41:31 10 Field List view_table0_innodb_greek_2
|
160731 19:41:38 10 Field List view_table0_innodb_hebrew_0
|
160731 19:41:46 10 Field List view_table0_innodb_hebrew_1
|
160731 19:41:54 10 Field List view_table0_innodb_hebrew_2
|
160731 19:42:01 10 Field List view_table0_innodb_hp8_0
|
160731 19:42:08 10 Field List view_table0_innodb_hp8_1
|
160731 19:42:15 10 Field List view_table0_innodb_hp8_2
|
160731 19:42:22 10 Field List view_table0_innodb_keybcs2_0
|
160731 19:42:30 10 Field List view_table0_innodb_keybcs2_1
|
160731 19:42:38 10 Field List view_table0_innodb_keybcs2_2
|
160731 19:42:46 10 Field List view_table0_innodb_koi8r_0
|
160731 19:42:53 10 Field List view_table0_innodb_koi8r_1
|
160731 19:43:00 10 Field List view_table0_innodb_koi8r_2
|
160731 19:43:08 10 Field List view_table0_innodb_koi8u_0
|
160731 19:43:16 10 Field List view_table0_innodb_koi8u_1
|
160731 19:43:24 10 Field List view_table0_innodb_koi8u_2
|
160731 19:43:32 10 Field List view_table0_innodb_latin1_0
|
160731 19:43:40 10 Field List view_table0_innodb_latin1_1
|
160731 19:43:49 10 Field List view_table0_innodb_latin1_2
|
160731 19:43:57 10 Field List view_table0_innodb_latin2_0
|
160731 19:44:06 10 Field List view_table0_innodb_latin2_1
|
160731 19:44:16 10 Field List view_table0_innodb_latin2_2
|
160731 19:44:25 10 Field List view_table0_innodb_latin5_0
|
160731 19:44:35 10 Field List view_table0_innodb_latin5_1
|
160731 19:44:44 10 Field List view_table0_innodb_latin5_2
|
160731 19:44:54 10 Field List view_table0_innodb_latin7_0
|
160731 19:45:03 10 Field List view_table0_innodb_latin7_1
|
160731 19:45:13 10 Field List view_table0_innodb_latin7_2
|
160731 19:45:22 10 Field List view_table0_innodb_macce_0
|
160731 19:45:31 10 Field List view_table0_innodb_macce_1
|
160731 19:45:40 10 Field List view_table0_innodb_macce_2
|
160731 19:45:49 10 Field List view_table0_innodb_macroman_0
|
160731 19:45:58 10 Field List view_table0_innodb_macroman_1
|
160731 19:46:07 10 Field List view_table0_innodb_macroman_2
|
160731 19:46:16 10 Field List view_table0_innodb_sjis_0
|
160731 19:46:24 10 Field List view_table0_innodb_sjis_1
|
160731 19:46:33 10 Field List view_table0_innodb_sjis_2
|
160731 19:46:42 10 Field List view_table0_innodb_swe7_0
|
160731 19:46:51 10 Field List view_table0_innodb_swe7_1
|
160731 19:47:01 10 Field List view_table0_innodb_swe7_2
|
160731 19:47:10 10 Field List view_table0_innodb_tis620_0
|
160731 19:47:20 10 Field List view_table0_innodb_tis620_1
|
160731 19:47:29 10 Field List view_table0_innodb_tis620_2
|
160731 19:47:39 10 Field List view_table0_innodb_ucs2_0
|
160731 19:47:49 10 Field List view_table0_innodb_ucs2_1
|
160731 19:47:59 10 Field List view_table0_innodb_ucs2_2
|
160731 19:48:10 10 Field List view_table0_innodb_ujis_0
|
160731 19:48:19 10 Field List view_table0_innodb_ujis_1
|
160731 19:48:29 10 Field List view_table0_innodb_ujis_2
|
160731 19:48:39 10 Field List view_table0_innodb_utf16_0
|
160731 19:48:50 10 Field List view_table0_innodb_utf16_1
|
160731 19:49:00 10 Field List view_table0_innodb_utf16_2
|
160731 19:49:11 10 Field List view_table0_innodb_utf16le_0
|
160731 19:49:23 10 Field List view_table0_innodb_utf16le_1
|
160731 19:49:35 10 Field List view_table0_innodb_utf16le_2
|
160731 19:49:47 10 Field List view_table0_innodb_utf32_0
|
160731 19:49:57 10 Field List view_table0_innodb_utf32_1
|
160731 19:50:08 10 Field List view_table0_innodb_utf32_2
|
160731 19:50:19 10 Field List view_table0_innodb_utf8_0
|
160731 19:50:30 10 Field List view_table0_innodb_utf8_1
|
160731 19:50:40 10 Field List view_table0_innodb_utf8_2
|
160731 19:50:51 10 Field List view_table0_innodb_utf8mb4_0
|
160731 19:51:03 10 Field List view_table0_innodb_utf8mb4_1
|
160731 19:51:14 10 Field List view_table0_innodb_utf8mb4_2
|
160731 19:51:26 10 Field List view_table0_myisam_armscii8_0
|
160731 19:51:35 10 Field List view_table0_myisam_armscii8_1
|
160731 19:51:45 10 Field List view_table0_myisam_armscii8_2
|
160731 19:51:54 10 Field List view_table0_myisam_ascii_0
|
160731 19:52:04 10 Field List view_table0_myisam_ascii_1
|
160731 19:52:13 10 Field List view_table0_myisam_ascii_2
|
160731 19:52:23 10 Field List view_table0_myisam_big5_0
|
160731 19:52:32 10 Field List view_table0_myisam_big5_1
|
160731 19:52:42 10 Field List view_table0_myisam_big5_2
|
160731 19:52:52 10 Field List view_table0_myisam_binary_0
|
160731 19:53:02 10 Field List view_table0_myisam_binary_1
|
160731 19:53:12 10 Field List view_table0_myisam_binary_2
|
160731 19:53:22 10 Field List view_table0_myisam_cp1250_0
|
160731 19:53:32 10 Field List view_table0_myisam_cp1250_1
|
160731 19:53:43 10 Field List view_table0_myisam_cp1250_2
|
160731 19:53:53 10 Field List view_table0_myisam_cp1251_0
|
160731 19:54:03 10 Field List view_table0_myisam_cp1251_1
|
160731 19:54:14 10 Field List view_table0_myisam_cp1251_2
|
160731 19:54:24 10 Field List view_table0_myisam_cp1256_0
|
160731 19:54:35 10 Field List view_table0_myisam_cp1256_1
|
160731 19:54:46 10 Field List view_table0_myisam_cp1256_2
|
160731 19:54:56 10 Field List view_table0_myisam_cp1257_0
|
160731 19:55:07 10 Field List view_table0_myisam_cp1257_1
|
160731 19:55:18 10 Field List view_table0_myisam_cp1257_2
|
160731 19:55:29 10 Field List view_table0_myisam_cp850_0
|
160731 19:55:40 10 Field List view_table0_myisam_cp850_1
|
160731 19:55:51 10 Field List view_table0_myisam_cp850_2
|
160731 19:56:02 10 Field List view_table0_myisam_cp852_0
|
160731 19:56:12 10 Field List view_table0_myisam_cp852_1
|
160731 19:56:23 10 Field List view_table0_myisam_cp852_2
|
160731 19:56:33 10 Field List view_table0_myisam_cp866_0
|
160731 19:56:44 10 Field List view_table0_myisam_cp866_1
|
160731 19:56:55 10 Field List view_table0_myisam_cp866_2
|
160731 19:57:05 10 Field List view_table0_myisam_cp932_0
|
160731 19:57:16 10 Field List view_table0_myisam_cp932_1
|
160731 19:57:26 10 Field List view_table0_myisam_cp932_2
|
160731 19:57:37 10 Field List view_table0_myisam_dec8_0
|
160731 19:57:48 10 Field List view_table0_myisam_dec8_1
|
160731 19:58:00 10 Field List view_table0_myisam_dec8_2
|
160731 19:58:12 10 Field List view_table0_myisam_eucjpms_0
|
160731 19:58:24 10 Field List view_table0_myisam_eucjpms_1
|
160731 19:58:37 10 Field List view_table0_myisam_eucjpms_2
|
160731 19:58:49 10 Field List view_table0_myisam_euckr_0
|
160731 19:59:01 10 Field List view_table0_myisam_euckr_1
|
160731 19:59:13 10 Field List view_table0_myisam_euckr_2
|
160731 19:59:25 10 Field List view_table0_myisam_gb2312_0
|
160731 19:59:37 10 Field List view_table0_myisam_gb2312_1
|
160731 19:59:49 10 Field List view_table0_myisam_gb2312_2
|
160731 20:00:00 10 Field List view_table0_myisam_gbk_0
|
160731 20:00:12 10 Field List view_table0_myisam_gbk_1
|
160731 20:00:23 10 Field List view_table0_myisam_gbk_2
|
160731 20:00:34 10 Field List view_table0_myisam_geostd8_0
|
160731 20:00:48 10 Field List view_table0_myisam_geostd8_1
|
160731 20:01:01 10 Field List view_table0_myisam_geostd8_2
|
160731 20:01:15 10 Field List view_table0_myisam_greek_0
|
160731 20:01:27 10 Field List view_table0_myisam_greek_1
|
160731 20:01:39 10 Field List view_table0_myisam_greek_2
|
160731 20:01:52 10 Field List view_table0_myisam_hebrew_0
|
160731 20:02:04 10 Field List view_table0_myisam_hebrew_1
|
160731 20:02:17 10 Field List view_table0_myisam_hebrew_2
|
160731 20:02:30 10 Field List view_table0_myisam_hp8_0
|
160731 20:02:42 10 Field List view_table0_myisam_hp8_1
|
160731 20:02:54 10 Field List view_table0_myisam_hp8_2
|
160731 20:03:06 10 Field List view_table0_myisam_keybcs2_0
|
160731 20:03:19 10 Field List view_table0_myisam_keybcs2_1
|
160731 20:03:32 10 Field List view_table0_myisam_keybcs2_2
|
160731 20:03:46 10 Field List view_table0_myisam_koi8r_0
|
160731 20:03:58 10 Field List view_table0_myisam_koi8r_1
|
160731 20:04:11 10 Field List view_table0_myisam_koi8r_2
|
160731 20:04:24 10 Field List view_table0_myisam_koi8u_0
|
160731 20:04:38 10 Field List view_table0_myisam_koi8u_1
|
160731 20:04:52 10 Field List view_table0_myisam_koi8u_2
|
160731 20:05:06 10 Field List view_table0_myisam_latin1_0
|
160731 20:05:21 10 Field List view_table0_myisam_latin1_1
|
160731 20:05:36 10 Field List view_table0_myisam_latin1_2
|
160731 20:05:51 10 Field List view_table0_myisam_latin2_0
|
160731 20:06:06 10 Field List view_table0_myisam_latin2_1
|
160731 20:06:21 10 Field List view_table0_myisam_latin2_2
|
160731 20:06:36 10 Field List view_table0_myisam_latin5_0
|
160731 20:06:52 10 Field List view_table0_myisam_latin5_1
|
160731 20:07:08 10 Field List view_table0_myisam_latin5_2
|
160731 20:07:24 10 Field List view_table0_myisam_latin7_0
|
160731 20:07:39 10 Field List view_table0_myisam_latin7_1
|
160731 20:07:54 10 Field List view_table0_myisam_latin7_2
|
160731 20:08:10 10 Field List view_table0_myisam_macce_0
|
160731 20:08:24 10 Field List view_table0_myisam_macce_1
|
160731 20:08:38 10 Field List view_table0_myisam_macce_2
|
160731 20:08:53 10 Field List view_table0_myisam_macroman_0
|
160731 20:09:08 10 Field List view_table0_myisam_macroman_1
|
160731 20:09:23 10 Field List view_table0_myisam_macroman_2
|
160731 20:09:38 10 Field List view_table0_myisam_sjis_0
|
160731 20:09:52 10 Field List view_table0_myisam_sjis_1
|
160731 20:10:06 10 Field List view_table0_myisam_sjis_2
|
160731 20:10:20 10 Field List view_table0_myisam_swe7_0
|
160731 20:10:35 10 Field List view_table0_myisam_swe7_1
|
160731 20:10:49 10 Field List view_table0_myisam_swe7_2
|
160731 20:11:04 10 Field List view_table0_myisam_tis620_0
|
160731 20:11:19 10 Field List view_table0_myisam_tis620_1
|
160731 20:11:33 10 Field List view_table0_myisam_tis620_2
|
160731 20:11:48 10 Field List view_table0_myisam_ucs2_0
|
160731 20:12:02 10 Field List view_table0_myisam_ucs2_1
|
160731 20:12:17 10 Field List view_table0_myisam_ucs2_2
|
160731 20:12:32 10 Field List view_table0_myisam_ujis_0
|
160731 20:12:47 10 Field List view_table0_myisam_ujis_1
|
160731 20:13:03 10 Field List view_table0_myisam_ujis_2
|
160731 20:13:18 10 Field List view_table0_myisam_utf16_0
|
160731 20:13:33 10 Field List view_table0_myisam_utf16_1
|
160731 20:13:49 10 Field List view_table0_myisam_utf16_2
|
160731 20:14:06 10 Field List view_table0_myisam_utf16le_0
|
160731 20:14:25 10 Field List view_table0_myisam_utf16le_1
|
160731 20:14:45 10 Field List view_table0_myisam_utf16le_2
|
160731 20:15:04 10 Field List view_table0_myisam_utf32_0
|
160731 20:15:21 10 Field List view_table0_myisam_utf32_1
|
160731 20:15:39 10 Field List view_table0_myisam_utf32_2
|
160731 20:15:56 10 Field List view_table0_myisam_utf8_0
|
160731 20:16:14 10 Field List view_table0_myisam_utf8_1
|
...
|
160731 20:16:31 10 Field List view_table0_myisam_utf8_2
|
160731 20:16:49 10 Field List view_table0_myisam_utf8mb4_0
|
160731 20:17:07 10 Field List view_table0_myisam_utf8mb4_1
|
160731 20:17:25 10 Field List view_table0_myisam_utf8mb4_2
|
160731 20:17:43 10 Query select @@version_comment limit 1
|
All versions of MariaDB and MySQL that I tried are affected. I assume it's "by design", but wonder if this design can be improved.
I've set it to upstream, but I'm not planning to file it to MySQL – even if it's not filed yet, which is difficult to believe, I don't think a request like that coming from us will be honored.