3
3
AND table_name LIKE 'falcon_%'
4
4
ORDER BY table_schema, table_name, column_name;
5
5
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT STORAGE FORMAT
6
NULL information_schema FALCON_DATABASE_IO BUFFERS 3 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
7
NULL information_schema FALCON_DATABASE_IO FAKES 7 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
8
NULL information_schema FALCON_DATABASE_IO LOGICAL_READS 6 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
9
NULL information_schema FALCON_DATABASE_IO PAGE_SIZE 2 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
10
NULL information_schema FALCON_DATABASE_IO PHYSICAL_READS 4 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
11
NULL information_schema FALCON_DATABASE_IO TABLESPACE 1 NO varchar 120 480 NULL NULL utf8 utf8_general_ci varchar(120) select Default Default
12
NULL information_schema FALCON_DATABASE_IO WRITES 5 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
13
6
NULL information_schema FALCON_RECORD_CACHE_DETAIL FILE 1 NO varchar 120 480 NULL NULL utf8 utf8_general_ci varchar(120) select Default Default
14
7
NULL information_schema FALCON_RECORD_CACHE_DETAIL LINE 2 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
15
8
NULL information_schema FALCON_RECORD_CACHE_DETAIL OBJECTS_DELETED 5 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
22
15
NULL information_schema FALCON_RECORD_CACHE_SUMMARY SMALL_HUNKS 5 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
23
16
NULL information_schema FALCON_RECORD_CACHE_SUMMARY TOTAL_SPACE 1 0 NO bigint NULL NULL 19 0 NULL NULL bigint(4) select Default Default
24
17
NULL information_schema FALCON_RECORD_CACHE_SUMMARY UNIQUE_SIZES 6 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
25
NULL information_schema FALCON_SERIAL_LOG_INFO BLOCKS 3 0 NO bigint NULL NULL 19 0 NULL NULL bigint(8) select Default Default
26
NULL information_schema FALCON_SERIAL_LOG_INFO BUFFERS 5 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
27
NULL information_schema FALCON_SERIAL_LOG_INFO DATABASE 1 NO varchar 120 480 NULL NULL utf8 utf8_general_ci varchar(120) select Default Default
28
NULL information_schema FALCON_SERIAL_LOG_INFO TRANSACTIONS 2 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
29
NULL information_schema FALCON_SERIAL_LOG_INFO WINDOWS 4 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
18
NULL information_schema FALCON_SERIAL_LOG_INFO BLOCKS 2 0 NO bigint NULL NULL 19 0 NULL NULL bigint(8) select Default Default
19
NULL information_schema FALCON_SERIAL_LOG_INFO BUFFERS 4 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
20
NULL information_schema FALCON_SERIAL_LOG_INFO TRANSACTIONS 1 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
21
NULL information_schema FALCON_SERIAL_LOG_INFO WINDOWS 3 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
30
22
NULL information_schema FALCON_SYNCOBJECTS CALLER 1 NO varchar 120 480 NULL NULL utf8 utf8_general_ci varchar(120) select Default Default
31
23
NULL information_schema FALCON_SYNCOBJECTS EXCLUSIVE 3 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
32
24
NULL information_schema FALCON_SYNCOBJECTS QUEUE_LENGTH 5 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
49
41
NULL information_schema FALCON_TABLES SCHEMA_NAME 1 NO varchar 127 508 NULL NULL utf8 utf8_general_ci varchar(127) select Default Default
50
42
NULL information_schema FALCON_TABLES TABLESPACE 4 NO varchar 127 508 NULL NULL utf8 utf8_general_ci varchar(127) select Default Default
51
43
NULL information_schema FALCON_TABLES TABLE_NAME 2 NO varchar 127 508 NULL NULL utf8 utf8_general_ci varchar(127) select Default Default
52
NULL information_schema FALCON_TRANSACTIONS DATABASE 1 NO varchar 120 480 NULL NULL utf8 utf8_general_ci varchar(120) select Default Default
53
NULL information_schema FALCON_TRANSACTIONS DEP 7 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
44
NULL information_schema FALCON_TABLESPACES COMMENT 3 NO varchar 127 508 NULL NULL utf8 utf8_general_ci varchar(127) select Default Default
45
NULL information_schema FALCON_TABLESPACES TABLESPACE_NAME 1 NO varchar 127 508 NULL NULL utf8 utf8_general_ci varchar(127) select Default Default
46
NULL information_schema FALCON_TABLESPACES TYPE 2 NO varchar 127 508 NULL NULL utf8 utf8_general_ci varchar(127) select Default Default
47
NULL information_schema FALCON_TABLESPACE_FILES FILE_ID 3 0 NO int NULL NULL 10 0 NULL NULL int(127) select Default Default
48
NULL information_schema FALCON_TABLESPACE_FILES FILE_NAME 4 NO varchar 127 508 NULL NULL utf8 utf8_general_ci varchar(127) select Default Default
49
NULL information_schema FALCON_TABLESPACE_FILES TABLESPACE_NAME 1 NO varchar 127 508 NULL NULL utf8 utf8_general_ci varchar(127) select Default Default
50
NULL information_schema FALCON_TABLESPACE_FILES TYPE 2 NO varchar 127 508 NULL NULL utf8 utf8_general_ci varchar(127) select Default Default
51
NULL information_schema FALCON_TABLESPACE_IO BUFFERS 3 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
52
NULL information_schema FALCON_TABLESPACE_IO FAKES 7 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
53
NULL information_schema FALCON_TABLESPACE_IO LOGICAL_READS 6 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
54
NULL information_schema FALCON_TABLESPACE_IO PAGE_SIZE 2 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
55
NULL information_schema FALCON_TABLESPACE_IO PHYSICAL_READS 4 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
56
NULL information_schema FALCON_TABLESPACE_IO TABLESPACE 1 NO varchar 120 480 NULL NULL utf8 utf8_general_ci varchar(120) select Default Default
57
NULL information_schema FALCON_TABLESPACE_IO WRITES 5 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
58
NULL information_schema FALCON_TRANSACTIONS DEP 6 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
54
59
NULL information_schema FALCON_TRANSACTIONS ID 3 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
55
NULL information_schema FALCON_TRANSACTIONS OLDEST 8 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
56
NULL information_schema FALCON_TRANSACTIONS PENDING 6 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
57
NULL information_schema FALCON_TRANSACTIONS RECORDS 9 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
58
NULL information_schema FALCON_TRANSACTIONS STATE 4 NO varchar 10 40 NULL NULL utf8 utf8_general_ci varchar(10) select Default Default
59
NULL information_schema FALCON_TRANSACTIONS STATEMENT 11 NO varchar 120 480 NULL NULL utf8 utf8_general_ci varchar(120) select Default Default
60
NULL information_schema FALCON_TRANSACTIONS OLDEST 7 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
61
NULL information_schema FALCON_TRANSACTIONS PENDING 5 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
62
NULL information_schema FALCON_TRANSACTIONS RECORDS 8 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
63
NULL information_schema FALCON_TRANSACTIONS STATE 1 NO varchar 120 480 NULL NULL utf8 utf8_general_ci varchar(120) select Default Default
64
NULL information_schema FALCON_TRANSACTIONS STATEMENT 10 NO varchar 120 480 NULL NULL utf8 utf8_general_ci varchar(120) select Default Default
60
65
NULL information_schema FALCON_TRANSACTIONS THREAD_ID 2 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
61
NULL information_schema FALCON_TRANSACTIONS UPDATES 5 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
62
NULL information_schema FALCON_TRANSACTIONS WAITING_FOR 10 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
63
NULL information_schema FALCON_TRANSACTION_SUMMARY ACTIVE 4 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
64
NULL information_schema FALCON_TRANSACTION_SUMMARY COMMITTED 2 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
65
NULL information_schema FALCON_TRANSACTION_SUMMARY DATABASE 1 NO varchar 120 480 NULL NULL utf8 utf8_general_ci varchar(120) select Default Default
66
NULL information_schema FALCON_TRANSACTION_SUMMARY PENDING_COMMIT 5 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
67
NULL information_schema FALCON_TRANSACTION_SUMMARY PENDING_COMPLETION 6 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
68
NULL information_schema FALCON_TRANSACTION_SUMMARY ROLLED_BACK 3 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
66
NULL information_schema FALCON_TRANSACTIONS UPDATES 4 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
67
NULL information_schema FALCON_TRANSACTIONS WAITING_FOR 9 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
68
NULL information_schema FALCON_TRANSACTION_SUMMARY ACTIVE 3 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
69
NULL information_schema FALCON_TRANSACTION_SUMMARY COMMITTED 1 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
70
NULL information_schema FALCON_TRANSACTION_SUMMARY PENDING_COMMIT 4 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
71
NULL information_schema FALCON_TRANSACTION_SUMMARY PENDING_COMPLETION 5 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
72
NULL information_schema FALCON_TRANSACTION_SUMMARY ROLLED_BACK 2 0 NO int NULL NULL 10 0 NULL NULL int(4) select Default Default
69
73
NULL information_schema FALCON_VERSION Date 2 NO varchar 32 128 NULL NULL utf8 utf8_general_ci varchar(32) select Default Default
70
74
NULL information_schema FALCON_VERSION Version 1 NO varchar 32 128 NULL NULL utf8 utf8_general_ci varchar(32) select Default Default
71
75
##########################################################################
124
128
AND table_name LIKE 'falcon_%'
125
129
ORDER BY TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION;
126
130
COL_CML TABLE_SCHEMA TABLE_NAME COLUMN_NAME DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE
127
4.0000 information_schema FALCON_DATABASE_IO TABLESPACE varchar 120 480 utf8 utf8_general_ci varchar(120)
128
NULL information_schema FALCON_DATABASE_IO PAGE_SIZE int NULL NULL NULL NULL int(4)
129
NULL information_schema FALCON_DATABASE_IO BUFFERS int NULL NULL NULL NULL int(4)
130
NULL information_schema FALCON_DATABASE_IO PHYSICAL_READS int NULL NULL NULL NULL int(4)
131
NULL information_schema FALCON_DATABASE_IO WRITES int NULL NULL NULL NULL int(4)
132
NULL information_schema FALCON_DATABASE_IO LOGICAL_READS int NULL NULL NULL NULL int(4)
133
NULL information_schema FALCON_DATABASE_IO FAKES int NULL NULL NULL NULL int(4)
134
131
4.0000 information_schema FALCON_RECORD_CACHE_DETAIL FILE varchar 120 480 utf8 utf8_general_ci varchar(120)
135
132
NULL information_schema FALCON_RECORD_CACHE_DETAIL LINE int NULL NULL NULL NULL int(4)
136
133
NULL information_schema FALCON_RECORD_CACHE_DETAIL OBJECTS_IN_USE int NULL NULL NULL NULL int(4)
170
166
4.0000 information_schema FALCON_TABLES PARTITION varchar 127 508 utf8 utf8_general_ci varchar(127)
171
167
4.0000 information_schema FALCON_TABLES TABLESPACE varchar 127 508 utf8 utf8_general_ci varchar(127)
172
168
4.0000 information_schema FALCON_TABLES INTERNAL_NAME varchar 127 508 utf8 utf8_general_ci varchar(127)
173
4.0000 information_schema FALCON_TRANSACTIONS DATABASE varchar 120 480 utf8 utf8_general_ci varchar(120)
169
4.0000 information_schema FALCON_TABLESPACES TABLESPACE_NAME varchar 127 508 utf8 utf8_general_ci varchar(127)
170
4.0000 information_schema FALCON_TABLESPACES TYPE varchar 127 508 utf8 utf8_general_ci varchar(127)
171
4.0000 information_schema FALCON_TABLESPACES COMMENT varchar 127 508 utf8 utf8_general_ci varchar(127)
172
4.0000 information_schema FALCON_TABLESPACE_FILES TABLESPACE_NAME varchar 127 508 utf8 utf8_general_ci varchar(127)
173
4.0000 information_schema FALCON_TABLESPACE_FILES TYPE varchar 127 508 utf8 utf8_general_ci varchar(127)
174
NULL information_schema FALCON_TABLESPACE_FILES FILE_ID int NULL NULL NULL NULL int(127)
175
4.0000 information_schema FALCON_TABLESPACE_FILES FILE_NAME varchar 127 508 utf8 utf8_general_ci varchar(127)
176
4.0000 information_schema FALCON_TABLESPACE_IO TABLESPACE varchar 120 480 utf8 utf8_general_ci varchar(120)
177
NULL information_schema FALCON_TABLESPACE_IO PAGE_SIZE int NULL NULL NULL NULL int(4)
178
NULL information_schema FALCON_TABLESPACE_IO BUFFERS int NULL NULL NULL NULL int(4)
179
NULL information_schema FALCON_TABLESPACE_IO PHYSICAL_READS int NULL NULL NULL NULL int(4)
180
NULL information_schema FALCON_TABLESPACE_IO WRITES int NULL NULL NULL NULL int(4)
181
NULL information_schema FALCON_TABLESPACE_IO LOGICAL_READS int NULL NULL NULL NULL int(4)
182
NULL information_schema FALCON_TABLESPACE_IO FAKES int NULL NULL NULL NULL int(4)
183
4.0000 information_schema FALCON_TRANSACTIONS STATE varchar 120 480 utf8 utf8_general_ci varchar(120)
174
184
NULL information_schema FALCON_TRANSACTIONS THREAD_ID int NULL NULL NULL NULL int(4)
175
185
NULL information_schema FALCON_TRANSACTIONS ID int NULL NULL NULL NULL int(4)
176
4.0000 information_schema FALCON_TRANSACTIONS STATE varchar 10 40 utf8 utf8_general_ci varchar(10)
177
186
NULL information_schema FALCON_TRANSACTIONS UPDATES int NULL NULL NULL NULL int(4)
178
187
NULL information_schema FALCON_TRANSACTIONS PENDING int NULL NULL NULL NULL int(4)
179
188
NULL information_schema FALCON_TRANSACTIONS DEP int NULL NULL NULL NULL int(4)