4
4
GLOBAL_STATUS CREATE TABLE `GLOBAL_STATUS` (
5
5
`VARIABLE_NAME` VARCHAR(256) NOT NULL,
6
6
`VARIABLE_VALUE` VARCHAR(1024) NOT NULL
7
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
7
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER SYSTEM
8
8
show create table GLOBAL_VARIABLES ;
10
10
GLOBAL_VARIABLES CREATE TABLE `GLOBAL_VARIABLES` (
11
11
`VARIABLE_NAME` VARCHAR(256) NOT NULL,
12
12
`VARIABLE_VALUE` VARCHAR(1024) NOT NULL
13
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
13
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER SYSTEM
14
14
show create table SESSION_STATUS;
16
16
SESSION_STATUS CREATE TABLE `SESSION_STATUS` (
17
17
`VARIABLE_NAME` VARCHAR(256) NOT NULL,
18
18
`VARIABLE_VALUE` VARCHAR(1024) NOT NULL
19
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
19
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER SYSTEM
20
20
show create table SESSION_VARIABLES;
22
22
SESSION_VARIABLES CREATE TABLE `SESSION_VARIABLES` (
23
23
`VARIABLE_NAME` VARCHAR(256) NOT NULL,
24
24
`VARIABLE_VALUE` VARCHAR(1024) NOT NULL
25
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
25
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER SYSTEM
26
26
SELECT count(*) FROM data_dictionary.GLOBAL_STATUS;