Bug #17633 Ability to set session variables on connect (with stored proc)
Submitted: 21 Feb 2006 23:38 Modified: 5 Mar 2006 9:49
Reporter: Arjen Lentz Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.x OS:Any (any)
Assigned to: CPU Architecture:Any

[21 Feb 2006 23:38] Arjen Lentz 
Description:
Server variables can be tuned within a connection, and even around individual queries.
But some applications where the source is not available, global server tuning is currently the only option. This is unpractical, as many important buffers are per-connection and would eat too many resources when set on the global level.

How to repeat:
as above.

Suggested fix:
Add the ability to call a stored procedure when a user connects, which could tweak server variables using the usual SET commands (and also do other things, if so desired).

(this of course leaves the issue individual queries, but it's still a huge step forward.)
[5 Mar 2006 9:10] Valeriy Kravchuk 
Thank you for a reasonable feature request. Something similar to Oracle's ON LOGON triggers will be surely useful.
[5 Mar 2006 9:49] Valeriy Kravchuk 
Looks like a duplicate of #17632.
[5 Mar 2006 9:50] Valeriy Kravchuk 
Duplicate of Bug #17632, I meant