MYSQL 使用太多磁碟(讀/寫)

MYSQL 使用太多磁碟(讀/寫)

我的伺服器有大問題。我使用的是 Ubuntu Linux 版本 22.04。當我打開apache(PHP)和MYSQL時,問題出在寫/讀磁碟(磁碟燈一直亮著)。這是圖片(CPU進程):

https://i.stack.imgur.com/kzv7h.jpg

我的設定在mysqlc.cnf

character-set-server = utf8mb4
collation-server = utf8mb4_slovenian_ci

user        = mysql
bind-address        = 127.0.0.1
mysqlx-bind-address = 127.0.0.1
key_buffer_size     = 44M
max_connections = 300
max_allowed_packet = 32M
myisam-recover-options  = BACKUP
log_error = /var/log/mysql/error.log
max_binlog_size   = 100M

相關內容