MySQL Forums
Forum List  »  Performance

Re: mysql57-(server/client) 5.7.34 does not work correctly
Posted by: Jiří Kubrt
Date: August 02, 2021 08:12PM

Hi,

having the same issue with 5.7.34 and now also with 5.7.35, have to run back on 5.7.33

FreeBSD 12.2-RELEASE-p7, php 7.4.22, apache 2.4.48

with 5.7.34/35 having CPUs on 100% load, with 5.7.33 normal low CPU use

runnig PHP IS app, lot of joined queries, not all indexed

config with query cache:

query_cache_type = 0
query_cache_size = 0

so not using it, but on .33 works all fine

running backup server with .35 with replication slave, runs ok, but slave replication is kind of very low load (no joins etc)

never experienced such a huge change on performace, except of memory overload when upgraded FreeBSD from 11 to 12 and had to use:

malloc-lib=/usr/local/lib/libtcmalloc_minimal.so

but disabling this line doesnt solve issue described above.

dont understand why .33 works fine but .34 (or .35) doesnt, there is nothing important related in Changelog

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: mysql57-(server/client) 5.7.34 does not work correctly
55
August 02, 2021 08:12PM


Sorry, only registered users may post in this forum.

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.