With the general query log enabled in advance its easy to see when a
and by whom a query was run, just be sure to put that log in the
logrotate cycle because it can get big, fast..
Ben
On Fri, Jul 23, 2010 at 9:09 AM, Bryan O'Neal
<
Bryan.ONeal@theonealandassociates.com> wrote:
> Other then query the MySQL grant table I am not sure of a good way to
> reconcile recent changes. As for out of sync replication stop the
> replication, apply a backup, start replicaiton.
>
> Sorry I don't have better advice. I can try playing around with some
> stuff this weekend and would love to know your solution if you find
> one before then.
>
> On Thu, Jul 22, 2010 at 11:00 PM, der.hans <PLUGd@lufthans.com> wrote:
>> moin moin,
>>
>> is there a way see when a particular grant was last used in MySQL? I can
>> probably troll logs, but I wonder if it's in the DB.
>>
>> Also, how should I sync grants from master to slave when they're out of
>> sync?
>>
>> In our case, the slave is also getting local changes. I'm pushing to stop
>> that, but haven't yet gotten it worked out. The local changes to the slave
>> didn't drop the missing grants, but since we've had emergency repairs
>> after local changes caused problems, it might be that the repairs did
>> cause the differences.
>>
>> ciao,
>>
>> der.hans
>> --
>> # http://www.LuftHans.com/Classes http://www.TwoGeekTechs.com/
>> # Director of Engineering, FonWallet Transaction Solutions, Inc.
>> # "The reasons for my decision to quit were myriad, but central to the
>> # decision was the realization that there are two kinds of companies:
>> # Good ones ask you to think for them.
>> # The others tell you to think like them." -- Benjy Feen
>> ---------------------------------------------------
>> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
>> To subscribe, unsubscribe, or to change your mail settings:
>> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)