Skip to content

Commit 9494307

Browse files
author
Sergey Vojtovich
committed
WL#6216 - Changes to Server defaults in 5.6
General changes: back_log, flush_time, join_buffer_size, max_allowed_packet, max_connect_errors, sql_mode.
1 parent 3f19402 commit 9494307

141 files changed

Lines changed: 706 additions & 736 deletions

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎mysql-test/include/linux_sys_vars.inc‎

Lines changed: 0 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -4,16 +4,8 @@
44

55
--disable_query_log
66

7-
SET @default_flush_time = 0;
8-
SET @min_flush_time = 0;
9-
#SET @max_flush_time = 0;
10-
117
SET @default_key_buffer_size = 131072;
128

13-
#SET @default_join_buffer_size = 131072;
14-
#SET @min_join_buffer_size = 8200;
15-
#SET @max_join_buffer_size = 4294967295;
16-
179
SET @default_max_join_size = 4294967295;
1810
SET @min_max_join_size = 1;
1911
SET @max_max_join_size = 4294967295;

‎mysql-test/include/windows_sys_vars.inc‎

Lines changed: 0 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -4,16 +4,8 @@
44

55
--disable_query_log
66

7-
SET @default_flush_time = 1800;
8-
SET @min_flush_time = 0;
9-
#SET @max_flush_time = 0;
10-
117
SET @default_key_buffer_size= 131072;
128

13-
#SET @default_join_buffer_size = 131072;
14-
#SET @min_join_buffer_size = 8200;
15-
#SET @max_join_buffer_size = 4294967295;
16-
179
SET @default_max_join_size = 4294967295;
1810
SET @min_max_join_size = 1;
1911
SET @max_max_join_size = 4294967295;

‎mysql-test/r/ctype_latin2_ch.result‎

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -249,7 +249,9 @@ Y
249249
z
250250
Z
251251
DROP TABLE t1;
252+
SET sql_mode='';
252253
CREATE TABLE t1 ENGINE=FALCON AS SELECT repeat('a', 5) AS s1 LIMIT 0;
254+
SET sql_mode=DEFAULT;
253255
INSERT INTO t1 VALUES ('x'),('y'),('z'),('X'),('Y'),('Z');
254256
SELECT * FROM t1 GROUP BY s1;
255257
s1
@@ -285,7 +287,9 @@ Y
285287
z
286288
Z
287289
DROP TABLE t1;
290+
SET sql_mode='';
288291
CREATE TABLE t1 ENGINE=MARIA AS SELECT repeat('a', 5) AS s1 LIMIT 0;
292+
SET sql_mode=DEFAULT;
289293
INSERT INTO t1 VALUES ('x'),('y'),('z'),('X'),('Y'),('Z');
290294
SELECT * FROM t1 GROUP BY s1;
291295
s1

‎mysql-test/r/ctype_utf16.result‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1131,7 +1131,7 @@ SELECT space(date_add(101, INTERVAL CHAR('1' USING utf16) hour_second));
11311131
space(date_add(101, INTERVAL CHAR('1' USING utf16) hour_second))
11321132
NULL
11331133
Warnings:
1134-
Warning 1301 Result of space() was larger than max_allowed_packet (1048576) - truncated
1134+
Warning 1301 Result of space() was larger than max_allowed_packet (4194304) - truncated
11351135
#
11361136
# Bug#11750518 41090: ORDER BY TRUNCATES GROUP_CONCAT RESULT
11371137
#

‎mysql-test/r/events_1.result‎

