Hi,
> Are there any issues with user variables ( SET @variable:=) overflowing
> memory on the server?
> At any one
> time I wouldn't need most of them, but I don't see any way of
> removing them
> once set. Might this be an issue, or is there some garbage collection
> and/or memory limit on the variables. Should I clear them after
> using them
> by setting them to NULL?
No, you don't need to clean up your variables after use. To quote from the
manual:
"All variables for a thread are automatically freed when the thread exits."
So, when you close the connection to the MySQL server, your variables are
unset automatically - but not for other connections, just your own (bear in
mind that user variables set in one thread are not available server-wide).
As for memory limits on variables, this may be one question for the
developers to answer, is it mentions nothing about limits in the manual.
Regards,
Basil Hussain
---------------------------------------
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php