Opening a file access it by its inode.
Once it is opened, it can be renamed, or deleted, and this will have no
effect
for the process that has it open.
Flush logs will close the inode, and create a new log, which will assign
a new inode
to be opened.
File names are just handy pointers to inodes
in mysql docs, http://www.mysql.com/doc/L/o/Log_file_maintenance.html :
1) shell> cd mysql-data-directory
2) shell> mv mysql.log mysql.old
3) shell> mysqladmin flush-logs
What's happening if there is a query between line 2 and 3, is it logged ?
How could I rotate my files without a query not log
