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
76
77
78
|
DROP TABLE IF EXISTS a;
DROP TABLE IF EXISTS b;
CREATE TABLE a (i int, PRIMARY KEY (i));
ALTER TABLE a ADD COLUMN j int;
DROP TABLE A;
CREATE TABLE a (i int, PRIMARY KEY (i));
INSERT INTO a VALUES (1);
DELETE FROM a WHERE i=1;
START TRANSACTION;
INSERT INTO a VALUES (1);
ROLLBACK;
START TRANSACTION;
INSERT INTO a VALUES (1);
COMMIT;
SELECT USERNAME, COUNT_SELECT, COUNT_DELETE, COUNT_UPDATE, COUNT_INSERT, COUNT_ROLLBACK, COUNT_COMMIT, COUNT_CREATE, COUNT_ALTER, COUNT_DROP, COUNT_ADMIN FROM DATA_DICTIONARY.CURRENT_SQL_COMMANDS WHERE USERNAME != "root";
USERNAME COUNT_SELECT COUNT_DELETE COUNT_UPDATE COUNT_INSERT COUNT_ROLLBACK COUNT_COMMIT COUNT_CREATE COUNT_ALTER COUNT_DROP COUNT_ADMIN
set global logging_stats_enable=false;
SELECT USERNAME, COUNT_SELECT, COUNT_DELETE, COUNT_UPDATE, COUNT_INSERT, COUNT_ROLLBACK, COUNT_COMMIT, COUNT_CREATE, COUNT_ALTER, COUNT_DROP, COUNT_ADMIN FROM DATA_DICTIONARY.CURRENT_SQL_COMMANDS WHERE USERNAME != "root";
USERNAME COUNT_SELECT COUNT_DELETE COUNT_UPDATE COUNT_INSERT COUNT_ROLLBACK COUNT_COMMIT COUNT_CREATE COUNT_ALTER COUNT_DROP COUNT_ADMIN
set global logging_stats_enable=true;
SHOW CREATE TABLE data_dictionary.SESSION_STATEMENTS;
Table Create Table
SESSION_STATEMENTS CREATE TABLE `SESSION_STATEMENTS` (
`VARIABLE_NAME` VARCHAR(256) NOT NULL,
`VARIABLE_VALUE` VARCHAR(1024) NOT NULL
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER SYSTEM
SELECT count(*) FROM data_dictionary.SESSION_STATEMENTS;
count(*)
#
SELECT * FROM data_dictionary.SESSION_STATEMENTS;
VARIABLE_NAME VARIABLE_VALUE
alter_db 0
alter_table 1
analyze 0
begin 2
change_db 0
check 0
checksum 0
commit 1
create_db 0
create_index 0
create_table 2
delete 1
drop_db 0
drop_index 0
drop_table 3
empty_query 0
flush 0
insert 3
insert_select 0
kill 0
load 0
release_savepoint 0
rename_table 0
replace 0
replace_select 0
rollback 1
rollback_to_savepoint 0
savepoint 0
select 4
set_option 1
show_create 0
show_create_db 0
show_errors 0
show_warns 0
truncate 0
unlock_tables 0
update 0
CREATE TABLE b (i int, PRIMARY KEY (i));
INSERT INTO b VALUES (1);
INSERT INTO b VALUES (2);
SELECT USERNAME, COUNT_SELECT, COUNT_DELETE, COUNT_UPDATE, COUNT_INSERT, COUNT_ROLLBACK, COUNT_COMMIT, COUNT_CREATE, COUNT_ALTER, COUNT_DROP, COUNT_ADMIN FROM DATA_DICTIONARY.CURRENT_SQL_COMMANDS WHERE USERNAME != "root";
USERNAME COUNT_SELECT COUNT_DELETE COUNT_UPDATE COUNT_INSERT COUNT_ROLLBACK COUNT_COMMIT COUNT_CREATE COUNT_ALTER COUNT_DROP COUNT_ADMIN
drizzle 0 0 0 1 0 0 0 0 0 0
SELECT SCOREBOARD_SIZE, NUMBER_OF_RANGE_LOCKS, MAX_USERS_LOGGED FROM DATA_DICTIONARY.SCOREBOARD_STATISTICS;
SCOREBOARD_SIZE NUMBER_OF_RANGE_LOCKS MAX_USERS_LOGGED
2000 10 503
DROP TABLE a,b;
|