We could use inotify-tools to monitor file or directory IO state
yum install inotify-tools
#inotifywait -m /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd
Setting up watches. Watches established. /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd MODIFY
this means mysqld process is writing file #sql-ib4747-2643139248.ibd now
we could add -r option to monitor directory IO state
#inotifywait -m -r /storage/sas/mysql3306/data/diablo_im/
Setting up watches. Beware: since -r was given, this may take a while!
Watches established.
/storage/sas/mysql3306/data/diablo_im/ MODIFY #sql-ib4747-2643139248.ibd
/storage/sas/mysql3306/data/diablo_im/ MODIFY #sql-ib4747-2643139248.ibd
/storage/sas/mysql3306/data/diablo_im/ MODIFY #sql-ib4747-2643139248.ibd
/storage/sas/mysql3306/data/diablo_im/ MODIFY #sql-ib4747-2643139248.ibd
/storage/sas/mysql3306/data/diablo_im/ MODIFY #sql-ib4747-2643139248.ibd
/storage/sas/mysql3306/data/diablo_im/ MODIFY #sql-ib4747-2643139248.ibd
/storage/sas/mysql3306/data/diablo_im/ MODIFY #sql-ib4747-2643139248.ibd
/storage/sas/mysql3306/data/diablo_im/ MODIFY #sql-ib4747-2643139248.ibd
/storage/sas/mysql3306/data/diablo_im/ MODIFY #sql-ib4747-2643139248.ibd
/storage/sas/mysql3306/data/diablo_im/ MODIFY #sql-ib4747-2643139248.ibd
/storage/sas/mysql3306/data/diablo_im/ MODIFY #sql-ib4747-2643139248.ibd
Events:
access file or directory contents were read
modify file or directory contents were written
attrib file or directory attributes changed
close_write file or directory closed, after being opened in writeable mode
close_nowrite file or directory closed, after being opened in read-only mode
close file or directory closed, regardless of read/write mode
open file or directory opened
moved_to file or directory moved to watched directory
moved_from file or directory moved from watched directory
move file or directory moved to or from watched directory
create file or directory created within watched directory
delete file or directory deleted within watched directory
delete_self file or directory was deleted
unmount file system containing file or directory unmounted