|
背景：有张日志表300G不用了，需要清理 ，使用drop table命令删除后，发现磁盘空间没有释放 排查：使用lsof | grep deleted | more排查后，发现有很多mysql的临时文件未能删除掉 ，如下图   大概是有两类的： 一类是xtrabackup的命令的文件 xtrabacku 1019481 1019487 xtrabacku node_exporter *868r REG 253,1 180224 52977049 /var/lib/mysql/fms/#sql-ib63745-248415986.ibd (deleted) xtrabacku 1019481 1019487 xtrabacku node_exporter *925r REG 253,1 147456 52980460 /var/lib/mysql/fms/#sql-ib66843-248417538.ibd (deleted) xtrabacku 1019481 1019487 xtrabacku node_exporter *935r REG 253,1 131072 52965104 /var/lib/mysql/fms/#sql2-1-1be3524#P#p203606.ibd (deleted) xtrabacku 1019481 1019487 xtrabacku node_exporter *948r REG 253,1 131072 52965121 /var/lib/mysql/fms/#sql2-1-1be3524#P#p203704.ibd (deleted) 一类是数据库mysqld的文件： mysqld 1167050 3532093 mysqld node_exporter 6u REG 0,244 0 245240698 /tmp/ibWscPzh (deleted) mysqld 1167050 3532093 mysqld node_exporter 7u REG 0,244 0 245240731 /tmp/ibDyxiz7 (deleted) mysqld 1167050 3532093 mysqld node_exporter 8u REG 0,244 1828 245240763 /tmp/ibJV8HjS (deleted) mysqld 1167050 3532093 mysqld node_exporter 28u REG 0,244 0 245240777 /tmp/ib8nFNf7 (deleted) mysqld 1167050 3532093 mysqld node_exporter 199u REG 0,244 0 245242721 /tmp/MLuAq91Q (deleted) 使用SELECT * FROM performance_schema.threads WHERE thread_os_id = 446056也查不到进程 这要如何排查和处理呢 ？ |
|
|
yejr
2024-1-9 11:17:10
| |
|
|
fengzhencai
2024-1-9 11:26:47
| |
合作电话：010-64087828
社区邮箱：greatsql@greatdb.com
