MySQL Bugs: #113474: mysql 8.0.35 suddenly has become extremely slow

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)

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%

my production environment is hanged from last two days database size 185 gb

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.

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.