Thanks for the answer, but I guess it brings up another question: I was
planning to keep the connection open while the app is running, which could
be a long period of time, and the same issue could occur during that period.
Is it better to open and close the connection for every query I run? I am
looking to handle up to about 50 concurrent users, each running simple
operations about every 5-30 minutes or so during maximum load. Should I
time out the connection at a few seconds so that a series of operations can
run at a time, but in between no threads are holding on the server?
>From: "Basil Hussain" <[EMAIL PROTECTED]>
>To: "Eric Ellis" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>Subject: RE: User variables
>Date: Fri, 8 Jun 2001 16:33:43 +0100
>
>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]
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
---------------------------------------------------------------------
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
