Re: [Maria-discuss] Per-db binlogging

2010-12-14 Thread Weldon Whipple
iled by #defining HAVE_DB_BINLOG I would appreciate putting the code out for feedback/suggestions. If there IS interest, please suggest how you want it. (E.g., a launchpad patch file, etc.) Thanks in advance! Weldon Whipple wel...@whipple.org (P.S. Because of our dependence on FLUSH TABLES t

Re: [Maria-discuss] How to lock individual tables in 1-db-per-file binlogging (Was: Re: Per-db binlogging)

2010-10-28 Thread Weldon Whipple
On Thu, Oct 28, 2010 at 1:42 AM, Mark Leith wrote: >> (Is there any externally available documentation on MySQL's use of PSI?) > > > There was a MySQL University session on it: > > http://forge.mysql.com/wiki/Performance_Schema:_Instrumenting_Code Thanks! (That's way cool stuff!) My additions

Re: [Maria-discuss] How to lock individual tables in 1-db-per-file binlogging (Was: Re: Per-db binlogging)

2010-10-27 Thread Weldon Whipple
Dmitry, Thank you very much for your response! (I apologize for the slowness of my reply. I've been fighting a cold for several days.) See below: On Thu, Oct 21, 2010 at 11:15 PM, Dmitry Lenev wrote: > Hello Weldon! > > * Weldon Whipple [10/10/20 00:26]: >> Thanks for th

Re: [Maria-discuss] How to lock individual tables in 1-db-per-file binlogging (Was: Re: Per-db binlogging)

2010-10-19 Thread Weldon Whipple
ase. Should I try to back port those locks to 5.1 in the interim? ... or leave well enough alone? Thanks in advance for your feedback/help/advice!! We.don Whipple On Mon, Oct 18, 2010 at 12:48 PM, Davi Arnaut wrote: > On 10/18/10 3:16 PM, Weldon Whipple wrote: >> >> Well, I

Re: [Maria-discuss] How to lock individual tables in 1-db-per-file binlogging (Was: Re: Per-db binlogging)

2010-10-18 Thread Weldon Whipple
le.org On Mon, Oct 18, 2010 at 12:48 PM, Davi Arnaut wrote: > On 10/18/10 3:16 PM, Weldon Whipple wrote: >> >> Well, I finished a working prototype that does everything except the >> locking and unlocking of databases. Someone mentioned that it's now >> possible t

[Maria-discuss] How to lock individual tables in 1-db-per-file binlogging (Was: Re: Per-db binlogging)

2010-10-18 Thread Weldon Whipple
7;s still there, but not very active ...]. :-) A few comments in response to your comments: On Thu, Sep 16, 2010 at 6:34 AM, Sergei Golubchik wrote: > Hi, Weldon! > > On Sep 15, Weldon Whipple wrote: >> >> > See where mysql_bin_log.write is called. >> >> Excelle

Re: [Maria-discuss] Per-db binlogging

2010-09-16 Thread Weldon Whipple
efully the book will demystify them for me. :-) More later ... Thanks again! Weldon On Thu, Sep 16, 2010 at 6:34 AM, Sergei Golubchik wrote: > Hi, Weldon! > > On Sep 15, Weldon Whipple wrote: >> >> > See where mysql_bin_log.write is called. >> >> Excellent in

Re: [Maria-discuss] Seeking command syntax feedback (Still Re: Per-db binlogging)

2010-09-15 Thread Weldon Whipple
On Wed, Sep 15, 2010 at 2:00 PM, Sergei Golubchik wrote: > Hi, Weldon! Hi, Sergei! > > On Sep 15, Weldon Whipple wrote: >> 2. FLUSH TABLES WITH READ LOCK FOR DATABASE dbname; >> >> (I just added an optional 'FOR DATABASE dbname' to the already >> e

Re: [Maria-discuss] Per-db binlogging

2010-09-15 Thread Weldon Whipple
Henrik, Thanks for your response! (See my replies below.) On Wed, Sep 15, 2010 at 2:33 PM, Henrik Ingo wrote: > On Tue, Sep 14, 2010 at 3:02 AM, MARK CALLAGHAN wrote: >> +maria-discuss as they are working in replication too > > To be exact, maria-developers@ is the counterpart to intern...@mysq

Re: [Maria-discuss] Per-db binlogging

2010-09-15 Thread Weldon Whipple
uit the cc :-) See my responses below On Wed, Sep 15, 2010 at 1:53 PM, Sergei Golubchik wrote: > Hi, Weldon! > > On Sep 13, Weldon Whipple wrote: >> Is it plausible to identify all places where a binlog addition might >> occur? In those places, if the singleton USER_BIN_L