# 1. 配置内核参数
# vi /etc/sysctl.conf
kernel.shmmax = 34359738368
kernel.shmall = 8388608
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
vm.swappiness = 10
vm.nr_hugepages = 16384

# sysctl -p

# 2. 配置用户资源限制
# vi /etc/security/limits.conf
mysql soft nofile 65535
mysql hard nofile 65535
mysql soft nproc 65535
mysql hard nproc 65535

# 3. 安装MySQL
# apt install mysql-server -y

# 输出示例：
正在读取软件包列表… 完成
正在分析软件包的依赖关系树… 完成
正在读取状态信息… 完成
下列【新】软件包将被安装：
mysql-server
升级了 0 个软件包，新安装了 1 个软件包，要卸载 0 个软件包，有 0 个软件包未被升级。
需要下载 50.0 MB 的归档。
解压缩后会消耗 200 MB 的额外空间。
获取:1 https://community-packages.deepin.com/deepin apricot/main amd64 mysql-server all 8.0.35-1 [50.0 MB]
已下载 50.0 MB，耗时 30秒 (1.7 MB/s)
正在选中未选择的软件包 mysql-server。
(正在读取数据库 … 系统当前共安装有 150000 个文件和目录。)
准备解压 …/mysql-server_8.0.35-1_all.deb …
正在解压 mysql-server (8.0.35-1) …
正在设置 mysql-server (8.0.35-1) …

# 4. 配置MySQL
# vi /etc/mysql/mysql.conf.d/mysqld.cnf
[mysqld]
datadir = /data/mysql
socket = /var/run/mysqld/mysqld.sock
port = 3306
innodb_buffer_pool_size = 32G
innodb_log_file_size = 1G
max_connections = 1000

# 5. 启动MySQL服务
# systemctl enable mysql
# systemctl start mysql

# 输出示例：
# systemctl status mysql
● mysql.service – MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; preset: enabled)
Active: active (running) since Fri 2026-04-04 10:00:00 CST; 5s ago
Process: 12345 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
Main PID: 12346 (mysqld)
Status: “Server is operational”
Tasks: 38 (limit: 4915)
Memory: 32.5G
CPU: 5.000s
CGroup: /system.slice/mysql.service
└─12346 /usr/sbin/mysqld

# 6. 配置UFW防火墙
# ufw allow from 192.168.1.0/24 to any port 3306

# 1. 安装Nginx
# apt install nginx -y

# 输出示例：
正在读取软件包列表… 完成
正在分析软件包的依赖关系树… 完成
正在读取状态信息… 完成
下列【新】软件包将被安装：
nginx
升级了 0 个软件包，新安装了 1 个软件包，要卸载 0 个软件包，有 0 个软件包未被升级。
需要下载 500 kB 的归档。
解压缩后会消耗 1.5 MB 的额外空间。
获取:1 https://community-packages.deepin.com/deepin apricot/main amd64 nginx amd64 1.22.1-4 [500 kB]
已下载 500 kB，耗时 1秒 (500 kB/s)
正在选中未选择的软件包 nginx。
(正在读取数据库 … 系统当前共安装有 150000 个文件和目录。)
准备解压 …/nginx_1.22.1-4_amd64.deb …
正在解压 nginx (1.22.1-4) …
正在设置 nginx (1.22.1-4) …

# 2. 配置Nginx
# vi /etc/nginx/nginx.conf

# 修改以下配置
worker_processes auto;
worker_rlimit_nofile 65535;

events {
worker_connections 65535;
}

http {
include /etc/nginx/mime.types;
default_type application/octet-stream;
sendfile on;
keepalive_timeout 65;

server {
listen 80;
server_name localhost;

location / {
root /var/www/html;
index index.html index.htm;
}
}
}

# 3. 启动Nginx服务
# systemctl enable nginx
# systemctl start nginx

# 输出示例：
# systemctl status nginx
● nginx.service – A high performance web server and a reverse proxy server
Loaded: loaded (/lib/systemd/system/nginx.service; enabled; preset: enabled)
Active: active (running) since Fri 2026-04-04 10:00:00 CST; 5s ago
Docs: man:nginx(8)
Process: 12345 ExecStartPre=/usr/sbin/nginx -t -q -g daemon on; master_process on; (code=exited, status=0/SUCCESS)
Main PID: 12346 (nginx)
Tasks: 3 (limit: 4915)
Memory: 5.0M
CPU: 50ms
CGroup: /system.slice/nginx.service
├─12346 “nginx: master process /usr/sbin/nginx -g daemon on; master_process on;”
├─12347 “nginx: worker process”
└─12348 “nginx: worker process”

# 4. 配置UFW防火墙
# ufw allow 80/tcp
# ufw allow 443/tcp

# 查看系统性能
# htop

# 输出示例：
CPU[ 2.5%] Tasks: 128, 5 thr; 1 running
Mem[|||||||||| 2.0G/64G] Load average: 0.50 0.45 0.40
Swp[ 0K/32G] Uptime: 2 days, 10:00:00

PID USER PRI NI VIRT RES SHR S CPU% MEM% TIME+ Command
12345 mysql 20 0 32.5G 8.0G 512M S 5.0 12.5 10:00.00 /usr/sbin/mysqld
12346 root 20 0 1500M 500M 100M S 2.0 0.8 5:00.00 /usr/sbin/nginx

# 查看磁盘I/O
# iotop -o

# 输出示例：
Total DISK READ: 0.00 B/s | Total DISK WRITE: 0.00 B/s
Current DISK READ: 0.00 B/s | Current DISK WRITE: 0.00 B/s
TID PRIO USER DISK READ DISK WRITE SWAPIN IO> COMMAND
12345 be/4 mysql 0.00 B/s 0.00 B/s 0.00 % 0.00 % mysqld

# 查看网络流量
# nethogs

# 输出示例：
Ethernet link detected
PID USER PROGRAM DEV SENT RECEIVED
12345 mysql mysqld ens33 0.000 0.500 KB/sec
12346 root nginx ens33 0.500 0.000 KB/sec
? root unknown TCP 0.000 0.000 KB/sec

# 查看系统日志
# journalctl -f
— Logs begin at Fri 2026-04-04 08:00:00 CST. —
Apr 04 10:00:00 fgedudb01 systemd[1]: Started MySQL Community Server.
Apr 04 10:00:00 fgedudb01 systemd[1]: Started A high performance web server and a reverse proxy server.