Skip to main content

MySQL杂项记录

查看配置的最大连接数​

SHOW VARIABLES LIKE "max_connections";

查看当前连接​

show full processlist;

设置binlog日志保留时间​

set global binlog_expire_logs_seconds=86400;

flush logs;

show binary logs;

导入数据指定编码​

# 从linux环境mysqldump 导出数据到 win环境恢复时，需要指定字符编码为 utf-8
mysql -h192.168.0.10 -p -ulmktest --default-character-set=utf8mb4 lmktest < 2022030911.sql