1
=== added file 'COPYING.show_temp_51'
2
--- COPYING.show_temp_51	1970-01-01 00:00:00 +0000
3
+++ COPYING.show_temp_51	2013-05-26 07:24:39 +0000
4
@@ -0,0 +1,13 @@
5
1
Portions of this software contain modifications contributed by Venu Anuganti.
6
2
These contributions are used with the following license:
7
3
8
4
Copyright (c) 2010, Venu Anuganti, http://venublog.com/
9
5
All rights reserved.
10
6
11
7
Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:
12
8
13
9
    * Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
14
10
    * Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.
15
11
    * Neither the name of the <ORGANIZATION> nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.
16
12
17
13
THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
18
0
14
19
=== removed file 'COPYING.show_temp_51'
20
--- COPYING.show_temp_51	2010-12-09 18:30:58 +0000
21
+++ COPYING.show_temp_51	1970-01-01 00:00:00 +0000
22
@@ -1,13 +0,0 @@
23
1
Portions of this software contain modifications contributed by Venu Anuganti.
24
2
These contributions are used with the following license:
25
3
26
4
Copyright (c) 2010, Venu Anuganti, http://venublog.com/
27
5
All rights reserved.
28
6
29
7
Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:
30
8
31
9
    * Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
32
10
    * Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.
33
11
    * Neither the name of the <ORGANIZATION> nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.
34
12
35
13
THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
36
14
0
37
=== added file 'Percona-Server/include/flashcache_ioctl.h'
38
--- Percona-Server/include/flashcache_ioctl.h	1970-01-01 00:00:00 +0000
39
+++ Percona-Server/include/flashcache_ioctl.h	2013-05-26 07:24:39 +0000
40
@@ -0,0 +1,53 @@
41
1
/****************************************************************************
42
2
 *  flashcache_ioctl.h
43
3
 *  FlashCache: Device mapper target for block-level disk caching
44
4
 *
45
5
 *  Copyright 2010 Facebook, Inc.
46
6
 *  Author: Mohan Srinivasan (mohan@facebook.com)
47
7
 *
48
8
 *  Based on DM-Cache:
49
9
 *   Copyright (C) International Business Machines Corp., 2006
50
10
 *   Author: Ming Zhao (mingzhao@ufl.edu)
51
11
 *
52
12
 *  This program is free software; you can redistribute it and/or modify
53
13
 *  it under the terms of the GNU General Public License as published by
54
14
 *  the Free Software Foundation; under version 2 of the License.
55
15
 *
56
16
 *  This program is distributed in the hope that it will be useful,
57
17
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
58
18
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
59
19
 *  GNU General Public License for more details.
60
20
 *
61
21
 * You should have received a copy of the GNU General Public License
62
22
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
63
23
 ****************************************************************************/
64
24
65
25
#ifndef FLASHCACHE_IOCTL_H
66
26
#define FLASHCACHE_IOCTL_H
67
27
68
28
#include <linux/types.h>
69
29
70
30
#define FLASHCACHE_IOCTL 0xfe
71
31
72
32
enum {
73
33
       FLASHCACHEADDNCPID_CMD=200,
74
34
       FLASHCACHEDELNCPID_CMD,
75
35
       FLASHCACHEDELNCALL_CMD,
76
36
       FLASHCACHEADDWHITELIST_CMD,
77
37
       FLASHCACHEDELWHITELIST_CMD,
78
38
       FLASHCACHEDELWHITELISTALL_CMD,
79
39
};
80
40
81
41
#define FLASHCACHEADDNCPID     _IOW(FLASHCACHE_IOCTL, FLASHCACHEADDNCPID_CMD, pid_t)
82
42
#define FLASHCACHEDELNCPID     _IOW(FLASHCACHE_IOCTL, FLASHCACHEDELNCPID_CMD, pid_t)
83
43
#define FLASHCACHEDELNCALL     _IOW(FLASHCACHE_IOCTL, FLASHCACHEDELNCALL_CMD, pid_t)
84
44
85
45
#define FLASHCACHEADDBLACKLIST         FLASHCACHEADDNCPID
86
46
#define FLASHCACHEDELBLACKLIST         FLASHCACHEDELNCPID
87
47
#define FLASHCACHEDELALLBLACKLIST      FLASHCACHEDELNCALL
88
48
89
49
#define FLASHCACHEADDWHITELIST         _IOW(FLASHCACHE_IOCTL, FLASHCACHEADDWHITELIST_CMD, pid_t)
90
50
#define FLASHCACHEDELWHITELIST         _IOW(FLASHCACHE_IOCTL, FLASHCACHEDELWHITELIST_CMD, pid_t)
91
51
#define FLASHCACHEDELALLWHITELIST      _IOW(FLASHCACHE_IOCTL, FLASHCACHEDELWHITELISTALL_CMD, pid_t)
92
52
93
53
#endif
94
0
54
95
=== removed file 'Percona-Server/include/flashcache_ioctl.h'
96
--- Percona-Server/include/flashcache_ioctl.h	2012-04-18 23:25:54 +0000
97
+++ Percona-Server/include/flashcache_ioctl.h	1970-01-01 00:00:00 +0000
98
@@ -1,53 +0,0 @@
99
1
/****************************************************************************
100
2
 *  flashcache_ioctl.h
101
3
 *  FlashCache: Device mapper target for block-level disk caching
102
4
 *
103
5
 *  Copyright 2010 Facebook, Inc.
104
6
 *  Author: Mohan Srinivasan (mohan@facebook.com)
105
7
 *
106
8
 *  Based on DM-Cache:
107
9
 *   Copyright (C) International Business Machines Corp., 2006
108
10
 *   Author: Ming Zhao (mingzhao@ufl.edu)
109
11
 *
110
12
 *  This program is free software; you can redistribute it and/or modify
111
13
 *  it under the terms of the GNU General Public License as published by
112
14
 *  the Free Software Foundation; under version 2 of the License.
113
15
 *
114
16
 *  This program is distributed in the hope that it will be useful,
115
17
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
116
18
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
117
19
 *  GNU General Public License for more details.
118
20
 *
119
21
 * You should have received a copy of the GNU General Public License
120
22
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
121
23
 ****************************************************************************/
122
24
123
25
#ifndef FLASHCACHE_IOCTL_H
124
26
#define FLASHCACHE_IOCTL_H
125
27
126
28
#include <linux/types.h>
127
29
128
30
#define FLASHCACHE_IOCTL 0xfe
129
31
130
32
enum {
131
33
       FLASHCACHEADDNCPID_CMD=200,
132
34
       FLASHCACHEDELNCPID_CMD,
133
35
       FLASHCACHEDELNCALL_CMD,
134
36
       FLASHCACHEADDWHITELIST_CMD,
135
37
       FLASHCACHEDELWHITELIST_CMD,
136
38
       FLASHCACHEDELWHITELISTALL_CMD,
137
39
};
138
40
139
41
#define FLASHCACHEADDNCPID     _IOW(FLASHCACHE_IOCTL, FLASHCACHEADDNCPID_CMD, pid_t)
140
42
#define FLASHCACHEDELNCPID     _IOW(FLASHCACHE_IOCTL, FLASHCACHEDELNCPID_CMD, pid_t)
141
43
#define FLASHCACHEDELNCALL     _IOW(FLASHCACHE_IOCTL, FLASHCACHEDELNCALL_CMD, pid_t)
142
44
143
45
#define FLASHCACHEADDBLACKLIST         FLASHCACHEADDNCPID
144
46
#define FLASHCACHEDELBLACKLIST         FLASHCACHEDELNCPID
145
47
#define FLASHCACHEDELALLBLACKLIST      FLASHCACHEDELNCALL
146
48
147
49
#define FLASHCACHEADDWHITELIST         _IOW(FLASHCACHE_IOCTL, FLASHCACHEADDWHITELIST_CMD, pid_t)
148
50
#define FLASHCACHEDELWHITELIST         _IOW(FLASHCACHE_IOCTL, FLASHCACHEDELWHITELIST_CMD, pid_t)
149
51
#define FLASHCACHEDELALLWHITELIST      _IOW(FLASHCACHE_IOCTL, FLASHCACHEDELWHITELISTALL_CMD, pid_t)
150
52
151
53
#endif
152
54
0
153
=== added file 'Percona-Server/mysql-test/include/have_response_time_distribution.inc'
154
--- Percona-Server/mysql-test/include/have_response_time_distribution.inc	1970-01-01 00:00:00 +0000
155
+++ Percona-Server/mysql-test/include/have_response_time_distribution.inc	2013-05-26 07:24:39 +0000
156
@@ -0,0 +1,4 @@
157
1
-- require r/have_response_time_distribution.require
158
2
disable_query_log;
159
3
show variables like 'have_response_time_distribution';
160
4
enable_query_log;
161
0
5
162
=== removed file 'Percona-Server/mysql-test/include/have_response_time_distribution.inc'
163
--- Percona-Server/mysql-test/include/have_response_time_distribution.inc	2012-04-18 23:25:50 +0000
164
+++ Percona-Server/mysql-test/include/have_response_time_distribution.inc	1970-01-01 00:00:00 +0000
165
@@ -1,4 +0,0 @@
166
1
-- require r/have_response_time_distribution.require
167
2
disable_query_log;
168
3
show variables like 'have_response_time_distribution';
169
4
enable_query_log;
170
5
0
171
=== added file 'Percona-Server/mysql-test/include/log_grep.inc'
172
--- Percona-Server/mysql-test/include/log_grep.inc	1970-01-01 00:00:00 +0000
173
+++ Percona-Server/mysql-test/include/log_grep.inc	2013-05-26 07:24:39 +0000
174
@@ -0,0 +1,41 @@
175
1
--echo [log_grep.inc] file: $log_file pattern: $grep_pattern
176
2
perl;
177
3
  $log_file=           $ENV{'log_file'};
178
4
  $log_file_full_path= $ENV{'log_file_full_path'};
179
5
  $log_slow_rate_test= $ENV{'log_slow_rate_test'};
180
6
  open(FILE, "$log_file_full_path") 
181
7
    or die("Cannot open file $log_file_full_path: $!\n");
182
8
183
9
  if ($log_slow_rate_test) {
184
10
    $one= 0;
185
11
    $two= 0;
186
12
    $three= 0;
187
13
    while(<FILE>) {
188
14
      $one++   if(/'connection_one'/);
189
15
      $two++   if(/'connection_two'/);
190
16
      $three++ if(/'connection_three'/);
191
17
    }
192
18
    $sum= $one + $two + $three;
193
19
    $zero= 0;
194
20
    if ($one == 0) {
195
21
      $zero++;
196
22
    }
197
23
    if ($two == 0) {
198
24
      $zero++;
199
25
    }
200
26
    if ($three == 0) {
201
27
      $zero++;
202
28
    }
203
29
    print "[log_grep.inc] sum:  $sum\n";
204
30
    print "[log_grep.inc] zero: $zero\n";
205
31
  }
206
32
  else {
207
33
    $grep_pattern=       $ENV{'grep_pattern'};
208
34
    $lines= 0;
209
35
    while(<FILE>) {
210
36
      $lines++ if (/$grep_pattern/);
211
37
    }
212
38
    print "[log_grep.inc] lines:   $lines\n";
213
39
  }
214
40
  close(FILE);
215
41
EOF
216
0
42
217
=== removed file 'Percona-Server/mysql-test/include/log_grep.inc'
218
--- Percona-Server/mysql-test/include/log_grep.inc	2012-04-18 23:25:38 +0000
219
+++ Percona-Server/mysql-test/include/log_grep.inc	1970-01-01 00:00:00 +0000
220
@@ -1,41 +0,0 @@
221
1
--echo [log_grep.inc] file: $log_file pattern: $grep_pattern
222
2
perl;
223
3
  $log_file=           $ENV{'log_file'};
224
4
  $log_file_full_path= $ENV{'log_file_full_path'};
225
5
  $log_slow_rate_test= $ENV{'log_slow_rate_test'};
226
6
  open(FILE, "$log_file_full_path") 
227
7
    or die("Cannot open file $log_file_full_path: $!\n");
228
8
229
9
  if ($log_slow_rate_test) {
230
10
    $one= 0;
231
11
    $two= 0;
232
12
    $three= 0;
233
13
    while(<FILE>) {
234
14
      $one++   if(/'connection_one'/);
235
15
      $two++   if(/'connection_two'/);
236
16
      $three++ if(/'connection_three'/);
237
17
    }
238
18
    $sum= $one + $two + $three;
239
19
    $zero= 0;
240
20
    if ($one == 0) {
241
21
      $zero++;
242
22
    }
243
23
    if ($two == 0) {
244
24
      $zero++;
245
25
    }
246
26
    if ($three == 0) {
247
27
      $zero++;
248
28
    }
249
29
    print "[log_grep.inc] sum:  $sum\n";
250
30
    print "[log_grep.inc] zero: $zero\n";
251
31
  }
252
32
  else {
253
33
    $grep_pattern=       $ENV{'grep_pattern'};
254
34
    $lines= 0;
255
35
    while(<FILE>) {
256
36
      $lines++ if (/$grep_pattern/);
257
37
    }
258
38
    print "[log_grep.inc] lines:   $lines\n";
259
39
  }
260
40
  close(FILE);
261
41
EOF
262
42
0
263
=== added file 'Percona-Server/mysql-test/include/percona_query_cache_with_comments.inc'
264
--- Percona-Server/mysql-test/include/percona_query_cache_with_comments.inc	1970-01-01 00:00:00 +0000
265
+++ Percona-Server/mysql-test/include/percona_query_cache_with_comments.inc	2013-05-26 07:24:39 +0000
266
@@ -0,0 +1,95 @@
267
1
--source include/percona_query_cache_with_comments_clear.inc
268
2
let $query=/* with comment first */select * from t1;
269
3
eval $query;
270
4
--source include/percona_query_cache_with_comments_eval.inc
271
5
272
6
let $query=# with comment first
273
7
select * from t1;
274
8
--source include/percona_query_cache_with_comments_eval.inc
275
9
276
10
let $query=-- with comment first
277
11
select * from t1;
278
12
--source include/percona_query_cache_with_comments_eval.inc
279
13
280
14
let $query=/* with comment first and "quote" */select * from t1;
281
15
--source include/percona_query_cache_with_comments_eval.inc
282
16
283
17
let $query=# with comment first and "quote"
284
18
select * from t1;
285
19
--source include/percona_query_cache_with_comments_eval.inc
286
20
287
21
let $query=-- with comment first and "quote" 
288
22
select * from t1;
289
23
--source include/percona_query_cache_with_comments_eval.inc
290
24
291
25
let $query=
292
26
    /* with comment and whitespaces first */select * from t1;
293
27
--source include/percona_query_cache_with_comments_eval.inc
294
28
295
29
let $query= 
296
30
    # with comment and whitespaces first
297
31
select * from t1;
298
32
--source include/percona_query_cache_with_comments_eval.inc
299
33
300
34
let $query=
301
35
    -- with comment and whitespaces first
302
36
select * from t1;
303
37
--source include/percona_query_cache_with_comments_eval.inc
304
38
305
39
let $internal=* internal comment *;
306
40
307
41
let $query=select * /$internal/ from t1;
308
42
--source include/percona_query_cache_with_comments_eval.inc
309
43
let $query=select */$internal/ from t1;
310
44
--source include/percona_query_cache_with_comments_eval.inc
311
45
let $query=select */$internal/from t1;
312
46
--source include/percona_query_cache_with_comments_eval.inc
313
47
314
48
let $internal=* internal comment with "quote" *;
315
49
316
50
let $query=select * /$internal/ from t1;
317
51
--source include/percona_query_cache_with_comments_eval.inc
318
52
let $query=select */$internal/ from t1;
319
53
--source include/percona_query_cache_with_comments_eval.inc
320
54
let $query=select */$internal/from t1;
321
55
--source include/percona_query_cache_with_comments_eval.inc
322
56
323
57
let $query=select * from t1
324
58
;
325
59
--source include/percona_query_cache_with_comments_eval.inc
326
60
327
61
let $query=select * from t1 ;
328
62
--source include/percona_query_cache_with_comments_eval.inc
329
63
330
64
let $query=select * from t1	;
331
65
--source include/percona_query_cache_with_comments_eval.inc
332
66
333
67
let $query=select * from t1
334
68
/* comment in the end */;
335
69
--source include/percona_query_cache_with_comments_eval.inc
336
70
337
71
let $query=select * from t1
338
72
/* *\/ */;
339
73
--source include/percona_query_cache_with_comments_eval.inc
340
74
341
75
let $query=select * from t1
342
76
/* comment in the end */
343
77
;
344
78
--source include/percona_query_cache_with_comments_eval.inc
345
79
346
80
let $query=select * from t1 #comment in the end;
347
81
--source include/percona_query_cache_with_comments_eval.inc
348
82
349
83
let $query=select * from t1 #comment in the end
350
84
;
351
85
--source include/percona_query_cache_with_comments_eval.inc
352
86
353
87
let $query=select * from t1 -- comment in the end;
354
88
--source include/percona_query_cache_with_comments_eval.inc
355
89
356
90
let $query=select * from t1 -- comment in the end
357
91
;
358
92
--source include/percona_query_cache_with_comments_eval.inc
359
93
360
94
let $query=select ' \'  ' from t1;
361
95
--source include/percona_query_cache_with_comments_eval.inc
362
0
96
363
=== removed file 'Percona-Server/mysql-test/include/percona_query_cache_with_comments.inc'
364
--- Percona-Server/mysql-test/include/percona_query_cache_with_comments.inc	2012-04-18 23:25:43 +0000
365
+++ Percona-Server/mysql-test/include/percona_query_cache_with_comments.inc	1970-01-01 00:00:00 +0000
366
@@ -1,95 +0,0 @@
367
1
--source include/percona_query_cache_with_comments_clear.inc
368
2
let $query=/* with comment first */select * from t1;
369
3
eval $query;
370
4
--source include/percona_query_cache_with_comments_eval.inc
371
5
372
6
let $query=# with comment first
373
7
select * from t1;
374
8
--source include/percona_query_cache_with_comments_eval.inc
375
9
376
10
let $query=-- with comment first
377
11
select * from t1;
378
12
--source include/percona_query_cache_with_comments_eval.inc
379
13
380
14
let $query=/* with comment first and "quote" */select * from t1;
381
15
--source include/percona_query_cache_with_comments_eval.inc
382
16
383
17
let $query=# with comment first and "quote"
384
18
select * from t1;
385
19
--source include/percona_query_cache_with_comments_eval.inc
386
20
387
21
let $query=-- with comment first and "quote" 
388
22
select * from t1;
389
23
--source include/percona_query_cache_with_comments_eval.inc
390
24
391
25
let $query=
392
26
    /* with comment and whitespaces first */select * from t1;
393
27
--source include/percona_query_cache_with_comments_eval.inc
394
28
395
29
let $query= 
396
30
    # with comment and whitespaces first
397
31
select * from t1;
398
32
--source include/percona_query_cache_with_comments_eval.inc
399
33
400
34
let $query=
401
35
    -- with comment and whitespaces first
