mysql log rotate

[Stéphane HENRY]

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

Best solution for a very busy MySQL server

[Stéphane HENRY]

Hello,

Have a look at :
http://www.compagnie.com/stef/solution1.jpg
http://www.compagnie.com/stef/solution2.jpg

I'm searching for a solution to change a high traffic mysql server with a
distributed system.

1)Is the solution 1 is good for a writing + reading access ? Are there
problems with locking processus ?
2)Is the solution 2 is good for :
 -direct writing to mysql server (insert, update, replace ...)
 -using MyODBC to read tables (select)

3) I found another MySQL cluster solution
http://prometheus.zerodivide.net/mysql_cluster/about/ This system uses MySQL
replication.

Thanks for advices.

Stéphane HENRY


-
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