Bug #113474 mysql 8.0.35 suddenly has become extremely slow

Submitted: 20 Dec 2023 13:30 Modified: 20 Dec 2023 14:08
Reporter: Bandana Kumari Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:8.0.35 OS:Ubuntu (36 gb ram)
Assigned to: CPU Architecture:x86 (8 core cpu)

[20 Dec 2023 13:30] Bandana Kumari
Description:
#
# The MySQL database server configuration file.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

[mysqld]
#
# * Basic Settings
#
 user		= mysql
 pid-file	= /var/run/mysqld/mysqld.pid
 socket	= /var/run/mysqld/mysqld.sock
 port		= 3306
 datadir	= /var/lib/mysql
#default-authentication-plugin=mysql_native_password
sql_mode=''

# If MySQL is running as a replication slave, this should be
# changed. Ref https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_tmpdir
# tmpdir		= /tmp
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address		= 127.0.0.1
#mysqlx-bind-address	=  127.0.0.1
#
# * Fine Tuning
#
key_buffer_size		= 16M
# max_allowed_packet	= 64M
# thread_stack		= 256K

# thread_cache_size       = -1

# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover-options  = BACKUP

# max_connections        = 151

# table_open_cache       = 4000

#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
#
# Log all queries
# Be aware that this log type is a performance killer.
# general_log_file        = /var/log/mysql/query.log
# general_log             = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
# slow_query_log		= on
# slow_query_log_file	= /var/log/mysql/mysql-slow.log
# long_query_time = 0.2
# log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
# server-id		= 1
# log_bin			= /var/log/mysql/mysql-bin.log
# binlog_expire_logs_seconds	= 2592000
max_binlog_size   = 100M
# binlog_do_db		= include_database_name
# binlog_ignore_db	= include_database_name

#innodb
innodb_buffer_pool_size= 24G
innodb_buffer_pool_chunk_size= 3G
innodb_buffer_pool_instances= 8
innodb_log_file_size = 3G
tmpdir = /tmp
tmp_table_size=1G
max_heap_table_size=1G
innodb_flush_log_at_trx_commit=0

How to repeat:
queries are slow but memory uses is only 15%
[20 Dec 2023 13:35] Bandana Kumari
my production environment is hanged from last two days database size 185 gb
[20 Dec 2023 14:07] MySQL Verification Team
Hi Mr. Kumari,

Thank you for your bug report.

However, you are on the wrong forum.

This is a forum for the bugs with fully repeatable test cases.

What you are looking for with this ticket is a support. Hence, we are sending you links to the free and paid support for MySQL.

Hence, read the following message very carefully.
[20 Dec 2023 14:08] MySQL Verification Team
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

For details on getting support for MySQL products see http://www.mysql.com/support/
You can also check our forums (free) at http://forums.mysql.com/

Thank you for your interest in MySQL.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.