402
36
select * from t1;
403
37
--source include/percona_query_cache_with_comments_eval.inc
404
38
405
39
let $internal=* internal comment *;
406
40
407
41
let $query=select * /$internal/ from t1;
408
42
--source include/percona_query_cache_with_comments_eval.inc
409
43
let $query=select */$internal/ from t1;
410
44
--source include/percona_query_cache_with_comments_eval.inc
411
45
let $query=select */$internal/from t1;
412
46
--source include/percona_query_cache_with_comments_eval.inc
413
47
414
48
let $internal=* internal comment with "quote" *;
415
49
416
50
let $query=select * /$internal/ from t1;
417
51
--source include/percona_query_cache_with_comments_eval.inc
418
52
let $query=select */$internal/ from t1;
419
53
--source include/percona_query_cache_with_comments_eval.inc
420
54
let $query=select */$internal/from t1;
421
55
--source include/percona_query_cache_with_comments_eval.inc
422
56
423
57
let $query=select * from t1
424
58
;
425
59
--source include/percona_query_cache_with_comments_eval.inc
426
60
427
61
let $query=select * from t1 ;
428
62
--source include/percona_query_cache_with_comments_eval.inc
429
63
430
64
let $query=select * from t1	;
431
65
--source include/percona_query_cache_with_comments_eval.inc
432
66
433
67
let $query=select * from t1
434
68
/* comment in the end */;
435
69
--source include/percona_query_cache_with_comments_eval.inc
436
70
437
71
let $query=select * from t1
438
72
/* *\/ */;
439
73
--source include/percona_query_cache_with_comments_eval.inc
440
74
441
75
let $query=select * from t1
442
76
/* comment in the end */
443
77
;
444
78
--source include/percona_query_cache_with_comments_eval.inc
445
79
446
80
let $query=select * from t1 #comment in the end;
447
81
--source include/percona_query_cache_with_comments_eval.inc
448
82
449
83
let $query=select * from t1 #comment in the end
450
84
;
451
85
--source include/percona_query_cache_with_comments_eval.inc
452
86
453
87
let $query=select * from t1 -- comment in the end;
454
88
--source include/percona_query_cache_with_comments_eval.inc
455
89
456
90
let $query=select * from t1 -- comment in the end
457
91
;
458
92
--source include/percona_query_cache_with_comments_eval.inc
459
93
460
94
let $query=select ' \'  ' from t1;
461
95
--source include/percona_query_cache_with_comments_eval.inc
462
96
0
463
=== added file 'Percona-Server/mysql-test/include/percona_query_cache_with_comments_begin.inc'
464
--- Percona-Server/mysql-test/include/percona_query_cache_with_comments_begin.inc	1970-01-01 00:00:00 +0000
465
+++ Percona-Server/mysql-test/include/percona_query_cache_with_comments_begin.inc	2013-05-26 07:24:39 +0000
466
@@ -0,0 +1,12 @@
467
1
-- source include/have_query_cache.inc
468
2
469
3
set GLOBAL query_cache_size=1355776;
470
4
471
5
--disable_warnings
472
6
drop table if exists t1;
473
7
--enable_warnings
474
8
475
9
create table t1 (a int not null);
476
10
insert into t1 values (1),(2),(3);
477
11
478
12
--source include/percona_query_cache_with_comments_clear.inc
479
0
13
480
=== removed file 'Percona-Server/mysql-test/include/percona_query_cache_with_comments_begin.inc'
481
--- Percona-Server/mysql-test/include/percona_query_cache_with_comments_begin.inc	2012-04-18 23:25:43 +0000
482
+++ Percona-Server/mysql-test/include/percona_query_cache_with_comments_begin.inc	1970-01-01 00:00:00 +0000
483
@@ -1,12 +0,0 @@
484
1
-- source include/have_query_cache.inc
485
2
486
3
set GLOBAL query_cache_size=1355776;
487
4
488
5
--disable_warnings
489
6
drop table if exists t1;
490
7
--enable_warnings
491
8
492
9
create table t1 (a int not null);
493
10
insert into t1 values (1),(2),(3);
494
11
495
12
--source include/percona_query_cache_with_comments_clear.inc
496
13
0
497
=== added file 'Percona-Server/mysql-test/include/percona_query_cache_with_comments_clear.inc'
498
--- Percona-Server/mysql-test/include/percona_query_cache_with_comments_clear.inc	1970-01-01 00:00:00 +0000
499
+++ Percona-Server/mysql-test/include/percona_query_cache_with_comments_clear.inc	2013-05-26 07:24:39 +0000
500
@@ -0,0 +1,5 @@
501
1
# Reset query cache variables.
502
2
flush query cache; # This crashed in some versions
503
3
flush query cache; # This crashed in some versions
504
4
reset query cache;
505
5
flush status;
506
0
6
507
=== removed file 'Percona-Server/mysql-test/include/percona_query_cache_with_comments_clear.inc'
508
--- Percona-Server/mysql-test/include/percona_query_cache_with_comments_clear.inc	2012-04-18 23:25:43 +0000
509
+++ Percona-Server/mysql-test/include/percona_query_cache_with_comments_clear.inc	1970-01-01 00:00:00 +0000
510
@@ -1,5 +0,0 @@
511
1
# Reset query cache variables.
512
2
flush query cache; # This crashed in some versions
513
3
flush query cache; # This crashed in some versions
514
4
reset query cache;
515
5
flush status;
516
6
0
517
=== added file 'Percona-Server/mysql-test/include/percona_query_cache_with_comments_end.inc'
518
--- Percona-Server/mysql-test/include/percona_query_cache_with_comments_end.inc	1970-01-01 00:00:00 +0000
519
+++ Percona-Server/mysql-test/include/percona_query_cache_with_comments_end.inc	2013-05-26 07:24:39 +0000
520
@@ -0,0 +1,3 @@
521
1
DROP TABLE t1;
522
2
SET GLOBAL query_cache_size=default;
523
3
set global query_cache_strip_comments=OFF;
524
0
4
525
=== removed file 'Percona-Server/mysql-test/include/percona_query_cache_with_comments_end.inc'
526
--- Percona-Server/mysql-test/include/percona_query_cache_with_comments_end.inc	2012-04-18 23:25:43 +0000
527
+++ Percona-Server/mysql-test/include/percona_query_cache_with_comments_end.inc	1970-01-01 00:00:00 +0000
528
@@ -1,3 +0,0 @@
529
1
DROP TABLE t1;
530
2
SET GLOBAL query_cache_size=default;
531
3
set global query_cache_strip_comments=OFF;
532
4
0
533
=== added file 'Percona-Server/mysql-test/include/percona_query_cache_with_comments_eval.inc'
534
--- Percona-Server/mysql-test/include/percona_query_cache_with_comments_eval.inc	1970-01-01 00:00:00 +0000
535
+++ Percona-Server/mysql-test/include/percona_query_cache_with_comments_eval.inc	2013-05-26 07:24:39 +0000
536
@@ -0,0 +1,7 @@
537
1
echo -----------------------------------------------------;
538
2
echo $query;
539
3
echo -----------------------------------------------------;
540
4
--source include/percona_query_cache_with_comments_show.inc
541
5
eval $query;
542
6
eval $query;
543
7
--source include/percona_query_cache_with_comments_show.inc
544
0
8
545
=== removed file 'Percona-Server/mysql-test/include/percona_query_cache_with_comments_eval.inc'
546
--- Percona-Server/mysql-test/include/percona_query_cache_with_comments_eval.inc	2012-04-18 23:25:43 +0000
547
+++ Percona-Server/mysql-test/include/percona_query_cache_with_comments_eval.inc	1970-01-01 00:00:00 +0000
548
@@ -1,7 +0,0 @@
549
1
echo -----------------------------------------------------;
550
2
echo $query;
551
3
echo -----------------------------------------------------;
552
4
--source include/percona_query_cache_with_comments_show.inc
553
5
eval $query;
554
6
eval $query;
555
7
--source include/percona_query_cache_with_comments_show.inc
556
8
0
557
=== added file 'Percona-Server/mysql-test/include/percona_query_cache_with_comments_show.inc'
558
--- Percona-Server/mysql-test/include/percona_query_cache_with_comments_show.inc	1970-01-01 00:00:00 +0000
559
+++ Percona-Server/mysql-test/include/percona_query_cache_with_comments_show.inc	2013-05-26 07:24:39 +0000
560
@@ -0,0 +1,8 @@
561
1
let $show=show status like "Qcache_queries_in_cache";
562
2
eval $show;
563
3
let $show=show status like "Qcache_inserts";
564
4
eval $show;
565
5
let $show=show status like "Qcache_hits";
566
6
eval $show;
567
7
568
8
569
0
9
570
=== removed file 'Percona-Server/mysql-test/include/percona_query_cache_with_comments_show.inc'
571
--- Percona-Server/mysql-test/include/percona_query_cache_with_comments_show.inc	2012-04-18 23:25:43 +0000
572
+++ Percona-Server/mysql-test/include/percona_query_cache_with_comments_show.inc	1970-01-01 00:00:00 +0000
573
@@ -1,8 +0,0 @@
574
1
let $show=show status like "Qcache_queries_in_cache";
575
2
eval $show;
576
3
let $show=show status like "Qcache_inserts";
577
4
eval $show;
578
5
let $show=show status like "Qcache_hits";
579
6
eval $show;
580
7
581
8
582
9
0
583
=== added file 'Percona-Server/mysql-test/include/percona_server_variables.inc'
584
--- Percona-Server/mysql-test/include/percona_server_variables.inc	1970-01-01 00:00:00 +0000
585
+++ Percona-Server/mysql-test/include/percona_server_variables.inc	2013-05-26 07:24:39 +0000
586
@@ -0,0 +1,3 @@
587
1
--source include/have_response_time_distribution.inc
588
2
--source include/have_innodb.inc
589
3
SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
590
0
4
591
=== removed file 'Percona-Server/mysql-test/include/percona_server_variables.inc'
592
--- Percona-Server/mysql-test/include/percona_server_variables.inc	2012-04-18 23:26:11 +0000
593
+++ Percona-Server/mysql-test/include/percona_server_variables.inc	1970-01-01 00:00:00 +0000
594
@@ -1,3 +0,0 @@
595
1
--source include/have_response_time_distribution.inc
596
2
--source include/have_innodb.inc
597
3
SELECT Variable_name FROM INFORMATION_SCHEMA.SESSION_VARIABLES ORDER BY 1;
598
4
0
599
=== added file 'Percona-Server/mysql-test/include/percona_show_slave_status_nolock.inc'
600
--- Percona-Server/mysql-test/include/percona_show_slave_status_nolock.inc	1970-01-01 00:00:00 +0000
601
+++ Percona-Server/mysql-test/include/percona_show_slave_status_nolock.inc	2013-05-26 07:24:39 +0000
602
@@ -0,0 +1,56 @@
603
1
--echo
604
2
--disable_result_log
605
3
connection slave_lock;
606
4
--echo [slave_lock]
607
5
send SHOW SLAVE STATUS;
608
6
609
7
connection slave;
610
8
--let $condition= 'SHOW SLAVE STATUS'
611
9
--source include/wait_show_condition.inc
612
10
613
11
--disable_warnings
614
12
SET DEBUG_SYNC='now WAIT_FOR signal.after_show_slave_status TIMEOUT 1';
615
13
--enable_warnings
616
14
617
15
--let current=`SELECT SUBSTR(Variable_value FROM 22) FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE Variable_name = 'DEBUG_SYNC'`
618
16
--echo SIGNAL after SHOW SLAVE STATUS is $current
619
17
620
18
connection slave;
621
19
--echo [slave]
622
20
SET DEBUG_SYNC='now SIGNAL signal.empty';
623
21
624
22
connection slave_nolock;
625
23
--echo [slave_nolock]
626
24
send SHOW SLAVE STATUS NOLOCK;
627
25
628
26
connection slave;
629
27
--let $condition= 'SHOW SLAVE STATUS NOLOCK'
630
28
--source include/wait_show_condition.inc
631
29
632
30
--disable_warnings
633
31
SET DEBUG_SYNC='now WAIT_FOR signal.after_show_slave_status TIMEOUT 1';
634
32
--enable_warnings
635
33
636
34
--echo # should be 'signal.after_show_slave_status'
637
35
--let current=`SELECT SUBSTR(Variable_value FROM 22) FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE Variable_name = 'DEBUG_SYNC'`
638
36
--echo SIGNAL after SHOW SLAVE STATUS NOLOCK is $current
639
37
640
38
connection slave;
641
39
--echo [slave]
642
40
SET DEBUG_SYNC='now SIGNAL signal.continue';
643
41
644
42
connection slave_lock;
645
43
--disable_result_log
646
44
reap;
647
45
--enable_result_log
648
46
649
47
connection slave_nolock;
650
48
--disable_result_log
651
49
reap;
652
50
--enable_result_log
653
51
654
52
connection slave;
655
53
--echo [slave]
656
54
SET DEBUG_SYNC='now SIGNAL signal.empty';
657
55
--enable_result_log
658
56
--echo
659
0
57
660
=== removed file 'Percona-Server/mysql-test/include/percona_show_slave_status_nolock.inc'
661
--- Percona-Server/mysql-test/include/percona_show_slave_status_nolock.inc	2012-04-18 23:25:57 +0000
662
+++ Percona-Server/mysql-test/include/percona_show_slave_status_nolock.inc	1970-01-01 00:00:00 +0000
663
@@ -1,56 +0,0 @@
664
1
--echo
665
2
--disable_result_log
666
3
connection slave_lock;
667
4
--echo [slave_lock]
668
5
send SHOW SLAVE STATUS;
669
6
670
7
connection slave;
671
8
--let $condition= 'SHOW SLAVE STATUS'
672
9
--source include/wait_show_condition.inc
673
10
674
11
--disable_warnings
675
12
SET DEBUG_SYNC='now WAIT_FOR signal.after_show_slave_status TIMEOUT 1';
676
13
--enable_warnings
677
14
678
15
--let current=`SELECT SUBSTR(Variable_value FROM 22) FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE Variable_name = 'DEBUG_SYNC'`
679
16
--echo SIGNAL after SHOW SLAVE STATUS is $current
680
17
681
18
connection slave;
682
19
--echo [slave]
683
20
SET DEBUG_SYNC='now SIGNAL signal.empty';
684
21
685
22
connection slave_nolock;
686
23
--echo [slave_nolock]
687
24
send SHOW SLAVE STATUS NOLOCK;
688
25
689
26
connection slave;
690
27
--let $condition= 'SHOW SLAVE STATUS NOLOCK'
691
28
--source include/wait_show_condition.inc
692
29
693
30
--disable_warnings
694
31
SET DEBUG_SYNC='now WAIT_FOR signal.after_show_slave_status TIMEOUT 1';
695
32
--enable_warnings
696
33
697
34
--echo # should be 'signal.after_show_slave_status'
698
35
--let current=`SELECT SUBSTR(Variable_value FROM 22) FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE Variable_name = 'DEBUG_SYNC'`
699
36
--echo SIGNAL after SHOW SLAVE STATUS NOLOCK is $current
700
37
701
38
connection slave;
702
39
--echo [slave]
703
40
SET DEBUG_SYNC='now SIGNAL signal.continue';
704
41
705
42
connection slave_lock;
706
43
--disable_result_log
707
44
reap;
708
45
--enable_result_log
709
46
710
47
connection slave_nolock;
711
48
--disable_result_log
712
49
reap;
713
50
--enable_result_log
714
51
715
52
connection slave;
716
53
--echo [slave]
717
54
SET DEBUG_SYNC='now SIGNAL signal.empty';
718
55
--enable_result_log
719
56
--echo
720
57
0
721
=== added file 'Percona-Server/mysql-test/include/query_response_time-replication.inc'
722
--- Percona-Server/mysql-test/include/query_response_time-replication.inc	1970-01-01 00:00:00 +0000
723
+++ Percona-Server/mysql-test/include/query_response_time-replication.inc	2013-05-26 07:24:39 +0000
724
@@ -0,0 +1,58 @@
725
1
connection master;
726
2
727
3
CREATE TABLE t(id INT);
728
4
729
5
sync_slave_with_master;
730
6
731
7
SET GLOBAL query_exec_time = 0.1;
732
8
--source include/restart_slave_sql.inc
733
9
734
10
connection slave;
735
11
736
12
SET SESSION query_exec_time=0.1;
737
13
738
14
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
739
15
--eval SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=$base
740
16
FLUSH QUERY_RESPONSE_TIME;
741
17
SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
742
18
743
19
connection master;
744
20
745
21
SET SESSION query_exec_time = 0.31; INSERT INTO t VALUES(1);
746
22
SET SESSION query_exec_time = 0.32; INSERT INTO t VALUES(1);
747
23
SET SESSION query_exec_time = 0.33; INSERT INTO t VALUES(1);
748
24
SET SESSION query_exec_time = 0.34; INSERT INTO t VALUES(1);
749
25
SET SESSION query_exec_time = 0.35; INSERT INTO t VALUES(1);
750
26
SET SESSION query_exec_time = 0.36; INSERT INTO t VALUES(1);
751
27
SET SESSION query_exec_time = 0.37; INSERT INTO t VALUES(1);
752
28
SET SESSION query_exec_time = 0.38; INSERT INTO t VALUES(1);
753
29
SET SESSION query_exec_time = 0.39; INSERT INTO t VALUES(1);
754
30
SET SESSION query_exec_time = 0.4; INSERT INTO t VALUES(1);
755
31
SET SESSION query_exec_time = 1.1; INSERT INTO t VALUES(1);
756
32
SET SESSION query_exec_time = 1.2; INSERT INTO t VALUES(1);
757
33
SET SESSION query_exec_time = 1.3; INSERT INTO t VALUES(1);
758
34
SET SESSION query_exec_time = 1.5; INSERT INTO t VALUES(1);
759
35
SET SESSION query_exec_time = 1.4; INSERT INTO t VALUES(1);
760
36
SET SESSION query_exec_time = 0.5; INSERT INTO t VALUES(1);
761
37
SET SESSION query_exec_time = 2.1; INSERT INTO t VALUES(1);
762
38
SET SESSION query_exec_time = 2.3; INSERT INTO t VALUES(1);
763
39
SET SESSION query_exec_time = 2.5; INSERT INTO t VALUES(1);
764
40
SET SESSION query_exec_time = 3.1; INSERT INTO t VALUES(1);
765
41
SET SESSION query_exec_time = 4.1; INSERT INTO t VALUES(1);
766
42
SET SESSION query_exec_time = 5.1; INSERT INTO t VALUES(1);
767
43
768
44
sync_slave_with_master;
769
45
770
46
connection slave;
771
47
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
772
48
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
773
49
SHOW QUERY_RESPONSE_TIME;
774
50
SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
775
51
776
52
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default;
777
53
SET GLOBAL QUERY_RESPONSE_TIME_STATS=default;
778
54
779
55
connection master;
780
56
DROP TABLE t;
781
57
782
58
sync_slave_with_master;
783
0
59
784
=== removed file 'Percona-Server/mysql-test/include/query_response_time-replication.inc'
785
--- Percona-Server/mysql-test/include/query_response_time-replication.inc	2013-01-28 11:28:44 +0000
786
+++ Percona-Server/mysql-test/include/query_response_time-replication.inc	1970-01-01 00:00:00 +0000
787
@@ -1,58 +0,0 @@
788
1
connection master;
789
2
790
3
CREATE TABLE t(id INT);
791
4
792
5
sync_slave_with_master;
793
6
794
7
SET GLOBAL query_exec_time = 0.1;
795
8
--source include/restart_slave_sql.inc
796
9
797
10
connection slave;
798
11
799
12
SET SESSION query_exec_time=0.1;
800
13
801
14
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
802
15
--eval SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=$base
803
16
FLUSH QUERY_RESPONSE_TIME;
804
17
SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
805
18
806
19
connection master;
807
20
808
21
SET SESSION query_exec_time = 0.31; INSERT INTO t VALUES(1);
809
22
SET SESSION query_exec_time = 0.32; INSERT INTO t VALUES(1);
810
23
SET SESSION query_exec_time = 0.33; INSERT INTO t VALUES(1);
811
24
SET SESSION query_exec_time = 0.34; INSERT INTO t VALUES(1);
812
25
SET SESSION query_exec_time = 0.35; INSERT INTO t VALUES(1);
813
26
SET SESSION query_exec_time = 0.36; INSERT INTO t VALUES(1);
814
27
SET SESSION query_exec_time = 0.37; INSERT INTO t VALUES(1);
815
28
SET SESSION query_exec_time = 0.38; INSERT INTO t VALUES(1);
816
29
SET SESSION query_exec_time = 0.39; INSERT INTO t VALUES(1);
817
30
SET SESSION query_exec_time = 0.4; INSERT INTO t VALUES(1);
818
31
SET SESSION query_exec_time = 1.1; INSERT INTO t VALUES(1);
819
32
SET SESSION query_exec_time = 1.2; INSERT INTO t VALUES(1);
820
33
SET SESSION query_exec_time = 1.3; INSERT INTO t VALUES(1);
821
34
SET SESSION query_exec_time = 1.5; INSERT INTO t VALUES(1);
822
35
SET SESSION query_exec_time = 1.4; INSERT INTO t VALUES(1);
823
36
SET SESSION query_exec_time = 0.5; INSERT INTO t VALUES(1);
824
37
SET SESSION query_exec_time = 2.1; INSERT INTO t VALUES(1);
825
38
SET SESSION query_exec_time = 2.3; INSERT INTO t VALUES(1);
826
39
SET SESSION query_exec_time = 2.5; INSERT INTO t VALUES(1);
827
40
SET SESSION query_exec_time = 3.1; INSERT INTO t VALUES(1);
828
41
SET SESSION query_exec_time = 4.1; INSERT INTO t VALUES(1);
829
42
SET SESSION query_exec_time = 5.1; INSERT INTO t VALUES(1);
830
43
831
44
sync_slave_with_master;
832
45
833
46
connection slave;
834
47
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
835
48
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
836
49
SHOW QUERY_RESPONSE_TIME;
837
50
SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
838
51
839
52
SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default;
840
53
SET GLOBAL QUERY_RESPONSE_TIME_STATS=default;
841
54
842
55
connection master;
843
56
DROP TABLE t;
844
57
845
58
sync_slave_with_master;
846
59
0
847
=== added file 'Percona-Server/mysql-test/include/query_response_time-stored.inc'
848
--- Percona-Server/mysql-test/include/query_response_time-stored.inc	1970-01-01 00:00:00 +0000
849
+++ Percona-Server/mysql-test/include/query_response_time-stored.inc	2013-05-26 07:24:39 +0000
850
@@ -0,0 +1,37 @@
851
1
SET SESSION query_exec_time=0.1;
852
2
853
3
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
854
4
EVAL SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=$base;
855
5
FLUSH QUERY_RESPONSE_TIME;
856
6
SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
857
7
858
8
CALL test_f(0.31);
859
9
CALL test_f(0.32);
860
10
CALL test_f(0.33);
861
11
CALL test_f(0.34);
862
12
CALL test_f(0.35);
863
13
CALL test_f(0.36);
864
14
CALL test_f(0.37);
865
15
CALL test_f(0.38);
866
16
CALL test_f(0.39);
867
17
CALL test_f(0.4);
868
18
CALL test_f(1.1);
869
19
CALL test_f(1.2);
870
20
CALL test_f(1.3);
871
21
CALL test_f(1.5);
872
22
CALL test_f(1.4);
873
23
CALL test_f(0.5);
874
24
CALL test_f(2.1);
875
25
CALL test_f(2.3);
876
26
CALL test_f(2.5);
877
27
CALL test_f(3.1);
878
28
CALL test_f(4.1);
879
29
CALL test_f(5.1);
880
30
881
31
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
882
32
883
33
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
884
34
SHOW QUERY_RESPONSE_TIME;
885
35
SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
886
36
887
37
SET SESSION query_exec_time=default;
888
0
38
889
=== removed file 'Percona-Server/mysql-test/include/query_response_time-stored.inc'
890
--- Percona-Server/mysql-test/include/query_response_time-stored.inc	2012-04-18 23:25:50 +0000
891
+++ Percona-Server/mysql-test/include/query_response_time-stored.inc	1970-01-01 00:00:00 +0000
892
@@ -1,37 +0,0 @@
893
1
SET SESSION query_exec_time=0.1;
894
2
895
3
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
896
4
EVAL SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=$base;
897
5
FLUSH QUERY_RESPONSE_TIME;
898
6
SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
899
7
900
8
CALL test_f(0.31);
901
9
CALL test_f(0.32);
902
10
CALL test_f(0.33);
903
11
CALL test_f(0.34);
904
12
CALL test_f(0.35);
905
13
CALL test_f(0.36);
906
14
CALL test_f(0.37);
907
15
CALL test_f(0.38);
908
16
CALL test_f(0.39);
909
17
CALL test_f(0.4);
910
18
CALL test_f(1.1);
911
19
CALL test_f(1.2);
912
20
CALL test_f(1.3);
913
21
CALL test_f(1.5);
914
22
CALL test_f(1.4);
915
23
CALL test_f(0.5);
916
24
CALL test_f(2.1);
917
25
CALL test_f(2.3);
918
26
CALL test_f(2.5);
919
27
CALL test_f(3.1);
920
28
CALL test_f(4.1);
921
29
CALL test_f(5.1);
922
30
923
31
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
924
32
925
33
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
926
34
SHOW QUERY_RESPONSE_TIME;
927
35
SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
928
36
929
37
SET SESSION query_exec_time=default;
930
38
0
931
=== added file 'Percona-Server/mysql-test/include/query_response_time.inc'
932
--- Percona-Server/mysql-test/include/query_response_time.inc	1970-01-01 00:00:00 +0000
933
+++ Percona-Server/mysql-test/include/query_response_time.inc	2013-05-26 07:24:39 +0000
934
@@ -0,0 +1,43 @@
935
1
SET SESSION query_exec_time=0.1;
936
2
937
3
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
938
4
EVAL SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=$base;
939
5
FLUSH QUERY_RESPONSE_TIME;
940
6
# Following two queries check works of FLUSH and 
941
7
# respecting of "QUERY_RESPONSE_TIME_STATS" variable (see launchpad bug #855312)
942
8
SHOW QUERY_RESPONSE_TIME;
943
9
SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
944
10
SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
945
11
946
12
SET SESSION query_exec_time=0.31; SELECT 1;
947
13
SET SESSION query_exec_time=0.32; SELECT 1;
948
14
SET SESSION query_exec_time=0.33; SELECT 1;
949
15
SET SESSION query_exec_time=0.34; SELECT 1;
950
16
SET SESSION query_exec_time=0.35; SELECT 1;
951
17
SET SESSION query_exec_time=0.36; SELECT 1;
952
18
SET SESSION query_exec_time=0.37; SELECT 1;
953
19
SET SESSION query_exec_time=0.38; SELECT 1;
954
20
SET SESSION query_exec_time=0.39; SELECT 1;
955
21
SET SESSION query_exec_time=0.4; SELECT 1;
956
22
SET SESSION query_exec_time=1.1; SELECT 1;
957
23
SET SESSION query_exec_time=1.2; SELECT 1;
958
24
SET SESSION query_exec_time=1.3; SELECT 1;
959
25
SET SESSION query_exec_time=1.5; SELECT 1;
960
26
SET SESSION query_exec_time=1.4; SELECT 1;
961
27
SET SESSION query_exec_time=0.5; SELECT 1;
962
28
SET SESSION query_exec_time=2.1; SELECT 1;
963
29
SET SESSION query_exec_time=2.3; SELECT 1;
964
30
SET SESSION query_exec_time=2.5; SELECT 1;
965
31
SET SESSION query_exec_time=3.1; SELECT 1;
966
32
SET SESSION query_exec_time=4.1; SELECT 1;
967
33
SET SESSION query_exec_time=5.1; SELECT 1;
968
34
969
35
SET SESSION query_exec_time=0.1;
970
36
971
37
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
972
38
973
39
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
974
40
SHOW QUERY_RESPONSE_TIME;
975
41
SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
976
42
977
43
SET SESSION query_exec_time=default;
978
0
44
979
=== removed file 'Percona-Server/mysql-test/include/query_response_time.inc'
980
--- Percona-Server/mysql-test/include/query_response_time.inc	2012-04-18 23:25:50 +0000
981
+++ Percona-Server/mysql-test/include/query_response_time.inc	1970-01-01 00:00:00 +0000
982
@@ -1,43 +0,0 @@
983
1
SET SESSION query_exec_time=0.1;
984
2
985
3
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
986
4
EVAL SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=$base;
987
5
FLUSH QUERY_RESPONSE_TIME;
988
6
# Following two queries check works of FLUSH and 
989
7
# respecting of "QUERY_RESPONSE_TIME_STATS" variable (see launchpad bug #855312)
990
8
SHOW QUERY_RESPONSE_TIME;
991
9
SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
992
10
SET GLOBAL QUERY_RESPONSE_TIME_STATS=1;
993
11
994
12
SET SESSION query_exec_time=0.31; SELECT 1;
995
13
SET SESSION query_exec_time=0.32; SELECT 1;
996
14
SET SESSION query_exec_time=0.33; SELECT 1;
997
15
SET SESSION query_exec_time=0.34; SELECT 1;
998
16
SET SESSION query_exec_time=0.35; SELECT 1;
999
17
SET SESSION query_exec_time=0.36; SELECT 1;
1000
18
SET SESSION query_exec_time=0.37; SELECT 1;
1001
19
SET SESSION query_exec_time=0.38; SELECT 1;
1002
20
SET SESSION query_exec_time=0.39; SELECT 1;
1003
21
SET SESSION query_exec_time=0.4; SELECT 1;
1004
22
SET SESSION query_exec_time=1.1; SELECT 1;
1005
23
SET SESSION query_exec_time=1.2; SELECT 1;
1006
24
SET SESSION query_exec_time=1.3; SELECT 1;
1007
25
SET SESSION query_exec_time=1.5; SELECT 1;
1008
26
SET SESSION query_exec_time=1.4; SELECT 1;
1009
27
SET SESSION query_exec_time=0.5; SELECT 1;
1010
28
SET SESSION query_exec_time=2.1; SELECT 1;
1011
29
SET SESSION query_exec_time=2.3; SELECT 1;
1012
30
SET SESSION query_exec_time=2.5; SELECT 1;
1013
31
SET SESSION query_exec_time=3.1; SELECT 1;
1014
32
SET SESSION query_exec_time=4.1; SELECT 1;
1015
33
SET SESSION query_exec_time=5.1; SELECT 1;
1016
34
1017
35
SET SESSION query_exec_time=0.1;
1018
36
1019
37
SET GLOBAL QUERY_RESPONSE_TIME_STATS=0;
1020
38
1021
39
SHOW GLOBAL VARIABLES where Variable_name like 'QUERY_RESPONSE_TIME_RANGE_BASE';
1022
40
SHOW QUERY_RESPONSE_TIME;
1023
41
SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
1024
42
1025
43
SET SESSION query_exec_time=default;
1026
44
0
1027
=== added file 'Percona-Server/mysql-test/lib/Subunit.pm'
1028
--- Percona-Server/mysql-test/lib/Subunit.pm	1970-01-01 00:00:00 +0000
1029
+++ Percona-Server/mysql-test/lib/Subunit.pm	2013-05-26 07:24:39 +0000
1030
@@ -0,0 +1,94 @@
1031
1
# Perl module for parsing and generating the Subunit protocol
1032
2
# Copyright (C) 2008-2009 Jelmer Vernooij <jelmer@samba.org>
1033
3
#
1034
4
#  Licensed under either the Apache License, Version 2.0 or the BSD 3-clause
1035
5
#  license at the users choice. A copy of both licenses are available in the
1036
6
#  project source as Apache-2.0 and BSD. You may not use this file except in
1037
7
#  compliance with one of these two licences.
1038
8
#
1039
9
#  Unless required by applicable law or agreed to in writing, software
1040
10
#  distributed under these licenses is distributed on an "AS IS" BASIS, WITHOUT
1041
11
#  WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  See the
1042
12
#  license you chose for the specific language governing permissions and
1043
13
#  limitations under that license.
1044
14
1045
15
package Subunit;
1046
16
use POSIX;
1047
17
1048
18
use vars qw ( $VERSION );
1049
19
1050
20
$VERSION = '0.0.2';
1051
21
1052
22
use strict;
1053
23
my $SUBUNIT_OUT= 'test_results.subunit';
1054
24
# reset the file
1055
25
open(SUBUNITOUT, ">$SUBUNIT_OUT");
1056
26
close(SUBUNITOUT);
1057
27
1058
28
sub subunit_start_test($)
1059
29
{
1060
30
	my ($testname) = @_;
1061
31
        open(SUBUNITOUT, ">>$SUBUNIT_OUT");
1062
32
	print SUBUNITOUT "test: $testname\n";
1063
33
        close(SUBUNITOUT);
1064
34
        return;
1065
35
}
1066
36
1067
37
sub subunit_end_test($$;$)
1068
38
{
1069
39
	my $name = shift;
1070
40
	my $result = shift;
1071
41
	my $reason = shift;
1072
42
        open(SUBUNITOUT, ">>$SUBUNIT_OUT");
1073
43
	if ($reason) {
1074
44
		print SUBUNITOUT "$result: $name [\n";
1075
45
		print SUBUNITOUT "$reason\n";
1076
46
		print SUBUNITOUT "]\n";
1077
47
	} else {
1078
48
		print SUBUNITOUT "$result: $name\n";
1079
49
	}
1080
50
        close(SUBUNITOUT);
1081
51
        return;
1082
52
}
1083
53
1084
54
sub subunit_skip_test($;$)
1085
55
{
1086
56
	my $name = shift;
1087
57
	my $reason = shift;
1088
58
	subunit_end_test($name, "skip", $reason);
1089
59
}
1090
60
1091
61
sub subunit_fail_test($;$)
1092
62
{
1093
63
	my $name = shift;
1094
64
	my $reason = shift;
1095
65
	subunit_end_test($name, "failure", $reason);
1096
66
}
1097
67
1098
68
sub subunit_pass_test($;$)
1099
69
{
1100
70
	my $name = shift;
1101
71
	my $reason = shift;
1102
72
	subunit_end_test($name, "success", $reason);
1103
73
}
1104
74
1105
75
sub subunit_xfail_test($;$)
1106
76
{
1107
77
	my $name = shift;
1108
78
	my $reason = shift;
1109
79
	subunit_end_test($name, "xfail", $reason);
1110
80
}
1111
81
1112
82
sub report_time($)
1113
83
{
1114
84
	my ($time) = @_;
1115
85
	my ($sec, $min, $hour, $mday, $mon, $year, $wday, $yday, $isdst) = localtime($time);
1116
86
        open(SUBUNITOUT, ">>$SUBUNIT_OUT");
1117
87
	printf SUBUNITOUT "time: %04d-%02d-%02d %02d:%02d:%02dZ\n", $year+1900, ($mon+1), $mday, $hour, $min, $sec;
1118
88
        close(SUBUNITOUT);
1119
89
        return;
1120
90
}
1121
91
1122
92
1123
93
1124
94
1;
1125
0
95
1126
=== removed file 'Percona-Server/mysql-test/lib/Subunit.pm'
1127
--- Percona-Server/mysql-test/lib/Subunit.pm	2012-04-18 23:26:32 +0000
1128
+++ Percona-Server/mysql-test/lib/Subunit.pm	1970-01-01 00:00:00 +0000
1129
@@ -1,94 +0,0 @@
1130
1
# Perl module for parsing and generating the Subunit protocol
1131
2
# Copyright (C) 2008-2009 Jelmer Vernooij <jelmer@samba.org>
1132
3
#
1133
4
#  Licensed under either the Apache License, Version 2.0 or the BSD 3-clause
1134
5
#  license at the users choice. A copy of both licenses are available in the
1135
6
#  project source as Apache-2.0 and BSD. You may not use this file except in
1136
7
#  compliance with one of these two licences.
1137
8
#
1138
9
#  Unless required by applicable law or agreed to in writing, software
1139
10
#  distributed under these licenses is distributed on an "AS IS" BASIS, WITHOUT
1140
11
#  WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  See the
1141
12
#  license you chose for the specific language governing permissions and
1142
13
#  limitations under that license.
1143
14
1144
15
package Subunit;
1145
16
use POSIX;
1146
17
1147
18
use vars qw ( $VERSION );
1148
19
1149
20
$VERSION = '0.0.2';
1150
21
1151
22
use strict;
1152
23
my $SUBUNIT_OUT= 'test_results.subunit';
1153
24
# reset the file
1154
25
open(SUBUNITOUT, ">$SUBUNIT_OUT");
1155
26
close(SUBUNITOUT);
1156
27
1157
28
sub subunit_start_test($)
1158
29
{
1159
30
	my ($testname) = @_;
1160
31
        open(SUBUNITOUT, ">>$SUBUNIT_OUT");
1161
32
	print SUBUNITOUT "test: $testname\n";
1162
33
        close(SUBUNITOUT);
1163
34
        return;
1164
35
}
1165
36
1166
37
sub subunit_end_test($$;$)
1167
38
{
1168
39
	my $name = shift;
1169
40
	my $result = shift;
1170
41
	my $reason = shift;
1171
42
        open(SUBUNITOUT, ">>$SUBUNIT_OUT");
1172
43
	if ($reason) {
1173
44
		print SUBUNITOUT "$result: $name [\n";
1174
45
		print SUBUNITOUT "$reason\n";
1175
46
		print SUBUNITOUT "]\n";
1176
47
	} else {
1177
48
		print SUBUNITOUT "$result: $name\n";
1178
49
	}
1179
50
        close(SUBUNITOUT);
1180
51
        return;
1181
52
}
1182
53
1183
54
sub subunit_skip_test($;$)
1184
55
{
1185
56
	my $name = shift;
1186
57
	my $reason = shift;
1187
58
	subunit_end_test($name, "skip", $reason);
1188
59
}
1189
60
1190
61
sub subunit_fail_test($;$)
1191
62
{
1192
63
	my $name = shift;
1193
64
	my $reason = shift;
1194
65
	subunit_end_test($name, "failure", $reason);
1195
66
}
1196
67
1197
68
sub subunit_pass_test($;$)
1198
69
{
1199
70
	my $name = shift;
1200
71
	my $reason = shift;
1201
72
	subunit_end_test($name, "success", $reason);
1202
73
}
1203
74
1204
75
sub subunit_xfail_test($;$)
1205
76
{
1206
77
	my $name = shift;
1207
78
	my $reason = shift;
1208
79
	subunit_end_test($name, "xfail", $reason);
1209
80
}
1210
81
1211
82
sub report_time($)
1212
83
{
1213
84
	my ($time) = @_;
1214
85
	my ($sec, $min, $hour, $mday, $mon, $year, $wday, $yday, $isdst) = localtime($time);
1215
86
        open(SUBUNITOUT, ">>$SUBUNIT_OUT");
1216
87
	printf SUBUNITOUT "time: %04d-%02d-%02d %02d:%02d:%02dZ\n", $year+1900, ($mon+1), $mday, $hour, $min, $sec;
1217
88
        close(SUBUNITOUT);
1218
89
        return;
1219
90
}
1220
91
1221
92
1222
93
1223
94
1;
1224
95
0
1225
=== added file 'Percona-Server/mysql-test/r/have_response_time_distribution.require'
1226
--- Percona-Server/mysql-test/r/have_response_time_distribution.require	1970-01-01 00:00:00 +0000
1227
+++ Percona-Server/mysql-test/r/have_response_time_distribution.require	2013-05-26 07:24:39 +0000
1228
@@ -0,0 +1,2 @@
1229
1
Variable_name	Value
1230
2
have_response_time_distribution	YES
1231
0
3
1232
=== removed file 'Percona-Server/mysql-test/r/have_response_time_distribution.require'
1233
--- Percona-Server/mysql-test/r/have_response_time_distribution.require	2012-04-18 23:25:50 +0000
1234
+++ Percona-Server/mysql-test/r/have_response_time_distribution.require	1970-01-01 00:00:00 +0000
1235
@@ -1,2 +0,0 @@
1236
1
Variable_name	Value
1237
2
have_response_time_distribution	YES
1238
3
0
1239
=== added file 'Percona-Server/mysql-test/r/percona_bug45702.result'
1240
--- Percona-Server/mysql-test/r/percona_bug45702.result	1970-01-01 00:00:00 +0000
1241
+++ Percona-Server/mysql-test/r/percona_bug45702.result	2013-05-26 07:24:39 +0000
1242
@@ -0,0 +1,21 @@
1243
1
CREATE TABLE t1 (a BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY) ENGINE=MyISAM;
1244
2
INSERT INTO t1 VALUES (), (), (), (), (), (), (), ();
1245
3
INSERT INTO t1 SELECT NULL FROM t1;
1246
4
INSERT INTO t1 SELECT NULL FROM t1;
1247
5
INSERT INTO t1 SELECT NULL FROM t1;
1248
6
INSERT INTO t1 SELECT NULL FROM t1;
1249
7
INSERT INTO t1 SELECT NULL FROM t1;
1250
8
INSERT INTO t1 SELECT NULL FROM t1;
1251
9
INSERT INTO t1 SELECT NULL FROM t1;
1252
10
INSERT INTO t1 SELECT NULL FROM t1;
1253
11
INSERT INTO t1 SELECT NULL FROM t1;
1254
12
SET @old_myisam_sort_buffer_size = @@myisam_sort_buffer_size;
1255
13
SET @@myisam_sort_buffer_size = 4 * 1024 * 1024 * 1024;
1256
14
REPAIR TABLE t1;
1257
15
Table	Op	Msg_type	Msg_text
1258
16
test.t1	repair	status	OK
1259
17
- recovering (with sort) MyISAM-table 'MYSQLD_DATADIR/test/t1'
1260
18
Data records: 4096
1261
19
- Fixing index 1
1262
20
SET @@myisam_sort_buffer_size = @old_myisam_sort_buffer_size;
1263
21
DROP TABLE t1;
1264
0
22
1265
=== removed file 'Percona-Server/mysql-test/r/percona_bug45702.result'
1266
--- Percona-Server/mysql-test/r/percona_bug45702.result	2012-04-18 23:26:36 +0000
1267
+++ Percona-Server/mysql-test/r/percona_bug45702.result	1970-01-01 00:00:00 +0000
1268
@@ -1,21 +0,0 @@
1269
1
CREATE TABLE t1 (a BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY) ENGINE=MyISAM;
1270
2
INSERT INTO t1 VALUES (), (), (), (), (), (), (), ();
1271
3
INSERT INTO t1 SELECT NULL FROM t1;
1272
4
INSERT INTO t1 SELECT NULL FROM t1;
1273
5
INSERT INTO t1 SELECT NULL FROM t1;
1274
6
INSERT INTO t1 SELECT NULL FROM t1;
1275
7
INSERT INTO t1 SELECT NULL FROM t1;
1276
8
INSERT INTO t1 SELECT NULL FROM t1;
1277
9
INSERT INTO t1 SELECT NULL FROM t1;
1278
10
INSERT INTO t1 SELECT NULL FROM t1;
1279
11
INSERT INTO t1 SELECT NULL FROM t1;
1280
12
SET @old_myisam_sort_buffer_size = @@myisam_sort_buffer_size;
1281
13
SET @@myisam_sort_buffer_size = 4 * 1024 * 1024 * 1024;
1282
14
REPAIR TABLE t1;
1283
15
Table	Op	Msg_type	Msg_text
1284
16
test.t1	repair	status	OK
1285
17
- recovering (with sort) MyISAM-table 'MYSQLD_DATADIR/test/t1'
1286
18
Data records: 4096
1287
19
- Fixing index 1
1288
20
SET @@myisam_sort_buffer_size = @old_myisam_sort_buffer_size;
1289
21
DROP TABLE t1;
1290
22
0
1291
=== added file 'Percona-Server/mysql-test/r/percona_bug933969.result'
1292
--- Percona-Server/mysql-test/r/percona_bug933969.result	1970-01-01 00:00:00 +0000
1293
+++ Percona-Server/mysql-test/r/percona_bug933969.result	2013-05-26 07:24:39 +0000
1294
@@ -0,0 +1,16 @@
1295
1
RESET MASTER;
1296
2
DROP TABLE IF EXISTS t1;
1297
3
CREATE TABLE t1 (word VARCHAR(20));
1298
4
INSERT INTO t1 VALUES ("hamite");
1299
5
INSERT INTO t1 VALUES ("hoho");
1300
6
INSERT INTO t1 VALUES ("znamenito");
1301
7
INSERT INTO t1 VALUES ("mrachny");
1302
8
INSERT INTO t1 VALUES ("mrak");
1303
9
INSERT INTO t1 VALUES ("zhut");
1304
10
INSERT INTO t1 VALUES ("parnisha");
1305
11
INSERT INTO t1 VALUES ("krrasota!");
1306
12
INSERT INTO t1 VALUES ("podumayesh");
1307
13
INSERT INTO t1 VALUES ("ogo!");
1308
14
FLUSH LOGS;
1309
15
DROP TABLE t1;
1310
16
RESET MASTER;
1311
0
17
1312
=== removed file 'Percona-Server/mysql-test/r/percona_bug933969.result'
1313
--- Percona-Server/mysql-test/r/percona_bug933969.result	2012-04-18 23:24:34 +0000
1314
+++ Percona-Server/mysql-test/r/percona_bug933969.result	1970-01-01 00:00:00 +0000
1315
@@ -1,16 +0,0 @@
1316
1
RESET MASTER;
1317
2
DROP TABLE IF EXISTS t1;
1318
3
CREATE TABLE t1 (word VARCHAR(20));
1319
4
INSERT INTO t1 VALUES ("hamite");
1320
5
INSERT INTO t1 VALUES ("hoho");
1321
6
INSERT INTO t1 VALUES ("znamenito");
1322
7
INSERT INTO t1 VALUES ("mrachny");
1323
8
INSERT INTO t1 VALUES ("mrak");
1324
9
INSERT INTO t1 VALUES ("zhut");
1325
10
INSERT INTO t1 VALUES ("parnisha");
1326
11
INSERT INTO t1 VALUES ("krrasota!");
1327
12
INSERT INTO t1 VALUES ("podumayesh");
1328
13
INSERT INTO t1 VALUES ("ogo!");
1329
14
FLUSH LOGS;
1330
15
DROP TABLE t1;
1331
16
RESET MASTER;
1332
17
0
1333
=== added file 'Percona-Server/mysql-test/r/percona_innodb_buffer_pool_shm.result'
1334
--- Percona-Server/mysql-test/r/percona_innodb_buffer_pool_shm.result	1970-01-01 00:00:00 +0000
1335
+++ Percona-Server/mysql-test/r/percona_innodb_buffer_pool_shm.result	2013-05-26 07:24:39 +0000
1336
@@ -0,0 +1,4 @@
1337
1
show variables like 'innodb_buffer_pool_shm%';
1338
2
Variable_name	Value
1339
3
innodb_buffer_pool_shm_checksum	ON
1340
4
innodb_buffer_pool_shm_key	123456
1341
0
5
1342
=== removed file 'Percona-Server/mysql-test/r/percona_innodb_buffer_pool_shm.result'
1343
--- Percona-Server/mysql-test/r/percona_innodb_buffer_pool_shm.result	2012-04-18 23:25:30 +0000
1344
+++ Percona-Server/mysql-test/r/percona_innodb_buffer_pool_shm.result	1970-01-01 00:00:00 +0000
1345
@@ -1,4 +0,0 @@
1346
1
show variables like 'innodb_buffer_pool_shm%';
1347
2
Variable_name	Value
1348
3
innodb_buffer_pool_shm_checksum	ON
1349
4
innodb_buffer_pool_shm_key	123456
1350
5
0
1351
=== added file 'Percona-Server/mysql-test/r/percona_innodb_deadlock_count.result'
1352
--- Percona-Server/mysql-test/r/percona_innodb_deadlock_count.result	1970-01-01 00:00:00 +0000
1353
+++ Percona-Server/mysql-test/r/percona_innodb_deadlock_count.result	2013-05-26 07:24:39 +0000
1354
@@ -0,0 +1,28 @@
1355
1
# Establish connection con1 (user=root)
1356
2
# Establish connection con2 (user=root)
1357
3
# Establish connection con3 (user=root)
1358
4
# Drop test table
1359
5
drop table if exists t;
1360
6
# Create test table
1361
7
create table t(a INT PRIMARY KEY, b INT) engine=InnoDB;
1362
8
# Insert two rows to test table
1363
9
insert into t values(2,1);
1364
10
insert into t values(1,2);
1365
11
# Switch to connection con1
1366
12
BEGIN;
1367
13
SELECT b FROM t WHERE a=1 FOR UPDATE;
1368
14
# Switch to connection con2
1369
15
BEGIN;
1370
16
SELECT b FROM t WHERE a=2 FOR UPDATE;
1371
17
# Switch to connection con1
1372
18
SELECT b FROM t WHERE a=2 FOR UPDATE;
1373
19
# Switch to connection con2
1374
20
SELECT b FROM t WHERE a=1 FOR UPDATE;
1375
21
# Switch to connection con1
1376
22
ROLLBACK;
1377
23
# Switch to connection con2
1378
24
ROLLBACK;
1379
25
# Switch to connection con3
1380
26
Deadlocks: 1
1381
27
# Drop test table
1382
28
drop table t;
1383
0
29
1384
=== removed file 'Percona-Server/mysql-test/r/percona_innodb_deadlock_count.result'
1385
--- Percona-Server/mysql-test/r/percona_innodb_deadlock_count.result	2012-04-18 23:25:25 +0000
1386
+++ Percona-Server/mysql-test/r/percona_innodb_deadlock_count.result	1970-01-01 00:00:00 +0000
1387
@@ -1,28 +0,0 @@
1388
1
# Establish connection con1 (user=root)
1389
2
# Establish connection con2 (user=root)
1390
3
# Establish connection con3 (user=root)
1391
4
# Drop test table
1392
5
drop table if exists t;
1393
6
# Create test table
1394
7
create table t(a INT PRIMARY KEY, b INT) engine=InnoDB;
1395
8
# Insert two rows to test table
1396
9
insert into t values(2,1);
1397
10
insert into t values(1,2);
1398
11
# Switch to connection con1
1399
12
BEGIN;
1400
13
SELECT b FROM t WHERE a=1 FOR UPDATE;
1401
14
# Switch to connection con2
1402
15
BEGIN;
1403
16
SELECT b FROM t WHERE a=2 FOR UPDATE;
1404
17
# Switch to connection con1
1405
18
SELECT b FROM t WHERE a=2 FOR UPDATE;
1406
19
# Switch to connection con2
1407
20
SELECT b FROM t WHERE a=1 FOR UPDATE;
1408
21
# Switch to connection con1
1409
22
ROLLBACK;
1410
23
# Switch to connection con2
1411
24
ROLLBACK;
1412
25
# Switch to connection con3
1413
26
Deadlocks: 1
1414
27
# Drop test table
1415
28
drop table t;
1416
29
0
1417
=== added file 'Percona-Server/mysql-test/r/percona_innodb_doublewrite_file.result'
1418
--- Percona-Server/mysql-test/r/percona_innodb_doublewrite_file.result	1970-01-01 00:00:00 +0000
1419
+++ Percona-Server/mysql-test/r/percona_innodb_doublewrite_file.result	2013-05-26 07:24:39 +0000
1420
@@ -0,0 +1,4 @@
1421
1
show variables like 'innodb_doublewrite%';
1422
2
Variable_name	Value
1423
3
innodb_doublewrite	ON
1424
4
innodb_doublewrite_file	ib_doublewrite
1425
0
5
1426
=== removed file 'Percona-Server/mysql-test/r/percona_innodb_doublewrite_file.result'
1427
--- Percona-Server/mysql-test/r/percona_innodb_doublewrite_file.result	2012-04-18 23:25:15 +0000
1428
+++ Percona-Server/mysql-test/r/percona_innodb_doublewrite_file.result	1970-01-01 00:00:00 +0000
1429
@@ -1,4 +0,0 @@
1430
1
show variables like 'innodb_doublewrite%';
1431
2
Variable_name	Value
1432
3
innodb_doublewrite	ON
1433
4
innodb_doublewrite_file	ib_doublewrite
1434
5
0
1435
=== added file 'Percona-Server/mysql-test/r/percona_innodb_expand_fast_index_creation.result'
1436
--- Percona-Server/mysql-test/r/percona_innodb_expand_fast_index_creation.result	1970-01-01 00:00:00 +0000
1437
+++ Percona-Server/mysql-test/r/percona_innodb_expand_fast_index_creation.result	2013-05-26 07:24:39 +0000
1438
@@ -0,0 +1,64 @@
1439
1
CREATE TABLE t1(
1440
2
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
1441
3
a CHAR(1) NOT NULL,
1442
4
b CHAR(36) NOT NULL) ENGINE=InnoDB;
1443
5
INSERT INTO t1(a,b) VALUES ('a','b');
1444
6
INSERT INTO t1(a,b) SELECT a,b FROM t1;
1445
7
INSERT INTO t1(a,b) SELECT a,b FROM t1;
1446
8
INSERT INTO t1(a,b) SELECT a,b FROM t1;
1447
9
INSERT INTO t1(a,b) SELECT a,b FROM t1;
1448
10
ALTER TABLE t1 ADD KEY (a);
1449
11
affected rows: 0
1450
12
info: Records: 0  Duplicates: 0  Warnings: 0
1451
13
EXPLAIN SELECT COUNT(*) FROM t1, t1 t2 WHERE t1.a = t2.a AND t1.b = t2.b;
1452
14
id	1
1453
15
select_type	SIMPLE
1454
16
table	t1
1455
17
type	ALL
1456
18
possible_keys	a
1457
19
key	NULL
1458
20
key_len	NULL
1459
21
ref	NULL
1460
22
rows	16
1461
23
Extra	
1462
24
id	1
1463
25
select_type	SIMPLE
1464
26
table	t2
1465
27
type	ref
1466
28
possible_keys	a
1467
29
key	a
1468
30
key_len	1
1469
31
ref	test.t1.a
1470
32
rows	1
1471
33
Extra	Using where
1472
34
ALTER TABLE t1 DROP KEY a;
1473
35
SET expand_fast_index_creation = 1;
1474
36
SELECT @@expand_fast_index_creation;
1475
37
@@expand_fast_index_creation
1476
38
1
1477
39
ALTER TABLE t1 ADD KEY (a);
1478
40
affected rows: 0
1479
41
info: Records: 0  Duplicates: 0  Warnings: 0
1480
42
EXPLAIN SELECT COUNT(*) FROM t1, t1 t2 WHERE t1.a = t2.a AND t1.b = t2.b;
1481
43
id	1
1482
44
select_type	SIMPLE
1483
45
table	t1
1484
46
type	ALL
1485
47
possible_keys	a
1486
48
key	NULL
1487
49
key_len	NULL
1488
50
ref	NULL
1489
51
rows	16
1490
52
Extra	
1491
53
id	1
1492
54
select_type	SIMPLE
1493
55
table	t2
1494
56
type	ALL
1495
57
possible_keys	a
1496
58
key	NULL
1497
59
key_len	NULL
1498
60
ref	NULL
1499
61
rows	16
1500
62
Extra	Using where; Using join buffer
1501
63
SET expand_fast_index_creation = 0;
1502
64
DROP TABLE t1;
1503
0
65
1504
=== removed file 'Percona-Server/mysql-test/r/percona_innodb_expand_fast_index_creation.result'
1505
--- Percona-Server/mysql-test/r/percona_innodb_expand_fast_index_creation.result	2012-04-18 23:26:09 +0000
1506
+++ Percona-Server/mysql-test/r/percona_innodb_expand_fast_index_creation.result	1970-01-01 00:00:00 +0000
1507
@@ -1,64 +0,0 @@
1508
1
CREATE TABLE t1(
1509
2
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
1510
3
a CHAR(1) NOT NULL,
1511
4
b CHAR(36) NOT NULL) ENGINE=InnoDB;
1512
5
INSERT INTO t1(a,b) VALUES ('a','b');
1513
6
INSERT INTO t1(a,b) SELECT a,b FROM t1;
1514
7
INSERT INTO t1(a,b) SELECT a,b FROM t1;
1515
8
INSERT INTO t1(a,b) SELECT a,b FROM t1;
1516
9
INSERT INTO t1(a,b) SELECT a,b FROM t1;
1517
10
ALTER TABLE t1 ADD KEY (a);
1518
11
affected rows: 0
1519
12
info: Records: 0  Duplicates: 0  Warnings: 0
1520
13
EXPLAIN SELECT COUNT(*) FROM t1, t1 t2 WHERE t1.a = t2.a AND t1.b = t2.b;
1521
14
id	1
1522
15
select_type	SIMPLE
1523
16
table	t1
1524
17
type	ALL
1525
18
possible_keys	a
1526
19
key	NULL
1527
20
key_len	NULL
1528
21
ref	NULL
1529
22
rows	16
1530
23
Extra	
1531
24
id	1
1532
25
select_type	SIMPLE
1533
26
table	t2
1534
27
type	ref
1535
28
possible_keys	a
1536
29
key	a
1537
30
key_len	1
1538
31
ref	test.t1.a
1539
32
rows	1
1540
33
Extra	Using where
1541
34
ALTER TABLE t1 DROP KEY a;
1542
35
SET expand_fast_index_creation = 1;
1543
36
SELECT @@expand_fast_index_creation;
1544
37
@@expand_fast_index_creation
1545
38
1
1546
39
ALTER TABLE t1 ADD KEY (a);
1547
40
affected rows: 0
1548
41
info: Records: 0  Duplicates: 0  Warnings: 0
1549
42
EXPLAIN SELECT COUNT(*) FROM t1, t1 t2 WHERE t1.a = t2.a AND t1.b = t2.b;
1550
43
id	1
1551
44
select_type	SIMPLE
1552
45
table	t1
1553
46
type	ALL
1554
47
possible_keys	a
1555
48
key	NULL
1556
49
key_len	NULL
1557
50
ref	NULL
1558
51
rows	16
1559
52
Extra	
1560
53
id	1
1561
54
select_type	SIMPLE
1562
55
table	t2
1563
56
type	ALL
1564
57
possible_keys	a
1565
58
key	NULL
1566
59
key_len	NULL
1567
60
ref	NULL
1568
61
rows	16
1569
62
Extra	Using where; Using join buffer
1570
63
SET expand_fast_index_creation = 0;
1571
64
DROP TABLE t1;
1572
65
0
1573
=== added file 'Percona-Server/mysql-test/r/percona_innodb_use_sys_stats_table.result'
1574
--- Percona-Server/mysql-test/r/percona_innodb_use_sys_stats_table.result	1970-01-01 00:00:00 +0000
1575
+++ Percona-Server/mysql-test/r/percona_innodb_use_sys_stats_table.result	2013-05-26 07:24:39 +0000
1576
@@ -0,0 +1,3 @@
1577
1
show variables like 'innodb_use_sys_stats%';
1578
2
Variable_name	Value
1579
3
innodb_use_sys_stats_table	ON
1580
0
4
1581
=== removed file 'Percona-Server/mysql-test/r/percona_innodb_use_sys_stats_table.result'
1582
--- Percona-Server/mysql-test/r/percona_innodb_use_sys_stats_table.result	2012-04-18 23:25:04 +0000
1583
+++ Percona-Server/mysql-test/r/percona_innodb_use_sys_stats_table.result	1970-01-01 00:00:00 +0000
1584
@@ -1,3 +0,0 @@
1585
1
show variables like 'innodb_use_sys_stats%';
1586
2
Variable_name	Value
1587
3
innodb_use_sys_stats_table	ON
1588
4
0
1589
=== added file 'Percona-Server/mysql-test/r/percona_innodb_version.result'
1590
--- Percona-Server/mysql-test/r/percona_innodb_version.result	1970-01-01 00:00:00 +0000
1591
+++ Percona-Server/mysql-test/r/percona_innodb_version.result	2013-05-26 07:24:39 +0000
1592
@@ -0,0 +1,3 @@
1593
1
SELECT @@innodb_version;
1594
2
@@innodb_version
1595
3
5.5.x-x.x
1596
0
4
1597
=== removed file 'Percona-Server/mysql-test/r/percona_innodb_version.result'
1598
--- Percona-Server/mysql-test/r/percona_innodb_version.result	2013-02-18 04:48:10 +0000
1599
+++ Percona-Server/mysql-test/r/percona_innodb_version.result	1970-01-01 00:00:00 +0000
1600
@@ -1,3 +0,0 @@
1601
1
SELECT @@innodb_version;
1602
2
@@innodb_version
1603
3
5.5.x-x.x
1604
4
0
1605
=== added file 'Percona-Server/mysql-test/r/percona_log_connection_error.result'
1606
--- Percona-Server/mysql-test/r/percona_log_connection_error.result	1970-01-01 00:00:00 +0000
1607
+++ Percona-Server/mysql-test/r/percona_log_connection_error.result	2013-05-26 07:24:39 +0000
1608
@@ -0,0 +1,16 @@
1609
1
SET @old_max_connections = @@max_connections;
1610
2
SET @old_log_warnings = @@log_warnings;
1611
3
SET GLOBAL max_connections=2;
1612
4
SET GLOBAL LOG_WARNINGS = 0;
1613
5
connect(localhost,root,,test,port,socket);
1614
6
ERROR HY000: Too many connections
1615
7
SET GLOBAL LOG_WARNINGS = 1;
1616
8
connect(localhost,root,,test,port,socket);
1617
9
ERROR HY000: Too many connections
1618
10
SET GLOBAL LOG_WARNINGS = 0;
1619
11
connect(localhost,root,,test,port,socket);
1620
12
ERROR HY000: Too many connections
1621
13
SET GLOBAL max_connections = @old_max_connections;
1622
14
SET GLOBAL log_warnings = @old_log_warnings;
1623
15
[log_grep.inc] file: percona.log_connection_error.err pattern: Too many connections
1624
16
[log_grep.inc] lines:   1
1625
0
17
1626
=== removed file 'Percona-Server/mysql-test/r/percona_log_connection_error.result'
1627
--- Percona-Server/mysql-test/r/percona_log_connection_error.result	2012-04-18 23:25:45 +0000
1628
+++ Percona-Server/mysql-test/r/percona_log_connection_error.result	1970-01-01 00:00:00 +0000
1629
@@ -1,16 +0,0 @@
1630
1
SET @old_max_connections = @@max_connections;
1631
2
SET @old_log_warnings = @@log_warnings;
1632
3
SET GLOBAL max_connections=2;
1633
4
SET GLOBAL LOG_WARNINGS = 0;
1634
5
connect(localhost,root,,test,port,socket);
1635
6
ERROR HY000: Too many connections
1636
7
SET GLOBAL LOG_WARNINGS = 1;
1637
8
connect(localhost,root,,test,port,socket);
1638
9
ERROR HY000: Too many connections
1639
10
SET GLOBAL LOG_WARNINGS = 0;
1640
11
connect(localhost,root,,test,port,socket);
1641
12
ERROR HY000: Too many connections
1642
13
SET GLOBAL max_connections = @old_max_connections;
1643
14
SET GLOBAL log_warnings = @old_log_warnings;
1644
15
[log_grep.inc] file: percona.log_connection_error.err pattern: Too many connections
1645
16
[log_grep.inc] lines:   1
1646
17
0
1647
=== added file 'Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config.result'
1648
--- Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config.result	1970-01-01 00:00:00 +0000
1649
+++ Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config.result	2013-05-26 07:24:39 +0000
1650
@@ -0,0 +1,6 @@
1651
1
SHOW GLOBAL VARIABLES like 'log_slow_admin_statements';
1652
2
Variable_name	Value
1653
3
log_slow_admin_statements	ON
1654
4
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='log_slow_admin_statements';
1655
5
VARIABLE_NAME	VARIABLE_VALUE
1656
6
LOG_SLOW_ADMIN_STATEMENTS	ON
1657
0
7
1658
=== removed file 'Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config.result'
1659
--- Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config.result	2012-04-18 23:25:38 +0000
1660
+++ Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config.result	1970-01-01 00:00:00 +0000
1661
@@ -1,6 +0,0 @@
1662
1
SHOW GLOBAL VARIABLES like 'log_slow_admin_statements';
1663
2
Variable_name	Value
1664
3
log_slow_admin_statements	ON
1665
4
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='log_slow_admin_statements';
1666
5
VARIABLE_NAME	VARIABLE_VALUE
1667
6
LOG_SLOW_ADMIN_STATEMENTS	ON
1668
7
0
1669
=== added file 'Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config_false.result'
1670
--- Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config_false.result	1970-01-01 00:00:00 +0000
1671
+++ Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config_false.result	2013-05-26 07:24:39 +0000
1672
@@ -0,0 +1,6 @@
1673
1
SHOW GLOBAL VARIABLES like 'log_slow_admin_statements';
1674
2
Variable_name	Value
1675
3
log_slow_admin_statements	OFF
1676
4
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='log_slow_admin_statements';
1677
5
VARIABLE_NAME	VARIABLE_VALUE
1678
6
LOG_SLOW_ADMIN_STATEMENTS	OFF
1679
0
7
1680
=== removed file 'Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config_false.result'
1681
--- Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config_false.result	2012-04-18 23:25:38 +0000
1682
+++ Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config_false.result	1970-01-01 00:00:00 +0000
1683
@@ -1,6 +0,0 @@
1684
1
SHOW GLOBAL VARIABLES like 'log_slow_admin_statements';
1685
2
Variable_name	Value
1686
3
log_slow_admin_statements	OFF
1687
4
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='log_slow_admin_statements';
1688
5
VARIABLE_NAME	VARIABLE_VALUE
1689
6
LOG_SLOW_ADMIN_STATEMENTS	OFF
1690
7
0
1691
=== added file 'Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config_foo.result'
1692
--- Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config_foo.result	1970-01-01 00:00:00 +0000
1693
+++ Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config_foo.result	2013-05-26 07:24:39 +0000
1694
@@ -0,0 +1,7 @@
1695
1
call mtr.add_suppression("option 'log_slow_admin_statements': boolean value 'foo' wasn't recognized. Set to OFF.");
1696
2
SHOW GLOBAL VARIABLES like 'log_slow_admin_statements';
1697
3
Variable_name	Value
1698
4
log_slow_admin_statements	OFF
1699
5
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='log_slow_admin_statements';
1700
6
VARIABLE_NAME	VARIABLE_VALUE
1701
7
LOG_SLOW_ADMIN_STATEMENTS	OFF
1702
0
8
1703
=== removed file 'Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config_foo.result'
1704
--- Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config_foo.result	2012-04-18 23:25:38 +0000
1705
+++ Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config_foo.result	1970-01-01 00:00:00 +0000
1706
@@ -1,7 +0,0 @@
1707
1
call mtr.add_suppression("option 'log_slow_admin_statements': boolean value 'foo' wasn't recognized. Set to OFF.");
1708
2
SHOW GLOBAL VARIABLES like 'log_slow_admin_statements';
1709
3
Variable_name	Value
1710
4
log_slow_admin_statements	OFF
1711
5
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='log_slow_admin_statements';
1712
6
VARIABLE_NAME	VARIABLE_VALUE
1713
7
LOG_SLOW_ADMIN_STATEMENTS	OFF
1714
8
0
1715
=== added file 'Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config_true.result'
1716
--- Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config_true.result	1970-01-01 00:00:00 +0000
1717
+++ Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config_true.result	2013-05-26 07:24:39 +0000
1718
@@ -0,0 +1,6 @@
1719
1
SHOW GLOBAL VARIABLES like 'log_slow_admin_statements';
1720
2
Variable_name	Value
1721
3
log_slow_admin_statements	ON
1722
4
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='log_slow_admin_statements';
1723
5
VARIABLE_NAME	VARIABLE_VALUE
1724
6
LOG_SLOW_ADMIN_STATEMENTS	ON
1725
0
7
1726
=== removed file 'Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config_true.result'
1727
--- Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config_true.result	2012-04-18 23:25:38 +0000
1728
+++ Percona-Server/mysql-test/r/percona_log_slow_admin_statements-config_true.result	1970-01-01 00:00:00 +0000
1729
@@ -1,6 +0,0 @@
1730
1
SHOW GLOBAL VARIABLES like 'log_slow_admin_statements';
1731
2
Variable_name	Value
1732
3
log_slow_admin_statements	ON
1733
4
SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='log_slow_admin_statements';
1734
5
VARIABLE_NAME	VARIABLE_VALUE
1735
6
LOG_SLOW_ADMIN_STATEMENTS	ON
1736
7
0
1737
=== added file 'Percona-Server/mysql-test/r/percona_log_slow_filter-cl.result'
1738
--- Percona-Server/mysql-test/r/percona_log_slow_filter-cl.result	1970-01-01 00:00:00 +0000
1739
+++ Percona-Server/mysql-test/r/percona_log_slow_filter-cl.result	2013-05-26 07:24:39 +0000
1740
@@ -0,0 +1,6 @@
1741
1
SHOW VARIABLES LIKE 'log_slow_filter';
1742
2
Variable_name	Value
1743
3
log_slow_filter	full_join
1744
4
SHOW GLOBAL VARIABLES LIKE 'log_slow_filter';
1745
5
Variable_name	Value
1746
6
log_slow_filter	full_join
1747
0
7
1748
=== removed file 'Percona-Server/mysql-test/r/percona_log_slow_filter-cl.result'
1749
--- Percona-Server/mysql-test/r/percona_log_slow_filter-cl.result	2012-04-18 23:25:38 +0000
1750
+++ Percona-Server/mysql-test/r/percona_log_slow_filter-cl.result	1970-01-01 00:00:00 +0000
1751
@@ -1,6 +0,0 @@
1752
1
SHOW VARIABLES LIKE 'log_slow_filter';
1753
2
Variable_name	Value
1754
3
log_slow_filter	full_join
1755
4
SHOW GLOBAL VARIABLES LIKE 'log_slow_filter';
1756
5
Variable_name	Value
1757
6
log_slow_filter	full_join
1758
7
0
1759
=== added file 'Percona-Server/mysql-test/r/percona_log_slow_slave_statements-cl.result'
1760
--- Percona-Server/mysql-test/r/percona_log_slow_slave_statements-cl.result	1970-01-01 00:00:00 +0000
1761
+++ Percona-Server/mysql-test/r/percona_log_slow_slave_statements-cl.result	2013-05-26 07:24:39 +0000
1762
@@ -0,0 +1,6 @@
1763
1
SHOW VARIABLES LIKE 'log_slow_slave_statements';
1764
2
Variable_name	Value
1765
3
log_slow_slave_statements	ON
1766
4
SHOW GLOBAL VARIABLES LIKE 'log_slow_slave_statements';
1767
5
Variable_name	Value
1768
6
log_slow_slave_statements	ON
1769
0
7
1770
=== removed file 'Percona-Server/mysql-test/r/percona_log_slow_slave_statements-cl.result'
1771
--- Percona-Server/mysql-test/r/percona_log_slow_slave_statements-cl.result	2012-04-18 23:25:38 +0000
1772
+++ Percona-Server/mysql-test/r/percona_log_slow_slave_statements-cl.result	1970-01-01 00:00:00 +0000
1773
@@ -1,6 +0,0 @@
1774
1
SHOW VARIABLES LIKE 'log_slow_slave_statements';
1775
2
Variable_name	Value
1776
3
log_slow_slave_statements	ON
1777
4
SHOW GLOBAL VARIABLES LIKE 'log_slow_slave_statements';
1778
5
Variable_name	Value
1779
6
log_slow_slave_statements	ON
1780
7
0
1781
=== added file 'Percona-Server/mysql-test/r/percona_log_slow_sp_statements-cl.result'
1782
--- Percona-Server/mysql-test/r/percona_log_slow_sp_statements-cl.result	1970-01-01 00:00:00 +0000
1783
+++ Percona-Server/mysql-test/r/percona_log_slow_sp_statements-cl.result	2013-05-26 07:24:39 +0000
1784
@@ -0,0 +1,6 @@
1785
1
SHOW VARIABLES LIKE 'log_slow_sp_statements';
1786
2
Variable_name	Value
1787
3
log_slow_sp_statements	ON
1788
4
SHOW GLOBAL VARIABLES LIKE 'log_slow_sp_statements';
1789
5
Variable_name	Value
1790
6
log_slow_sp_statements	ON
1791
0
7
1792
=== removed file 'Percona-Server/mysql-test/r/percona_log_slow_sp_statements-cl.result'
1793
--- Percona-Server/mysql-test/r/percona_log_slow_sp_statements-cl.result	2012-04-18 23:25:38 +0000
1794
+++ Percona-Server/mysql-test/r/percona_log_slow_sp_statements-cl.result	1970-01-01 00:00:00 +0000
1795
@@ -1,6 +0,0 @@
1796
1
SHOW VARIABLES LIKE 'log_slow_sp_statements';
1797
2
Variable_name	Value
1798
3
log_slow_sp_statements	ON
1799
4
SHOW GLOBAL VARIABLES LIKE 'log_slow_sp_statements';
1800
5
Variable_name	Value
1801
6
log_slow_sp_statements	ON
1802
7
0
1803
=== added file 'Percona-Server/mysql-test/r/percona_log_slow_verbosity-cl.result'
1804
--- Percona-Server/mysql-test/r/percona_log_slow_verbosity-cl.result	1970-01-01 00:00:00 +0000
1805
+++ Percona-Server/mysql-test/r/percona_log_slow_verbosity-cl.result	2013-05-26 07:24:39 +0000
1806
@@ -0,0 +1,6 @@
1807
1
SHOW VARIABLES LIKE 'log_slow_verbosity';
1808
2
Variable_name	Value
1809
3
log_slow_verbosity	microtime,query_plan,innodb
1810
4
SHOW GLOBAL VARIABLES LIKE 'log_slow_verbosity';
1811
5
Variable_name	Value
1812
6
log_slow_verbosity	microtime,query_plan,innodb
1813
0
7
1814
=== removed file 'Percona-Server/mysql-test/r/percona_log_slow_verbosity-cl.result'
1815
--- Percona-Server/mysql-test/r/percona_log_slow_verbosity-cl.result	2012-04-18 23:25:38 +0000
1816
+++ Percona-Server/mysql-test/r/percona_log_slow_verbosity-cl.result	1970-01-01 00:00:00 +0000
1817
@@ -1,6 +0,0 @@
1818
1
SHOW VARIABLES LIKE 'log_slow_verbosity';
1819
2
Variable_name	Value
1820
3
log_slow_verbosity	microtime,query_plan,innodb
1821
4
SHOW GLOBAL VARIABLES LIKE 'log_slow_verbosity';
1822
5
Variable_name	Value
1823
6
log_slow_verbosity	microtime,query_plan,innodb
1824
7
0
1825
=== added file 'Percona-Server/mysql-test/r/percona_min_examined_row_limit.result'
1826
--- Percona-Server/mysql-test/r/percona_min_examined_row_limit.result	1970-01-01 00:00:00 +0000
1827
+++ Percona-Server/mysql-test/r/percona_min_examined_row_limit.result	2013-05-26 07:24:39 +0000
1828
@@ -0,0 +1,35 @@
1829
1
drop table if exists t;
1830
2
create table t(id INT PRIMARY KEY);
1831
3
insert into t values(1);
1832
4
insert into t values(2);
1833
5
insert into t values(3);
1834
6
SET GLOBAL long_query_time=2;
1835
7
SET GLOBAL slow_query_log_use_global_control='long_query_time,min_examined_row_limit';
1836
8
[log_start.inc] percona.slow_extended.min_examined_row_limit
1837
9
SET SESSION query_exec_time=2.1;
1838
10
SELECT 1;
1839
11
1
1840
12
1
1841
13
SET GLOBAL min_examined_row_limit=5;
1842
14
SELECT * FROM t AS t1, t AS t2;
1843
15
id	id
1844
16
1	1
1845
17
2	1
1846
18
3	1
1847
19
1	2
1848
20
2	2
1849
21
3	2
1850
22
1	3
1851
23
2	3
1852
24
3	3
1853
25
SELECT 1;
1854
26
1
1855
27
1
1856
28
SET SESSION query_exec_time=default;
1857
29
[log_stop.inc] percona.slow_extended.min_examined_row_limit
1858
30
SET GLOBAL min_examined_row_limit=default;
1859
31
SET GLOBAL slow_query_log_use_global_control=default;
1860
32
SET GLOBAL long_query_time=default;
1861
33
[log_grep.inc] file: percona.slow_extended.min_examined_row_limit pattern: Query_time
1862
34
[log_grep.inc] lines:   1
1863
35
DROP TABLE t;
1864
0
36
1865
=== removed file 'Percona-Server/mysql-test/r/percona_min_examined_row_limit.result'
1866
--- Percona-Server/mysql-test/r/percona_min_examined_row_limit.result	2013-01-20 13:26:51 +0000
1867
+++ Percona-Server/mysql-test/r/percona_min_examined_row_limit.result	1970-01-01 00:00:00 +0000
1868
@@ -1,35 +0,0 @@
1869
1
drop table if exists t;
1870
2
create table t(id INT PRIMARY KEY);
1871
3
insert into t values(1);
1872
4
insert into t values(2);
1873
5
insert into t values(3);
1874
6
SET GLOBAL long_query_time=2;
1875
7
SET GLOBAL slow_query_log_use_global_control='long_query_time,min_examined_row_limit';
1876
8
[log_start.inc] percona.slow_extended.min_examined_row_limit
1877
9
SET SESSION query_exec_time=2.1;
1878
10
SELECT 1;
1879
11
1
1880
12
1
1881
13
SET GLOBAL min_examined_row_limit=5;
1882
14
SELECT * FROM t AS t1, t AS t2;
1883
15
id	id
1884
16
1	1
1885
17
2	1
1886
18
3	1
1887
19
1	2
1888
20
2	2
1889
21
3	2
1890
22
1	3
1891
23
2	3
1892
24
3	3
1893
25
SELECT 1;
1894
26
1
1895
27
1
1896
28
SET SESSION query_exec_time=default;
1897
29
[log_stop.inc] percona.slow_extended.min_examined_row_limit
1898
30
SET GLOBAL min_examined_row_limit=default;
1899
31
SET GLOBAL slow_query_log_use_global_control=default;
1900
32
SET GLOBAL long_query_time=default;
1901
33
[log_grep.inc] file: percona.slow_extended.min_examined_row_limit pattern: Query_time
1902
34
[log_grep.inc] lines:   1
1903
35
DROP TABLE t;
1904
36
0
1905
=== added file 'Percona-Server/mysql-test/r/percona_query_cache_with_comments.result'
1906
--- Percona-Server/mysql-test/r/percona_query_cache_with_comments.result	1970-01-01 00:00:00 +0000
1907
+++ Percona-Server/mysql-test/r/percona_query_cache_with_comments.result	2013-05-26 07:24:39 +0000
1908
@@ -0,0 +1,866 @@
1909
1
set global query_cache_strip_comments=ON;
1910
2
set GLOBAL query_cache_size=1355776;
1911
3
drop table if exists t1;
1912
4
create table t1 (a int not null);
1913
5
insert into t1 values (1),(2),(3);
1914
6
flush query cache;
1915
7
flush query cache;
1916
8
reset query cache;
1917
9
flush status;
1918
10
flush query cache;
1919
11
flush query cache;
1920
12
reset query cache;
1921
13
flush status;
1922
14
/* with comment first */select * from t1;
1923
15
a
1924
16
1
1925
17
2
1926
18
3
1927
19
-----------------------------------------------------
1928
20
/* with comment first */select * from t1
1929
21
-----------------------------------------------------
1930
22
show status like "Qcache_queries_in_cache";
1931
23
Variable_name	Value
1932
24
Qcache_queries_in_cache	1
1933
25
show status like "Qcache_inserts";
1934
26
Variable_name	Value
1935
27
Qcache_inserts	1
1936
28
show status like "Qcache_hits";
1937
29
Variable_name	Value
1938
30
Qcache_hits	0
1939
31
/* with comment first */select * from t1;
1940
32
a
1941
33
1
1942
34
2
1943
35
3
1944
36
/* with comment first */select * from t1;
1945
37
a
1946
38
1
1947
39
2
1948
40
3
1949
41
show status like "Qcache_queries_in_cache";
1950
42
Variable_name	Value
1951
43
Qcache_queries_in_cache	1
1952
44
show status like "Qcache_inserts";
1953
45
Variable_name	Value
1954
46
Qcache_inserts	1
1955
47
show status like "Qcache_hits";
1956
48
Variable_name	Value
1957
49
Qcache_hits	2
1958
50
-----------------------------------------------------
1959
51
# with comment first
1960
52
select * from t1
1961
53
-----------------------------------------------------
1962
54
show status like "Qcache_queries_in_cache";
1963
55
Variable_name	Value
1964
56
Qcache_queries_in_cache	1
1965
57
show status like "Qcache_inserts";
1966
58
Variable_name	Value
1967
59
Qcache_inserts	1
1968
60
show status like "Qcache_hits";
1969
61
Variable_name	Value
1970
62
Qcache_hits	2
1971
63
# with comment first
1972
64
select * from t1;
1973
65
a
1974
66
1
1975
67
2
1976
68
3
1977
69
# with comment first
1978
70
select * from t1;
1979
71
a
1980
72
1
1981
73
2
1982
74
3
1983
75
show status like "Qcache_queries_in_cache";
1984
76
Variable_name	Value
1985
77
Qcache_queries_in_cache	1
1986
78
show status like "Qcache_inserts";
1987
79
Variable_name	Value
1988
80
Qcache_inserts	1
1989
81
show status like "Qcache_hits";
1990
82
Variable_name	Value
1991
83
Qcache_hits	4
1992
84
-----------------------------------------------------
1993
85
-- with comment first
1994
86
select * from t1
1995
87
-----------------------------------------------------
1996
88
show status like "Qcache_queries_in_cache";
1997
89
Variable_name	Value
1998
90
Qcache_queries_in_cache	1
1999
91
show status like "Qcache_inserts";
2000
92
Variable_name	Value
2001
93
Qcache_inserts	1
2002
94
show status like "Qcache_hits";
2003
95
Variable_name	Value
2004
96
Qcache_hits	4
2005
97
-- with comment first
2006
98
select * from t1;
2007
99
a
2008
100
1
2009
101
2
2010
102
3
2011
103
-- with comment first
2012
104
select * from t1;
2013
105
a
2014
106
1
2015
107
2
2016
108
3
2017
109
show status like "Qcache_queries_in_cache";
2018
110
Variable_name	Value
2019
111
Qcache_queries_in_cache	1
2020
112
show status like "Qcache_inserts";
2021
113
Variable_name	Value
2022
114
Qcache_inserts	1
2023
115
show status like "Qcache_hits";
2024
116
Variable_name	Value
2025
117
Qcache_hits	6
2026
118
-----------------------------------------------------
2027
119
/* with comment first and "quote" */select * from t1
2028
120
-----------------------------------------------------
2029
121
show status like "Qcache_queries_in_cache";
2030
122
Variable_name	Value
2031
123
Qcache_queries_in_cache	1
2032
124
show status like "Qcache_inserts";
2033
125
Variable_name	Value
2034
126
Qcache_inserts	1
2035
127
show status like "Qcache_hits";
2036
128
Variable_name	Value
2037
129
Qcache_hits	6
2038
130
/* with comment first and "quote" */select * from t1;
2039
131
a
2040
132
1
2041
133
2
2042
134
3
2043
135
/* with comment first and "quote" */select * from t1;
2044
136
a
2045
137
1
2046
138
2
2047
139
3
2048
140
show status like "Qcache_queries_in_cache";
2049
141
Variable_name	Value
2050
142
Qcache_queries_in_cache	1
2051
143
show status like "Qcache_inserts";
2052
144
Variable_name	Value
2053
145
Qcache_inserts	1
2054
146
show status like "Qcache_hits";
2055
147
Variable_name	Value
2056
148
Qcache_hits	8
2057
149
-----------------------------------------------------
2058
150
# with comment first and "quote"
2059
151
select * from t1
2060
152
-----------------------------------------------------
2061
153
show status like "Qcache_queries_in_cache";
2062
154
Variable_name	Value
2063
155
Qcache_queries_in_cache	1
2064
156
show status like "Qcache_inserts";
2065
157
Variable_name	Value
2066
158
Qcache_inserts	1
2067
159
show status like "Qcache_hits";
2068
160
Variable_name	Value
2069
161
Qcache_hits	8
2070
162
# with comment first and "quote"
2071
163
select * from t1;
2072
164
a
2073
165
1
2074
166
2
2075
167
3
2076
168
# with comment first and "quote"
2077
169
select * from t1;
2078
170
a
2079
171
1
2080
172
2
2081
173
3
2082
174
show status like "Qcache_queries_in_cache";
2083
175
Variable_name	Value
2084
176
Qcache_queries_in_cache	1
2085
177
show status like "Qcache_inserts";
2086
178
Variable_name	Value
2087
179
Qcache_inserts	1
2088
180
show status like "Qcache_hits";
2089
181
Variable_name	Value
2090
182
Qcache_hits	10
2091
183
-----------------------------------------------------
2092
184
-- with comment first and "quote" 
2093
185
select * from t1
2094
186
-----------------------------------------------------
2095
187
show status like "Qcache_queries_in_cache";
2096
188
Variable_name	Value
2097
189
Qcache_queries_in_cache	1
2098
190
show status like "Qcache_inserts";
2099
191
Variable_name	Value
2100
192
Qcache_inserts	1
2101
193
show status like "Qcache_hits";
2102
194
Variable_name	Value
2103
195
Qcache_hits	10
2104
196
-- with comment first and "quote" 
2105
197
select * from t1;
2106
198
a
2107
199
1
2108
200
2
2109
201
3
2110
202
-- with comment first and "quote" 
2111
203
select * from t1;
2112
204
a
2113
205
1
2114
206
2
2115
207
3
2116
208
show status like "Qcache_queries_in_cache";
2117
209
Variable_name	Value
2118
210
Qcache_queries_in_cache	1
2119
211
show status like "Qcache_inserts";
2120
212
Variable_name	Value
2121
213
Qcache_inserts	1
2122
214
show status like "Qcache_hits";
2123
215
Variable_name	Value
2124
216
Qcache_hits	12
2125
217
-----------------------------------------------------
2126
218
/* with comment and whitespaces first */select * from t1
2127
219
-----------------------------------------------------
2128
220
show status like "Qcache_queries_in_cache";
2129
221
Variable_name	Value
2130
222
Qcache_queries_in_cache	1
2131
223
show status like "Qcache_inserts";
2132
224
Variable_name	Value
2133
225
Qcache_inserts	1
2134
226
show status like "Qcache_hits";
2135
227
Variable_name	Value
2136
228
Qcache_hits	12
2137
229
/* with comment and whitespaces first */select * from t1;
2138
230
a
2139
231
1
2140
232
2
2141
233
3
2142
234
/* with comment and whitespaces first */select * from t1;
2143
235
a
2144
236
1
2145
237
2
2146
238
3
2147
239
show status like "Qcache_queries_in_cache";
2148
240
Variable_name	Value
2149
241
Qcache_queries_in_cache	1
2150
242
show status like "Qcache_inserts";
2151
243
Variable_name	Value
2152
244
Qcache_inserts	1
2153
245
show status like "Qcache_hits";
2154
246
Variable_name	Value
2155
247
Qcache_hits	14
2156
248
-----------------------------------------------------
2157
249
# with comment and whitespaces first
2158
250
select * from t1
2159
251
-----------------------------------------------------
2160
252
show status like "Qcache_queries_in_cache";
2161
253
Variable_name	Value
2162
254
Qcache_queries_in_cache	1
2163
255
show status like "Qcache_inserts";
2164
256
Variable_name	Value
2165
257
Qcache_inserts	1
2166
258
show status like "Qcache_hits";
2167
259
Variable_name	Value
2168
260
Qcache_hits	14
2169
261
# with comment and whitespaces first
2170
262
select * from t1;
2171
263
a
2172
264
1
2173
265
2
2174
266
3
2175
267
# with comment and whitespaces first
2176
268
select * from t1;
2177
269
a
2178
270
1
2179
271
2
2180
272
3
2181
273
show status like "Qcache_queries_in_cache";
2182
274
Variable_name	Value
2183
275
Qcache_queries_in_cache	1
2184
276
show status like "Qcache_inserts";
2185
277
Variable_name	Value
2186
278
Qcache_inserts	1
2187
279
show status like "Qcache_hits";
2188
280
Variable_name	Value
2189
281
Qcache_hits	16
2190
282
-----------------------------------------------------
2191
283
-- with comment and whitespaces first
2192
284
select * from t1
2193
285
-----------------------------------------------------
2194
286
show status like "Qcache_queries_in_cache";
2195
287
Variable_name	Value
2196
288
Qcache_queries_in_cache	1
2197
289
show status like "Qcache_inserts";
2198
290
Variable_name	Value
2199
291
Qcache_inserts	1
2200
292
show status like "Qcache_hits";
2201
293
Variable_name	Value
2202
294
Qcache_hits	16
2203
295
-- with comment and whitespaces first
2204
296
select * from t1;
2205
297
a
2206
298
1
2207
299
2
2208
300
3
2209
301
-- with comment and whitespaces first
2210
302
select * from t1;
2211
303
a
2212
304
1
2213
305
2
2214
306
3
2215
307
show status like "Qcache_queries_in_cache";
2216
308
Variable_name	Value
2217
309
Qcache_queries_in_cache	1
2218
310
show status like "Qcache_inserts";
2219
311
Variable_name	Value
2220
312
Qcache_inserts	1
2221
313
show status like "Qcache_hits";
2222
314
Variable_name	Value
2223
315
Qcache_hits	18
2224
316
-----------------------------------------------------
2225
317
select * /* internal comment */ from t1
2226
318
-----------------------------------------------------
2227
319
show status like "Qcache_queries_in_cache";
2228
320
Variable_name	Value
2229
321
Qcache_queries_in_cache	1
2230
322
show status like "Qcache_inserts";
2231
323
Variable_name	Value
2232
324
Qcache_inserts	1
2233
325
show status like "Qcache_hits";
2234
326
Variable_name	Value
2235
327
Qcache_hits	18
2236
328
select * /* internal comment */ from t1;
2237
329
a
2238
330
1
2239
331
2
2240
332
3
2241
333
select * /* internal comment */ from t1;
2242
334
a
2243
335
1
2244
336
2
2245
337
3
2246
338
show status like "Qcache_queries_in_cache";
2247
339
Variable_name	Value
2248
340
Qcache_queries_in_cache	1
2249
341
show status like "Qcache_inserts";
2250
342
Variable_name	Value
2251
343
Qcache_inserts	1
2252
344
show status like "Qcache_hits";
2253
345
Variable_name	Value
2254
346
Qcache_hits	20
2255
347
-----------------------------------------------------
2256
348
select */* internal comment */ from t1
2257
349
-----------------------------------------------------
2258
350
show status like "Qcache_queries_in_cache";
2259
351
Variable_name	Value
2260
352
Qcache_queries_in_cache	1
2261
353
show status like "Qcache_inserts";
2262
354
Variable_name	Value
2263
355
Qcache_inserts	1
2264
356
show status like "Qcache_hits";
2265
357
Variable_name	Value
2266
358
Qcache_hits	20
2267
359
select */* internal comment */ from t1;
2268
360
a
2269
361
1
2270
362
2
2271
363
3
2272
364
select */* internal comment */ from t1;
2273
365
a
2274
366
1
2275
367
2
2276
368
3
2277
369
show status like "Qcache_queries_in_cache";
2278
370
Variable_name	Value
2279
371
Qcache_queries_in_cache	1
2280
372
show status like "Qcache_inserts";
2281
373
Variable_name	Value
2282
374
Qcache_inserts	1
2283
375
show status like "Qcache_hits";
2284
376
Variable_name	Value
2285
377
Qcache_hits	22
2286
378
-----------------------------------------------------
2287
379
select */* internal comment */from t1
2288
380
-----------------------------------------------------
2289
381
show status like "Qcache_queries_in_cache";
2290
382
Variable_name	Value
2291
383
Qcache_queries_in_cache	1
2292
384
show status like "Qcache_inserts";
2293
385
Variable_name	Value
2294
386
Qcache_inserts	1
2295
387
show status like "Qcache_hits";
2296
388
Variable_name	Value
2297
389
Qcache_hits	22
2298
390
select */* internal comment */from t1;
2299
391
a
2300
392
1
2301
393
2
2302
394
3
2303
395
select */* internal comment */from t1;
2304
396
a
2305
397
1
2306
398
2
2307
399
3
2308
400
show status like "Qcache_queries_in_cache";
2309
401
Variable_name	Value
2310
402
Qcache_queries_in_cache	1
2311
403
show status like "Qcache_inserts";
2312
404
Variable_name	Value
2313
405
Qcache_inserts	1
2314
406
show status like "Qcache_hits";
2315
407
Variable_name	Value
2316
408
Qcache_hits	24
2317
409
-----------------------------------------------------
2318
410
select * /* internal comment with "quote" */ from t1
2319
411
-----------------------------------------------------
2320
412
show status like "Qcache_queries_in_cache";
2321
413
Variable_name	Value
2322
414
Qcache_queries_in_cache	1
2323
415
show status like "Qcache_inserts";
2324
416
Variable_name	Value
2325
417
Qcache_inserts	1
2326
418
show status like "Qcache_hits";
2327
419
Variable_name	Value
2328
420
Qcache_hits	24
2329
421
select * /* internal comment with "quote" */ from t1;
2330
422
a
2331
423
1
2332
424
2
2333
425
3
2334
426
select * /* internal comment with "quote" */ from t1;
2335
427
a
2336
428
1
2337
429
2
2338
430
3
2339
431
show status like "Qcache_queries_in_cache";
2340
432
Variable_name	Value
2341
433
Qcache_queries_in_cache	1
2342
434
show status like "Qcache_inserts";
2343
435
Variable_name	Value
2344
436
Qcache_inserts	1
2345
437
show status like "Qcache_hits";
2346
438
Variable_name	Value
2347
439
Qcache_hits	26
2348
440
-----------------------------------------------------
2349
441
select */* internal comment with "quote" */ from t1
2350
442
-----------------------------------------------------
2351
443
show status like "Qcache_queries_in_cache";
2352
444
Variable_name	Value
2353
445
Qcache_queries_in_cache	1
2354
446
show status like "Qcache_inserts";
2355
447
Variable_name	Value
2356
448
Qcache_inserts	1
2357
449
show status like "Qcache_hits";
2358
450
Variable_name	Value
2359
451
Qcache_hits	26
2360
452
select */* internal comment with "quote" */ from t1;
2361
453
a
2362
454
1
2363
455
2
2364
456
3
2365
457
select */* internal comment with "quote" */ from t1;
2366
458
a
2367
459
1
2368
460
2
2369
461
3
2370
462
show status like "Qcache_queries_in_cache";
2371
463
Variable_name	Value
2372
464
Qcache_queries_in_cache	1
2373
465
show status like "Qcache_inserts";
2374
466
Variable_name	Value
2375
467
Qcache_inserts	1
2376
468
show status like "Qcache_hits";
2377
469
Variable_name	Value
2378
470
Qcache_hits	28
2379
471
-----------------------------------------------------
2380
472
select */* internal comment with "quote" */from t1
2381
473
-----------------------------------------------------
2382
474
show status like "Qcache_queries_in_cache";
2383
475
Variable_name	Value
2384
476
Qcache_queries_in_cache	1
2385
477
show status like "Qcache_inserts";
2386
478
Variable_name	Value
2387
479
Qcache_inserts	1
2388
480
show status like "Qcache_hits";
2389
481
Variable_name	Value
2390
482
Qcache_hits	28
2391
483
select */* internal comment with "quote" */from t1;
2392
484
a
2393
485
1
2394
486
2
2395
487
3
2396
488
select */* internal comment with "quote" */from t1;
2397
489
a
2398
490
1
2399
491
2
2400
492
3
2401
493
show status like "Qcache_queries_in_cache";
2402
494
Variable_name	Value
2403
495
Qcache_queries_in_cache	1
2404
496
show status like "Qcache_inserts";
2405
497
Variable_name	Value
2406
498
Qcache_inserts	1
2407
499
show status like "Qcache_hits";
2408
500
Variable_name	Value
2409
501
Qcache_hits	30
2410
502
-----------------------------------------------------
2411
503
select * from t1
2412
504
2413
505
-----------------------------------------------------
2414
506
show status like "Qcache_queries_in_cache";
2415
507
Variable_name	Value
2416
508
Qcache_queries_in_cache	1
2417
509
show status like "Qcache_inserts";
2418
510
Variable_name	Value
2419
511
Qcache_inserts	1
2420
512
show status like "Qcache_hits";
2421
513
Variable_name	Value
2422
514
Qcache_hits	30
2423
515
select * from t1
2424
516
;
2425
517
a
2426
518
1
2427
519
2
2428
520
3
2429
521
select * from t1
2430
522
;
2431
523
a
2432
524
1
2433
525
2
2434
526
3
2435
527
show status like "Qcache_queries_in_cache";
2436
528
Variable_name	Value
2437
529
Qcache_queries_in_cache	1
2438
530
show status like "Qcache_inserts";
2439
531
Variable_name	Value
2440
532
Qcache_inserts	1
2441
533
show status like "Qcache_hits";
2442
534
Variable_name	Value
2443
535
Qcache_hits	32
2444
536
-----------------------------------------------------
2445
537
select * from t1 
2446
538
-----------------------------------------------------
2447
539
show status like "Qcache_queries_in_cache";
2448
540
Variable_name	Value
2449
541
Qcache_queries_in_cache	1
2450
542
show status like "Qcache_inserts";
2451
543
Variable_name	Value
2452
544
Qcache_inserts	1
2453
545
show status like "Qcache_hits";
2454
546
Variable_name	Value
2455
547
Qcache_hits	32
2456
548
select * from t1 ;
2457
549
a
2458
550
1
2459
551
2
2460
552
3
2461
553
select * from t1 ;
2462
554
a
2463
555
1
2464
556
2
2465
557
3
2466
558
show status like "Qcache_queries_in_cache";
2467
559
Variable_name	Value
2468
560
Qcache_queries_in_cache	1
2469
561
show status like "Qcache_inserts";
2470
562
Variable_name	Value
2471
563
Qcache_inserts	1
2472
564
show status like "Qcache_hits";
2473
565
Variable_name	Value
2474
566
Qcache_hits	34
2475
567
-----------------------------------------------------
2476
568
select * from t1	
2477
569
-----------------------------------------------------
2478
570
show status like "Qcache_queries_in_cache";
2479
571
Variable_name	Value
2480
572
Qcache_queries_in_cache	1
2481
573
show status like "Qcache_inserts";
2482
574
Variable_name	Value
2483
575
Qcache_inserts	1
2484
576
show status like "Qcache_hits";
2485
577
Variable_name	Value
2486
578
Qcache_hits	34
2487
579
select * from t1	;
2488
580
a
2489
581
1
2490
582
2
2491
583
3
2492
584
select * from t1	;
2493
585
a
2494
586
1
2495
587
2
2496
588
3
2497
589
show status like "Qcache_queries_in_cache";
2498
590
Variable_name	Value
2499
591
Qcache_queries_in_cache	1
2500
592
show status like "Qcache_inserts";
2501
593
Variable_name	Value
2502
594
Qcache_inserts	1
2503
595
show status like "Qcache_hits";
2504
596
Variable_name	Value
2505
597
Qcache_hits	36
2506
598
-----------------------------------------------------
2507
599
select * from t1
2508
600
/* comment in the end */
2509
601
-----------------------------------------------------
2510
602
show status like "Qcache_queries_in_cache";
2511
603
Variable_name	Value
2512
604
Qcache_queries_in_cache	1
2513
605
show status like "Qcache_inserts";
2514
606
Variable_name	Value
2515
607
Qcache_inserts	1
2516
608
show status like "Qcache_hits";
2517
609
Variable_name	Value
2518
610
Qcache_hits	36
2519
611
select * from t1
2520
612
/* comment in the end */;
2521
613
a
2522
614
1
2523
615
2
2524
616
3
2525
617
select * from t1
2526
618
/* comment in the end */;
2527
619
a
2528
620
1
2529
621
2
2530
622
3
2531
623
show status like "Qcache_queries_in_cache";
2532
624
Variable_name	Value
2533
625
Qcache_queries_in_cache	1
2534
626
show status like "Qcache_inserts";
2535
627
Variable_name	Value
2536
628
Qcache_inserts	1
2537
629
show status like "Qcache_hits";
2538
630
Variable_name	Value
2539
631
Qcache_hits	38
2540
632
-----------------------------------------------------
2541
633
select * from t1
2542
634
/* *\/ */
2543
635
-----------------------------------------------------
2544
636
show status like "Qcache_queries_in_cache";
2545
637
Variable_name	Value
2546
638
Qcache_queries_in_cache	1
2547
639
show status like "Qcache_inserts";
2548
640
Variable_name	Value
2549
641
Qcache_inserts	1
2550
642
show status like "Qcache_hits";
2551
643
Variable_name	Value
2552
644
Qcache_hits	38
2553
645
select * from t1
2554
646
/* *\/ */;
2555
647
a
2556
648
1
2557
649
2
2558
650
3
2559
651
select * from t1
2560
652
/* *\/ */;
2561
653
a
2562
654
1
2563
655
2
2564
656
3
2565
657
show status like "Qcache_queries_in_cache";
2566
658
Variable_name	Value
2567
659
Qcache_queries_in_cache	1
2568
660
show status like "Qcache_inserts";
2569
661
Variable_name	Value
2570
662
Qcache_inserts	1
2571
663
show status like "Qcache_hits";
2572
664
Variable_name	Value
2573
665
Qcache_hits	40
2574
666
-----------------------------------------------------
2575
667
select * from t1
2576
668
/* comment in the end */
2577
669
2578
670
-----------------------------------------------------
2579
671
show status like "Qcache_queries_in_cache";
2580
672
Variable_name	Value
2581
673
Qcache_queries_in_cache	1
2582
674
show status like "Qcache_inserts";
2583
675
Variable_name	Value
2584
676
Qcache_inserts	1
2585
677
show status like "Qcache_hits";
2586
678
Variable_name	Value
2587
679
Qcache_hits	40
2588
680
select * from t1
2589
681
/* comment in the end */
2590
682
;
2591
683
a
2592
684
1
2593
685
2
2594
686
3
2595
687
select * from t1
2596
688
/* comment in the end */
2597
689
;
2598
690
a
2599
691
1
2600
692
2
2601
693
3
2602
694
show status like "Qcache_queries_in_cache";
2603
695
Variable_name	Value
2604
696
Qcache_queries_in_cache	1
2605
697
show status like "Qcache_inserts";
2606
698
Variable_name	Value
2607
699
Qcache_inserts	1
2608
700
show status like "Qcache_hits";
2609
701
Variable_name	Value
2610
702
Qcache_hits	42
2611
703
-----------------------------------------------------
2612
704
select * from t1 #comment in the end
2613
705
-----------------------------------------------------
2614
706
show status like "Qcache_queries_in_cache";
2615
707
Variable_name	Value
2616
708
Qcache_queries_in_cache	1
2617
709
show status like "Qcache_inserts";
2618
710
Variable_name	Value
2619
711
Qcache_inserts	1
2620
712
show status like "Qcache_hits";
2621
713
Variable_name	Value
2622
714
Qcache_hits	42
2623
715
select * from t1 #comment in the end;
2624
716
a
2625
717
1
2626
718
2
2627
719
3
2628
720
select * from t1 #comment in the end;
2629
721
a
2630
722
1
2631
723
2
2632
724
3
2633
725
show status like "Qcache_queries_in_cache";
2634
726
Variable_name	Value
2635
727
Qcache_queries_in_cache	1
2636
728
show status like "Qcache_inserts";
2637
729
Variable_name	Value
2638
730
Qcache_inserts	1
2639
731
show status like "Qcache_hits";
2640
732
Variable_name	Value
2641
733
Qcache_hits	44
2642
734
-----------------------------------------------------
2643
735
select * from t1 #comment in the end
2644
736
2645
737
-----------------------------------------------------
2646
738
show status like "Qcache_queries_in_cache";
2647
739
Variable_name	Value
2648
740
Qcache_queries_in_cache	1
2649
741
show status like "Qcache_inserts";
2650
742
Variable_name	Value
2651
743
Qcache_inserts	1
2652
744
show status like "Qcache_hits";
2653
745
Variable_name	Value
2654
746
Qcache_hits	44
2655
747
select * from t1 #comment in the end
2656
748
;
2657
749
a
2658
750
1
2659
751
2
2660
752
3
2661
753
select * from t1 #comment in the end
2662
754
;
2663
755
a
2664
756
1
2665
757
2
2666
758
3
2667
759
show status like "Qcache_queries_in_cache";
2668
760
Variable_name	Value
2669
761
Qcache_queries_in_cache	1
2670
762
show status like "Qcache_inserts";
2671
763
Variable_name	Value
2672
764
Qcache_inserts	1
2673
765
show status like "Qcache_hits";
2674
766
Variable_name	Value
2675
767
Qcache_hits	46
2676
768
-----------------------------------------------------
2677
769
select * from t1 -- comment in the end
2678
770
-----------------------------------------------------
2679
771
show status like "Qcache_queries_in_cache";
2680
772
Variable_name	Value
2681
773
Qcache_queries_in_cache	1
2682
774
show status like "Qcache_inserts";
2683
775
Variable_name	Value
2684
776
Qcache_inserts	1
2685
777
show status like "Qcache_hits";
2686
778
Variable_name	Value
2687
779
Qcache_hits	46
2688
780
select * from t1 -- comment in the end;
2689
781
a
2690
782
1
2691
783
2
2692
784
3
2693
785
select * from t1 -- comment in the end;
2694
786
a
2695
787
1
2696
788
2
2697
789
3
2698
790
show status like "Qcache_queries_in_cache";
2699
791
Variable_name	Value
2700
792
Qcache_queries_in_cache	1
2701
793
show status like "Qcache_inserts";
2702
794
Variable_name	Value
2703
795
Qcache_inserts	1
2704
796
show status like "Qcache_hits";
2705
797
Variable_name	Value
2706
798
Qcache_hits	48
2707
799
-----------------------------------------------------
2708
800
select * from t1 -- comment in the end
2709
801
2710
802
-----------------------------------------------------
2711
803
show status like "Qcache_queries_in_cache";
2712
804
Variable_name	Value
2713
805
Qcache_queries_in_cache	1
2714
806
show status like "Qcache_inserts";
2715
807
Variable_name	Value
2716
808
Qcache_inserts	1
2717
809
show status like "Qcache_hits";
2718
810
Variable_name	Value
2719
811
Qcache_hits	48
2720
812
select * from t1 -- comment in the end
2721
813
;
2722
814
a
2723
815
1
2724
816
2
2725
817
3
2726
818
select * from t1 -- comment in the end
2727
819
;
2728
820
a
2729
821
1
2730
822
2
2731
823
3
2732
824
show status like "Qcache_queries_in_cache";
2733
825
Variable_name	Value
2734
826
Qcache_queries_in_cache	1
2735
827
show status like "Qcache_inserts";
2736
828
Variable_name	Value
2737
829
Qcache_inserts	1
2738
830
show status like "Qcache_hits";
2739
831
Variable_name	Value
2740
832
Qcache_hits	50
2741
833
-----------------------------------------------------
2742
834
select ' \'  ' from t1
2743
835
-----------------------------------------------------
2744
836
show status like "Qcache_queries_in_cache";
2745
837
Variable_name	Value
2746
838
Qcache_queries_in_cache	1
2747
839
show status like "Qcache_inserts";
2748
840
Variable_name	Value
2749
841
Qcache_inserts	1
2750
842
show status like "Qcache_hits";
2751
843
Variable_name	Value
2752
844
Qcache_hits	50
2753
845
select ' \'  ' from t1;
2754
846
'  
2755
847
 '  
