3.3G #sql-497_89ee9ca.MYD
115M #sql-497_89ee9ca.MYI
貌似是临时文件,可以直接rm删掉吗?
5 个解决方案
#1
不能 应该是数据库建立索引等的临时文件 不要删除 临时文件会自动删除掉
#2
查看时间,都是很早的时间用过的
[root@AY131231112054982e2bZ weshow]# stat db.opt
File: `db.opt'
Size: 61 Blocks: 8 IO Block: 4096 regular file
Device: ca01h/51713d Inode: 951719 Links: 1
Access: (0660/-rw-rw----) Uid: ( 27/ mysql) Gid: ( 27/ mysql)
Access: 2015-09-02 11:38:22.913102982 +0800
Modify: 2014-03-01 17:36:56.190161366 +0800
Change: 2015-03-16 10:27:22.043132042 +0800
[root@AY131231112054982e2bZ weshow]# stat \#sql-497_89ee9ca.frm
File: `#sql-497_89ee9ca.frm'
Size: 9164 Blocks: 24 IO Block: 4096 regular file
Device: ca01h/51713d Inode: 951901 Links: 1
Access: (0660/-rw-rw----) Uid: ( 27/ mysql) Gid: ( 27/ mysql)
Access: 2015-07-03 21:48:37.807013317 +0800
Modify: 2015-07-03 21:48:33.064872434 +0800
Change: 2015-07-03 21:48:33.064872434 +0800
[root@AY131231112054982e2bZ weshow]# stat \#sql-497_89ee9ca.myd
stat: cannot stat `#sql-497_89ee9ca.myd': No such file or directory
[root@AY131231112054982e2bZ weshow]# stat \#sql-497_89ee9ca.MYD
File: `#sql-497_89ee9ca.MYD'
Size: 3441033216 Blocks: 6720776 IO Block: 4096 regular file
Device: ca01h/51713d Inode: 951903 Links: 1
Access: (0660/-rw-rw----) Uid: ( 27/ mysql) Gid: ( 27/ mysql)
Access: 2015-07-03 21:48:37.807013318 +0800
Modify: 2015-07-03 22:11:00.913971611 +0800
Change: 2015-07-03 22:11:00.913971611 +0800
[root@AY131231112054982e2bZ weshow]# ls
check_pos.frm click_ad.frm db.opt #sql-497_89ee9ca.MYD view100_table.MYD weshow_tmp.frm
check_pos.MYD click_ad.MYD insertCheck_view50.TRN #sql-497_89ee9ca.MYI view100_table.MYI weshow_tmp.MYD
check_pos.MYI click_ad.MYI musicLib.frm test.frm weshow_info.frm weshow_tmp.MYI
check_table.frm click_guanzhu.frm musicLib.MYD test.MYD weshow_info.MYD
check_table.MYD click_guanzhu.MYD musicLib.MYI test.MYI weshow_info.MYI
check_table.MYI click_guanzhu.MYI #sql-497_89ee9ca.frm view100_table.frm weshow_info.TRG
[root@AY131231112054982e2bZ weshow]# stat \#sql-497_89ee9ca.MYI
File: `#sql-497_89ee9ca.MYI'
Size: 120448000 Blocks: 235264 IO Block: 4096 regular file
Device: ca01h/51713d Inode: 951902 Links: 1
Access: (0660/-rw-rw----) Uid: ( 27/ mysql) Gid: ( 27/ mysql)
Access: 2015-07-03 22:11:04.450076842 +0800
Modify: 2015-07-03 22:11:04.227070205 +0800
Change: 2015-07-03 22:11:04.227070205 +0800
都是7月3日,好像那天mysql出现了错误,我修复过
#3
这个表是MyIsam引擎,frm记录表结构,MYD存储表里的数据,MYI保存的索引,都不能删。
#4
楼主你好,
诚如3楼所说,不能删除
诚如3楼所说,不能删除
#5
临时文件,
你可以停止MYSQL服务,然后把文件移动到其它目录中,如无问题,则可以删除。
你可以停止MYSQL服务,然后把文件移动到其它目录中,如无问题,则可以删除。
#1
不能 应该是数据库建立索引等的临时文件 不要删除 临时文件会自动删除掉
#2
查看时间,都是很早的时间用过的
[root@AY131231112054982e2bZ weshow]# stat db.opt
File: `db.opt'
Size: 61 Blocks: 8 IO Block: 4096 regular file
Device: ca01h/51713d Inode: 951719 Links: 1
Access: (0660/-rw-rw----) Uid: ( 27/ mysql) Gid: ( 27/ mysql)
Access: 2015-09-02 11:38:22.913102982 +0800
Modify: 2014-03-01 17:36:56.190161366 +0800
Change: 2015-03-16 10:27:22.043132042 +0800
[root@AY131231112054982e2bZ weshow]# stat \#sql-497_89ee9ca.frm
File: `#sql-497_89ee9ca.frm'
Size: 9164 Blocks: 24 IO Block: 4096 regular file
Device: ca01h/51713d Inode: 951901 Links: 1
Access: (0660/-rw-rw----) Uid: ( 27/ mysql) Gid: ( 27/ mysql)
Access: 2015-07-03 21:48:37.807013317 +0800
Modify: 2015-07-03 21:48:33.064872434 +0800
Change: 2015-07-03 21:48:33.064872434 +0800
[root@AY131231112054982e2bZ weshow]# stat \#sql-497_89ee9ca.myd
stat: cannot stat `#sql-497_89ee9ca.myd': No such file or directory
[root@AY131231112054982e2bZ weshow]# stat \#sql-497_89ee9ca.MYD
File: `#sql-497_89ee9ca.MYD'
Size: 3441033216 Blocks: 6720776 IO Block: 4096 regular file
Device: ca01h/51713d Inode: 951903 Links: 1
Access: (0660/-rw-rw----) Uid: ( 27/ mysql) Gid: ( 27/ mysql)
Access: 2015-07-03 21:48:37.807013318 +0800
Modify: 2015-07-03 22:11:00.913971611 +0800
Change: 2015-07-03 22:11:00.913971611 +0800
[root@AY131231112054982e2bZ weshow]# ls
check_pos.frm click_ad.frm db.opt #sql-497_89ee9ca.MYD view100_table.MYD weshow_tmp.frm
check_pos.MYD click_ad.MYD insertCheck_view50.TRN #sql-497_89ee9ca.MYI view100_table.MYI weshow_tmp.MYD
check_pos.MYI click_ad.MYI musicLib.frm test.frm weshow_info.frm weshow_tmp.MYI
check_table.frm click_guanzhu.frm musicLib.MYD test.MYD weshow_info.MYD
check_table.MYD click_guanzhu.MYD musicLib.MYI test.MYI weshow_info.MYI
check_table.MYI click_guanzhu.MYI #sql-497_89ee9ca.frm view100_table.frm weshow_info.TRG
[root@AY131231112054982e2bZ weshow]# stat \#sql-497_89ee9ca.MYI
File: `#sql-497_89ee9ca.MYI'
Size: 120448000 Blocks: 235264 IO Block: 4096 regular file
Device: ca01h/51713d Inode: 951902 Links: 1
Access: (0660/-rw-rw----) Uid: ( 27/ mysql) Gid: ( 27/ mysql)
Access: 2015-07-03 22:11:04.450076842 +0800
Modify: 2015-07-03 22:11:04.227070205 +0800
Change: 2015-07-03 22:11:04.227070205 +0800
都是7月3日,好像那天mysql出现了错误,我修复过
#3
这个表是MyIsam引擎,frm记录表结构,MYD存储表里的数据,MYI保存的索引,都不能删。
#4
楼主你好,
诚如3楼所说,不能删除
诚如3楼所说,不能删除
#5
临时文件,
你可以停止MYSQL服务,然后把文件移动到其它目录中,如无问题,则可以删除。
你可以停止MYSQL服务,然后把文件移动到其它目录中,如无问题,则可以删除。