← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

Viewing changes to plugin/logging_stats/tests/r/command.result

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2010-10-02 14:17:48 UTC
  • mfrom: (1.1.1 upstream)
  • mto: (2.1.17 sid)
  • mto: This revision was merged to the branch mainline in revision 3.
  • Revision ID: james.westby@ubuntu.com-20101002141748-m6vbfbfjhrw1153e
Tags: 2010.09.1802-1
* New upstream release.
* Removed pid-file argument hack.
* Updated GPL-2 address to be new address.
* Directly copy in drizzledump.1 since debian doesn't have sphinx 1.0 yet.
* Link to jquery from libjs-jquery. Add it as a depend.
* Add drizzled.8 symlink to the install files.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/logging_stats/tests/r/command.result
 
1
DROP TABLE IF EXISTS a;
 
2
DROP TABLE IF EXISTS b;
 
3
CREATE TABLE a (i int,  PRIMARY KEY (i));
 
4
ALTER TABLE a ADD COLUMN j int;
 
5
DROP TABLE A;
 
6
CREATE TABLE a (i int,  PRIMARY KEY (i));
 
7
INSERT INTO a VALUES (1);
 
8
DELETE FROM a WHERE i=1;
 
9
START TRANSACTION;
 
10
INSERT INTO a VALUES (1);
 
11
ROLLBACK;
 
12
START TRANSACTION;
 
13
INSERT INTO a VALUES (1);
 
14
COMMIT;
 
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;
 
16
USER    COUNT_SELECT    COUNT_DELETE    COUNT_UPDATE    COUNT_INSERT    COUNT_ROLLBACK  COUNT_COMMIT    COUNT_CREATE    COUNT_ALTER     COUNT_DROP      COUNT_ADMIN
 
17
root    0       1       0       3       1       1       2       1       3       0
 
18
set global logging_stats_enable=false;
 
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;
 
20
USER    COUNT_SELECT    COUNT_DELETE    COUNT_UPDATE    COUNT_INSERT    COUNT_ROLLBACK  COUNT_COMMIT    COUNT_CREATE    COUNT_ALTER     COUNT_DROP      COUNT_ADMIN
 
21
set global logging_stats_enable=true;
 
22
SHOW CREATE TABLE data_dictionary.SESSION_STATEMENTS;
 
23
Table   Create Table
 
24
SESSION_STATEMENTS      CREATE TABLE `SESSION_STATEMENTS` (
 
25
  `VARIABLE_NAME` VARCHAR(256) NOT NULL,
 
26
  `VARIABLE_VALUE` VARCHAR(1024) NOT NULL
 
27
) ENGINE=FunctionEngine COLLATE = utf8_general_ci
 
28
SELECT count(*) FROM data_dictionary.SESSION_STATEMENTS;
 
29
count(*)
 
30
#
 
31
SELECT * FROM data_dictionary.SESSION_STATEMENTS;
 
32
VARIABLE_NAME   VARIABLE_VALUE
 
33
select  2
 
34
create_table    2
 
35
create_index    0
 
36
alter_table     1
 
37
update  0
 
38
insert  3
 
39
insert_select   0
 
40
delete  1
 
41
truncate        0
 
42
drop_table      3
 
43
drop_index      0
 
44
show_create     1
 
45
show_create_db  0
 
46
load    0
 
47
set_option      1
 
48
unlock_tables   0
 
49
change_db       0
 
50
create_db       0
 
51
drop_db 0
 
52
alter_db        0
 
53
replace 0
 
54
replace_select  0
 
55
check   0
 
56
flush   0
 
57
kill    0
 
58
analyze 0
 
59
rollback        1
 
60
rollback_to_savepoint   0
 
61
commit  1
 
62
savepoint       0
 
63
release_savepoint       0
 
64
begin   2
 
65
rename_table    0
 
66
show_warns      0
 
67
empty_query     0
 
68
show_errors     0
 
69
checksum        0
 
70
CREATE TABLE b (i int,  PRIMARY KEY (i));
 
71
INSERT INTO b VALUES (1);
 
72
INSERT INTO b VALUES (2);
 
73
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;
 
74
USER    COUNT_SELECT    COUNT_DELETE    COUNT_UPDATE    COUNT_INSERT    COUNT_ROLLBACK  COUNT_COMMIT    COUNT_CREATE    COUNT_ALTER     COUNT_DROP      COUNT_ADMIN
 
75
root    3       1       0       3       1       1       2       1       3       0
 
76
root    0       0       0       1       0       0       1       0       0       0
 
77
drizzle 0       0       0       1       0       0       0       0       0       0
 
78
SELECT SCOREBOARD_SIZE, NUMBER_OF_RANGE_LOCKS, MAX_USERS_LOGGED FROM DATA_DICTIONARY.SCOREBOARD_STATISTICS;
 
79
SCOREBOARD_SIZE NUMBER_OF_RANGE_LOCKS   MAX_USERS_LOGGED
 
80
2000    10      503
 
81
DROP TABLE a,b;