You could also do:
SET GLOBAL expire_log_days=n;
BTW - this same hint is on the the very same manual page you mentioned
at the beginning of this thread.
--
Augusto Bott
On Mon, May 12, 2008 at 11:11 AM, Rick James [EMAIL PROTECTED] wrote:
RESET is not a good idea -- PURGE to some point
wasn't commited, it won't be written to the
binary log, so it won't be executed and rolled back on the slave
(that's only true when all tables involved on a transaction are
transaction-safe tables).
--
Augusto Bott
On 10/30/07, Thomas Raso [EMAIL PROTECTED] wrote:
Hi all,
on a replication
It seems that the trunk version supports RO/RW splitting:
http://jan.kneschke.de/2007/8/1/mysql-proxy-learns-r-w-splitting and
http://jan.kneschke.de/2007/8/26/mysql-proxy-more-r-w-splitting
--
Augusto Bott
On 9/7/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
On Fri, 07 Sep 2007 07:05:31
| a|1 | aa |
| 2 | b| NULL | NULL |
| 3 | c|3 | bb |
| 3 | c|3 | bb |
+---+--+--+--+
4 rows in set (0.00 sec)
--
Augusto Bott
augusto.bott (at) gmail.com
On 2/2/06, Scott Klarenbach [EMAIL PROTECTED] wrote:
I have a table `requirement` which is left