← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Brian Aker
  • Date: 2010-10-09 00:49:33 UTC
  • mfrom: (1812.5.8 staging)
  • Revision ID: brian@tangent.org-20101009004933-tehugnkubtzp6uy4
Merge in changes for show create table.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/logging_stats/tests/r/command.result
30
30
#
31
31
SELECT * FROM data_dictionary.SESSION_STATEMENTS;
32
32
VARIABLE_NAME   VARIABLE_VALUE
33
 
select  2
 
33
select  3
34
34
create_table    2
35
35
create_index    0
36
36
alter_table     1
41
41
truncate        0
42
42
drop_table      3
43
43
drop_index      0
44
 
show_create     1
 
44
show_create     0
45
45
show_create_db  0
46
46
load    0
47
47
set_option      1
72
72
INSERT INTO b VALUES (2);
73
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
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
 
75
root    4       1       0       3       1       1       2       1       3       0
76
76
root    0       0       0       1       0       0       1       0       0       0
77
77
drizzle 0       0       0       1       0       0       0       0       0       0
78
78
SELECT SCOREBOARD_SIZE, NUMBER_OF_RANGE_LOCKS, MAX_USERS_LOGGED FROM DATA_DICTIONARY.SCOREBOARD_STATISTICS;