Comment 7 for bug 1490548

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

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);