2756
848
 '  
2757
849
 '  
2758
850
select ' \'  ' from t1;
2759
851
'  
2760
852
 '  
2761
853
 '  
2762
854
 '  
2763
855
show status like "Qcache_queries_in_cache";
2764
856
Variable_name	Value
2765
857
Qcache_queries_in_cache	2
2766
858
show status like "Qcache_inserts";
2767
859
Variable_name	Value
2768
860
Qcache_inserts	2
2769
861
show status like "Qcache_hits";
2770
862
Variable_name	Value
2771
863
Qcache_hits	51
2772
864
DROP TABLE t1;
2773
865
SET GLOBAL query_cache_size=default;
2774
866
set global query_cache_strip_comments=OFF;
2775
0
867
2776
=== removed file 'Percona-Server/mysql-test/r/percona_query_cache_with_comments.result'
2777
--- Percona-Server/mysql-test/r/percona_query_cache_with_comments.result	2012-04-18 23:25:43 +0000
2778
+++ Percona-Server/mysql-test/r/percona_query_cache_with_comments.result	1970-01-01 00:00:00 +0000
2779
@@ -1,866 +0,0 @@
2780
1
set global query_cache_strip_comments=ON;
2781
2
set GLOBAL query_cache_size=1355776;
2782
3
drop table if exists t1;
2783
4
create table t1 (a int not null);
2784
5
insert into t1 values (1),(2),(3);
2785
6
flush query cache;
2786
7
flush query cache;
2787
8
reset query cache;
2788
9
flush status;
2789
10
flush query cache;
2790
11
flush query cache;
2791
12
reset query cache;
2792
13
flush status;
2793
14
/* with comment first */select * from t1;
2794
15
a
2795
16
1
2796
17
2
2797
18
3
2798
19
-----------------------------------------------------
2799
20
/* with comment first */select * from t1
2800
21
-----------------------------------------------------
2801
22
show status like "Qcache_queries_in_cache";
2802
23
Variable_name	Value
2803
24
Qcache_queries_in_cache	1
2804
25
show status like "Qcache_inserts";
2805
26
Variable_name	Value
2806
27
Qcache_inserts	1
2807
28
show status like "Qcache_hits";
2808
29
Variable_name	Value
2809
30
Qcache_hits	0
2810
31
/* with comment first */select * from t1;
2811
32
a
2812
33
1
2813
34
2
2814
35
3
2815
36
/* with comment first */select * from t1;
2816
37
a
2817
38
1
2818
39
2
2819
40
3
2820
41
show status like "Qcache_queries_in_cache";
2821
42
Variable_name	Value
2822
43
Qcache_queries_in_cache	1
2823
44
show status like "Qcache_inserts";
2824
45
Variable_name	Value
2825
46
Qcache_inserts	1
2826
47
show status like "Qcache_hits";
2827
48
Variable_name	Value
2828
49
Qcache_hits	2
2829
50
-----------------------------------------------------
2830
51
# with comment first
2831
52
select * from t1
2832
53
-----------------------------------------------------
2833
54
show status like "Qcache_queries_in_cache";
2834
55
Variable_name	Value
2835
56
Qcache_queries_in_cache	1
2836
57
show status like "Qcache_inserts";
2837
58
Variable_name	Value
2838
59
Qcache_inserts	1
2839
60
show status like "Qcache_hits";
2840
61
Variable_name	Value
2841
62
Qcache_hits	2
2842
63
# with comment first
2843
64
select * from t1;
2844
65
a
2845
66
1
2846
67
2
2847
68
3
2848
69
# with comment first
2849
70
select * from t1;
2850
71
a
2851
72
1
2852
73
2
2853
74
3
2854
75
show status like "Qcache_queries_in_cache";
2855
76
Variable_name	Value
2856
77
Qcache_queries_in_cache	1
2857
78
show status like "Qcache_inserts";
2858
79
Variable_name	Value
2859
80
Qcache_inserts	1
2860
81
show status like "Qcache_hits";
2861
82
Variable_name	Value
2862
83
Qcache_hits	4
2863
84
-----------------------------------------------------
2864
85
-- with comment first
2865
86
select * from t1
2866
87
-----------------------------------------------------
2867
88
show status like "Qcache_queries_in_cache";
2868
89
Variable_name	Value
2869
90
Qcache_queries_in_cache	1
2870
91
show status like "Qcache_inserts";
2871
92
Variable_name	Value
2872
93
Qcache_inserts	1
2873
94
show status like "Qcache_hits";
2874
95
Variable_name	Value
2875
96
Qcache_hits	4
2876
97
-- with comment first
2877
98
select * from t1;
2878
99
a
2879
100
1
2880
101
2
2881
102
3
2882
103
-- with comment first
2883
104
select * from t1;
2884
105
a
2885
106
1
2886
107
2
2887
108
3
2888
109
show status like "Qcache_queries_in_cache";
2889
110
Variable_name	Value
2890
111
Qcache_queries_in_cache	1
2891
112
show status like "Qcache_inserts";
2892
113
Variable_name	Value
2893
114
Qcache_inserts	1
2894
115
show status like "Qcache_hits";
2895
116
Variable_name	Value
2896
117
Qcache_hits	6
2897
118
-----------------------------------------------------
2898
119
/* with comment first and "quote" */select * from t1
2899
120
-----------------------------------------------------
2900
121
show status like "Qcache_queries_in_cache";
2901
122
Variable_name	Value
2902
123
Qcache_queries_in_cache	1
2903
124
show status like "Qcache_inserts";
2904
125
Variable_name	Value
2905
126
Qcache_inserts	1
2906
127
show status like "Qcache_hits";
2907
128
Variable_name	Value
2908
129
Qcache_hits	6
2909
130
/* with comment first and "quote" */select * from t1;
2910
131
a
2911
132
1
2912
133
2
2913
134
3
2914
135
/* with comment first and "quote" */select * from t1;
2915
136
a
2916
137
1
2917
138
2
2918
139
3
2919
140
show status like "Qcache_queries_in_cache";
2920
141
Variable_name	Value
2921
142
Qcache_queries_in_cache	1
2922
143
show status like "Qcache_inserts";
2923
144
Variable_name	Value
2924
145
Qcache_inserts	1
2925
146
show status like "Qcache_hits";
2926
147
Variable_name	Value
2927
148
Qcache_hits	8
2928
149
-----------------------------------------------------
2929
150
# with comment first and "quote"
2930
151
select * from t1
2931
152
-----------------------------------------------------
2932
153
show status like "Qcache_queries_in_cache";
2933
154
Variable_name	Value
2934
155
Qcache_queries_in_cache	1
2935
156
show status like "Qcache_inserts";
2936
157
Variable_name	Value
2937
158
Qcache_inserts	1
2938
159
show status like "Qcache_hits";
2939
160
Variable_name	Value
2940
161
Qcache_hits	8
2941
162
# with comment first and "quote"
2942
163
select * from t1;
2943
164
a
2944
165
1
2945
166
2
2946
167
3
2947
168
# with comment first and "quote"
2948
169
select * from t1;
2949
170
a
2950
171
1
2951
172
2
2952
173
3
2953
174
show status like "Qcache_queries_in_cache";
2954
175
Variable_name	Value
2955
176
Qcache_queries_in_cache	1
2956
177
show status like "Qcache_inserts";
2957
178
Variable_name	Value
2958
179
Qcache_inserts	1
2959
180
show status like "Qcache_hits";
2960
181
Variable_name	Value
2961
182
Qcache_hits	10
2962
183
-----------------------------------------------------
2963
184
-- with comment first and "quote" 
2964
185
select * from t1
2965
186
-----------------------------------------------------
2966
187
show status like "Qcache_queries_in_cache";
2967
188
Variable_name	Value
2968
189
Qcache_queries_in_cache	1
2969
190
show status like "Qcache_inserts";
2970
191
Variable_name	Value
2971
192
Qcache_inserts	1
2972
193
show status like "Qcache_hits";
2973
194
Variable_name	Value
2974
195
Qcache_hits	10
2975
196
-- with comment first and "quote" 
2976
197
select * from t1;
2977
198
a
2978
199
1
2979
200
2
2980
201
3
2981
202
-- with comment first and "quote" 
2982
203
select * from t1;
2983
204
a
2984
205
1
2985
206
2
2986
207
3
2987
208
show status like "Qcache_queries_in_cache";
2988
209
Variable_name	Value
2989
210
Qcache_queries_in_cache	1
2990
211
show status like "Qcache_inserts";
2991
212
Variable_name	Value
2992
213
Qcache_inserts	1
2993
214
show status like "Qcache_hits";
2994
215
Variable_name	Value
2995
216
Qcache_hits	12
2996
217
-----------------------------------------------------
2997
218
/* with comment and whitespaces first */select * from t1
2998
219
-----------------------------------------------------
2999
220
show status like "Qcache_queries_in_cache";
3000
221
Variable_name	Value
3001
222
Qcache_queries_in_cache	1
3002
223
show status like "Qcache_inserts";
3003
224
Variable_name	Value
3004
225
Qcache_inserts	1
3005
226
show status like "Qcache_hits";
3006
227
Variable_name	Value
3007
228
Qcache_hits	12
3008
229
/* with comment and whitespaces first */select * from t1;
3009
230
a
3010
231
1
3011
232
2
3012
233
3
3013
234
/* with comment and whitespaces first */select * from t1;
3014
235
a
3015
236
1
3016
237
2
3017
238
3
3018
239
show status like "Qcache_queries_in_cache";
3019
240
Variable_name	Value
3020
241
Qcache_queries_in_cache	1
3021
242
show status like "Qcache_inserts";
3022
243
Variable_name	Value
3023
244
Qcache_inserts	1
3024
245
show status like "Qcache_hits";
3025
246
Variable_name	Value
3026
247
Qcache_hits	14
3027
248
-----------------------------------------------------
3028
249
# with comment and whitespaces first
3029
250
select * from t1
3030
251
-----------------------------------------------------
3031
252
show status like "Qcache_queries_in_cache";
3032
253
Variable_name	Value
3033
254
Qcache_queries_in_cache	1
3034
255
show status like "Qcache_inserts";
3035
256
Variable_name	Value
3036
257
Qcache_inserts	1
3037
258
show status like "Qcache_hits";
3038
259
Variable_name	Value
3039
260
Qcache_hits	14
3040
261
# with comment and whitespaces first
3041
262
select * from t1;
3042
263
a
3043
264
1
3044
265
2
3045
266
3
3046
267
# with comment and whitespaces first
3047
268
select * from t1;
3048
269
a
3049
270
1
3050
271
2
3051
272
3
3052
273
show status like "Qcache_queries_in_cache";
3053
274
Variable_name	Value
3054
275
Qcache_queries_in_cache	1
3055
276
show status like "Qcache_inserts";
3056
277
Variable_name	Value
3057
278
Qcache_inserts	1
3058
279
show status like "Qcache_hits";
3059
280
Variable_name	Value
3060
281
Qcache_hits	16
3061
282
-----------------------------------------------------
3062
283
-- with comment and whitespaces first
3063
284
select * from t1
3064
285
-----------------------------------------------------
3065
286
show status like "Qcache_queries_in_cache";
3066
287
Variable_name	Value
3067
288
Qcache_queries_in_cache	1
3068
289
show status like "Qcache_inserts";
3069
290
Variable_name	Value
3070
291
Qcache_inserts	1
3071
292
show status like "Qcache_hits";
3072
293
Variable_name	Value
3073
294
Qcache_hits	16
3074
295
-- with comment and whitespaces first
3075
296
select * from t1;
3076
297
a
3077
298
1
3078
299
2
3079
300
3
3080
301
-- with comment and whitespaces first
3081
302
select * from t1;
3082
303
a
3083
304
1
3084
305
2
3085
306
3
3086
307
show status like "Qcache_queries_in_cache";
3087
308
Variable_name	Value
3088
309
Qcache_queries_in_cache	1
3089
310
show status like "Qcache_inserts";
3090
311
Variable_name	Value
3091
312
Qcache_inserts	1
3092
313
show status like "Qcache_hits";
3093
314
Variable_name	Value
3094
315
Qcache_hits	18
3095
316
-----------------------------------------------------
3096
317
select * /* internal comment */ from t1
3097
318
-----------------------------------------------------
3098
319
show status like "Qcache_queries_in_cache";
3099
320
Variable_name	Value
3100
321
Qcache_queries_in_cache	1
3101
322
show status like "Qcache_inserts";
3102
323
Variable_name	Value
3103
324
Qcache_inserts	1
3104
325
show status like "Qcache_hits";
3105
326
Variable_name	Value
3106
327
Qcache_hits	18
3107
328
select * /* internal comment */ from t1;
3108
329
a
3109
330
1
3110
331
2
3111
332
3
3112
333
select * /* internal comment */ from t1;
3113
334
a
3114
335
1
3115
336
2
3116
337
3
3117
338
show status like "Qcache_queries_in_cache";
3118
339
Variable_name	Value
3119
340
Qcache_queries_in_cache	1
3120
341
show status like "Qcache_inserts";
3121
342
Variable_name	Value
3122
343
Qcache_inserts	1
3123
344
show status like "Qcache_hits";
3124
345
Variable_name	Value
3125
346
Qcache_hits	20
3126
347
-----------------------------------------------------
3127
348
select */* internal comment */ from t1
3128
349
-----------------------------------------------------
3129
350
show status like "Qcache_queries_in_cache";
3130
351
Variable_name	Value
3131
352
Qcache_queries_in_cache	1
3132
353
show status like "Qcache_inserts";
3133
354
Variable_name	Value
3134
355
Qcache_inserts	1
3135
356
show status like "Qcache_hits";
3136
357
Variable_name	Value
3137
358
Qcache_hits	20
3138
359
select */* internal comment */ from t1;
3139
360
a
3140
361
1
3141
362
2
3142
363
3
3143
364
select */* internal comment */ from t1;
3144
365
a
3145
366
1
3146
367
2
3147
368
3
3148
369
show status like "Qcache_queries_in_cache";
3149
370
Variable_name	Value
3150
371
Qcache_queries_in_cache	1
3151
372
show status like "Qcache_inserts";
3152
373
Variable_name	Value
3153
374
Qcache_inserts	1
3154
375
show status like "Qcache_hits";
3155
376
Variable_name	Value
3156
377
Qcache_hits	22
3157
378
-----------------------------------------------------
3158
379
select */* internal comment */from t1
3159
380
-----------------------------------------------------
3160
381
show status like "Qcache_queries_in_cache";
3161
382
Variable_name	Value
3162
383
Qcache_queries_in_cache	1
3163
384
show status like "Qcache_inserts";
3164
385
Variable_name	Value
3165
386
Qcache_inserts	1
3166
387
show status like "Qcache_hits";
3167
388
Variable_name	Value
3168
389
Qcache_hits	22
3169
390
select */* internal comment */from t1;
3170
391
a
3171
392
1
3172
393
2
3173
394
3
3174
395
select */* internal comment */from t1;
3175
396
a
3176
397
1
3177
398
2
3178
399
3
3179
400
show status like "Qcache_queries_in_cache";
3180
401
Variable_name	Value
3181
402
Qcache_queries_in_cache	1
3182
403
show status like "Qcache_inserts";
3183
404
Variable_name	Value
3184
405
Qcache_inserts	1
3185
406
show status like "Qcache_hits";
3186
407
Variable_name	Value
3187
408
Qcache_hits	24
3188
409
-----------------------------------------------------
3189
410
select * /* internal comment with "quote" */ from t1
3190
411
-----------------------------------------------------
3191
412
show status like "Qcache_queries_in_cache";
3192
413
Variable_name	Value
3193
414
Qcache_queries_in_cache	1
3194
415
show status like "Qcache_inserts";
3195
416
Variable_name	Value
3196
417
Qcache_inserts	1
3197
418
show status like "Qcache_hits";
3198
419
Variable_name	Value
3199
420
Qcache_hits	24
3200
421
select * /* internal comment with "quote" */ from t1;
3201
422
a
3202
423
1
3203
424
2
3204
425
3
3205
426
select * /* internal comment with "quote" */ from t1;
3206
427
a
3207
428
1
3208
429
2
3209
430
3
3210
431
show status like "Qcache_queries_in_cache";
3211
432
Variable_name	Value
3212
433
Qcache_queries_in_cache	1
3213
434
show status like "Qcache_inserts";
3214
435
Variable_name	Value
3215
436
Qcache_inserts	1
3216
437
show status like "Qcache_hits";
3217
438
Variable_name	Value
3218
439
Qcache_hits	26
3219
440
-----------------------------------------------------
3220
441
select */* internal comment with "quote" */ from t1
3221
442
-----------------------------------------------------
3222
443
show status like "Qcache_queries_in_cache";
3223
444
Variable_name	Value
3224
445
Qcache_queries_in_cache	1
3225
446
show status like "Qcache_inserts";
3226
447
Variable_name	Value
3227
448
Qcache_inserts	1
3228
449
show status like "Qcache_hits";
3229
450
Variable_name	Value
3230
451
Qcache_hits	26
3231
452
select */* internal comment with "quote" */ from t1;
3232
453
a
3233
454
1
3234
455
2
3235
456
3
3236
457
select */* internal comment with "quote" */ from t1;
3237
458
a
3238
459
1
3239
460
2
3240
461
3
3241
462
show status like "Qcache_queries_in_cache";
3242
463
Variable_name	Value
3243
464
Qcache_queries_in_cache	1
3244
465
show status like "Qcache_inserts";
3245
466
Variable_name	Value
3246
467
Qcache_inserts	1
3247
468
show status like "Qcache_hits";
3248
469
Variable_name	Value
3249
470
Qcache_hits	28
3250
471
-----------------------------------------------------
3251
472
select */* internal comment with "quote" */from t1
3252
473
-----------------------------------------------------
3253
474
show status like "Qcache_queries_in_cache";
3254
475
Variable_name	Value
3255
476
Qcache_queries_in_cache	1
3256
477
show status like "Qcache_inserts";
3257
478
Variable_name	Value
3258
479
Qcache_inserts	1
3259
480
show status like "Qcache_hits";
3260
481
Variable_name	Value
3261
482
Qcache_hits	28
3262
483
select */* internal comment with "quote" */from t1;
3263
484
a
3264
485
1
3265
486
2
3266
487
3
3267
488
select */* internal comment with "quote" */from t1;
3268
489
a
3269
490
1
3270
491
2
3271
492
3
3272
493
show status like "Qcache_queries_in_cache";
3273
494
Variable_name	Value
3274
495
Qcache_queries_in_cache	1
3275
496
show status like "Qcache_inserts";
3276
497
Variable_name	Value
3277
498
Qcache_inserts	1
3278
499
show status like "Qcache_hits";
3279
500
Variable_name	Value
3280
501
Qcache_hits	30
3281
502
-----------------------------------------------------
3282
503
select * from t1
3283
504
3284
505
-----------------------------------------------------
3285
506
show status like "Qcache_queries_in_cache";
3286
507
Variable_name	Value
3287
508
Qcache_queries_in_cache	1
3288
509
show status like "Qcache_inserts";
3289
510
Variable_name	Value
3290
511
Qcache_inserts	1
3291
512
show status like "Qcache_hits";
3292
513
Variable_name	Value
3293
514
Qcache_hits	30
3294
515
select * from t1
3295
516
;
3296
517
a
3297
518
1
3298
519
2
3299
520
3
3300
521
select * from t1
3301
522
;
3302
523
a
3303
524
1
3304
525
2
3305
526
3
3306
527
show status like "Qcache_queries_in_cache";
3307
528
Variable_name	Value
3308
529
Qcache_queries_in_cache	1
3309
530
show status like "Qcache_inserts";
3310
531
Variable_name	Value
3311
532
Qcache_inserts	1
3312
533
show status like "Qcache_hits";
3313
534
Variable_name	Value
3314
535
Qcache_hits	32
3315
536
-----------------------------------------------------
3316
537
select * from t1 
3317
538
-----------------------------------------------------
3318
539
show status like "Qcache_queries_in_cache";
3319
540
Variable_name	Value
3320
541
Qcache_queries_in_cache	1
3321
542
show status like "Qcache_inserts";
3322
543
Variable_name	Value
3323
544
Qcache_inserts	1
3324
545
show status like "Qcache_hits";
3325
546
Variable_name	Value
3326
547
Qcache_hits	32
3327
548
select * from t1 ;
3328
549
a
3329
550
1
3330
551
2
3331
552
3
3332
553
select * from t1 ;
3333
554
a
3334
555
1
3335
556
2
3336
557
3
3337
558
show status like "Qcache_queries_in_cache";
3338
559
Variable_name	Value
3339
560
Qcache_queries_in_cache	1
3340
561
show status like "Qcache_inserts";
3341
562
Variable_name	Value
3342
563
Qcache_inserts	1
3343
564
show status like "Qcache_hits";
3344
565
Variable_name	Value
3345
566
Qcache_hits	34
3346
567
-----------------------------------------------------
3347
568
select * from t1	
3348
569
-----------------------------------------------------
3349
570
show status like "Qcache_queries_in_cache";
3350
571
Variable_name	Value
3351
572
Qcache_queries_in_cache	1
3352
573
show status like "Qcache_inserts";
3353
574
Variable_name	Value
3354
575
Qcache_inserts	1
3355
576
show status like "Qcache_hits";
3356
577
Variable_name	Value
3357
578
Qcache_hits	34
3358
579
select * from t1	;
3359
580
a
3360
581
1
3361
582
2
3362
583
3
3363
584
select * from t1	;
3364
585
a
3365
586
1
3366
587
2
3367
588
3
3368
589
show status like "Qcache_queries_in_cache";
3369
590
Variable_name	Value
3370
591
Qcache_queries_in_cache	1
3371
592
show status like "Qcache_inserts";
3372
593
Variable_name	Value
3373
594
Qcache_inserts	1
3374
595
show status like "Qcache_hits";
3375
596
Variable_name	Value
3376
597
Qcache_hits	36
3377
598
-----------------------------------------------------
3378
599
select * from t1
3379
600
/* comment in the end */
3380
601
-----------------------------------------------------
3381
602
show status like "Qcache_queries_in_cache";
3382
603
Variable_name	Value
3383
604
Qcache_queries_in_cache	1
3384
605
show status like "Qcache_inserts";
3385
606
Variable_name	Value
3386
607
Qcache_inserts	1
3387
608
show status like "Qcache_hits";
3388
609
Variable_name	Value
3389
610
Qcache_hits	36
3390
611
select * from t1
3391
612
/* comment in the end */;
3392
613
a
3393
614
1
3394
615
2
3395
616
3
3396
617
select * from t1
3397
618
/* comment in the end */;
3398
619
a
3399
620
1
3400
621
2
3401
622
3
3402
623
show status like "Qcache_queries_in_cache";
3403
624
Variable_name	Value
3404
625
Qcache_queries_in_cache	1
3405
626
show status like "Qcache_inserts";
3406
627
Variable_name	Value
3407
628
Qcache_inserts	1
3408
629
show status like "Qcache_hits";
3409
630
Variable_name	Value
3410
631
Qcache_hits	38
3411
632
-----------------------------------------------------
3412
633
select * from t1
3413
634
/* *\/ */
3414
635
-----------------------------------------------------
3415
636
show status like "Qcache_queries_in_cache";
3416
637
Variable_name	Value
3417
638
Qcache_queries_in_cache	1
3418
639
show status like "Qcache_inserts";
3419
640
Variable_name	Value
3420
641
Qcache_inserts	1
3421
642
show status like "Qcache_hits";
3422
643
Variable_name	Value
3423
644
Qcache_hits	38
3424
645
select * from t1
3425
646
/* *\/ */;
3426
647
a
3427
648
1
3428
649
2
3429
650
3
3430
651
select * from t1
3431
652
/* *\/ */;
3432
653
a
3433
654
1
3434
655
2
3435
656
3
3436
657
show status like "Qcache_queries_in_cache";
3437
658
Variable_name	Value
3438
659
Qcache_queries_in_cache	1
3439
660
show status like "Qcache_inserts";
3440
661
Variable_name	Value
3441
662
Qcache_inserts	1
3442
663
show status like "Qcache_hits";
3443
664
Variable_name	Value
3444
665
Qcache_hits	40
3445
666
-----------------------------------------------------
3446
667
select * from t1
3447
668
/* comment in the end */
3448
669
3449
670
-----------------------------------------------------
3450
671
show status like "Qcache_queries_in_cache";
3451
672
Variable_name	Value
3452
673
Qcache_queries_in_cache	1
3453
674
show status like "Qcache_inserts";
3454
675
Variable_name	Value
3455
676
Qcache_inserts	1
3456
677
show status like "Qcache_hits";
3457
678
Variable_name	Value
3458
679
Qcache_hits	40
3459
680
select * from t1
3460
681
/* comment in the end */
3461
682
;
3462
683
a
3463
684
1
3464
685
2
3465
686
3
3466
687
select * from t1
3467
688
/* comment in the end */
3468
689
;
3469
690
a
3470
691
1
3471
692
2
3472
693
3
3473
694
show status like "Qcache_queries_in_cache";
3474
695
Variable_name	Value
3475
696
Qcache_queries_in_cache	1
3476
697
show status like "Qcache_inserts";
3477
698
Variable_name	Value
3478
699
Qcache_inserts	1
3479
700
show status like "Qcache_hits";
3480
701
Variable_name	Value
3481
702
Qcache_hits	42
3482
703
-----------------------------------------------------
3483
704
select * from t1 #comment in the end
3484
705
-----------------------------------------------------
3485
706
show status like "Qcache_queries_in_cache";
3486
707
Variable_name	Value
3487
708
Qcache_queries_in_cache	1
3488
709
show status like "Qcache_inserts";
3489
710
Variable_name	Value
3490
711
Qcache_inserts	1
3491
712
show status like "Qcache_hits";
3492
713
Variable_name	Value
3493
714
Qcache_hits	42
3494
715
select * from t1 #comment in the end;
3495
716
a
3496
717
1
3497
718
2
3498
719
3
3499
720
select * from t1 #comment in the end;
3500
721
a
3501
722
1
3502
723
2
3503
724
3
3504
725
show status like "Qcache_queries_in_cache";
3505
726
Variable_name	Value
3506
727
Qcache_queries_in_cache	1
3507
728
show status like "Qcache_inserts";
3508
729
Variable_name	Value
3509
730
Qcache_inserts	1
3510
731
show status like "Qcache_hits";
3511
732
Variable_name	Value
3512
733
Qcache_hits	44
3513
734
-----------------------------------------------------
3514
735
select * from t1 #comment in the end
3515
736
3516
737
-----------------------------------------------------
3517
738
show status like "Qcache_queries_in_cache";
3518
739
Variable_name	Value
3519
740
Qcache_queries_in_cache	1
3520
741
show status like "Qcache_inserts";
3521
742
Variable_name	Value
3522
743
Qcache_inserts	1
3523
744
show status like "Qcache_hits";
3524
745
Variable_name	Value
3525
746
Qcache_hits	44
3526
747
select * from t1 #comment in the end
3527
748
;
3528
749
a
3529
750
1
3530
751
2
3531
752
3
3532
753
select * from t1 #comment in the end
3533
754
;
3534
755
a
3535
756
1
3536
757
2
3537
758
3
3538
759
show status like "Qcache_queries_in_cache";
3539
760
Variable_name	Value
3540
761
Qcache_queries_in_cache	1
3541
762
show status like "Qcache_inserts";
3542
763
Variable_name	Value
3543
764
Qcache_inserts	1
3544
765
show status like "Qcache_hits";
3545
766
Variable_name	Value
3546
767
Qcache_hits	46
3547
768
-----------------------------------------------------
3548
769
select * from t1 -- comment in the end
3549
770
-----------------------------------------------------
3550
771
show status like "Qcache_queries_in_cache";
3551
772
Variable_name	Value
3552
773
Qcache_queries_in_cache	1
3553
774
show status like "Qcache_inserts";
3554
775
Variable_name	Value
3555
776
Qcache_inserts	1
3556
777
show status like "Qcache_hits";
3557
778
Variable_name	Value
3558
779
Qcache_hits	46
3559
780
select * from t1 -- comment in the end;
3560
781
a
3561
782
1
3562
783
2
3563
784
3
3564
785
select * from t1 -- comment in the end;
3565
786
a
3566
787
1
3567
788
2
3568
789
3
3569
790
show status like "Qcache_queries_in_cache";
3570
791
Variable_name	Value
3571
792
Qcache_queries_in_cache	1
3572
793
show status like "Qcache_inserts";
3573
794
Variable_name	Value
3574
795
Qcache_inserts	1
3575
796
show status like "Qcache_hits";
3576
797
Variable_name	Value
3577
798
Qcache_hits	48
3578
799
-----------------------------------------------------
3579
800
select * from t1 -- comment in the end
3580
801
3581
802
-----------------------------------------------------
3582
803
show status like "Qcache_queries_in_cache";
3583
804
Variable_name	Value
3584
805
Qcache_queries_in_cache	1
3585
806
show status like "Qcache_inserts";
3586
807
Variable_name	Value
3587
808
Qcache_inserts	1
3588
809
show status like "Qcache_hits";
3589
810
Variable_name	Value
3590
811
Qcache_hits	48
3591
812
select * from t1 -- comment in the end
3592
813
;
3593
814
a
3594
815
1
3595
816
2
3596
817
3
3597
818
select * from t1 -- comment in the end
3598
819
;
3599
820
a
3600
821
1
3601
822
2
3602
823
3
3603
824
show status like "Qcache_queries_in_cache";
3604
825
Variable_name	Value
3605
826
Qcache_queries_in_cache	1
3606
827
show status like "Qcache_inserts";
3607
828
Variable_name	Value
3608
829
Qcache_inserts	1
3609
830
show status like "Qcache_hits";
3610
831
Variable_name	Value
3611
832
Qcache_hits	50
3612
833
-----------------------------------------------------
3613
834
select ' \'  ' from t1
3614
835
-----------------------------------------------------
3615
836
show status like "Qcache_queries_in_cache";
3616
837
Variable_name	Value
3617
838
Qcache_queries_in_cache	1
3618
839
show status like "Qcache_inserts";
3619
840
Variable_name	Value
3620
841
Qcache_inserts	1
3621
842
show status like "Qcache_hits";
3622
843
Variable_name	Value
3623
844
Qcache_hits	50
3624
845
select ' \'  ' from t1;
3625
846
'  
3626
847
 '  
