| /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/sys_vars/r/ |
| H A D | optimizer_trace_basic.result | 5 select @@global.optimizer_trace;
6 @@global.optimizer_trace
8 select @@session.optimizer_trace;
9 @@session.optimizer_trace
23 set global optimizer_trace=1;
25 @@global.optimizer_trace
29 @@session.optimizer_trace
33 @@global.optimizer_trace
37 @@session.optimizer_trace
41 @@session.optimizer_trace
[all …]
|
| /dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/sys_vars/r/ |
| H A D | optimizer_trace_basic.result | 5 select @@global.optimizer_trace;
6 @@global.optimizer_trace
8 select @@session.optimizer_trace;
9 @@session.optimizer_trace
23 set global optimizer_trace=1;
25 @@global.optimizer_trace
29 @@session.optimizer_trace
33 @@global.optimizer_trace
37 @@session.optimizer_trace
41 @@session.optimizer_trace
[all …]
|
| /dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/sys_vars/r/ |
| H A D | optimizer_trace_basic.result | 5 select @@global.optimizer_trace;
6 @@global.optimizer_trace
8 select @@session.optimizer_trace;
9 @@session.optimizer_trace
23 set global optimizer_trace=1;
25 @@global.optimizer_trace
29 @@session.optimizer_trace
33 @@global.optimizer_trace
37 @@session.optimizer_trace
41 @@session.optimizer_trace
[all …]
|
| /dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/sys_vars/r/ |
| H A D | optimizer_trace_basic.result | 5 select @@global.optimizer_trace;
6 @@global.optimizer_trace
8 select @@session.optimizer_trace;
9 @@session.optimizer_trace
23 set global optimizer_trace=1;
25 @@global.optimizer_trace
29 @@session.optimizer_trace
33 @@global.optimizer_trace
37 @@session.optimizer_trace
41 @@session.optimizer_trace
[all …]
|
| /dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/suite/sys_vars/r/ |
| H A D | optimizer_trace_basic.result | 5 select @@global.optimizer_trace;
6 @@global.optimizer_trace
8 select @@session.optimizer_trace;
9 @@session.optimizer_trace
23 set global optimizer_trace=1;
25 @@global.optimizer_trace
29 @@session.optimizer_trace
33 @@global.optimizer_trace
37 @@session.optimizer_trace
41 @@session.optimizer_trace
[all …]
|
| /dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/sys_vars/r/ |
| H A D | optimizer_trace_basic.result | 5 select @@global.optimizer_trace;
6 @@global.optimizer_trace
8 select @@session.optimizer_trace;
9 @@session.optimizer_trace
23 set global optimizer_trace=1;
25 @@global.optimizer_trace
29 @@session.optimizer_trace
33 @@global.optimizer_trace
37 @@session.optimizer_trace
41 @@session.optimizer_trace
[all …]
|
| /dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/sys_vars/r/ |
| H A D | optimizer_trace_basic.result | 5 select @@global.optimizer_trace;
6 @@global.optimizer_trace
8 select @@session.optimizer_trace;
9 @@session.optimizer_trace
23 set global optimizer_trace=1;
25 @@global.optimizer_trace
29 @@session.optimizer_trace
33 @@global.optimizer_trace
37 @@session.optimizer_trace
41 @@session.optimizer_trace
[all …]
|
| /dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/sys_vars/r/ |
| H A D | optimizer_trace_basic.result | 5 select @@global.optimizer_trace;
6 @@global.optimizer_trace
8 select @@session.optimizer_trace;
9 @@session.optimizer_trace
23 set global optimizer_trace=1;
25 @@global.optimizer_trace
29 @@session.optimizer_trace
33 @@global.optimizer_trace
37 @@session.optimizer_trace
41 @@session.optimizer_trace
[all …]
|
| /dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/sys_vars/r/ |
| H A D | optimizer_trace_basic.result | 5 select @@global.optimizer_trace;
6 @@global.optimizer_trace
8 select @@session.optimizer_trace;
9 @@session.optimizer_trace
23 set global optimizer_trace=1;
25 @@global.optimizer_trace
29 @@session.optimizer_trace
33 @@global.optimizer_trace
37 @@session.optimizer_trace
41 @@session.optimizer_trace
[all …]
|
| /dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/sys_vars/r/ |
| H A D | optimizer_trace_basic.result | 5 select @@global.optimizer_trace;
6 @@global.optimizer_trace
8 select @@session.optimizer_trace;
9 @@session.optimizer_trace
23 set global optimizer_trace=1;
25 @@global.optimizer_trace
29 @@session.optimizer_trace
33 @@global.optimizer_trace
37 @@session.optimizer_trace
41 @@session.optimizer_trace
[all …]
|
| /dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/sys_vars/r/ |
| H A D | optimizer_trace_basic.result | 5 select @@global.optimizer_trace;
6 @@global.optimizer_trace
8 select @@session.optimizer_trace;
9 @@session.optimizer_trace
23 set global optimizer_trace=1;
25 @@global.optimizer_trace
29 @@session.optimizer_trace
33 @@global.optimizer_trace
37 @@session.optimizer_trace
41 @@session.optimizer_trace
[all …]
|
| /dports/databases/mysql56-client/mysql-5.6.51/mysql-test/suite/sys_vars/r/ |
| H A D | optimizer_trace_basic.result | 5 select @@global.optimizer_trace;
6 @@global.optimizer_trace
8 select @@session.optimizer_trace;
9 @@session.optimizer_trace
23 set global optimizer_trace=1;
25 @@global.optimizer_trace
29 @@session.optimizer_trace
33 @@global.optimizer_trace
37 @@session.optimizer_trace
41 @@session.optimizer_trace
[all …]
|
| /dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_trace_basic.test | 9 select @@global.optimizer_trace;
10 select @@session.optimizer_trace;
19 set global optimizer_trace=1;
20 select @@global.optimizer_trace;
21 set session optimizer_trace=1;
22 select @@session.optimizer_trace;
23 set global optimizer_trace=0;
24 select @@global.optimizer_trace;
25 set session optimizer_trace=0;
34 set global optimizer_trace=1.1;
[all …]
|
| /dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_trace_basic.test | 9 select @@global.optimizer_trace;
10 select @@session.optimizer_trace;
19 set global optimizer_trace=1;
20 select @@global.optimizer_trace;
21 set session optimizer_trace=1;
22 select @@session.optimizer_trace;
23 set global optimizer_trace=0;
24 select @@global.optimizer_trace;
25 set session optimizer_trace=0;
34 set global optimizer_trace=1.1;
[all …]
|
| /dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_trace_basic.test | 9 select @@global.optimizer_trace;
10 select @@session.optimizer_trace;
19 set global optimizer_trace=1;
20 select @@global.optimizer_trace;
21 set session optimizer_trace=1;
22 select @@session.optimizer_trace;
23 set global optimizer_trace=0;
24 select @@global.optimizer_trace;
25 set session optimizer_trace=0;
34 set global optimizer_trace=1.1;
[all …]
|
| /dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_trace_basic.test | 9 select @@global.optimizer_trace;
10 select @@session.optimizer_trace;
19 set global optimizer_trace=1;
20 select @@global.optimizer_trace;
21 set session optimizer_trace=1;
22 select @@session.optimizer_trace;
23 set global optimizer_trace=0;
24 select @@global.optimizer_trace;
25 set session optimizer_trace=0;
34 set global optimizer_trace=1.1;
[all …]
|
| /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_trace_basic.test | 9 select @@global.optimizer_trace;
10 select @@session.optimizer_trace;
21 set global optimizer_trace=1;
22 select @@global.optimizer_trace;
23 set session optimizer_trace=1;
24 select @@session.optimizer_trace;
25 set global optimizer_trace=0;
26 select @@global.optimizer_trace;
27 set session optimizer_trace=0;
36 set global optimizer_trace=1.1;
[all …]
|
| /dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_trace_basic.test | 9 select @@global.optimizer_trace;
10 select @@session.optimizer_trace;
21 set global optimizer_trace=1;
22 select @@global.optimizer_trace;
23 set session optimizer_trace=1;
24 select @@session.optimizer_trace;
25 set global optimizer_trace=0;
26 select @@global.optimizer_trace;
27 set session optimizer_trace=0;
36 set global optimizer_trace=1.1;
[all …]
|
| /dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_trace_basic.test | 9 select @@global.optimizer_trace;
10 select @@session.optimizer_trace;
21 set global optimizer_trace=1;
22 select @@global.optimizer_trace;
23 set session optimizer_trace=1;
24 select @@session.optimizer_trace;
25 set global optimizer_trace=0;
26 select @@global.optimizer_trace;
27 set session optimizer_trace=0;
36 set global optimizer_trace=1.1;
[all …]
|
| /dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_trace_basic.test | 9 select @@global.optimizer_trace;
10 select @@session.optimizer_trace;
21 set global optimizer_trace=1;
22 select @@global.optimizer_trace;
23 set session optimizer_trace=1;
24 select @@session.optimizer_trace;
25 set global optimizer_trace=0;
26 select @@global.optimizer_trace;
27 set session optimizer_trace=0;
36 set global optimizer_trace=1.1;
[all …]
|
| /dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_trace_basic.test | 9 select @@global.optimizer_trace;
10 select @@session.optimizer_trace;
21 set global optimizer_trace=1;
22 select @@global.optimizer_trace;
23 set session optimizer_trace=1;
24 select @@session.optimizer_trace;
25 set global optimizer_trace=0;
26 select @@global.optimizer_trace;
27 set session optimizer_trace=0;
36 set global optimizer_trace=1.1;
[all …]
|
| /dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_trace_basic.test | 9 select @@global.optimizer_trace;
10 select @@session.optimizer_trace;
21 set global optimizer_trace=1;
22 select @@global.optimizer_trace;
23 set session optimizer_trace=1;
24 select @@session.optimizer_trace;
25 set global optimizer_trace=0;
26 select @@global.optimizer_trace;
27 set session optimizer_trace=0;
36 set global optimizer_trace=1.1;
[all …]
|
| /dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_trace_basic.test | 9 select @@global.optimizer_trace;
10 select @@session.optimizer_trace;
21 set global optimizer_trace=1;
22 select @@global.optimizer_trace;
23 set session optimizer_trace=1;
24 select @@session.optimizer_trace;
25 set global optimizer_trace=0;
26 select @@global.optimizer_trace;
27 set session optimizer_trace=0;
36 set global optimizer_trace=1.1;
[all …]
|
| /dports/databases/mysql56-client/mysql-5.6.51/mysql-test/suite/sys_vars/t/ |
| H A D | optimizer_trace_basic.test | 9 select @@global.optimizer_trace;
10 select @@session.optimizer_trace;
19 set global optimizer_trace=1;
20 select @@global.optimizer_trace;
21 set session optimizer_trace=1;
22 select @@session.optimizer_trace;
23 set global optimizer_trace=0;
24 select @@global.optimizer_trace;
25 set session optimizer_trace=0;
34 set global optimizer_trace=1.1;
[all …]
|
| /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/opt_trace/t/ |
| H A D | skip_scan.test | 8 SET optimizer_trace="enabled=on,one_line=off";
13 SELECT count(*) FROM information_schema.optimizer_trace WHERE trace LIKE '%query_references_nonkey_…
16 SELECT count(*) FROM information_schema.optimizer_trace WHERE trace LIKE '%disjuntive_predicate_pre…
34 SELECT count(*) FROM information_schema.optimizer_trace WHERE trace LIKE '%no_range_predicate%';
41 SELECT * FROM information_schema.optimizer_trace;
44 SELECT * FROM information_schema.optimizer_trace;
47 SELECT * FROM information_schema.optimizer_trace;
51 SELECT * FROM information_schema.optimizer_trace;
53 SET optimizer_trace="enabled=off";
58 SET optimizer_trace="enabled=on,one_line=off";
[all …]
|