Eric, I have seen this in use with clients.
People sometimes use MEMORY tables for caching, and have init_file in place for loading on a server restart. Re init_connect, what is really lacking is ability for auditing of successful and unsuccessful connections. You can log just success with this, and I agree with Roland, some hook for disconnect is valuable for this purpose of auditing. Hopefully the auditing issue in general will be covered by either plugins or appropriate authentication models. Ronald On Tue, Apr 7, 2009 at 10:46 AM, Roland Bouman <[email protected]>wrote: > Hi! > > On Tue, Apr 7, 2009 at 6:06 AM, Eric Day <[email protected]> wrote: > > Does anyone see a reason to keep init_file or init_connect? As a > > In MySQL, I use init_connect to ensure the session starts with autcommit > off. > > That said, I am just interested in starting a session with autocommit > off - I don't really care how that is achieved exactly, but I think > this is the only way in MySQL. > > On another note, I wished there was a hook for disconnect too. At some > point I was interested maintaining per-user statistics and I could > find nothing better than polling the processlist to figure out when a > session ended (whereas it is easy to see when one started provided you > can control init_connect) > > > Anyone feel strongly towards these things? Personally I feel this > > is something best kept in the client or added back in through some > > other plugin hook. > > I agree a plugin would be better. > > > > > Thanks! > > -Eric > > > > _______________________________________________ > > Mailing list: > > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > > Post to : [email protected] > > Unsubscribe : > > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > > More help : https://help.launchpad.net/ListHelp > > > > > > -- > Roland Bouman > http://rpbouman.blogspot.com/ > > _______________________________________________ > Mailing list: > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > Post to : [email protected] > Unsubscribe : > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
