1. 安装依赖
apt update
apt install -y gnupg wget lsb-release
2. 下载 MySQL APT 源配置包
wget https://dev.mysql.com/get/mysql-apt-config_0.8.33-1_all.deb
3. 预配置，直接选择 mysql-8.4-lts
这里用 debconf-set-selections 跳过交互界面
echo "mysql-apt-config mysql-apt-config/select-server select mysql-8.4-lts" | debconf-set-selections
4. 安装配置包（不会再卡在循环界面）
DEBIAN_FRONTEND=noninteractive dpkg -i mysql-apt-config_0.8.33-1_all.deb
5. 更新 apt 源
apt update
6. 安装 MySQL 8.4
apt install -y mysql-server
7. 确认版本
mysql --version
其它优化配置
[mysqld]
# === 基本安全配置 ===
bind-address = 127.0.0.1
symbolic-links = 0
ngram_token_size = 2
# skip-grant-tables
# === 连接配置 ===
max_connections = 2000
open_files_limit = 524288
table_open_cache = 8000
table_definition_cache = 4096
# === InnoDB 内存配置 ===
innodb_buffer_pool_size = 40G
innodb_buffer_pool_instances = 8
# === InnoDB 日志配置 ===
innodb_redo_log_capacity = 4G
innodb_log_buffer_size = 256M
# === 刷新策略 ===
innodb_flush_log_at_trx_commit = 0
innodb_flush_method = O_DIRECT
# === 文件配置 ===
innodb_open_files = 40000
# === 字符集 ===
character_set_server = utf8mb4
collation_server = utf8mb4_unicode_ci
# === InnoDB 优化 ===
innodb_file_per_table = 1
innodb_strict_mode = 1
# === 临时表 ===
tmp_table_size = 128M
max_heap_table_size = 128M
