1、nacos版本过低,新版本有密码,但旧版本无法设置
2、nginx无法安装,使用yum安装,yum重启nginx的语句为:nginx -s reload
3、数据库引擎从MYISAM改为INNODB,查询语句
SELECT CONCAT('ALTER TABLE ', table_name, ' ENGINE=InnoDB;') AS sql_statements
FROM information_schema.tables
WHERE table_schema = 'characteristic_town4'
AND engine = 'MyISAM'
ORDER BY table_name ASC;
也可以指定“行格式”
ALTER TABLE cm_tourists_statistics ENGINE=InnoDB, ROW_FORMAT=DYNAMIC;
ALTER TABLE cm_tourists_statistics ENGINE=InnoDB, ROW_FORMAT=COMPACT;
ALTER TABLE cm_tourists_statistics ENGINE=InnoDB, ROW_FORMAT=DEFAULT;
4、引擎MYISAM无法转换成INNODB的row_forma(行格式)=FIXED,FIXED改为DYNAMIC(动态格式)
5、查找docker容器里的路径
docker ps
docker inspect 容器id
查找binlog是否开启
show VARIABLES like "log%";
找到最新的binlog日志
show binlog EVENTS IN "binlog.000212";
6、关闭GTID
因为myisam引擎和innodb引擎不能在同一个事物里提交(因为myisam没有事物),所以需要关闭GTID
show variables like '%gtid%'
SET GLOBAL gtid_mode = OFF;
SET GLOBAL enforce_gtid_consistency = OFF;
如果没有权限,会出现如下报错
7、数据库传输数据卡死与替换个别字段
查看锁表与释放
show processlist;
kill 766;
替换字段
UPDATE wp_content_file_es
SET file_url = REPLACE(file_url, '14.116.199.122', '36.212.55.176')
WHERE file_url LIKE '%14.116.199.122%';
8、接口请求的body大小被限制
修改Spring Boot配置文件
spring:
servlet:
multipart:
max-file-size: 100MB
max-request-size: 100MB
修改nginx配置
http {
client_max_body_size 100M;
...
}