1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
#
# Test of how rewritten queries are logged.
#
# Query rewrite plugin was installed.
INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
VALUES ( 'SELECT"The_original_query"', 'SELECT"The_rewritten_query"');
CALL query_rewrite.flush_rewrite_rules();
SET @old_log_output= @@global.log_output;
SET @old_general_log= @@global.general_log;
SET @old_general_log_file= @@global.general_log_file;
SET GLOBAL general_log_file = '.../log/rewrite_general.log';
SET GLOBAL log_output = 'FILE,TABLE';
SET GLOBAL general_log= 'ON';
SELECT 'The_original_query';
The_rewritten_query
The_rewritten_query
Warnings:
Note 1105 Query 'SELECT 'The_original_query'' rewritten to 'SELECT"The_rewritten_query"' by a query rewrite plugin
CREATE TABLE test_log ( line TEXT );
LOAD DATA LOCAL INFILE '.../log/rewrite_general.log'
INTO TABLE test_log FIELDS TERMINATED BY '\n'
IGNORE 3 LINES;
SELECT substring_index( line, ' ', -1 ) AS incoming_query
FROM test_log
WHERE line LIKE ( '%SELECT%' );
incoming_query
Query SELECT"The_rewritten_query"
DROP TABLE test_log;
SET GLOBAL general_log = DEFAULT;
SET GLOBAL general_log_file= @old_general_log_file;
SET GLOBAL general_log= @old_general_log;
SET GLOBAL log_output= @old_log_output;
Warnings:
Warning 1620 Plugin is busy and will be uninstalled on shutdown
# Query rewrite plugin was queued for uninstalling.
SET @@global.log_output = @old_log_output;
SET @@global.general_log = @old_general_log;
SET @@global.general_log_file = @old_general_log_file;
TRUNCATE TABLE mysql.general_log;
|
