Debian Codegraph @

mysql-test/suite/perfschema/t/idx_compare_socket_instances.test

raw
1 #
2 # Verify that query results are the same with and without indexes.
3 #
4 --source include/have_debug_sync.inc
5
6 let $table = "socket_instances";
7
8 --echo TABLE: $table
9 --echo INDEXES: PK (OBJECT_INSTANCE_BEGIN), KEY (THREAD_ID), KEY (SOCKET_ID), KEY (IP), KEY (PORT)
10
11 --source ../include/idx_compare_setup.inc
12
13 --disable_query_log
14 # Get object_instance_begin, socket_id, ip and port
15 eval SELECT object_instance_begin, socket_id, ip, port
16 INTO @object_instance_begin, @target_id, @target_ip, @target_port
17 FROM performance_schema.socket_instances
18 WHERE event_name = 'wait/io/socket/sql/server_tcpip_socket';
19 --enable_query_log
20
21 --echo
22 --echo ## Test OBJECT_INSTANCE_BEGIN
23 let $key_group = 12;
24 --source ../include/idx_compare_load.inc
25
26 --echo
27 --echo ## Test SOCKET_ID
28 let $key_group = 14;
29 let $id_column = SOCKET_ID;
30 --source ../include/idx_compare_load.inc
31
32 --echo
33 --echo ## Test IP, PORT
34 let $key_group = 16.1;
35 let $target_ip = `SELECT @target_ip`;
36 --source ../include/idx_compare_load.inc
37
38 --source ../include/idx_compare_cleanup.inc