millions of mysqld empty files to be deleted with a script

Majed17 · 03-01-2013, 01:21 AM

in the process there were created N millions of nearly empty files in a catalog which are found on one partition with mysqld data.
a danger has occured of staying without free inodes.

it is necessary to delete them but not with the simple and slow work of mysqld.

a utility is needed that can do the job and that can be launched with the following way:

gently-recursively-delete /mnt/var-lib-mysql/sorry-me-were-insane
server has the following available:
bash, perl, escript, gcc, g++

acid_kewpie · 03-01-2013, 02:11 AM

you might want to say please or thank you next time.

find /mnt/var/wherever/ -type f -size 0 -exec rm {} \;

that will delete millions of empty files in a directory. see the find manpage for details.

Majed17 · 03-01-2013, 02:18 AM

well thanks for the reply, i wish i could try it in practice

acid_kewpie · 03-01-2013, 02:27 AM

you can, just change the "exec"

find /mnt/var/wherever/ -type f -size 0 -exec echo rm {} \;

this will just print out the command, rather than execute it.

or just run

find /mnt/var/wherever/ -type f -size 0

and that will just print out the filenames