wait_timeout issue

Hi,
I am trying to set this variable to something bigger
than the default, 28800, i cant seem to do this from
the adminstrator, or from the command line or in the
my.ini file, is there a number of correct variable for
it?


MArk



__________________________________
Do you Yahoo!?
Plan great trips with Yahoo! Travel: Now over 17,000 guides!
http://travel.yahoo.com/p-travelguide

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: wait_timeout issue

How are you trying to see the value after setting it and how are you settin=
g it?
Be aware that we have two scopes, the session (local) and the GLOBAL
one, each one with different values.

On 4/19/05, Mark Mchugh wrote:
> Hi,
> I am trying to set this variable to something bigger
> than the default, 28800, i cant seem to do this from
> the adminstrator, or from the command line or in the
> my.ini file, is there a number of correct variable for
> it?
>=20
> MArk
>=20
> __________________________________
> Do you Yahoo!?
> Plan great trips with Yahoo! Travel: Now over 17,000 guides!
> http://travel.yahoo.com/p-travelguide
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gma=
il.com
>=20
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: wait_timeout issue

i am using the show varibales to see it?
--- Daniel da Veiga wrote:
> How are you trying to see the value after setting it
> and how are you setting it?
> Be aware that we have two scopes, the session
> (local) and the GLOBAL
> one, each one with different values.
>
> On 4/19/05, Mark Mchugh wrote:
> > Hi,
> > I am trying to set this variable to something
> bigger
> > than the default, 28800, i cant seem to do this
> from
> > the adminstrator, or from the command line or in
> the
> > my.ini file, is there a number of correct variable
> for
> > it?
> >
> > MArk
> >
> > __________________________________
> > Do you Yahoo!?
> > Plan great trips with Yahoo! Travel: Now over
> 17,000 guides!
> > http://travel.yahoo.com/p-travelguide
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
>
http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
> >
> >
>
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
>
http://lists.mysql.com/win32?unsub=mark_mch@yahoo.com
>
>



__________________________________
Do you Yahoo!?
Plan great trips with Yahoo! Travel: Now over 17,000 guides!
http://travel.yahoo.com/p-travelguide

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: wait_timeout issue

You see, administrator and most applications RESET the SESSION value
of wait_timeout and interactive_timeout in their session, and clients
that don't do that get the value of the global variable, the only way
to see its value (that will be default for clients) is using:

show GLOBAL variables;

If you issue a simple show variables you'll see the modified values...

Hope that helps,

On 4/19/05, Mark Mchugh wrote:
> i am using the show varibales to see it?
> --- Daniel da Veiga wrote:
> > How are you trying to see the value after setting it
> > and how are you setting it?
> > Be aware that we have two scopes, the session
> > (local) and the GLOBAL
> > one, each one with different values.
> >
> > On 4/19/05, Mark Mchugh wrote:
> > > Hi,
> > > I am trying to set this variable to something
> > bigger
> > > than the default, 28800, i cant seem to do this
> > from
> > > the adminstrator, or from the command line or in
> > the
> > > my.ini file, is there a number of correct variable
> > for
> > > it?
> > >
> > > MArk
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > Plan great trips with Yahoo! Travel: Now over
> > 17,000 guides!
> > > http://travel.yahoo.com/p-travelguide
> > >
> > > --
> > > MySQL Windows Mailing List
> > > For list archives: http://lists.mysql.com/win32
> > > To unsubscribe:
> >
> http://lists.mysql.com/win32?unsub=3Ddanieldaveiga@gmail.com
> > >
> > >
> >
> >
> > --
> > Daniel da Veiga
> > Computer Operator - RS - Brazil
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> >
> http://lists.mysql.com/win32?unsub=3Dmark_mch@yahoo.com
> >
> >
>=20
> __________________________________
> Do you Yahoo!?
> Plan great trips with Yahoo! Travel: Now over 17,000 guides!
> http://travel.yahoo.com/p-travelguide
>=20


--=20
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org