3627
848
 '  
3628
849
 '  
3629
850
select ' \'  ' from t1;
3630
851
'  
3631
852
 '  
3632
853
 '  
3633
854
 '  
3634
855
show status like "Qcache_queries_in_cache";
3635
856
Variable_name	Value
3636
857
Qcache_queries_in_cache	2
3637
858
show status like "Qcache_inserts";
3638
859
Variable_name	Value
3639
860
Qcache_inserts	2
3640
861
show status like "Qcache_hits";
3641
862
Variable_name	Value
3642
863
Qcache_hits	51
3643
864
DROP TABLE t1;
3644
865
SET GLOBAL query_cache_size=default;
3645
866
set global query_cache_strip_comments=OFF;
3646
867
0
3647
=== added file 'Percona-Server/mysql-test/r/percona_query_cache_with_comments_crash.result'
3648
--- Percona-Server/mysql-test/r/percona_query_cache_with_comments_crash.result	1970-01-01 00:00:00 +0000
3649
+++ Percona-Server/mysql-test/r/percona_query_cache_with_comments_crash.result	2013-05-26 07:24:39 +0000
3650
@@ -0,0 +1,21 @@
3651
1
set GLOBAL query_cache_size=1355776;
3652
2
drop table if exists t1;
3653
3
create table t1 (a int not null);
3654
4
insert into t1 values (1),(2),(3);
3655
5
flush query cache;
3656
6
flush query cache;
3657
7
reset query cache;
3658
8
flush status;
3659
9
( select * from t1 );
3660
10
a
3661
11
1
3662
12
2
3663
13
3
3664
14
/*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := REPLACE(REPLACE(@@SQL_MODE, 'ANSI_QUOTES', ''), ',,', ','), @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */;
3665
15
/* only comment */;
3666
16
# only comment
3667
17
;
3668
18
-- only comment
3669
19
;
3670
20
DROP TABLE t1;
3671
21
SET GLOBAL query_cache_size= default;
3672
0
22
3673
=== removed file 'Percona-Server/mysql-test/r/percona_query_cache_with_comments_crash.result'
3674
--- Percona-Server/mysql-test/r/percona_query_cache_with_comments_crash.result	2012-04-18 23:25:43 +0000
3675
+++ Percona-Server/mysql-test/r/percona_query_cache_with_comments_crash.result	1970-01-01 00:00:00 +0000
3676
@@ -1,21 +0,0 @@
3677
1
set GLOBAL query_cache_size=1355776;
3678
2
drop table if exists t1;
3679
3
create table t1 (a int not null);
3680
4
insert into t1 values (1),(2),(3);
3681
5
flush query cache;
3682
6
flush query cache;
3683
7
reset query cache;
3684
8
flush status;
3685
9
( select * from t1 );
3686
10
a
3687
11
1
3688
12
2
3689
13
3
3690
14
/*!40101 SET @OLD_SQL_MODE := @@SQL_MODE, @@SQL_MODE := REPLACE(REPLACE(@@SQL_MODE, 'ANSI_QUOTES', ''), ',,', ','), @OLD_QUOTE := @@SQL_QUOTE_SHOW_CREATE, @@SQL_QUOTE_SHOW_CREATE := 1 */;
3691
15
/* only comment */;
3692
16
# only comment
3693
17
;
3694
18
-- only comment
3695
19
;
3696
20
DROP TABLE t1;
3697
21
SET GLOBAL query_cache_size= default;
3698
22
0
3699
=== added file 'Percona-Server/mysql-test/r/percona_query_cache_with_comments_disable.result'
3700
--- Percona-Server/mysql-test/r/percona_query_cache_with_comments_disable.result	1970-01-01 00:00:00 +0000
3701
+++ Percona-Server/mysql-test/r/percona_query_cache_with_comments_disable.result	2013-05-26 07:24:39 +0000
3702
@@ -0,0 +1,865 @@
3703
1
set GLOBAL query_cache_size=1355776;
3704
2
drop table if exists t1;
3705
3
create table t1 (a int not null);
3706
4
insert into t1 values (1),(2),(3);
3707
5
flush query cache;
3708
6
flush query cache;
3709
7
reset query cache;
3710
8
flush status;
3711
9
flush query cache;
3712
10
flush query cache;
3713
11
reset query cache;
3714
12
flush status;
3715
13
/* with comment first */select * from t1;
3716
14
a
3717
15
1
3718
16
2
3719
17
3
3720
18
-----------------------------------------------------
3721
19
/* with comment first */select * from t1
3722
20
-----------------------------------------------------
3723
21
show status like "Qcache_queries_in_cache";
3724
22
Variable_name	Value
3725
23
Qcache_queries_in_cache	1
3726
24
show status like "Qcache_inserts";
3727
25
Variable_name	Value
3728
26
Qcache_inserts	1
3729
27
show status like "Qcache_hits";
3730
28
Variable_name	Value
3731
29
Qcache_hits	0
3732
30
/* with comment first */select * from t1;
3733
31
a
3734
32
1
3735
33
2
3736
34
3
3737
35
/* with comment first */select * from t1;
3738
36
a
3739
37
1
3740
38
2
3741
39
3
3742
40
show status like "Qcache_queries_in_cache";
3743
41
Variable_name	Value
3744
42
Qcache_queries_in_cache	1
3745
43
show status like "Qcache_inserts";
3746
44
Variable_name	Value
3747
45
Qcache_inserts	1
3748
46
show status like "Qcache_hits";
3749
47
Variable_name	Value
3750
48
Qcache_hits	2
3751
49
-----------------------------------------------------
3752
50
# with comment first
3753
51
select * from t1
3754
52
-----------------------------------------------------
3755
53
show status like "Qcache_queries_in_cache";
3756
54
Variable_name	Value
3757
55
Qcache_queries_in_cache	1
3758
56
show status like "Qcache_inserts";
3759
57
Variable_name	Value
3760
58
Qcache_inserts	1
3761
59
show status like "Qcache_hits";
3762
60
Variable_name	Value
3763
61
Qcache_hits	2
3764
62
# with comment first
3765
63
select * from t1;
3766
64
a
3767
65
1
3768
66
2
3769
67
3
3770
68
# with comment first
3771
69
select * from t1;
3772
70
a
3773
71
1
3774
72
2
3775
73
3
3776
74
show status like "Qcache_queries_in_cache";
3777
75
Variable_name	Value
3778
76
Qcache_queries_in_cache	2
3779
77
show status like "Qcache_inserts";
3780
78
Variable_name	Value
3781
79
Qcache_inserts	2
3782
80
show status like "Qcache_hits";
3783
81
Variable_name	Value
3784
82
Qcache_hits	2
3785
83
-----------------------------------------------------
3786
84
-- with comment first
3787
85
select * from t1
3788
86
-----------------------------------------------------
3789
87
show status like "Qcache_queries_in_cache";
3790
88
Variable_name	Value
3791
89
Qcache_queries_in_cache	2
3792
90
show status like "Qcache_inserts";
3793
91
Variable_name	Value
3794
92
Qcache_inserts	2
3795
93
show status like "Qcache_hits";
3796
94
Variable_name	Value
3797
95
Qcache_hits	2
3798
96
-- with comment first
3799
97
select * from t1;
3800
98
a
3801
99
1
3802
100
2
3803
101
3
3804
102
-- with comment first
3805
103
select * from t1;
3806
104
a
3807
105
1
3808
106
2
3809
107
3
3810
108
show status like "Qcache_queries_in_cache";
3811
109
Variable_name	Value
3812
110
Qcache_queries_in_cache	3
3813
111
show status like "Qcache_inserts";
3814
112
Variable_name	Value
3815
113
Qcache_inserts	3
3816
114
show status like "Qcache_hits";
3817
115
Variable_name	Value
3818
116
Qcache_hits	2
3819
117
-----------------------------------------------------
3820
118
/* with comment first and "quote" */select * from t1
3821
119
-----------------------------------------------------
3822
120
show status like "Qcache_queries_in_cache";
3823
121
Variable_name	Value
3824
122
Qcache_queries_in_cache	3
3825
123
show status like "Qcache_inserts";
3826
124
Variable_name	Value
3827
125
Qcache_inserts	3
3828
126
show status like "Qcache_hits";
3829
127
Variable_name	Value
3830
128
Qcache_hits	2
3831
129
/* with comment first and "quote" */select * from t1;
3832
130
a
3833
131
1
3834
132
2
3835
133
3
3836
134
/* with comment first and "quote" */select * from t1;
3837
135
a
3838
136
1
3839
137
2
3840
138
3
3841
139
show status like "Qcache_queries_in_cache";
3842
140
Variable_name	Value
3843
141
Qcache_queries_in_cache	4
3844
142
show status like "Qcache_inserts";
3845
143
Variable_name	Value
3846
144
Qcache_inserts	4
3847
145
show status like "Qcache_hits";
3848
146
Variable_name	Value
3849
147
Qcache_hits	3
3850
148
-----------------------------------------------------
3851
149
# with comment first and "quote"
3852
150
select * from t1
3853
151
-----------------------------------------------------
3854
152
show status like "Qcache_queries_in_cache";
3855
153
Variable_name	Value
3856
154
Qcache_queries_in_cache	4
3857
155
show status like "Qcache_inserts";
3858
156
Variable_name	Value
3859
157
Qcache_inserts	4
3860
158
show status like "Qcache_hits";
3861
159
Variable_name	Value
3862
160
Qcache_hits	3
3863
161
# with comment first and "quote"
3864
162
select * from t1;
3865
163
a
3866
164
1
3867
165
2
3868
166
3
3869
167
# with comment first and "quote"
3870
168
select * from t1;
3871
169
a
3872
170
1
3873
171
2
3874
172
3
3875
173
show status like "Qcache_queries_in_cache";
3876
174
Variable_name	Value
3877
175
Qcache_queries_in_cache	5
3878
176
show status like "Qcache_inserts";
3879
177
Variable_name	Value
3880
178
Qcache_inserts	5
3881
179
show status like "Qcache_hits";
3882
180
Variable_name	Value
3883
181
Qcache_hits	3
3884
182
-----------------------------------------------------
3885
183
-- with comment first and "quote" 
3886
184
select * from t1
3887
185
-----------------------------------------------------
3888
186
show status like "Qcache_queries_in_cache";
3889
187
Variable_name	Value
3890
188
Qcache_queries_in_cache	5
3891
189
show status like "Qcache_inserts";
3892
190
Variable_name	Value
3893
191
Qcache_inserts	5
3894
192
show status like "Qcache_hits";
3895
193
Variable_name	Value
3896
194
Qcache_hits	3
3897
195
-- with comment first and "quote" 
3898
196
select * from t1;
3899
197
a
3900
198
1
3901
199
2
3902
200
3
3903
201
-- with comment first and "quote" 
3904
202
select * from t1;
3905
203
a
3906
204
1
3907
205
2
3908
206
3
3909
207
show status like "Qcache_queries_in_cache";
3910
208
Variable_name	Value
3911
209
Qcache_queries_in_cache	6
3912
210
show status like "Qcache_inserts";
3913
211
Variable_name	Value
3914
212
Qcache_inserts	6
3915
213
show status like "Qcache_hits";
3916
214
Variable_name	Value
3917
215
Qcache_hits	3
3918
216
-----------------------------------------------------
3919
217
/* with comment and whitespaces first */select * from t1
3920
218
-----------------------------------------------------
3921
219
show status like "Qcache_queries_in_cache";
3922
220
Variable_name	Value
3923
221
Qcache_queries_in_cache	6
3924
222
show status like "Qcache_inserts";
3925
223
Variable_name	Value
3926
224
Qcache_inserts	6
3927
225
show status like "Qcache_hits";
3928
226
Variable_name	Value
3929
227
Qcache_hits	3
3930
228
/* with comment and whitespaces first */select * from t1;
3931
229
a
3932
230
1
3933
231
2
3934
232
3
3935
233
/* with comment and whitespaces first */select * from t1;
3936
234
a
3937
235
1
3938
236
2
3939
237
3
3940
238
show status like "Qcache_queries_in_cache";
3941
239
Variable_name	Value
3942
240
Qcache_queries_in_cache	7
3943
241
show status like "Qcache_inserts";
3944
242
Variable_name	Value
3945
243
Qcache_inserts	7
3946
244
show status like "Qcache_hits";
3947
245
Variable_name	Value
3948
246
Qcache_hits	4
3949
247
-----------------------------------------------------
3950
248
# with comment and whitespaces first
3951
249
select * from t1
3952
250
-----------------------------------------------------
3953
251
show status like "Qcache_queries_in_cache";
3954
252
Variable_name	Value
3955
253
Qcache_queries_in_cache	7
3956
254
show status like "Qcache_inserts";
3957
255
Variable_name	Value
3958
256
Qcache_inserts	7
3959
257
show status like "Qcache_hits";
3960
258
Variable_name	Value
3961
259
Qcache_hits	4
3962
260
# with comment and whitespaces first
3963
261
select * from t1;
3964
262
a
3965
263
1
3966
264
2
3967
265
3
3968
266
# with comment and whitespaces first
3969
267
select * from t1;
3970
268
a
3971
269
1
3972
270
2
3973
271
3
3974
272
show status like "Qcache_queries_in_cache";
3975
273
Variable_name	Value
3976
274
Qcache_queries_in_cache	8
3977
275
show status like "Qcache_inserts";
3978
276
Variable_name	Value
3979
277
Qcache_inserts	8
3980
278
show status like "Qcache_hits";
3981
279
Variable_name	Value
3982
280
Qcache_hits	4
3983
281
-----------------------------------------------------
3984
282
-- with comment and whitespaces first
3985
283
select * from t1
3986
284
-----------------------------------------------------
3987
285
show status like "Qcache_queries_in_cache";
3988
286
Variable_name	Value
3989
287
Qcache_queries_in_cache	8
3990
288
show status like "Qcache_inserts";
3991
289
Variable_name	Value
3992
290
Qcache_inserts	8
3993
291
show status like "Qcache_hits";
3994
292
Variable_name	Value
3995
293
Qcache_hits	4
3996
294
-- with comment and whitespaces first
3997
295
select * from t1;
3998
296
a
3999
297
1
4000
298
2
4001
299
3
4002
300
-- with comment and whitespaces first
4003
301
select * from t1;
4004
302
a
4005
303
1
4006
304
2
4007
305
3
4008
306
show status like "Qcache_queries_in_cache";
4009
307
Variable_name	Value
4010
308
Qcache_queries_in_cache	9
4011
309
show status like "Qcache_inserts";
4012
310
Variable_name	Value
4013
311
Qcache_inserts	9
4014
312
show status like "Qcache_hits";
4015
313
Variable_name	Value
4016
314
Qcache_hits	4
4017
315
-----------------------------------------------------
4018
316
select * /* internal comment */ from t1
4019
317
-----------------------------------------------------
4020
318
show status like "Qcache_queries_in_cache";
4021
319
Variable_name	Value
4022
320
Qcache_queries_in_cache	9
4023
321
show status like "Qcache_inserts";
4024
322
Variable_name	Value
4025
323
Qcache_inserts	9
4026
324
show status like "Qcache_hits";
4027
325
Variable_name	Value
4028
326
Qcache_hits	4
4029
327
select * /* internal comment */ from t1;
4030
328
a
4031
329
1
4032
330
2
4033
331
3
4034
332
select * /* internal comment */ from t1;
4035
333
a
4036
334
1
4037
335
2
4038
336
3
4039
337
show status like "Qcache_queries_in_cache";
4040
338
Variable_name	Value
4041
339
Qcache_queries_in_cache	10
4042
340
show status like "Qcache_inserts";
4043
341
Variable_name	Value
4044
342
Qcache_inserts	10
4045
343
show status like "Qcache_hits";
4046
344
Variable_name	Value
4047
345
Qcache_hits	5
4048
346
-----------------------------------------------------
4049
347
select */* internal comment */ from t1
4050
348
-----------------------------------------------------
4051
349
show status like "Qcache_queries_in_cache";
4052
350
Variable_name	Value
4053
351
Qcache_queries_in_cache	10
4054
352
show status like "Qcache_inserts";
4055
353
Variable_name	Value
4056
354
Qcache_inserts	10
4057
355
show status like "Qcache_hits";
4058
356
Variable_name	Value
4059
357
Qcache_hits	5
4060
358
select */* internal comment */ from t1;
4061
359
a
4062
360
1
4063
361
2
4064
362
3
4065
363
select */* internal comment */ from t1;
4066
364
a
4067
365
1
4068
366
2
4069
367
3
4070
368
show status like "Qcache_queries_in_cache";
4071
369
Variable_name	Value
4072
370
Qcache_queries_in_cache	11
4073
371
show status like "Qcache_inserts";
4074
372
Variable_name	Value
4075
373
Qcache_inserts	11
4076
374
show status like "Qcache_hits";
4077
375
Variable_name	Value
4078
376
Qcache_hits	6
4079
377
-----------------------------------------------------
4080
378
select */* internal comment */from t1
4081
379
-----------------------------------------------------
4082
380
show status like "Qcache_queries_in_cache";
4083
381
Variable_name	Value
4084
382
Qcache_queries_in_cache	11
4085
383
show status like "Qcache_inserts";
4086
384
Variable_name	Value
4087
385
Qcache_inserts	11
4088
386
show status like "Qcache_hits";
4089
387
Variable_name	Value
4090
388
Qcache_hits	6
4091
389
select */* internal comment */from t1;
4092
390
a
4093
391
1
4094
392
2
4095
393
3
4096
394
select */* internal comment */from t1;
4097
395
a
4098
396
1
4099
397
2
4100
398
3
4101
399
show status like "Qcache_queries_in_cache";
4102
400
Variable_name	Value
4103
401
Qcache_queries_in_cache	12
4104
402
show status like "Qcache_inserts";
4105
403
Variable_name	Value
4106
404
Qcache_inserts	12
4107
405
show status like "Qcache_hits";
4108
406
Variable_name	Value
4109
407
Qcache_hits	7
4110
408
-----------------------------------------------------
4111
409
select * /* internal comment with "quote" */ from t1
4112
410
-----------------------------------------------------
4113
411
show status like "Qcache_queries_in_cache";
4114
412
Variable_name	Value
4115
413
Qcache_queries_in_cache	12
4116
414
show status like "Qcache_inserts";
4117
415
Variable_name	Value
4118
416
Qcache_inserts	12
4119
417
show status like "Qcache_hits";
4120
418
Variable_name	Value
4121
419
Qcache_hits	7
4122
420
select * /* internal comment with "quote" */ from t1;
4123
421
a
4124
422
1
4125
423
2
4126
424
3
4127
425
select * /* internal comment with "quote" */ from t1;
4128
426
a
4129
427
1
4130
428
2
4131
429
3
4132
430
show status like "Qcache_queries_in_cache";
4133
431
Variable_name	Value
4134
432
Qcache_queries_in_cache	13
4135
433
show status like "Qcache_inserts";
4136
434
Variable_name	Value
4137
435
Qcache_inserts	13
4138
436
show status like "Qcache_hits";
4139
437
Variable_name	Value
4140
438
Qcache_hits	8
4141
439
-----------------------------------------------------
4142
440
select */* internal comment with "quote" */ from t1
4143
441
-----------------------------------------------------
4144
442
show status like "Qcache_queries_in_cache";
4145
443
Variable_name	Value
4146
444
Qcache_queries_in_cache	13
4147
445
show status like "Qcache_inserts";
4148
446
Variable_name	Value
4149
447
Qcache_inserts	13
4150
448
show status like "Qcache_hits";
4151
449
Variable_name	Value
4152
450
Qcache_hits	8
4153
451
select */* internal comment with "quote" */ from t1;
4154
452
a
4155
453
1
4156
454
2
4157
455
3
4158
456
select */* internal comment with "quote" */ from t1;
4159
457
a
4160
458
1
4161
459
2
4162
460
3
4163
461
show status like "Qcache_queries_in_cache";
4164
462
Variable_name	Value
4165
463
Qcache_queries_in_cache	14
4166
464
show status like "Qcache_inserts";
4167
465
Variable_name	Value
4168
466
Qcache_inserts	14
4169
467
show status like "Qcache_hits";
4170
468
Variable_name	Value
4171
469
Qcache_hits	9
4172
470
-----------------------------------------------------
4173
471
select */* internal comment with "quote" */from t1
4174
472
-----------------------------------------------------
4175
473
show status like "Qcache_queries_in_cache";
4176
474
Variable_name	Value
4177
475
Qcache_queries_in_cache	14
4178
476
show status like "Qcache_inserts";
4179
477
Variable_name	Value
4180
478
Qcache_inserts	14
4181
479
show status like "Qcache_hits";
4182
480
Variable_name	Value
4183
481
Qcache_hits	9
4184
482
select */* internal comment with "quote" */from t1;
4185
483
a
4186
484
1
4187
485
2
4188
486
3
4189
487
select */* internal comment with "quote" */from t1;
4190
488
a
4191
489
1
4192
490
2
4193
491
3
4194
492
show status like "Qcache_queries_in_cache";
4195
493
Variable_name	Value
4196
494
Qcache_queries_in_cache	15
4197
495
show status like "Qcache_inserts";
4198
496
Variable_name	Value
4199
497
Qcache_inserts	15
4200
498
show status like "Qcache_hits";
4201
499
Variable_name	Value
4202
500
Qcache_hits	10
4203
501
-----------------------------------------------------
4204
502
select * from t1
4205
503
4206
504
-----------------------------------------------------
4207
505
show status like "Qcache_queries_in_cache";
4208
506
Variable_name	Value
4209
507
Qcache_queries_in_cache	15
4210
508
show status like "Qcache_inserts";
4211
509
Variable_name	Value
4212
510
Qcache_inserts	15
4213
511
show status like "Qcache_hits";
4214
512
Variable_name	Value
4215
513
Qcache_hits	10
4216
514
select * from t1
4217
515
;
4218
516
a
4219
517
1
4220
518
2
4221
519
3
4222
520
select * from t1
4223
521
;
4224
522
a
4225
523
1
4226
524
2
4227
525
3
4228
526
show status like "Qcache_queries_in_cache";
4229
527
Variable_name	Value
4230
528
Qcache_queries_in_cache	16
4231
529
show status like "Qcache_inserts";
4232
530
Variable_name	Value
4233
531
Qcache_inserts	16
4234
532
show status like "Qcache_hits";
4235
533
Variable_name	Value
4236
534
Qcache_hits	11
4237
535
-----------------------------------------------------
4238
536
select * from t1 
4239
537
-----------------------------------------------------
4240
538
show status like "Qcache_queries_in_cache";
4241
539
Variable_name	Value
4242
540
Qcache_queries_in_cache	16
4243
541
show status like "Qcache_inserts";
4244
542
Variable_name	Value
4245
543
Qcache_inserts	16
4246
544
show status like "Qcache_hits";
4247
545
Variable_name	Value
4248
546
Qcache_hits	11
4249
547
select * from t1 ;
4250
548
a
4251
549
1
4252
550
2
4253
551
3
4254
552
select * from t1 ;
4255
553
a
4256
554
1
4257
555
2
4258
556
3
4259
557
show status like "Qcache_queries_in_cache";
4260
558
Variable_name	Value
4261
559
Qcache_queries_in_cache	16
4262
560
show status like "Qcache_inserts";
4263
561
Variable_name	Value
4264
562
Qcache_inserts	16
4265
563
show status like "Qcache_hits";
4266
564
Variable_name	Value
4267
565
Qcache_hits	13
4268
566
-----------------------------------------------------
4269
567
select * from t1	
4270
568
-----------------------------------------------------
4271
569
show status like "Qcache_queries_in_cache";
4272
570
Variable_name	Value
4273
571
Qcache_queries_in_cache	16
4274
572
show status like "Qcache_inserts";
4275
573
Variable_name	Value
4276
574
Qcache_inserts	16
4277
575
show status like "Qcache_hits";
4278
576
Variable_name	Value
4279
577
Qcache_hits	13
4280
578
select * from t1	;
4281
579
a
4282
580
1
4283
581
2
4284
582
3
4285
583
select * from t1	;
4286
584
a
4287
585
1
4288
586
2
4289
587
3
4290
588
show status like "Qcache_queries_in_cache";
4291
589
Variable_name	Value
4292
590
Qcache_queries_in_cache	16
4293
591
show status like "Qcache_inserts";
4294
592
Variable_name	Value
4295
593
Qcache_inserts	16
4296
594
show status like "Qcache_hits";
4297
595
Variable_name	Value
4298
596
Qcache_hits	15
4299
597
-----------------------------------------------------
4300
598
select * from t1
4301
599
/* comment in the end */
4302
600
-----------------------------------------------------
4303
601
show status like "Qcache_queries_in_cache";
4304
602
Variable_name	Value
4305
603
Qcache_queries_in_cache	16
4306
604
show status like "Qcache_inserts";
4307
605
Variable_name	Value
4308
606
Qcache_inserts	16
4309
607
show status like "Qcache_hits";
4310
608
Variable_name	Value
4311
609
Qcache_hits	15
4312
610
select * from t1
4313
611
/* comment in the end */;
4314
612
a
4315
613
1
4316
614
2
4317
615
3
4318
616
select * from t1
4319
617
/* comment in the end */;
4320
618
a
4321
619
1
4322
620
2
4323
621
3
4324
622
show status like "Qcache_queries_in_cache";
4325
623
Variable_name	Value
4326
624
Qcache_queries_in_cache	17
4327
625
show status like "Qcache_inserts";
4328
626
Variable_name	Value
4329
627
Qcache_inserts	17
4330
628
show status like "Qcache_hits";
4331
629
Variable_name	Value
4332
630
Qcache_hits	16
4333
631
-----------------------------------------------------
4334
632
select * from t1
4335
633
/* *\/ */
4336
634
-----------------------------------------------------
4337
635
show status like "Qcache_queries_in_cache";
4338
636
Variable_name	Value
4339
637
Qcache_queries_in_cache	17
4340
638
show status like "Qcache_inserts";
4341
639
Variable_name	Value
4342
640
Qcache_inserts	17
4343
641
show status like "Qcache_hits";
4344
642
Variable_name	Value
4345
643
Qcache_hits	16
4346
644
select * from t1
4347
645
/* *\/ */;
4348
646
a
4349
647
1
4350
648
2
4351
649
3
4352
650
select * from t1
4353
651
/* *\/ */;
4354
652
a
4355
653
1
4356
654
2
4357
655
3
4358
656
show status like "Qcache_queries_in_cache";
4359
657
Variable_name	Value
4360
658
Qcache_queries_in_cache	18
4361
659
show status like "Qcache_inserts";
4362
660
Variable_name	Value
4363
661
Qcache_inserts	18
4364
662
show status like "Qcache_hits";
4365
663
Variable_name	Value
4366
664
Qcache_hits	17
4367
665
-----------------------------------------------------
4368
666
select * from t1
4369
667
/* comment in the end */
4370
668
4371
669
-----------------------------------------------------
4372
670
show status like "Qcache_queries_in_cache";
4373
671
Variable_name	Value
4374
672
Qcache_queries_in_cache	18
4375
673
show status like "Qcache_inserts";
4376
674
Variable_name	Value
4377
675
Qcache_inserts	18
4378
676
show status like "Qcache_hits";
4379
677
Variable_name	Value
4380
678
Qcache_hits	17
4381
679
select * from t1
4382
680
/* comment in the end */
4383
681
;
4384
682
a
4385
683
1
4386
684
2
4387
685
3
4388
686
select * from t1
4389
687
/* comment in the end */
4390
688
;
4391
689
a
4392
690
1
4393
691
2
4394
692
3
4395
693
show status like "Qcache_queries_in_cache";
4396
694
Variable_name	Value
4397
695
Qcache_queries_in_cache	18
4398
696
show status like "Qcache_inserts";
4399
697
Variable_name	Value
4400
698
Qcache_inserts	18
4401
699
show status like "Qcache_hits";
4402
700
Variable_name	Value
4403
701
Qcache_hits	19
4404
702
-----------------------------------------------------
4405
703
select * from t1 #comment in the end
4406
704
-----------------------------------------------------
4407
705
show status like "Qcache_queries_in_cache";
4408
706
Variable_name	Value
4409
707
Qcache_queries_in_cache	18
4410
708
show status like "Qcache_inserts";
4411
709
Variable_name	Value
4412
710
Qcache_inserts	18
4413
711
show status like "Qcache_hits";
4414
712
Variable_name	Value
4415
713
Qcache_hits	19
4416
714
select * from t1 #comment in the end;
4417
715
a
4418
716
1
4419
717
2
4420
718
3
4421
719
select * from t1 #comment in the end;
4422
720
a
4423
721
1
4424
722
2
4425
723
3
4426
724
show status like "Qcache_queries_in_cache";
4427
725
Variable_name	Value
4428
726
Qcache_queries_in_cache	19
4429
727
show status like "Qcache_inserts";
4430
728
Variable_name	Value
4431
729
Qcache_inserts	19
4432
730
show status like "Qcache_hits";
4433
731
Variable_name	Value
4434
732
Qcache_hits	20
4435
733
-----------------------------------------------------
4436
734
select * from t1 #comment in the end
4437
735
4438
736
-----------------------------------------------------
4439
737
show status like "Qcache_queries_in_cache";
4440
738
Variable_name	Value
4441
739
Qcache_queries_in_cache	19
4442
740
show status like "Qcache_inserts";
4443
741
Variable_name	Value
4444
742
Qcache_inserts	19
4445
743
show status like "Qcache_hits";
4446
744
Variable_name	Value
4447
745
Qcache_hits	20
4448
746
select * from t1 #comment in the end
4449
747
;
4450
748
a
4451
749
1
4452
750
2
4453
751
3
4454
752
select * from t1 #comment in the end
4455
753
;
4456
754
a
4457
755
1
4458
756
2
4459
757
3
4460
758
show status like "Qcache_queries_in_cache";
4461
759
Variable_name	Value
4462
760
Qcache_queries_in_cache	19
4463
761
show status like "Qcache_inserts";
4464
762
Variable_name	Value
4465
763
Qcache_inserts	19
4466
764
show status like "Qcache_hits";
4467
765
Variable_name	Value
4468
766
Qcache_hits	22
4469
767
-----------------------------------------------------
4470
768
select * from t1 -- comment in the end
4471
769
-----------------------------------------------------
4472
770
show status like "Qcache_queries_in_cache";
4473
771
Variable_name	Value
4474
772
Qcache_queries_in_cache	19
4475
773
show status like "Qcache_inserts";
4476
774
Variable_name	Value
4477
775
Qcache_inserts	19
4478
776
show status like "Qcache_hits";
4479
777
Variable_name	Value
4480
778
Qcache_hits	22
4481
779
select * from t1 -- comment in the end;
4482
780
a
4483
781
1
4484
782
2
4485
783
3
4486
784
select * from t1 -- comment in the end;
4487
785
a
4488
786
1
4489
787
2
4490
788
3
4491
789
show status like "Qcache_queries_in_cache";
4492
790
Variable_name	Value
4493
791
Qcache_queries_in_cache	20
4494
792
show status like "Qcache_inserts";
4495
793
Variable_name	Value
4496
794
Qcache_inserts	20
4497
795
show status like "Qcache_hits";
4498
796
Variable_name	Value
4499
797
Qcache_hits	23
4500
798
-----------------------------------------------------
4501
799
select * from t1 -- comment in the end
4502
800
4503
801
-----------------------------------------------------
4504
802
show status like "Qcache_queries_in_cache";
4505
803
Variable_name	Value
4506
804
Qcache_queries_in_cache	20
4507
805
show status like "Qcache_inserts";
4508
806
Variable_name	Value
4509
807
Qcache_inserts	20
4510
808
show status like "Qcache_hits";
4511
809
Variable_name	Value
4512
810
Qcache_hits	23
4513
811
select * from t1 -- comment in the end
4514
812
;
4515
813
a
4516
814
1
4517
815
2
4518
816
3
4519
817
select * from t1 -- comment in the end
4520
818
;
4521
819
a
4522
820
1
4523
821
2
4524
822
3
4525
823
show status like "Qcache_queries_in_cache";
4526
824
Variable_name	Value
4527
825
Qcache_queries_in_cache	20
4528
826
show status like "Qcache_inserts";
4529
827
Variable_name	Value
4530
828
Qcache_inserts	20
4531
829
show status like "Qcache_hits";
4532
830
Variable_name	Value
4533
831
Qcache_hits	25
4534
832
-----------------------------------------------------
4535
833
select ' \'  ' from t1
4536
834
-----------------------------------------------------
4537
835
show status like "Qcache_queries_in_cache";
4538
836
Variable_name	Value
4539
837
Qcache_queries_in_cache	20
4540
838
show status like "Qcache_inserts";
4541
839
Variable_name	Value
4542
840
Qcache_inserts	20
4543
841
show status like "Qcache_hits";
4544
842
Variable_name	Value
4545
843
Qcache_hits	25
4546
844
select ' \'  ' from t1;
4547
845
'  
4548
846
 '  
