1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
|
#####################################################################
#
# Author: Hema Sridharan
# Date: May 2009
#
# Purpose: Implementation of WL#4732: The test is intended to verify
# the interoperability of MySQL BACKUP / RESTORE operations with other
# server operations.
# This grammar file will execute server operations in parallel to BACKUP /
# RESTORE
#
# Associated files are:
# mysql-test/gentest/conf/backup_obj.yy
# mysql-test/gentest/conf/backup_interop.yy
# mysql-test/gentest/lib/Gentest/Reporter/BackupInterop.pm
#
#####################################################################
query:
server_operation ;
server_operation:
rotate_event | event_scheduler | sql_mode | character_set | engine |
time_zone | key_cache_size | key_buffer_size | binlog_format |
tx_isolation ;
rotate_event:
FLUSH LOGS | FLUSH TABLES | FLUSH PRIVILEGES ;
sql_mode:
SET SQL_MODE=' ' | SET SQL_MODE='TRADITIONAL' |
SET SQL_MODE='PIPES_AS_CONCAT' | SET SQL_MODE='ANSI_QUOTES' ;
tx_isolation:
SET GLOBAL TRANSACTION ISOLATION LEVEL READ UNCOMMITTED |
SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED |
SET GLOBAL TRANSACTION ISOLATION LEVEL REPEATABLE READ |
SET GLOBAL TRANSACTION ISOLATION LEVEL SERIALIZABLE ;
character_set:
SET CHARACTER_SET_CLIENT=cset | SET CHARACTER_SET_CONNECTION=cset |
SET CHARACTER_SET_DATABASE=cset | SET CHARACTER_SET_FILESYSTEM=cset |
SET CHARACTER_SET_RESULTS=cset | SET CHARACTER_SET_SERVER=cset |
SET COLLATION_CONNECTION=coll | SET COLLATION_DATABASE=coll |
SET COLLATION_SERVER=coll ;
cset: LATIN1 | LATIN2 | LATIN5 | LATIN7 | SWE7 | BIG5 | EUCJPMS |
GB2312 | ARMSCII8 | CP932 | UTF8 ;
coll: LATIN1_SWEDISH_CI | LATIN2_GENERAL_CI | LATIN5_TURKISH_CI |
LATIN7_GENERAL_CI | SWE7_SWEDISH_CI | BIG5_CHINESE_CI |
EUCJPMS_JAPANESE_CI | GB2312_CHINESE_CI | ARMSCII8_GENERAL_CI |
CP932_JAPANESE_CI | UTF8_SPANISH_CI ;
engine: SET STORAGE_ENGINE=storage_engine ;
storage_engine: Myisam | Innodb ;
time_zone: SET TIME_ZONE=time ;
time: 'UTC' | 'Universal' | 'Europe/Moscow' | 'Japan' ;
key_buffer_size: SET GLOBAL KEY_BUFFER_SIZE=0 |
SET GLOBAL KEY_BUFFER_SIZE=400000 ;
key_cache_size: SET GLOBAL QUERY_CACHE_SIZE=1600000 |
SET GLOBAL QUERY_CACHE_SIZE=4198490 ;
event_scheduler: SET GLOBAL EVENT_SCHEDULER=ON |
SET GLOBAL EVENT_SCHEDULER=OFF ;
binlog_format: SET GLOBAL BINLOG_FORMAT = ROW |
SET GLOBAL BINLOG_FORMAT = STATEMENT |
SET GLOBAL BINLOG_FORMAT = MIXED ;
|