mysql57-(server/client) 5.7.34 does not work correctly
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
Subject
Views
Written By
Posted
mysql57-(server/client) 5.7.34 does not work correctly
1487
June 26, 2021 11:37PM
396
June 26, 2021 11:40PM
379
June 30, 2021 06:53AM
399
June 30, 2021 07:09AM
423
July 10, 2021 10:48AM
378
June 30, 2021 02:13AM
390
July 10, 2021 12:54PM
424
July 12, 2021 07:01AM
384
July 12, 2021 10:50AM
368
July 16, 2021 11:16AM
369
July 16, 2021 04:03PM
408
July 17, 2021 12:52AM
375
July 17, 2021 01:02PM
416
August 02, 2021 08:12PM
420
August 02, 2021 09:08PM
433
August 03, 2021 07:52AM
464
August 03, 2021 10:21AM
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.