[MDEV-10443] Building completion hash is extremely slow when the schema has many columns Created: 2016-07-26  Updated: 2016-07-31

Status: Open
Project: MariaDB Server
Component/s: Scripts & Clients
Affects Version/s: 5.5, 10.0, 10.1
Fix Version/s: 10.2

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: upstream

Attachments: File mdev10443.dump.gz    

 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.


Generated at Thu Feb 08 07:42:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.