← Back to branch summary

~vkolesnikov/pbxt/pbxt-preload-test-bug

« back to all changes in this revision

Viewing changes to pbxt/mysql-test-update/mysql-test/r/events_logs_tests.result

  • Committer: paul-mccullagh
  • Date: 2008-03-10 11:36:34 UTC
  • Revision ID: paul-mccullagh-417ebf175a9c8ee6e5b3777d9e2398e1fb197391
Implemented full durability

Show diffs side-by-side

added added

removed removed

Lines of Context:
pbxt/mysql-test-update/mysql-test/r/events_logs_tests.result
32
32
SET @old_session_long_query_time:=@@long_query_time;
33
33
SHOW VARIABLES LIKE 'log_slow_queries';
34
34
Variable_name   Value
35
 
log_slow_queries        OFF
 
35
log_slow_queries        ON
36
36
DROP FUNCTION get_value;
37
37
"Make it quite long"
38
38
SET SESSION long_query_time=300;
48
48
0
49
49
SELECT user_host, query_time, db, sql_text FROM mysql.slow_log;
50
50
user_host       query_time      db      sql_text
 
51
USER_HOST       SLEEPVAL        events_test     SELECT SLEEP(2)
51
52
SET SESSION long_query_time=300;
52
53
"Make it quite long"
53
54
TRUNCATE mysql.slow_log;
87
88
"Check slow log. Should see 1 row because 4 is over the threshold of 3 for GLOBAL, though under SESSION which is 10"
88
89
SELECT user_host, query_time, db, sql_text FROM mysql.slow_log;
89
90
user_host       query_time      db      sql_text
 
91
USER_HOST       SLEEPVAL        events_test     INSERT INTO slow_event_test SELECT @@long_query_time, SLEEP(2)
90
92
DROP EVENT long_event2;
91
93
"Make it quite long"
92
94
SET SESSION long_query_time=300;