# 另一个终端查看MySQL进程
# ps aux | grep mysqld
mysql 12351 0.1 5.0 1234567 204800 ? Sl 15:15 0:05 /usr/sbin/mysqld

# 查看错误日志
# tail -n 50 /mysql/logs/error.log
2026-04-02T15:30:00.123456Z 0 [System] [MY-011012] [Server] Received shutdown from user root. Shutting down mysqld (Version: 8.4.0).
2026-04-02T15:30:00.123456Z 0 [System] [MY-014900] [Server] Giving 3600 seconds to transaction(s) to complete

# 查看正在运行的事务
# mysql -u root -p -e “SHOW ENGINE INNODB STATUS\G” | grep -A 10 “TRANSACTIONS”
TRANSACTIONS
————
Trx id counter 12345
Purge done for trx’s n:o < 12340 undo n:o < 0 state: running but idle History list length 100 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 12344, ACTIVE 1800 sec 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 10, OS thread handle 1234567890123, query id 500 192.168.1.100 user1 UPDATE fgedu_users SET status = 'active' WHERE id = 1 # 终止长时间运行的事务 # mysql -u root -p -e "KILL 10;" # 再次检查MySQL状态 # systemctl status mysqld ● mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: inactive (dead) since Tue 2026-04-02 15:35:00 CST; 1min ago

# MySQL配置信息
MYSQL_USER=”root”
MYSQL_PASS=”password”
MYSQL_SOCKET=”/var/lib/mysql/mysql.sock”
LOG_FILE=”/mysql/logs/mysql_control.log”

# 日志函数
log() {
echo “$(date ‘+%Y-%m-%d %H:%M:%S’) – $1” >> $LOG_FILE
}

# 检查MySQL状态
check_status() {
if systemctl status mysqld > /dev/null 2>&1; then
return 0
else
return 1
fi
}

# 启动MySQL
start_mysql() {
log “Starting MySQL…”
if check_status; then
log “MySQL is already running”
echo “MySQL is already running”
return 0
fi

systemctl start mysqld
if [ $? -eq 0 ]; then
log “MySQL started successfully”
echo “MySQL started successfully”
return 0
else
log “Failed to start MySQL”
echo “Failed to start MySQL”
return 1
fi
}

# 停止MySQL
stop_mysql() {
log “Stopping MySQL…”
if ! check_status; then
log “MySQL is already stopped”
echo “MySQL is already stopped”
return 0
fi

systemctl stop mysqld
if [ $? -eq 0 ]; then
log “MySQL stopped successfully”
echo “MySQL stopped successfully”
return 0
else
log “Failed to stop MySQL”
echo “Failed to stop MySQL”
return 1
fi
}

# 重启MySQL
restart_mysql() {
log “Restarting MySQL…”
systemctl restart mysqld
if [ $? -eq 0 ]; then
log “MySQL restarted successfully”
echo “MySQL restarted successfully”
return 0
else
log “Failed to restart MySQL”
echo “Failed to restart MySQL”
return 1
fi
}

# 状态检查
status_mysql() {
if check_status; then
echo “MySQL is running”
mysqladmin -u $MYSQL_USER -p”$MYSQL_PASS” -S $MYSQL_SOCKET status
else
echo “MySQL is not running”
fi
}

# 主函数
case “$1” in
start)
start_mysql
;;
stop)
stop_mysql
;;
restart)
restart_mysql
;;
status)
status_mysql
;;
*)
echo “Usage: $0 {start|stop|restart|status}”
exit 1
;;
esac

# 启动MySQL
# /mysql/scripts/mysql_control.sh start
MySQL started successfully

# 检查状态
# /mysql/scripts/mysql_control.sh status
MySQL is running
Uptime: 10 Threads: 2 Questions: 10 Slow queries: 0 Opens: 100 Flush tables: 1 Open tables: 50 Queries per second avg: 1.000

# 重启MySQL
# /mysql/scripts/mysql_control.sh restart
MySQL restarted successfully

# 停止MySQL
# /mysql/scripts/mysql_control.sh stop
MySQL stopped successfully