1
set GLOBAL query_cache_size=1355776;
2
drop table if exists t1;
3
create table t1 (a int not null);
4
insert into t1 values (1),(2),(3);
13
/* with comment first */select * from t1;
18
-----------------------------------------------------
19
/* with comment first */select * from t1
20
-----------------------------------------------------
21
show status like "Qcache_queries_in_cache";
23
Qcache_queries_in_cache 1
24
show status like "Qcache_inserts";
27
show status like "Qcache_hits";
30
/* with comment first */select * from t1;
35
/* with comment first */select * from t1;
40
show status like "Qcache_queries_in_cache";
42
Qcache_queries_in_cache 1
43
show status like "Qcache_inserts";
46
show status like "Qcache_hits";
49
-----------------------------------------------------
52
-----------------------------------------------------
53
show status like "Qcache_queries_in_cache";
55
Qcache_queries_in_cache 1
56
show status like "Qcache_inserts";
59
show status like "Qcache_hits";
74
show status like "Qcache_queries_in_cache";
76
Qcache_queries_in_cache 2
77
show status like "Qcache_inserts";
80
show status like "Qcache_hits";
83
-----------------------------------------------------
85
-----------------------------------------------------
86
show status like "Qcache_queries_in_cache";
88
Qcache_queries_in_cache 2
89
show status like "Qcache_inserts";
92
show status like "Qcache_hits";
105
show status like "Qcache_queries_in_cache";
107
Qcache_queries_in_cache 3
108
show status like "Qcache_inserts";
111
show status like "Qcache_hits";
114
-----------------------------------------------------
115
/* with comment first and "quote" */select * from t1
116
-----------------------------------------------------
117
show status like "Qcache_queries_in_cache";
119
Qcache_queries_in_cache 3
120
show status like "Qcache_inserts";
123
show status like "Qcache_hits";
126
/* with comment first and "quote" */select * from t1;
131
/* with comment first and "quote" */select * from t1;
136
show status like "Qcache_queries_in_cache";
138
Qcache_queries_in_cache 4
139
show status like "Qcache_inserts";
142
show status like "Qcache_hits";
145
-----------------------------------------------------
146
# with comment first and "quote"
148
-----------------------------------------------------
149
show status like "Qcache_queries_in_cache";
151
Qcache_queries_in_cache 4
152
show status like "Qcache_inserts";
155
show status like "Qcache_hits";
158
# with comment first and "quote"
164
# with comment first and "quote"
170
show status like "Qcache_queries_in_cache";
172
Qcache_queries_in_cache 5
173
show status like "Qcache_inserts";
176
show status like "Qcache_hits";
179
-----------------------------------------------------
181
-----------------------------------------------------
182
show status like "Qcache_queries_in_cache";
184
Qcache_queries_in_cache 5
185
show status like "Qcache_inserts";
188
show status like "Qcache_hits";
201
show status like "Qcache_queries_in_cache";
203
Qcache_queries_in_cache 6
204
show status like "Qcache_inserts";
207
show status like "Qcache_hits";
210
-----------------------------------------------------
211
/* with comment and whitespaces first */select * from t1
212
-----------------------------------------------------
213
show status like "Qcache_queries_in_cache";
215
Qcache_queries_in_cache 6
216
show status like "Qcache_inserts";
219
show status like "Qcache_hits";
222
/* with comment and whitespaces first */select * from t1;
227
/* with comment and whitespaces first */select * from t1;
232
show status like "Qcache_queries_in_cache";
234
Qcache_queries_in_cache 7
235
show status like "Qcache_inserts";
238
show status like "Qcache_hits";
241
-----------------------------------------------------
242
# with comment and whitespaces first
244
-----------------------------------------------------
245
show status like "Qcache_queries_in_cache";
247
Qcache_queries_in_cache 7
248
show status like "Qcache_inserts";
251
show status like "Qcache_hits";
254
# with comment and whitespaces first
260
# with comment and whitespaces first
266
show status like "Qcache_queries_in_cache";
268
Qcache_queries_in_cache 8
269
show status like "Qcache_inserts";
272
show status like "Qcache_hits";
275
-----------------------------------------------------
277
-----------------------------------------------------
278
show status like "Qcache_queries_in_cache";
280
Qcache_queries_in_cache 8
281
show status like "Qcache_inserts";
284
show status like "Qcache_hits";
297
show status like "Qcache_queries_in_cache";
299
Qcache_queries_in_cache 9
300
show status like "Qcache_inserts";
303
show status like "Qcache_hits";
306
-----------------------------------------------------
307
select * /* internal comment */ from t1
308
-----------------------------------------------------
309
show status like "Qcache_queries_in_cache";
311
Qcache_queries_in_cache 9
312
show status like "Qcache_inserts";
315
show status like "Qcache_hits";
318
select * /* internal comment */ from t1;
323
select * /* internal comment */ from t1;
328
show status like "Qcache_queries_in_cache";
330
Qcache_queries_in_cache 10
331
show status like "Qcache_inserts";
334
show status like "Qcache_hits";
337
-----------------------------------------------------
338
select */* internal comment */ from t1
339
-----------------------------------------------------
340
show status like "Qcache_queries_in_cache";
342
Qcache_queries_in_cache 10
343
show status like "Qcache_inserts";
346
show status like "Qcache_hits";
349
select */* internal comment */ from t1;
354
select */* internal comment */ from t1;
359
show status like "Qcache_queries_in_cache";
361
Qcache_queries_in_cache 11
362
show status like "Qcache_inserts";
365
show status like "Qcache_hits";
368
-----------------------------------------------------
369
select */* internal comment */from t1
370
-----------------------------------------------------
371
show status like "Qcache_queries_in_cache";
373
Qcache_queries_in_cache 11
374
show status like "Qcache_inserts";
377
show status like "Qcache_hits";
380
select */* internal comment */from t1;
385
select */* internal comment */from t1;
390
show status like "Qcache_queries_in_cache";
392
Qcache_queries_in_cache 12
393
show status like "Qcache_inserts";
396
show status like "Qcache_hits";
399
-----------------------------------------------------
400
select * /* internal comment with "quote" */ from t1
401
-----------------------------------------------------
402
show status like "Qcache_queries_in_cache";
404
Qcache_queries_in_cache 12
405
show status like "Qcache_inserts";
408
show status like "Qcache_hits";
411
select * /* internal comment with "quote" */ from t1;
416
select * /* internal comment with "quote" */ from t1;
421
show status like "Qcache_queries_in_cache";
423
Qcache_queries_in_cache 13
424
show status like "Qcache_inserts";
427
show status like "Qcache_hits";
430
-----------------------------------------------------
431
select */* internal comment with "quote" */ from t1
432
-----------------------------------------------------
433
show status like "Qcache_queries_in_cache";
435
Qcache_queries_in_cache 13
436
show status like "Qcache_inserts";
439
show status like "Qcache_hits";
442
select */* internal comment with "quote" */ from t1;
447
select */* internal comment with "quote" */ from t1;
452
show status like "Qcache_queries_in_cache";
454
Qcache_queries_in_cache 14
455
show status like "Qcache_inserts";
458
show status like "Qcache_hits";
461
-----------------------------------------------------
462
select */* internal comment with "quote" */from t1
463
-----------------------------------------------------
464
show status like "Qcache_queries_in_cache";
466
Qcache_queries_in_cache 14
467
show status like "Qcache_inserts";
470
show status like "Qcache_hits";
473
select */* internal comment with "quote" */from t1;
478
select */* internal comment with "quote" */from t1;
483
show status like "Qcache_queries_in_cache";
485
Qcache_queries_in_cache 15
486
show status like "Qcache_inserts";
489
show status like "Qcache_hits";
492
-----------------------------------------------------
495
-----------------------------------------------------
496
show status like "Qcache_queries_in_cache";
498
Qcache_queries_in_cache 15
499
show status like "Qcache_inserts";
502
show status like "Qcache_hits";
517
show status like "Qcache_queries_in_cache";
519
Qcache_queries_in_cache 16
520
show status like "Qcache_inserts";
523
show status like "Qcache_hits";
526
-----------------------------------------------------
528
-----------------------------------------------------
529
show status like "Qcache_queries_in_cache";
531
Qcache_queries_in_cache 16
532
show status like "Qcache_inserts";
535
show status like "Qcache_hits";
548
show status like "Qcache_queries_in_cache";
550
Qcache_queries_in_cache 16
551
show status like "Qcache_inserts";
554
show status like "Qcache_hits";
557
-----------------------------------------------------
559
-----------------------------------------------------
560
show status like "Qcache_queries_in_cache";
562
Qcache_queries_in_cache 16
563
show status like "Qcache_inserts";
566
show status like "Qcache_hits";
579
show status like "Qcache_queries_in_cache";
581
Qcache_queries_in_cache 16
582
show status like "Qcache_inserts";
585
show status like "Qcache_hits";
588
-----------------------------------------------------
590
/* comment in the end */
591
-----------------------------------------------------
592
show status like "Qcache_queries_in_cache";
594
Qcache_queries_in_cache 16
595
show status like "Qcache_inserts";
598
show status like "Qcache_hits";
602
/* comment in the end */;
608
/* comment in the end */;
613
show status like "Qcache_queries_in_cache";
615
Qcache_queries_in_cache 17
616
show status like "Qcache_inserts";
619
show status like "Qcache_hits";
622
-----------------------------------------------------
625
-----------------------------------------------------
626
show status like "Qcache_queries_in_cache";
628
Qcache_queries_in_cache 17
629
show status like "Qcache_inserts";
632
show status like "Qcache_hits";
647
show status like "Qcache_queries_in_cache";
649
Qcache_queries_in_cache 18
650
show status like "Qcache_inserts";
653
show status like "Qcache_hits";
656
-----------------------------------------------------
658
/* comment in the end */
660
-----------------------------------------------------
661
show status like "Qcache_queries_in_cache";
663
Qcache_queries_in_cache 18
664
show status like "Qcache_inserts";
667
show status like "Qcache_hits";
671
/* comment in the end */
678
/* comment in the end */
684
show status like "Qcache_queries_in_cache";
686
Qcache_queries_in_cache 18
687
show status like "Qcache_inserts";
690
show status like "Qcache_hits";
693
-----------------------------------------------------
694
select * from t1 #comment in the end
695
-----------------------------------------------------
696
show status like "Qcache_queries_in_cache";
698
Qcache_queries_in_cache 18
699
show status like "Qcache_inserts";
702
show status like "Qcache_hits";
705
select * from t1 #comment in the end;
710
select * from t1 #comment in the end;
715
show status like "Qcache_queries_in_cache";
717
Qcache_queries_in_cache 19
718
show status like "Qcache_inserts";
721
show status like "Qcache_hits";
724
-----------------------------------------------------
725
select * from t1 #comment in the end
727
-----------------------------------------------------
728
show status like "Qcache_queries_in_cache";
730
Qcache_queries_in_cache 19
731
show status like "Qcache_inserts";
734
show status like "Qcache_hits";
737
select * from t1 #comment in the end
743
select * from t1 #comment in the end
749
show status like "Qcache_queries_in_cache";
751
Qcache_queries_in_cache 19
752
show status like "Qcache_inserts";
755
show status like "Qcache_hits";
758
-----------------------------------------------------
759
select * from t1 -- comment in the end
760
-----------------------------------------------------
761
show status like "Qcache_queries_in_cache";
763
Qcache_queries_in_cache 19
764
show status like "Qcache_inserts";
767
show status like "Qcache_hits";
770
select * from t1 -- comment in the end;
775
select * from t1 -- comment in the end;
780
show status like "Qcache_queries_in_cache";
782
Qcache_queries_in_cache 20
783
show status like "Qcache_inserts";
786
show status like "Qcache_hits";
789
-----------------------------------------------------
790
select * from t1 -- comment in the end
792
-----------------------------------------------------
793
show status like "Qcache_queries_in_cache";
795
Qcache_queries_in_cache 20
796
show status like "Qcache_inserts";
799
show status like "Qcache_hits";
802
select * from t1 -- comment in the end
808
select * from t1 -- comment in the end
814
show status like "Qcache_queries_in_cache";
816
Qcache_queries_in_cache 20
817
show status like "Qcache_inserts";
820
show status like "Qcache_hits";
823
-----------------------------------------------------
824
select ' \' ' from t1
825
-----------------------------------------------------
826
show status like "Qcache_queries_in_cache";
828
Qcache_queries_in_cache 20
829
show status like "Qcache_inserts";
832
show status like "Qcache_hits";
835
select ' \' ' from t1;
840
select ' \' ' from t1;
845
show status like "Qcache_queries_in_cache";
847
Qcache_queries_in_cache 21
848
show status like "Qcache_inserts";
851
show status like "Qcache_hits";
855
SET GLOBAL query_cache_size=default;
856
set global query_cache_strip_comments=OFF;