as somebody in the list already pointed out it all depends on the
amount of RAM you have , the formula has been taken from Jeremy's book
, high performance Mysql
Expressed mathematically, that is:
min_memory_needed = global_buffers + (thread_buffers * max_connections)
where thread_buffers include
. Thanks!
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 06, 2005 7:03 AM
To: mysql@lists.mysql.com
Subject: Re: max_connections in 3.23.49
Hello.
For such an old version of MySQL use --set-variable syntax.
See:
http://dev.mysql.com/doc
Hello.
For such an old version of MySQL use --set-variable syntax.
See:
http://dev.mysql.com/doc/refman/4.1/en/program-variables.html
I'm not sure if it supports dynamic system variables through the SET
syntax, according to the manual they have appeared in 4.0.3. In the future,
instead
ent: Tuesday, June 07, 2005 1:55 PM
Subject: RE: max_connections
> I would then gather to say that the limit (hence the error) is being
> generate by Torque, which does the connection pooling, and has nothing to
> do directly with max_conn.
>
> Is there a config file or something that
:[EMAIL PROTECTED]
Sent: Tuesday, June 07, 2005 12:51 PM
To: mysql@lists.mysql.com
Subject: Re: max_connections
This error is thrown in a mask we use called Torque, it does the
connection
pooling but we have never had a problem with it such as this until now.
James
- Original Message
This error is thrown in a mask we use called Torque, it does the connection
pooling but we have never had a problem with it such as this until now.
James
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>;
Sent: Tuesday, June 07, 2005 1:23 PM
Where are you getting this error from?
Sounds like something on top of mysql that is doing the connection pooling
perhaps.
-Original Message-
From: James Sherwood [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 07, 2005 12:28 PM
To: mysql@lists.mysql.com
Subject: max_connections
Hello,
Jan Josefowicz <[EMAIL PROTECTED]> wrote:
> I'm trying to change the value of max_connections variable but mysqld
> doesn't accept that.
> I use mysql 3.23.54 and my config file /etc/my.cnf looks like:
>
> [mysql.server]
> ...
> ...
> set-variable max_connections=200
>
> After a newstart of mysq
"Gary Huntress" <[EMAIL PROTECTED]> wrote:
> I have some simple user quotas set to help balance my server load. I think
> I've implemented them properly because people do whine to me when they
> reach the query limit.
>
> I have max_connections set to 200, but right now I'm watching connections
m: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Gary Huntress" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, June 28, 2003 7:09 PM
Subject: Re: max_connections being ignored/overridden?
> At 18:15 -0400 6/28/03, Gary Huntress wrote:
> >Yes, I am ref
o: "Gary Huntress" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, June 28, 2003 5:45 PM
Subject: Re: max_connections being ignored/overridden?
At 17:26 -0400 6/28/03, Gary Huntress wrote:
>I have some simple user quotas set to help balance my server load. I
thi
DuBois" <[EMAIL PROTECTED]>
To: "Gary Huntress" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, June 28, 2003 5:45 PM
Subject: Re: max_connections being ignored/overridden?
> At 17:26 -0400 6/28/03, Gary Huntress wrote:
> >I have some simple user qu
At 17:26 -0400 6/28/03, Gary Huntress wrote:
I have some simple user quotas set to help balance my server load. I think
I've implemented them properly because people do whine to me when they
reach the query limit.
I have max_connections set to 200, but right now I'm watching connections
for 1 use
Stefan,
Thursday, September 19, 2002, 9:45:52 AM, you wrote:
SF> I want to change the varibale "max_connections" from 100 to 250. how can
SF> I do that? I use MySQL 3.23.52 under Windows XP professional
SF> Is the place I take the set-variable = max_connections=300 wrong?
SF> I have the fallowi
yes. put an entry "set-variable=max_connections=300" after "set-variable =
thread_concurrency=8" in your my.ini. Make sure this change is done in the
my.ini that is in the windows directory.
Karthik.
- Original Message -
From: "Stefan Faist" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Se
Pada Fri, 26 Jul 2002 11:17:08 -0700
Troy Hakala <[EMAIL PROTECTED]> menulis :
> ok, i turns out I have lots of sleeping connections. This is because I'm
> using PHP's mysql_pconnect which opens persistent connections so the next
> connect (on the same process) will reuse the connection. this d
At 11:17 -0700 7/26/02, Troy Hakala wrote:
>ok, i turns out I have lots of sleeping connections. This is because
>I'm using PHP's mysql_pconnect which opens persistent connections so
>the next connect (on the same process) will reuse the connection.
>this does appear to improve performance over
The language is English (same as server) and the client is PHP.
I've never seen this problem even when maxing out the connections at the
default 100.
On Thursday, July 25, 2002, at 02:55 PM, Georg Richter wrote:
> On Thursday, 25. July 2002 18:48, Troy Hakala wrote:
> Hello,
>
>> I've been ru
ok, i turns out I have lots of sleeping connections. This is because I'm
using PHP's mysql_pconnect which opens persistent connections so the next
connect (on the same process) will reuse the connection. this does appear
to improve performance overall, which is good. but it seems to leave lots
On Tue, 18 Jun 2002, louie miranda wrote:
> [mysqld]
> max_connections= 500
> Hi i have here my [mysqld] settings, im having troubles though on
> "max_connections"
> I was wondering if this settings is correct, and what option is correct?
max_connections is also a server variable, s
D], MySQL <[EMAIL PROTECTED]>
cc:
Subject:Re: max_connections
If you are just doing a port scan, that shouldn't be a problem. However,
if
you are going to the DB server, you will need to grant at least 'usage'
permissions to user@host via the GRANT statement.
If you are just doing a port scan, that shouldn't be a problem. However, if
you are going to the DB server, you will need to grant at least 'usage'
permissions to user@host via the GRANT statement.
Regards,
Bhavin.
- Original Message -
From: <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECT
22 matches
Mail list logo
