Re: mysql log rotate

[Gerald Clark]

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 <mysql-thread107748@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>