2
show create table GLOBAL_STATUS ;
4
GLOBAL_STATUS CREATE TABLE `global_status` (
5
`VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '',
6
`VARIABLE_VALUE` varchar(1024) NOT NULL DEFAULT ''
7
) ENGINE=FunctionEngine
8
show create table GLOBAL_STATEMENTS ;
10
GLOBAL_STATEMENTS CREATE TABLE `global_statements` (
11
`VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '',
12
`VARIABLE_VALUE` varchar(1024) NOT NULL DEFAULT ''
13
) ENGINE=FunctionEngine
14
show create table GLOBAL_VARIABLES ;
16
GLOBAL_VARIABLES CREATE TABLE `global_variables` (
17
`VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '',
18
`VARIABLE_VALUE` varchar(1024) NOT NULL DEFAULT ''
19
) ENGINE=FunctionEngine
20
show create table SESSION_STATEMENTS;
22
SESSION_STATEMENTS CREATE TABLE `session_statements` (
23
`VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '',
24
`VARIABLE_VALUE` varchar(1024) NOT NULL DEFAULT ''
25
) ENGINE=FunctionEngine
26
show create table SESSION_STATUS;
28
SESSION_STATUS CREATE TABLE `session_status` (
29
`VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '',
30
`VARIABLE_VALUE` varchar(1024) NOT NULL DEFAULT ''
31
) ENGINE=FunctionEngine
32
show create table SESSION_VARIABLES;
34
SESSION_VARIABLES CREATE TABLE `session_variables` (
35
`VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '',
36
`VARIABLE_VALUE` varchar(1024) NOT NULL DEFAULT ''
37
) ENGINE=FunctionEngine
38
SELECT count(*) FROM data_dictionary.GLOBAL_STATEMENTS;
41
SELECT count(*) FROM data_dictionary.GLOBAL_STATUS;
44
SELECT count(*) FROM data_dictionary.GLOBAL_VARIABLES;
47
SELECT count(*) FROM data_dictionary.SESSION_STATEMENTS;
50
SELECT count(*) FROM data_dictionary.SESSION_STATUS;
53
SELECT count(*) FROM data_dictionary.SESSION_VARIABLES;
56
CREATE SCHEMA drizzleslap;
57
DROP SCHEMA drizzleslap;