一、查看集群状态
ceph -s
显示HEALTH_WARN
mon openstack-con01 is low on available
![](https://blog.ebancom.com/wp-content/uploads/2023/10/2023-10-07_ceph-s.png)
ceph health detail
显示mon.openstack-con01 has 30% avail
![](https://blog.ebancom.com/wp-content/uploads/2023/10/2023-10-07_cephhealth.png)
二、查看磁盘使用情况
df -h
![](https://blog.ebancom.com/wp-content/uploads/2023/10/2023-10-07_df-h.png)
![](https://blog.ebancom.com/wp-content/uploads/2023/10/2023-10-07_var.png)
du -sh * |grep G
排查到mysql占用大
![](https://blog.ebancom.com/wp-content/uploads/2023/10/2023-10-07_mysql.png)
![](https://blog.ebancom.com/wp-content/uploads/2023/10/2023-10-07_ll.png)
ls -l |grep mysql-bin |wc -l
![](https://blog.ebancom.com/wp-content/uploads/2023/10/2023-10-07_mysqlbin.png)
三、查看mysql情况
mysql
![](https://blog.ebancom.com/wp-content/uploads/2023/10/2023-10-07_usemysql.png)
show status like “%wsrep%”;
![](https://blog.ebancom.com/wp-content/uploads/2023/10/2023-10-07_size3.png)
show binary los;
![](https://blog.ebancom.com/wp-content/uploads/2023/10/2023-10-07_show.png)
![](https://blog.ebancom.com/wp-content/uploads/2023/10/2023-10-07_show1.png)
今天是10.7.2023 查看9.7的文件名
![](https://blog.ebancom.com/wp-content/uploads/2023/10/2023-10-07_sep7.png)
purge binary logs to ‘mysql-bin.000824’;
![](https://blog.ebancom.com/wp-content/uploads/2023/10/2023-10-07_purge.png)
df -h
![](https://blog.ebancom.com/wp-content/uploads/2023/10/2023-10-07_df-h1.png)
ceph -s
![](https://blog.ebancom.com/wp-content/uploads/2023/10/2023-10-07_ok.png)
HEALTH_OK