Debian Codegraph @

mysql-test/suite/perfschema/r/show_misc.result

raw
1 select 1;
2 1
3 1
4 SHOW STATUS LIKE 'Last_query_partial_plans';
5 Variable_name Value
6 select 2;
7 2
8 2
9 SHOW STATUS LIKE 'Last_query_cost';
10 Variable_name Value
11 Last_query_cost 0.000000
12 flush status;
13 SHOW STATUS LIKE 'Created_tmp_tables';
14 Variable_name Value
15 Created_tmp_tables 0
16
17 ================================================================================
18 Bug#21789221 SHOW STATUS FAILS WITH LOCK TABLES AND SHOW_COMPATIBILITY_56=OFF
19 ================================================================================
20 Verify that SHOW STATUS and SHOW VARIABLES works under LOCK TABLES mode
21
22 CREATE TABLE test.t1 (s1 INT);
23 LOCK TABLE test.t1 READ;
24
25 SHOW GLOBAL STATUS WHERE VARIABLE_NAME LIKE "foo";
26 Variable_name Value
27
28 SHOW SESSION STATUS WHERE VARIABLE_NAME LIKE "foo";
29 Variable_name Value
30
31 SHOW GLOBAL VARIABLES WHERE VARIABLE_NAME LIKE "foo";
32 Variable_name Value
33
34 SHOW SESSION VARIABLES WHERE VARIABLE_NAME LIKE "foo";
35 Variable_name Value
36
37 UNLOCK TABLES;
38
39 LOCK TABLE test.t1 WRITE;
40
41 SHOW GLOBAL STATUS WHERE VARIABLE_NAME LIKE "foo";
42 Variable_name Value
43
44 SHOW SESSION STATUS WHERE VARIABLE_NAME LIKE "foo";
45 Variable_name Value
46
47 SHOW GLOBAL VARIABLES WHERE VARIABLE_NAME LIKE "foo";
48 Variable_name Value
49
50 SHOW SESSION VARIABLES WHERE VARIABLE_NAME LIKE "foo";
51 Variable_name Value
52
53 UNLOCK TABLES;
54 DROP TABLE test.t1;
55
56 ================================================================================
57 Bug#28515475 BOGUS DATA WHEN ORDERING RESULTS FROM VARIABLES_BY_THREAD
58 ================================================================================
59 Verify the results from "WHERE variable_name IN(...)", particularly for those
60 variables that are listed after the deprecated variable gtid_executed.
61 The ORDER BY also forces an additional code path through rnd_pos().
62
63 SELECT variable_name FROM performance_schema.variables_by_thread
64 WHERE variable_name IN ('interactive_timeout','net_read_timeout','net_write_timeout','wait_timeout')
65 ORDER BY variable_name;
66 variable_name
67 interactive_timeout
68 net_read_timeout
69 net_write_timeout
70 wait_timeout
71
72 ================================================================================
73 CLEAN UP
74 ================================================================================