CPU使用率一直较低,某天凌晨选择降级数据库,上午业务系统使用后,数据库CPU持续100%,查了慢sql,发现出现很多之前不是慢sql现在是慢sql的情况,查询了半天,最终发现是降级后,很多表的索引统计信息丢失,导致出现性能事故。官方也没有好的办法,只能持续观察慢sql找出索引失效的表,重新更新统计信息。有人遇到类似情况吗? 有无升降级后自动检查校验的方案?目前只能单表 show index from table 查看索引基数是否为0.
[root@VM-0-16-centos yum.repos.d]# yum install mariadb-serve
Last metadata expiration check: 0:13:43 ago on Fri 09 Apr 2021 11:07:46 PM CST.
Error:
Problem: cannot install the best candidate for the job
- nothing provides perl(File::Temp) needed by MariaDB-server-10.5.9-1.el8.x86_64
- nothing
提示错误We couldn't connect to the remote PC. Make sure the PC is turned on and connected to the network, and that remote access is enabled.
Error code: 0x204