MySQL Forums :: Performance :: Performance issues afre upgrading to 5.7


Advanced Search

Performance issues afre upgrading to 5.7
Posted by: Alexandru Badulescu ()
Date: November 24, 2016 08:48AM

Hi,
We have been using 5.6 for a long time with no big problems.
We have recently migrated to 5.7 (and a way more powerful server, with SSD and faster drives in the RAID), and we are seeing performance issues.
Most of the queries are taking a LOT more time than they used to on 5.6, on the same data.
We have many tables with 3-5 million records. A select count(*) from such a table used to finish in 2-5 seconds.
Example:
select count(*) from table_111;
+----------+
| count(*) |
+----------+
| 4908086 |
+----------+
1 row in set (3.92 sec)

On the server running 5.7 it looks like this:

select count(*) from osbp.cdrs_2016_11_12;
+----------+
| count(*) |
+----------+
| 4908086 |
+----------+
1 row in set (34.12 sec)

Both queries were ran without having the tables loaded in buffer.
On 5.7 the query appears as "optimizing" in process list.

We tried matching the settings on the 2 servers with no luck.

I saw 3 bugs opened on this topic and none had replies yet (ex: https://bugs.mysql.com/bug.php?id=80191)
Did anybody else ran into similar problems with 5.7?

Options: ReplyQuote


Subject Views Written By Posted
Performance issues afre upgrading to 5.7 314 Alexandru Badulescu 11/24/2016 08:48AM
Re: Performance issues afre upgrading to 5.7 250 Peter Brawley 11/24/2016 11:32AM
Re: Performance issues afre upgrading to 5.7 158 Øystein Grøvlen 11/25/2016 07:28AM
Re: Performance issues afre upgrading to 5.7 175 Øystein Grøvlen 11/25/2016 06:16AM
Re: Performance issues afre upgrading to 5.7 163 Alexandru Badulescu 11/25/2016 06:59AM
Re: Performance issues afre upgrading to 5.7 255 Øystein Grøvlen 11/25/2016 07:53AM
Re: Performance issues afre upgrading to 5.7 166 Rick James 11/25/2016 08:18PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.