- Original Message -
> From: "Stdranwl"
>
> So then no use of setting 3G sort buffer in my.cnf untill system will
> take a rebot?
> I was in the impression that 10M will be used and it will be
> scratched to 3G whenever required as same is set globally?
No, you've got it the wrong way ro
gt;
> > On Wed, Nov 30, 2011 at 8:47 PM, Paul DuBois
> wrote:
> >
> > On Nov 30, 2011, at 4:04 AM, Stdranwl wrote:
> >
> > > Hi
> > > I can see different values when I run show global variables like
> > > . && sh
different values when I run show global variables like
> > . && show variables like .? could any body please
> > revert me on the scope and how they works?
>
>
> These sections of the MySQL manual may be of interest:
>
> http://dev.mysql.
> > DO NOT REPLY OFF-LIST
>
> Also, do not shout :-)
Ugh point taken, but why are you still replying to him off-list? Keep
inboxes clean! ;)
--
Rik Wasmus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
variables'.
> global is what would be used if the thread does not change it
That is, at connect time all the session variables are initialized from the
global variables; and the session can then override them.
For status variables (like com_*), the globals are cumulative counters, while
th
e.net>> wrote:
>
>
>
> Am 30.11.2011 11:04, schrieb Stdranwl:
> > Hi
> > I can see different values when I run show global variables like
> > . && show variables like .? could any body please
> > revert me
Am 30.11.2011 11:04, schrieb Stdranwl:
> Hi
> I can see different values when I run show global variables like
> . && show variables like .? could any body please
> revert me on the scope and how they works?
a global variable is global and for all thread
Hi
I can see different values when I run show global variables like
. && show variables like .? could any body please
revert me on the scope and how they works?
Yes and No.
Its depend on the type of variable you have changed.
If its Dynamic , MySQL restart not required, else its required.
System variables can be set at server startup using options on the command
> line or in an option file. Most of them can be changed dynamically while the
> server is run
unless and until if the variable is read-only, you don't need Lin.
On Mon, May 31, 2010 at 3:17 PM, Lin Chun wrote:
> hi
>
> as the title
>
> thanks
>
> --
> -
> Lin Chun
>
--
Thanks
Suresh Kuna
MySQL DBA
hi
as the title
thanks
--
-
Lin Chun
dude
try put it on var/my.cf
set-variable = max_connections = 1024
set-variable = max_user_connections = 128
set-variable = table_cache=1200
:wq!
i have this working with a mysql3x
should be similar to mysql4/5x
On 3/14/07, Bing Du <[EMAIL PROTECTED]> wrote:
Hi,
We're running mysql 4
We're running mysql 4.1.20. If I understand the manual correctly, I can
change max_connections while mysqld is running without restart mysqld to
make the change take effect
Correct.
But what if mysqld restarts later in some
other situations, like machine reboot, would my (global) change on
ma
On Wed, March 14, 2007 9:35, Bing Du said:
> Hi,
>
> We're running mysql 4.1.20. If I understand the manual correctly, I can
> change max_connections while mysqld is running without restart mysqld to
> make the change take effect. But what if mysqld restarts later in some
> other situations, like
I believe it would revert back to the settings in your my.cnf file. If
you want the change to be permanent, then set it there.
Steve Musumeche
CIO, Internet Retail Connection
[EMAIL PROTECTED]
Bing Du wrote:
Hi,
We're running mysql 4.1.20. If I understand the manual correctly, I can
chang
Hi,
We're running mysql 4.1.20. If I understand the manual correctly, I can
change max_connections while mysqld is running without restart mysqld to
make the change take effect. But what if mysqld restarts later in some
other situations, like machine reboot, would my (global) change on
max_conne
16 matches
Mail list logo
