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. An inode may have many or no names associated with it. Stéphane HENRY wrote: >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 logged and without stopping >the server ? > >Thanks for help > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
