Setting Variables

2008-02-25 Thread Endie
Dear all.. Does anyone know how to set variables in MySQL ideal for the performance so the machine can run maximum which variable i should be notice? what is the value of each variable? how can i calculate to get the value? is there the formula? for example: max_allowed_packet =? max_binlog_size

Setting Variables

2008-02-25 Thread e-Ndie
Dear all.. Does anyone know how to set variables in MySQL ideal for the performance so the machine can run maximum which variable i should be notice? what is the value of each variable? how can i calculate to get the value? is there the formula? for example: max_allowed_packet =? max_binlog_size=

Re: Setting variables on update

2004-02-24 Thread Bill Easton
ot no response--however, the problem seems to have gone away in 4.0.14. -Original Message- From: [EMAIL PROTECTED] Subject: RE: Setting variables on update Date: Mon, 23 Feb 2004 11:50:38 -0700 Try this...works on 4.1.2 UPDATE ControlTable SET NextID=3D 1 + (select @prevval :=3D NextID

RE: Setting variables on update

2004-02-23 Thread emierzwa
Try this...works on 4.1.2 UPDATE ControlTable SET NextID= 1 + (select @prevval := NextID) Ed -Original Message- From: Sasha Pachev [mailto:[EMAIL PROTECTED] Sent: Monday, February 23, 2004 11:19 AM To: Matt Fagan Cc: [EMAIL PROTECTED] Subject: Re: Setting variables on update Matt

Re: Setting variables on update

2004-02-23 Thread Sasha Pachev
Matt Fagan wrote: Hello, I'm trying to run an SQL update statement like: UPDATE ControlTable SET @prevval := NextID, NextID = NextID + 1 I've tried using a range of different syntax, but nothing seems to work. This is something that does work in another SQL server I used to use. Does anybody know

Setting variables on update

2004-02-20 Thread Matt Fagan
Hello, I'm trying to run an SQL update statement like: UPDATE ControlTable SET @prevval := NextID, NextID = NextID + 1 I've tried using a range of different syntax, but nothing seems to work. This is something that does work in another SQL server I used to use. Does anybody know if this is some

Re: Setting variables in XP

2002-11-26 Thread Heikki Tuuri
Peter, - Original Message - From: ""Peter Boivin"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, November 26, 2002 11:25 PM Subject: Setting variables in XP > I would like to put "SET AUTOCOMMIT=0" in my.ini. When I pu

Setting variables in XP

2002-11-26 Thread Peter Boivin
I would like to put "SET AUTOCOMMIT=0" in my.ini. When I put it under "[mysqld]", mysql will not start as a service. When I put it under "[WinMySQLadmin]", the service starts but does not appear to have any effect. Any suggestions? Kindly, Peter Boivin [EMAIL PROTECTED] ---