Debian Codegraph @

mysql-test/suite/test_service_sql_api/r/test_session_general_log.result

raw
1 # Setting general_log to initial state empty
2 TRUNCATE TABLE mysql.general_log;
3 SET @old_log_output = @@global.log_output;
4 SET @old_general_log = @@global.general_log;
5 SET @old_general_log_file = @@global.general_log_file;
6 ##########################################
7 # Start plugin with general log
8 ##########################################
9 SET GLOBAL general_log_file = '.../log/test_session_general.log';
10 SET GLOBAL log_output = 'FILE,TABLE';
11 SET GLOBAL general_log = 'ON';
12 ##########################################
13 # Run plugin
14 ##########################################
15 INSTALL PLUGIN test_session_in_thd SONAME 'TEST_SESSION_IN_THD';
16 SELECT plugin_name FROM information_schema.plugins WHERE plugin_name LIKE 'test_session_in_thd';
17 plugin_name
18 test_session_in_thd
19 ##########################################
20 # Stop plugin
21 ##########################################
22 UNINSTALL PLUGIN test_session_in_thd;
23 ##########################################
24 # Plugin log
25 ##########################################
26 Follows threaded run
27 ============================================================================================
28 init thread
29 sql open session 0.
30 sql open session 1.
31 sql open session 2.
32 sql open session 3.
33 sql open session 4.
34 sql open session 5.
35 sql open session 6.
36 sql open session 7.
37 sql open session 8.
38 close following nb of sessions: 9
39 sql session close session 8.
40 sql session close session 7.
41 sql session close session 6.
42 sql session close session 5.
43 sql session close session 4.
44 sql session close session 3.
45 sql session close session 2.
46 sql session close session 1.
47 sql session close session 0.
48 sql open session 0.
49 sql open session 1.
50 sql open session 2.
51 sql open session 3.
52 sql open session 4.
53 sql open session 5.
54 sql open session 6.
55 sql open session 7.
56 sql open session 8.
57 close following nb of sessions: 9
58 sql session close session 0.
59 sql session close session 1.
60 sql session close session 2.
61 sql session close session 3.
62 sql session close session 4.
63 sql session close session 5.
64 sql session close session 6.
65 sql session close session 7.
66 sql session close session 8.
67 deinit thread
68 SET GLOBAL general_log = 'OFF';
69 ##########################################
70 # Check general log file
71 ##########################################
72 CREATE TABLE t1 (c1 TEXT, c2 TEXT);
73 LOAD DATA LOCAL INFILE 'MYSQLTEST_VARDIR/log/test_session_general.log' INTO TABLE t1;
74 SELECT count(*) FROM t1 WHERE c2 LIKE '%Connect%';
75 count(*)
76 18
77 SELECT count(*) FROM t1 WHERE c2 LIKE '%Quit%';
78 count(*)
79 18
80 SELECT count(*) >= 36 FROM mysql.general_log WHERE command_type IN ('Connect','Quit') AND user_host NOT LIKE '%mysql.session%';
81 count(*) >= 36
82 1
83 ##########################################
84 # Cleanup
85 ##########################################
86 # Dropping the created table
87 DROP TABLE t1;
88 # Removing general_log content
89 TRUNCATE TABLE mysql.general_log;
90 # Deleting log file created
91 SET GLOBAL log_output = @old_log_output;
92 SET GLOBAL general_log = @old_general_log;
93 SET GLOBAL general_log_file = @old_general_log_file;