12
13
INSERT INTO a VALUES (1);
14
SELECT USER, COUNT_SELECT, COUNT_DELETE, COUNT_UPDATE, COUNT_INSERT, COUNT_ROLLBACK, COUNT_COMMIT, COUNT_CREATE, COUNT_ALTER, COUNT_DROP, COUNT_ADMIN FROM DATA_DICTIONARY.SQL_COMMANDS_BY_USER;
15
SELECT USER, 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;
15
16
USER COUNT_SELECT COUNT_DELETE COUNT_UPDATE COUNT_INSERT COUNT_ROLLBACK COUNT_COMMIT COUNT_CREATE COUNT_ALTER COUNT_DROP COUNT_ADMIN
16
root 0 1 0 3 1 1 2 1 2 0
17
root 0 1 0 3 1 1 2 1 3 0
17
18
set global logging_stats_enable=false;
18
SELECT USER, COUNT_SELECT, COUNT_DELETE, COUNT_UPDATE, COUNT_INSERT, COUNT_ROLLBACK, COUNT_COMMIT, COUNT_CREATE, COUNT_ALTER, COUNT_DROP, COUNT_ADMIN FROM DATA_DICTIONARY.SQL_COMMANDS_BY_USER;
19
SELECT USER, 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;
19
20
USER COUNT_SELECT COUNT_DELETE COUNT_UPDATE COUNT_INSERT COUNT_ROLLBACK COUNT_COMMIT COUNT_CREATE COUNT_ALTER COUNT_DROP COUNT_ADMIN
20
21
set global logging_stats_enable=true;
21
22
CREATE TABLE b (i int, PRIMARY KEY (i));
22
23
INSERT INTO b VALUES (1);
23
24
INSERT INTO b VALUES (2);
24
SELECT USER, COUNT_SELECT, COUNT_DELETE, COUNT_UPDATE, COUNT_INSERT, COUNT_ROLLBACK, COUNT_COMMIT, COUNT_CREATE, COUNT_ALTER, COUNT_DROP, COUNT_ADMIN FROM DATA_DICTIONARY.SQL_COMMANDS_BY_USER;
25
SELECT USER, 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;
25
26
USER COUNT_SELECT COUNT_DELETE COUNT_UPDATE COUNT_INSERT COUNT_ROLLBACK COUNT_COMMIT COUNT_CREATE COUNT_ALTER COUNT_DROP COUNT_ADMIN
26
root 1 1 0 3 1 1 2 1 2 0
27
root 1 1 0 3 1 1 2 1 3 0
27
28
root 0 0 0 1 0 0 1 0 0 0
28
29
drizzle 0 0 0 1 0 0 0 0 0 0