1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
DROP TABLE IF EXISTS a;
CREATE TABLE a (i int, PRIMARY KEY (i));
ALTER TABLE a ADD COLUMN j int;
SELECT * FROM DATA_DICTIONARY.SQL_COMMANDS_BY_USER;
USER IP COUNT_SELECT COUNT_DELETE COUNT_UPDATE COUNT_INSERT COUNT_ROLLBACK COUNT_COMMIT COUNT_CREATE COUNT_ALTER COUNT_DROP COUNT_ADMIN
root 127.0.0.1 0 0 0 0 0 0 1 1 1 0
DROP TABLE IF EXISTS A;
CREATE TABLE a (i int, PRIMARY KEY (i));
INSERT INTO a VALUES (1);
DELETE FROM a WHERE i=1;
SELECT * FROM DATA_DICTIONARY.SQL_COMMANDS_BY_USER;
USER IP COUNT_SELECT COUNT_DELETE COUNT_UPDATE COUNT_INSERT COUNT_ROLLBACK COUNT_COMMIT COUNT_CREATE COUNT_ALTER COUNT_DROP COUNT_ADMIN
root 127.0.0.1 1 1 0 1 0 0 2 1 2 0
DROP TABLE IF EXISTS A;
CREATE TABLE a (i int, PRIMARY KEY (i));
DROP TABLE a;
SELECT * FROM DATA_DICTIONARY.SQL_COMMANDS_BY_USER;
USER IP COUNT_SELECT COUNT_DELETE COUNT_UPDATE COUNT_INSERT COUNT_ROLLBACK COUNT_COMMIT COUNT_CREATE COUNT_ALTER COUNT_DROP COUNT_ADMIN
root 127.0.0.1 2 1 0 1 0 0 3 1 4 0
set global logging_stats_enable=false;
SELECT * FROM DATA_DICTIONARY.SQL_COMMANDS_BY_USER;
USER IP 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;
|