Unable to reproduce with PS 5.5.44
mysql> select count(*) from companies; +----------+ | count(*) | +----------+ | 20 | +----------+ 1 row in set (0.02 sec)
mysql>
# Time: 150907 6:05:15 # User@Host: msandbox[msandbox] @ localhost [] # Thread_id: 3 Schema: test Last_errno: 0 Killed: 0 # Query_time: 0.000747 Lock_time: 0.000167 Rows_sent: 5 Rows_examined: 5 Rows_affected: 0 Rows_read: 5 # Bytes_sent: 2168 SET timestamp=1441620315; SELECT `companies`.* FROM `companies` WHERE `companies`.`id` IN (1,2, 3, 4, 5);
After run pt-osc.
# Time: 150907 6:06:12 # User@Host: msandbox[msandbox] @ localhost [] # Thread_id: 6 Schema: test Last_errno: 0 Killed: 0 # Query_time: 0.000545 Lock_time: 0.000149 Rows_sent: 5 Rows_examined: 5 Rows_affected: 0 Rows_read: 5 # Bytes_sent: 2243 SET timestamp=1441620372; SELECT `companies`.* FROM `companies` WHERE `companies`.`id` IN (1,2, 3, 4, 5);
Unable to reproduce with PS 5.5.44
mysql> select count(*) from companies;
+----------+
| count(*) |
+----------+
| 20 |
+----------+
1 row in set (0.02 sec)
mysql>
# Time: 150907 6:05:15 1441620315;
# User@Host: msandbox[msandbox] @ localhost []
# Thread_id: 3 Schema: test Last_errno: 0 Killed: 0
# Query_time: 0.000747 Lock_time: 0.000167 Rows_sent: 5 Rows_examined: 5 Rows_affected: 0 Rows_read: 5
# Bytes_sent: 2168
SET timestamp=
SELECT `companies`.* FROM `companies` WHERE `companies`.`id` IN (1,2, 3, 4, 5);
After run pt-osc.
# Time: 150907 6:06:12 1441620372;
# User@Host: msandbox[msandbox] @ localhost []
# Thread_id: 6 Schema: test Last_errno: 0 Killed: 0
# Query_time: 0.000545 Lock_time: 0.000149 Rows_sent: 5 Rows_examined: 5 Rows_affected: 0 Rows_read: 5
# Bytes_sent: 2243
SET timestamp=
SELECT `companies`.* FROM `companies` WHERE `companies`.`id` IN (1,2, 3, 4, 5);