List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:May 1 2002 9:04pm
Subject:Re: mysql log rotate
View as plain text  
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
>
>


Thread
mysql log rotateSt├ęphane HENRY1 May
  • Re: mysql log rotateGerald Clark1 May