MySQL Forums
Forum List  »  Performance

mysql57-(server/client) 5.7.34 does not work correctly
Posted by: bagas bagas
Date: June 26, 2021 11:37PM

Hello.
Update mysql 5.7.34 does not work correctly, it creates a heavy load on the server.
Software in the system is updated.

100% CPU load from mysqld after upgrade.
With mysql 5.7.33, the processor load is minimal, maximum 2 processor cores.
With mysql 5.7.34, the load is 100% of the processor on all 8 cores.
MY CPU CPU: Intel(R) Xeon(R) CPU E3-1270 v6 @ 3.80GHz (3792.19-MHz K8-class CPU).

Web cms bitrix.
I had to roll back to the previous version mysql 5.7.33.
My system FreeBSD 12.2-RELEASE-p7 amd64.
There are no errors in the mysql log.
There are no errors in the messages system log.
What to do, what to do ?!

My mysql config file.
/usr/local/etc/mysql/my.cnf
[client]
port=3306
socket=/tmp/mysql.sock

[mysqld]
sql-mode=
datadir=/var/db/base_mysql/mysql
bind-address=10.10.10.2
port=3306
socket=/tmp/mysql.sock
skip-log-bin
skip_ssl
skip-name-resolve
skip-external-locking
symbolic-links=0
sync_binlog = 0
explicit_defaults_for_timestamp = 1
wait_timeout = 180
interactive_timeout = 180
max_connections = 550
key_buffer_size = 2M
myisam_sort_buffer_size = 1M
max_allowed_packet = 480M
sort_buffer_size = 2M
read_buffer_size = 1M
join_buffer_size = 2M
read_rnd_buffer_size = 8M
tmp_table_size=320M
max_heap_table_size=320M
table_open_cache = 247900
table_definition_cache = 3000
table_open_cache_instances = 16
query_cache_size= 16M
query_cache_type = 1
thread_cache_size = 130
default-storage-engine = innodb
innodb_buffer_pool_size = 22G
innodb_buffer_pool_instances = 22
innodb_log_file_size = 2G
innodb_write_io_threads = 64
innodb_read_io_threads = 64
innodb_lru_scan_depth = 256
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 0
innodb_log_buffer_size = 18M
transaction-isolation = READ-COMMITTED
innodb_flush_method = O_DIRECT
innodb_io_capacity=15000
innodb_io_capacity_max=55000
general_log = 0
slow_query_log = 0
log_error = /mnt/backup/log/mysql/errors.log

[mysqldump]
quick

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql57-(server/client) 5.7.34 does not work correctly
579
June 26, 2021 11:37PM


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.