2
DROP TABLE IF EXISTS a;
3
DROP TABLE IF EXISTS b;
5
CREATE TABLE a (i int, PRIMARY KEY (i));
6
ALTER TABLE a ADD COLUMN j int;
8
CREATE TABLE a (i int, PRIMARY KEY (i));
9
INSERT INTO a VALUES (1);
10
DELETE FROM a WHERE i=1;
12
INSERT INTO a VALUES (1);
15
INSERT INTO a VALUES (1);
18
# The statistics are incremented after the statements have already returned
19
# so its possible a query could be missed if we do not wait
21
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;
24
set global logging_stats_enable=false;
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;
27
set global logging_stats_enable=true;
29
connect (con1, localhost, root,,);
30
CREATE TABLE b (i int, PRIMARY KEY (i));
31
INSERT INTO b VALUES (1);
32
connect (con2, localhost, drizzle,,);
33
INSERT INTO b VALUES (2);
36
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;