MYSQL was hanging with nothing in the error log. When restarting the only messages I could see are
I believe it maybe something in my configuration as the performance seems to be quite poor and doesn't use as much resources as I was expecting
I have also set limits of
What could the freeze be? and what configuration do you suggest for a powerful server (64GB RAM, Ryzen 9 5950X, NVMe) using Litespeed
2022-06-01T08:38:59.762398Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.29-cll-lve' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server - GPL. 2022-06-01T08:38:54.148053Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.29-cll-lve) MySQL Community Server - GPL. 2022-06-01T08:38:46.314464Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 9445 user: 'root'.
[mysqld] disable-log-bin = 1 default-authentication-plugin = mysql_native_password performance-schema = 0 datadir = /var/lib/mysql socket = /var/lib/mysql/mysql.sock log-error = /var/log/mysqld.log pid-file = /var/run/mysqld/mysqld.pid #innodb_buffer_pool_size = 134217728 max_allowed_packet = 268435456 #open_files_limit=49000 # LimitNOFILE=100000 # LimitMEMLOCK=100000 innodb_file_per_table = 1 mysqlx = 0 innodb_buffer_pool_size=15G max_heap_table_size=128M tmp_table_size=128M max_connections=400 table_open_cache=37000 table_definition_cache=37000 thread_cache_size=200 key_buffer_size=128M sort_buffer_size=1M read_buffer_size=4M read_rnd_buffer_size=512k join_buffer_size=3M