Bug 256292

Summary: mysql57-(server/client) 5.7.34 does not work correctly
Product: Ports & Packages Reporter: bagas <bagas1983>
Component: Individual Port(s)Assignee: Jochen Neumeister <joneum>
Status: Closed Not Enough Information    
Severity: Affects Only Me CC: jirikubrt, joneum
Priority: --- Flags: linimon: maintainer-feedback? (joneum)
Version: Latest   
Hardware: amd64   
OS: Any   

Description bagas 2021-05-31 12:35:24 UTC 
Hello.
Update mysql 5.7.34 does not work correctly, it creates a heavy load on the server.
Be careful.
I had to roll back to the previous version mysql 5.7.33.
My system FreeBSD 12.2-RELEASE-p7 amd64.
Comment 1 bagas 2021-06-13 09:27:15 UTC 
After 2 weeks, I tried to update mysql again.
As before, after the update, the load is 100% of the processor from the mysql process.
How to be?
After returning to the version mysql 5.7.33, there is no load on the processor.
Something is wrong with mysql version 5.7.34.
Comment 2 bagas 2021-06-13 09:28:17 UTC 
At the time of the load of the processor is not in the log mysql error.
Comment 3 Jiri Kubrt 2021-07-12 15:02:38 UTC 
Hi,

same issue here, had to switch back to 5.7.33

using FreeBSD 12.2-RELEASE, apache 2.4, PHP 7.4

5.7.34 overloads server with 100% CPU (16 cores) and database is unusable

switching back to 5.7.33 solves problem
Comment 4 Jochen Neumeister freebsd_committer freebsd_triage 2021-07-12 16:27:35 UTC 
I have no problems on several machines with different FreeBSD versions, and without logs or further information I can't do anything here. Unfortunately I can not be clairvoyant :)