Lines changed: 19 additions & 19 deletions
Original file line numberDiff line numberDiff line change
@@ -124,80 +124,80 @@ set names utf8;
124124
CREATE EVENT root6 ON SCHEDULE EVERY '10:20' MINUTE_SECOND ON COMPLETION PRESERVE ENABLE COMMENT 'some comment' DO select 1;
125125
SHOW CREATE EVENT root6;
126126
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
127-
root6 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root6` ON SCHEDULE EVERY '10:20' MINUTE_SECOND STARTS '#' ON COMPLETION PRESERVE ENABLE COMMENT 'some comment' DO select 1 utf8 utf8_general_ci latin1_swedish_ci
127+
root6 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root6` ON SCHEDULE EVERY '10:20' MINUTE_SECOND STARTS '#' ON COMPLETION PRESERVE ENABLE COMMENT 'some comment' DO select 1 utf8 utf8_general_ci latin1_swedish_ci
128128
create event root7 on schedule every 2 year do select 1;
129129
SHOW CREATE EVENT root7;
130130
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
131-
root7 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root7` ON SCHEDULE EVERY 2 YEAR STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
131+
root7 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root7` ON SCHEDULE EVERY 2 YEAR STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
132132
create event root8 on schedule every '2:5' year_month do select 1;
133133
SHOW CREATE EVENT root8;
134134
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
135-
root8 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root8` ON SCHEDULE EVERY '2-5' YEAR_MONTH STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
135+
root8 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root8` ON SCHEDULE EVERY '2-5' YEAR_MONTH STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
136136
create event root8_1 on schedule every '2:15' year_month do select 1;
137137
SHOW CREATE EVENT root8_1;
138138
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
139-
root8_1 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root8_1` ON SCHEDULE EVERY '3-3' YEAR_MONTH STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
139+
root8_1 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root8_1` ON SCHEDULE EVERY '3-3' YEAR_MONTH STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
140140
create event root9 on schedule every 2 week ON COMPLETION PRESERVE DISABLE COMMENT 'коментар на кирилица' do select 1;
141141
SHOW CREATE EVENT root9;
142142
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
143-
root9 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root9` ON SCHEDULE EVERY 2 WEEK STARTS '#' ON COMPLETION PRESERVE DISABLE COMMENT 'коментар на кирилица' DO select 1 utf8 utf8_general_ci latin1_swedish_ci
143+
root9 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root9` ON SCHEDULE EVERY 2 WEEK STARTS '#' ON COMPLETION PRESERVE DISABLE COMMENT 'коментар на кирилица' DO select 1 utf8 utf8_general_ci latin1_swedish_ci
144144
create event root10 on schedule every '20:5' day_hour do select 1;
145145
SHOW CREATE EVENT root10;
146146
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
147-
root10 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root10` ON SCHEDULE EVERY '20 5' DAY_HOUR STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
147+
root10 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root10` ON SCHEDULE EVERY '20 5' DAY_HOUR STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
148148
create event root11 on schedule every '20:25' day_hour do select 1;
149149
SHOW CREATE EVENT root11;
150150
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
151-
root11 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root11` ON SCHEDULE EVERY '21 1' DAY_HOUR STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
151+
root11 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root11` ON SCHEDULE EVERY '21 1' DAY_HOUR STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
152152
create event root12 on schedule every '20:25' hour_minute do select 1;
153153
SHOW CREATE EVENT root12;
154154
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
155-
root12 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root12` ON SCHEDULE EVERY '20:25' HOUR_MINUTE STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
155+
root12 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root12` ON SCHEDULE EVERY '20:25' HOUR_MINUTE STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
156156
create event root13 on schedule every '25:25' hour_minute do select 1;
157157
SHOW CREATE EVENT root13;
158158
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
159-
root13 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root13` ON SCHEDULE EVERY '25:25' HOUR_MINUTE STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
159+
root13 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root13` ON SCHEDULE EVERY '25:25' HOUR_MINUTE STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
160160
create event root13_1 on schedule every '11:65' hour_minute do select 1;
161161
SHOW CREATE EVENT root13_1;
162162
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
163-
root13_1 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root13_1` ON SCHEDULE EVERY '12:5' HOUR_MINUTE STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
163+
root13_1 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root13_1` ON SCHEDULE EVERY '12:5' HOUR_MINUTE STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
164164
create event root14 on schedule every '35:35' minute_second do select 1;
165165
SHOW CREATE EVENT root14;
166166
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
167-
root14 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root14` ON SCHEDULE EVERY '35:35' MINUTE_SECOND STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
167+
root14 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root14` ON SCHEDULE EVERY '35:35' MINUTE_SECOND STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
168168
create event root15 on schedule every '35:66' minute_second do select 1;
169169
SHOW CREATE EVENT root15;
170170
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
171-
root15 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root15` ON SCHEDULE EVERY '36:6' MINUTE_SECOND STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
171+
root15 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root15` ON SCHEDULE EVERY '36:6' MINUTE_SECOND STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
172172
create event root16 on schedule every '35:56' day_minute do select 1;
173173
SHOW CREATE EVENT root16;
174174
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
175-
root16 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root16` ON SCHEDULE EVERY '1 11:56' DAY_MINUTE STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
175+
root16 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root16` ON SCHEDULE EVERY '1 11:56' DAY_MINUTE STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
176176
create event root17 on schedule every '35:12:45' day_minute do select 1;
177177
SHOW CREATE EVENT root17;
178178
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
179-
root17 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root17` ON SCHEDULE EVERY '35 12:45' DAY_MINUTE STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
179+
root17 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root17` ON SCHEDULE EVERY '35 12:45' DAY_MINUTE STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
180180
create event root17_1 on schedule every '35:25:65' day_minute do select 1;
181181
SHOW CREATE EVENT root17_1;
182182
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
183-
root17_1 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root17_1` ON SCHEDULE EVERY '36 2:5' DAY_MINUTE STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
183+
root17_1 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root17_1` ON SCHEDULE EVERY '36 2:5' DAY_MINUTE STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
184184
create event root18 on schedule every '35:12:45' hour_second do select 1;
185185
SHOW CREATE EVENT root18;
186186
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
187-
root18 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root18` ON SCHEDULE EVERY '35:12:45' HOUR_SECOND STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
187+
root18 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root18` ON SCHEDULE EVERY '35:12:45' HOUR_SECOND STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
188188
create event root19 on schedule every '15:59:85' hour_second do select 1;
189189
SHOW CREATE EVENT root19;
190190
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
191-
root19 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root19` ON SCHEDULE EVERY '16:0:25' HOUR_SECOND STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
191+
root19 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root19` ON SCHEDULE EVERY '16:0:25' HOUR_SECOND STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
192192
create event root20 on schedule every '50:20:12:45' day_second do select 1;
193193
SHOW CREATE EVENT root20;
194194
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
195-
root20 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root20` ON SCHEDULE EVERY '50 20:12:45' DAY_SECOND STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
195+
root20 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `root20` ON SCHEDULE EVERY '50 20:12:45' DAY_SECOND STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
196196
set names cp1251;
197197
create event ����21 on schedule every '50:23:59:95' day_second COMMENT '���� � 1251 ��������' do select 1;
198198
SHOW CREATE EVENT ����21;
199199
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
200-
����21 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `руут21` ON SCHEDULE EVERY '51 0:0:35' DAY_SECOND STARTS '#' ON COMPLETION NOT PRESERVE ENABLE COMMENT 'това е 1251 коментар' DO select 1 cp1251 cp1251_general_ci latin1_swedish_ci
200+
����21 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `руут21` ON SCHEDULE EVERY '51 0:0:35' DAY_SECOND STARTS '#' ON COMPLETION NOT PRESERVE ENABLE COMMENT 'това е 1251 коментар' DO select 1 cp1251 cp1251_general_ci latin1_swedish_ci
201201
insert into mysql.event (
202202
db,
203203
name,

‎mysql-test/r/events_2.result‎

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -128,7 +128,7 @@ create event e1 on schedule every 10 hour do select 1;
128128
lock table t1 read;
129129
show create event e1;
130130
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
131-
e1 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e1` ON SCHEDULE EVERY 10 HOUR STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
131+
e1 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e1` ON SCHEDULE EVERY 10 HOUR STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
132132
select event_name from information_schema.events;
133133
event_name
134134
e1
@@ -146,7 +146,7 @@ unlock tables;
146146
lock table t1 write;
147147
show create event e1;
148148
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
149-
e1 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e1` ON SCHEDULE EVERY 10 HOUR STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
149+
e1 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e1` ON SCHEDULE EVERY 10 HOUR STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
150150
select event_name from information_schema.events;
151151
event_name
152152
e1
@@ -164,7 +164,7 @@ unlock tables;
164164
lock table t1 read, mysql.event read;
165165
show create event e1;
166166
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
167-
e1 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e1` ON SCHEDULE EVERY 10 HOUR STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
167+
e1 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e1` ON SCHEDULE EVERY 10 HOUR STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
168168
select event_name from information_schema.events;
169169
event_name
170170
e1
@@ -182,7 +182,7 @@ unlock tables;
182182
lock table t1 write, mysql.event read;
183183
show create event e1;
184184
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
185-
e1 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e1` ON SCHEDULE EVERY 10 HOUR STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
185+
e1 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e1` ON SCHEDULE EVERY 10 HOUR STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
186186
select event_name from information_schema.events;
187187
event_name
188188
e1
@@ -204,7 +204,7 @@ ERROR HY000: You can't combine write-locking of system tables with other tables
204204
lock table mysql.event write;
205205
show create event e1;
206206
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
207-
e1 SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e1` ON SCHEDULE EVERY 10 HOUR STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
207+
e1 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `e1` ON SCHEDULE EVERY 10 HOUR STARTS '#' ON COMPLETION NOT PRESERVE ENABLE DO select 1 utf8 utf8_general_ci latin1_swedish_ci
208208
select event_name from information_schema.events;
209209
event_name
210210
e1

0 commit comments

Comments
 (0)