4549
847
 '  
4550
848
 '  
4551
849
select ' \'  ' from t1;
4552
850
'  
4553
851
 '  
4554
852
 '  
4555
853
 '  
4556
854
show status like "Qcache_queries_in_cache";
4557
855
Variable_name	Value
4558
856
Qcache_queries_in_cache	21
4559
857
show status like "Qcache_inserts";
4560
858
Variable_name	Value
4561
859
Qcache_inserts	21
4562
860
show status like "Qcache_hits";
4563
861
Variable_name	Value
4564
862
Qcache_hits	26
4565
863
DROP TABLE t1;
4566
864
SET GLOBAL query_cache_size=default;
4567
865
set global query_cache_strip_comments=OFF;
4568
0
866
4569
=== removed file 'Percona-Server/mysql-test/r/percona_query_cache_with_comments_disable.result'
4570
--- Percona-Server/mysql-test/r/percona_query_cache_with_comments_disable.result	2012-04-18 23:25:43 +0000
4571
+++ Percona-Server/mysql-test/r/percona_query_cache_with_comments_disable.result	1970-01-01 00:00:00 +0000
4572
@@ -1,865 +0,0 @@
4573
1
set GLOBAL query_cache_size=1355776;
4574
2
drop table if exists t1;
4575
3
create table t1 (a int not null);
4576
4
insert into t1 values (1),(2),(3);
4577
5
flush query cache;
4578
6
flush query cache;
4579
7
reset query cache;
4580
8
flush status;
4581
9
flush query cache;
4582
10
flush query cache;
4583
11
reset query cache;
4584
12
flush status;
4585
13
/* with comment first */select * from t1;
4586
14
a
4587
15
1
4588
16
2
4589
17
3
4590
18
-----------------------------------------------------
4591
19
/* with comment first */select * from t1
4592
20
-----------------------------------------------------
4593
21
show status like "Qcache_queries_in_cache";
4594
22
Variable_name	Value
4595
23
Qcache_queries_in_cache	1
4596
24
show status like "Qcache_inserts";
4597
25
Variable_name	Value
4598
26
Qcache_inserts	1
4599
27
show status like "Qcache_hits";
4600
28
Variable_name	Value
4601
29
Qcache_hits	0
4602
30
/* with comment first */select * from t1;
4603
31
a
4604
32
1
4605
33
2
4606
34
3
4607
35
/* with comment first */select * from t1;
4608
36
a
4609
37
1
4610
38
2
4611
39
3
4612
40
show status like "Qcache_queries_in_cache";
4613
41
Variable_name	Value
4614
42
Qcache_queries_in_cache	1
4615
43
show status like "Qcache_inserts";
4616
44
Variable_name	Value
4617
45
Qcache_inserts	1
4618
46
show status like "Qcache_hits";
4619
47
Variable_name	Value
4620
48
Qcache_hits	2
4621
49
-----------------------------------------------------
4622
50
# with comment first
4623
51
select * from t1
4624
52
-----------------------------------------------------
4625
53
show status like "Qcache_queries_in_cache";
4626
54
Variable_name	Value
4627
55
Qcache_queries_in_cache	1
4628
56
show status like "Qcache_inserts";
4629
57
Variable_name	Value
4630
58
Qcache_inserts	1
4631
59
show status like "Qcache_hits";
4632
60
Variable_name	Value
4633
61
Qcache_hits	2
4634
62
# with comment first
4635
63
select * from t1;
4636
64
a
4637
65
1
4638
66
2
4639
67
3
4640
68
# with comment first
4641
69
select * from t1;
4642
70
a
4643
71
1
4644
72
2
4645
73
3
4646
74
show status like "Qcache_queries_in_cache";
4647
75
Variable_name	Value
4648
76
Qcache_queries_in_cache	2
4649
77
show status like "Qcache_inserts";
4650
78
Variable_name	Value
4651
79
Qcache_inserts	2
4652
80
show status like "Qcache_hits";
4653
81
Variable_name	Value
4654
82
Qcache_hits	2
4655
83
-----------------------------------------------------
4656
84
-- with comment first
4657
85
select * from t1
4658
86
-----------------------------------------------------
4659
87
show status like "Qcache_queries_in_cache";
4660
88
Variable_name	Value
4661
89
Qcache_queries_in_cache	2
4662
90
show status like "Qcache_inserts";
4663
91
Variable_name	Value
4664
92
Qcache_inserts	2
4665
93
show status like "Qcache_hits";
4666
94
Variable_name	Value
4667
95
Qcache_hits	2
4668
96
-- with comment first
4669
97
select * from t1;
4670
98
a
4671
99
1
4672
100
2
4673
101
3
4674
102
-- with comment first
4675
103
select * from t1;
4676
104
a
4677
105
1
4678
106
2
4679
107
3
4680
108
show status like "Qcache_queries_in_cache";
4681
109
Variable_name	Value
4682
110
Qcache_queries_in_cache	3
4683
111
show status like "Qcache_inserts";
4684
112
Variable_name	Value
4685
113
Qcache_inserts	3
4686
114
show status like "Qcache_hits";
4687
115
Variable_name	Value
4688
116
Qcache_hits	2
4689
117
-----------------------------------------------------
4690
118
/* with comment first and "quote" */select * from t1
4691
119
-----------------------------------------------------
4692
120
show status like "Qcache_queries_in_cache";
4693
121
Variable_name	Value
4694
122
Qcache_queries_in_cache	3
4695
123
show status like "Qcache_inserts";
4696
124
Variable_name	Value
4697
125
Qcache_inserts	3
4698
126
show status like "Qcache_hits";
4699
127
Variable_name	Value
4700
128
Qcache_hits	2
4701
129
/* with comment first and "quote" */select * from t1;
4702
130
a
4703
131
1
4704
132
2
4705
133
3
4706
134
/* with comment first and "quote" */select * from t1;
4707
135
a
4708
136
1
4709
137
2
4710
138
3
4711
139
show status like "Qcache_queries_in_cache";
4712
140
Variable_name	Value
4713
141
Qcache_queries_in_cache	4
4714
142
show status like "Qcache_inserts";
4715
143
Variable_name	Value
4716
144
Qcache_inserts	4
4717
145
show status like "Qcache_hits";
4718
146
Variable_name	Value
4719
147
Qcache_hits	3
4720
148
-----------------------------------------------------
4721
149
# with comment first and "quote"
4722
150
select * from t1
4723
151
-----------------------------------------------------
4724
152
show status like "Qcache_queries_in_cache";
4725
153
Variable_name	Value
4726
154
Qcache_queries_in_cache	4
4727
155
show status like "Qcache_inserts";
4728
156
Variable_name	Value
4729
157
Qcache_inserts	4
4730
158
show status like "Qcache_hits";
4731
159
Variable_name	Value
4732
160
Qcache_hits	3
4733
161
# with comment first and "quote"
4734
162
select * from t1;
4735
163
a
4736
164
1
4737
165
2
4738
166
3
4739
167
# with comment first and "quote"
4740
168
select * from t1;
4741
169
a
4742
170
1
4743
171
2
4744
172
3
4745
173
show status like "Qcache_queries_in_cache";
4746
174
Variable_name	Value
4747
175
Qcache_queries_in_cache	5
4748
176
show status like "Qcache_inserts";
4749
177
Variable_name	Value
4750
178
Qcache_inserts	5
4751
179
show status like "Qcache_hits";
4752
180
Variable_name	Value
4753
181
Qcache_hits	3
4754
182
-----------------------------------------------------
4755
183
-- with comment first and "quote" 
4756
184
select * from t1
4757
185
-----------------------------------------------------
4758
186
show status like "Qcache_queries_in_cache";
4759
187
Variable_name	Value
4760
188
Qcache_queries_in_cache	5
4761
189
show status like "Qcache_inserts";
4762
190
Variable_name	Value
4763
191
Qcache_inserts	5
4764
192
show status like "Qcache_hits";
4765
193
Variable_name	Value
4766
194
Qcache_hits	3
4767
195
-- with comment first and "quote" 
4768
196
select * from t1;
4769
197
a
4770
198
1
4771
199
2
4772
200
3
4773
201
-- with comment first and "quote" 
4774
202
select * from t1;
4775
203
a
4776
204
1
4777
205
2
4778
206
3
4779
207
show status like "Qcache_queries_in_cache";
4780
208
Variable_name	Value
4781
209
Qcache_queries_in_cache	6
4782
210
show status like "Qcache_inserts";
4783
211
Variable_name	Value
4784
212
Qcache_inserts	6
4785
213
show status like "Qcache_hits";
4786
214
Variable_name	Value
4787
215
Qcache_hits	3
4788
216
-----------------------------------------------------
4789
217
/* with comment and whitespaces first */select * from t1
4790
218
-----------------------------------------------------
4791
219
show status like "Qcache_queries_in_cache";
4792
220
Variable_name	Value
4793
221
Qcache_queries_in_cache	6
4794
222
show status like "Qcache_inserts";
4795
223
Variable_name	Value
4796
224
Qcache_inserts	6
4797
225
show status like "Qcache_hits";
4798
226
Variable_name	Value
4799
227
Qcache_hits	3
4800
228
/* with comment and whitespaces first */select * from t1;
4801
229
a
4802
230
1
4803
231
2
4804
232
3
4805
233
/* with comment and whitespaces first */select * from t1;
4806
234
a
4807
235
1
4808
236
2
4809
237
3
4810
238
show status like "Qcache_queries_in_cache";
4811
239
Variable_name	Value
4812
240
Qcache_queries_in_cache	7
4813
241
show status like "Qcache_inserts";
4814
242
Variable_name	Value
4815
243
Qcache_inserts	7
4816
244
show status like "Qcache_hits";
4817
245
Variable_name	Value
4818
246
Qcache_hits	4
4819
247
-----------------------------------------------------
4820
248
# with comment and whitespaces first
4821
249
select * from t1
4822
250
-----------------------------------------------------
4823
251
show status like "Qcache_queries_in_cache";
4824
252
Variable_name	Value
4825
253
Qcache_queries_in_cache	7
4826
254
show status like "Qcache_inserts";
4827
255
Variable_name	Value
4828
256
Qcache_inserts	7
4829
257
show status like "Qcache_hits";
4830
258
Variable_name	Value
4831
259
Qcache_hits	4
4832
260
# with comment and whitespaces first
4833
261
select * from t1;
4834
262
a
4835
263
1
4836
264
2
4837
265
3
4838
266
# with comment and whitespaces first
4839
267
select * from t1;
4840
268
a
4841
269
1
4842
270
2
4843
271
3
4844
272
show status like "Qcache_queries_in_cache";
4845
273
Variable_name	Value
4846
274
Qcache_queries_in_cache	8
4847
275
show status like "Qcache_inserts";
4848
276
Variable_name	Value
4849
277
Qcache_inserts	8
4850
278
show status like "Qcache_hits";
4851
279
Variable_name	Value
4852
280
Qcache_hits	4
4853
281
-----------------------------------------------------
4854
282
-- with comment and whitespaces first
4855
283
select * from t1
4856
284
-----------------------------------------------------
4857
285
show status like "Qcache_queries_in_cache";
4858
286
Variable_name	Value
4859
287
Qcache_queries_in_cache	8
4860
288
show status like "Qcache_inserts";
4861
289
Variable_name	Value
4862
290
Qcache_inserts	8
4863
291
show status like "Qcache_hits";
4864
292
Variable_name	Value
4865
293
Qcache_hits	4
4866
294
-- with comment and whitespaces first
4867
295
select * from t1;
4868
296
a
4869
297
1
4870
298
2
4871
299
3
4872
300
-- with comment and whitespaces first
4873
301
select * from t1;
4874
302
a
4875
303
1
4876
304
2
4877
305
3
4878
306
show status like "Qcache_queries_in_cache";
4879
307
Variable_name	Value
4880
308
Qcache_queries_in_cache	9
4881
309
show status like "Qcache_inserts";
4882
310
Variable_name	Value
4883
311
Qcache_inserts	9
4884
312
show status like "Qcache_hits";
4885
313
Variable_name	Value
4886
314
Qcache_hits	4
4887
315
-----------------------------------------------------
4888
316
select * /* internal comment */ from t1
4889
317
-----------------------------------------------------
4890
318
show status like "Qcache_queries_in_cache";
4891
319
Variable_name	Value
4892
320
Qcache_queries_in_cache	9
4893
321
show status like "Qcache_inserts";
4894
322
Variable_name	Value
4895
323
Qcache_inserts	9
4896
324
show status like "Qcache_hits";
4897
325
Variable_name	Value
4898
326
Qcache_hits	4
4899
327
select * /* internal comment */ from t1;
4900
328
a
4901
329
1
4902
330
2
4903
331
3
4904
332
select * /* internal comment */ from t1;
4905
333
a
4906
334
1
4907
335
2
4908
336
3
4909
337
show status like "Qcache_queries_in_cache";
4910
338
Variable_name	Value
4911
339
Qcache_queries_in_cache	10
4912
340
show status like "Qcache_inserts";
4913
341
Variable_name	Value
4914
342
Qcache_inserts	10
4915
343
show status like "Qcache_hits";
4916
344
Variable_name	Value
4917
345
Qcache_hits	5
4918
346
-----------------------------------------------------
4919
347
select */* internal comment */ from t1
4920
348
-----------------------------------------------------
4921
349
show status like "Qcache_queries_in_cache";
4922
350
Variable_name	Value
4923
351
Qcache_queries_in_cache	10
4924
352
show status like "Qcache_inserts";
4925
353
Variable_name	Value
4926
354
Qcache_inserts	10
4927
355
show status like "Qcache_hits";
4928
356
Variable_name	Value
4929
357
Qcache_hits	5
4930
358
select */* internal comment */ from t1;
4931
359
a
4932
360
1
4933
361
2
4934
362
3
4935
363
select */* internal comment */ from t1;
4936
364
a
4937
365
1
4938
366
2
4939
367
3
4940
368
show status like "Qcache_queries_in_cache";
4941
369
Variable_name	Value
4942
370
Qcache_queries_in_cache	11
4943
371
show status like "Qcache_inserts";
4944
372
Variable_name	Value
4945
373
Qcache_inserts	11
4946
374
show status like "Qcache_hits";
4947
375
Variable_name	Value
4948
376
Qcache_hits	6
4949
377
-----------------------------------------------------
4950
378
select */* internal comment */from t1
4951
379
-----------------------------------------------------
4952
380
show status like "Qcache_queries_in_cache";
4953
381
Variable_name	Value
4954
382
Qcache_queries_in_cache	11
4955
383
show status like "Qcache_inserts";
4956
384
Variable_name	Value
4957
385
Qcache_inserts	11
4958
386
show status like "Qcache_hits";
4959
387
Variable_name	Value
4960
388
Qcache_hits	6
4961
389
select */* internal comment */from t1;
4962
390
a
4963
391
1
4964
392
2
4965
393
3
4966
394
select */* internal comment */from t1;
4967
395
a
4968
396
1
4969
397
2
4970
398
3
4971
399
show status like "Qcache_queries_in_cache";
4972
400
Variable_name	Value
4973
401
Qcache_queries_in_cache	12
4974
402
show status like "Qcache_inserts";
4975
403
Variable_name	Value
4976
404
Qcache_inserts	12
4977
405
show status like "Qcache_hits";
4978
406
Variable_name	Value
4979
407
Qcache_hits	7
4980
408
-----------------------------------------------------
4981
409
select * /* internal comment with "quote" */ from t1
4982
410
-----------------------------------------------------
4983
411
show status like "Qcache_queries_in_cache";
4984
412
Variable_name	Value
4985
413
Qcache_queries_in_cache	12
4986
414
show status like "Qcache_inserts";
4987
415
Variable_name	Value
4988
416
Qcache_inserts	12
4989
417
show status like "Qcache_hits";
4990
418
Variable_name	Value
4991
419
Qcache_hits	7
4992
420
select * /* internal comment with "quote" */ from t1;
4993
421
a
4994
422
1
4995
423
2
4996
424
3
4997
425
select * /* internal comment with "quote" */ from t1;
4998
426
a
4999
427
1
5000
428
2
Reviewer	Date Requested	Status
Stewart Smith (community)		Approve on 2013-05-28
Registry Administrators	2013-05-26	Pending
Review via email: mp+165777@code.launchpad.net