enterprise-support team mailing list archive

[Nilnandan Joshi <nilnandan.joshi@xxxxxxxxxxx>]

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


** Changed in: percona-server/5.5
       Status: New => Invalid

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1490548

Title:
  Bad execution plan after running pt-osc

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1490548/+subscriptions