'Linux: Use Lsof to Find Which Files Are Open by a Process'

lsof works under linux and MacOS X and will help you figure out what files are open.

lsof | grep ‘mysqld’