RE: MySQL8 Collation Conversion Made Easy: A Pre-Upgrade Guide for Sugar 25.1

DHIRENDRA KUMAR — Tue, 01 Apr 2025 11:53:27 GMT

I have the latest MySQL server installed: MySQL Ver 8.0.41-0ubuntu0.20.04.1.

I recently imported my database, including structure and data, from MySQL 5.7 to 8.0.41. After connecting SugarCRM to MySQL 8.0, I noticed a significant performance slowdown. However, connecting the same SugarCRM instance to MySQL 5.7 runs significantly faster.

To analyze the difference, I created a test connection file and measured the connection times for both versions:

MySQL 5.7.40-0ubuntu0.18.04.1
- Connection Time: 0.002336 seconds
MySQL 8.0.41-0ubuntu0.20.04.1
- Connection Time: 0.299383 seconds

As is evident, there is a huge difference in connection time between the two versions.

Key Details:

Both MySQL servers are running on identical resources: 8GB RAM with 160GB storage.
InnoDB settings have been configured similarly to MySQL 5.7, except for parameters deprecated in MySQL 8.0.
The performance issue is specific to MySQL 8.0.41, while MySQL 5.7 remains fast.

Could you please guide me on the key factors I should check to resolve this performance issue?

RE: MySQL8 Collation Conversion Made Easy: A Pre-Upgrade Guide for Sugar 25.1

Nabil Francis — Thu, 06 Mar 2025 11:21:42 GMT

Hi [mention:1ec9289a19b7489188e562f4d7c7d4ac:e9ed411860ed4f2ba0265705b8793d05:label=Rafael%20Fernandes%2C]

Can you please add the script again to this page?

Thanks,