Re: Mysql 5.1 to 5.5.1.18 Upgrade Poor Performance

[Sen Thiru]

Thomas,
We notice the same behaviour after upgrading to MYSQL 5.5.1.18.
The queries are running very slow. I tried all possible changes to the configuration file and we have a dedicated 32GB RAM on the Solaris machine with only a single instance of MYSQL running.
Let me share a simple query that use to complete in minute or so on 5.1 now takes close to 4min 30 secs.
SELECT Order_Date,Product_code, SUM(Qty),SUM(Order_Value)
FROM orders,customer
WHERE orders.order_group = customer.group
AND order_Date='2012-01-05'
AND cus_name = 'OURCUSTOMER'
GROUP BY order, product;

Did you by any chance happen to find a solution to performance issue noticed in 5.5? OR Did you revert it back to 5.1.

It is going to be a bit difficult for me to revert back to 5.1 due to the fix made available in 5.5 for partitioning issue.

Any thoughts on this would be very much appreciated.

Thanks in Advance.