hi all
in the mysql.user table, what is the difference between max_connections
and mac_user_connections? or to put it simply, if i want each user
except root to only be able to have only one connection to the server at
any one time, which field should i set to 1?
--
PO Box 26453 00504
> This might help you
> http://kjalleda.googlepages.com/maxconnbymysql
>
> Kishore Jalleda
Thanks Kishore.
Regards,
Rithish.
This might help you
http://kjalleda.googlepages.com/maxconnbymysql
Kishore Jalleda
On 8/2/06, Rithish Saralaya <[EMAIL PROTECTED]> wrote:
Hello folks.
How do I determine what is the safest value that I can set for
max_connections in my.cnf? The default value of 100 is proving t
Hello folks.
How do I determine what is the safest value that I can set for
max_connections in my.cnf? The default value of 100 is proving to be a
shortfall during some cases of peak hour traffic.
Could you point me to a resource available if any?
1. Our server is RHEL 3, 2*3.00 GHz, 4GB
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_bu
Are there any statistics that I can use to determine how high or low I
should set max_connections? I am using MySQL as the backend for a Java web
application that will need to accommodate a moderate amount of traffic.
Also, if max_connections is set too high relative to the needs of the
. 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
stead of 'set @variable' syntax for system variables, use 'set
@@global.variable' or 'set global variable=...'. See:
http://dev.mysql.com/doc/refman/4.1/en/system-variables.html
I strongly recommend you to upgrade.
Douglas B. Jones wrote:
> How do y
How do you up max_connections on 3.23.29 mysql? I
have tried in the my.cnf file, command line and
in mysql (set @max_connections=200). Thanks for
any help!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
t; To: mysql@lists.mysql.com
> Subject: Re: Increasing max_connections and table_cache on Solaris 8
>
> Hello.
>
> I don't have enough experience with Solaris.. But on most
> Unixes your could change the limit of file descriptors for
> process, not for whole system.
>
> Se
ions, should I let the
> sysadmin increase the limit of open file descriptors on the Solaris box,
> or is there a setting in MySQL that I overlooked?
>
> Note: max_connections is set to 1000 in the my.cnf file, but when
> starting up, MySQL doesn't accept that value and de
SQL that I overlooked?
Note: max_connections is set to 1000 in the my.cnf file, but when
starting up, MySQL doesn't accept that value and decreases it to 246.
Setting the variable to 1000 whilst MySQL is running /is/ accepted.
Kind regards,
--
Martijn
ASML ITM&S Application Support /
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
Subject: RE: max_connections
> 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
&
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
Hello,
I have a problem with a database mask I use named torque. I get an
error "Cannot get connection from pool"
I beleive it is from the max_connections reaching their limit. I put the
line max_connections=200 in the my.cnf file but when I check the show
variables of the databa
Hi...
I need to increase my max_connection variable on mysql DB.
Her value now is 100... I must to increase to 500.
(Mysql 3.23.49 on Red Hat 8. My server is a IBM Pentium 4, 1.6 Ghz, HD 40G, 1G
of RAM)
What do I have to do for balance my DB and my server in this case?
Which others elements or
Can I assume that that with a innodb_buffer_pool_size of 1G I can
accept only 500 max_connections (stack size 2M*500 connections).
Also, I noticed that I can't set a innodb_buffer_pool_size > 1G. Ideas?
Max
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
> -Original Message-
> From: Dathan Pattishall [mailto:[EMAIL PROTECTED]
> Sent: donderdag 3 februari 2005 1:21
> To: Mark; mysql@lists.mysql.com
> Subject: RE: Relationship between 'table_cache' and 'max_connections'
>
> Max_connections rel
Table_cache is a pool of file descriptors held open, so the over head of
opening table is not necessary since the open is cached.
Max_connections relates to table_cache because they both use
descriptors. Thus at least the sum of the 2 is used by mySQL to set the
ulimit of file descriptors higher
I hope someone can clarify the relationship between 'table_cache' and
'max_connections' (I use MySQL 4.0.23). The manual says:
"table_cache is related to max_connections. For example, for
200 concurrent running connections, you should have a table
cache size of
Hello all,
Can someone tell me the consequences of setting max_connections and
open-files-limit too high? That is, higher than I'd expect to need under
normal circumstances, say 10,000 connections when all I'd expect is less
than 1,000 at any one time. Could a malicious user bring My
Alberto Mucignat <[EMAIL PROTECTED]> wrote:
> I mean, suppose we have max_connections=500, is it possible to say that
> from all external clients there could be at max 490 connections, while a
> single host or user can have at max 10 connections? Obviously, if host
> who
Is it possible to configure MySQL to have different max_connections
limit based on either user or host which is connecting to server?
I mean, suppose we have max_connections=500, is it possible to say that
from all external clients there could be at max 490 connections, while a
single host or
> >
> > My problem is that we're hitting our max_connections more and more frequently. Is
> > it safe to raise this to (say) 200, or will
this
> > cause performance problems? Already the machine is using up a lot of swap; would
> > you recommend that I bump t
Alex Greg wrote:
Hi,
Our main database server is a 2 x PIII 1.2Ghz with 1.5GB RAM and a 73GB SCSI
RAID-5 made up of 3 36GB disks. It does between 300 and
1200 queries per second. The read to write ratio is about 4:1.
My problem is that we're hitting our max_connections more and more frequ
Hi,
Our main database server is a 2 x PIII 1.2Ghz with 1.5GB RAM and a 73GB SCSI RAID-5
made up of 3 36GB disks. It does between 300 and
1200 queries per second. The read to write ratio is about 4:1.
My problem is that we're hitting our max_connections more and more frequently. Is it
sa
Hi.
Can someone help me with problem of max connection when it rech the limit
cause some process has lock table so I want to login as root to make some
kill that process but I can login because of max connection bloack me.
And I known some user with PROCESS_ACL can login is root has this
privi
MAX_CONNECTIONS_PER_HOUR ?
Now, I set the "MAX_CONNECTIONS", but I didn't know about
MAX_CONNECTIONS_PER_HOUR. Still, the problem has persisted when left
for a day or two without restarting. In fact, the issues only go away
when the server is restarted (though I did NO
; #mysql -p -u comet
> Enter password:
> ERROR 1226: User 'comet' has exceeded the 'max_connections' resource
> (current value: 100)
>
> Now, that is exactly what I'd expect to see, IF the user had 100
> connections. Instead, when viewing the processlist,
#x27;comet' has exceeded the 'max_connections' resource
(current value: 100)
Now, that is exactly what I'd expect to see, IF the user had 100
connections. Instead, when viewing the processlist, I get :
#mysql
Hello, list,
What is a "good" setting for max_connections on a Windows machine with 1GB
RAM, Dual Athlons, RAID, etc...
The default of 100 seems a bit lean, we would like to increase this number,
but don't have any experience history with MySQL to draw upon.
The docs say that 5
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_
Hi,
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 mysqld the value of max_connections is unc
/site2/fst/etc/my.cnf
/home/virtual/site3/fst/etc/my.cnf
/home/virtual/site4/fst/etc/my.cnf
/home/virtual/site5/fst/etc/my.cnf
---
All the files except for /etc/my.cnf.admin_appl and /etc/my.cnf only
contain client information. I added max_connections
/my.cnf
/home/virtual/site4/fst/etc/my.cnf
/home/virtual/site5/fst/etc/my.cnf
---
All the files except for /etc/my.cnf.admin_appl and /etc/my.cnf only
contain client information. I added max_connections=1500 to both of
those files and restarted MySQL
search for
my.cnf
If it does not exist you can create it,
http://www.mysql.com/doc/en/Option_files.html
Peter
-Original Message-
From: Richard Sumilang [mailto:[EMAIL PROTECTED]
Sent: 22 July 2003 07:56
To: [EMAIL PROTECTED]
Subject: Setting max_connections
Where do I go to set
Where do I go to set the max_connections settings so I can have over
100?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello all,
We have 3 instances on the same server, prod, test and dev. Is it possible
to increase the max_connection limit just for one instance, or would
changing the limit effect all 3 ?
Many thanks
** For great Emap magazine subscription & gift offers visit
http://www.emapmagazines.co.uk
"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, bu
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
At 18:15 -0400 6/28/03, Gary Huntress wrote:
Yes, I am referring to MAX_CONNECTIONS_PER_HOUR, poorly worded on my part
sorry.
Users are granted access to only one database (barring errors in my scripts)
and I did verify that his entry in mysql.user is 200 for max_connections.
And the connections
Yes, I am referring to MAX_CONNECTIONS_PER_HOUR, poorly worded on my part
sorry.
Users are granted access to only one database (barring errors in my scripts)
and I did verify that his entry in mysql.user is 200 for max_connections.
And the connections in the logfile are for the same user each
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 connect
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 user scroll by at an alarming rate
Hi all
please help
19:36:59[p0]talmuth@smtp:~>cat /etc/my.cnf
[client]
host=localhost
user=root
[mysqld]
max_connections = 5000
19:37:58[p0]talmuth@smtp:~>cat /usr/local/etc/rc.d/mysql.sh
#!/bin/sh
cd /usr/local/mysql
./bin/mysqld_safe --user=mysql --default-character-set=cp1251 --max_c
You have mistaken the syntax, use the option
--set-variable max_connections=200
or add to your my.cnf file in one of [mysqld], [server] or [safe_mysqld]
sections:
set-variable = max_connections=200
On Thu, 2003-01-30 at 17:16, [EMAIL PROTECTED] wrote:
> Hi Group,
>
> I want to
You can add the entry to my.cnf:
[mysqld]
set-variable= max_connections=200
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: How can I start my mysql server with max_connections option
Date: Thu, 30 Jan 2003 22:46:27 +0530 (IST)
Hi Group,
I want to start m
On Thu, Jan 30, 2003 at 10:46:27PM +0530, [EMAIL PROTECTED] wrote:
> Hi Group,
>
> I want to start my mysql with max_connections option. Now I am getting To
> many connction error. So I want to allow 200 concurrent connections...
>
> I tried with
> safe_mysqld max_connecti
Hi Group,
I want to start my mysql with max_connections option. Now I am getting To
many connction error. So I want to allow 200 concurrent connections...
I tried with
safe_mysqld max_connections=200 &
But it is not coming up...
How can I set max_connections as 200. Do I need to specify tha
What is the maximum for max_connections when I have:
MySQL database server 4.0.3-beta
HP NetServer LC2000 running RedHat Linux 7.3
Dual Pentium III 800mhz
1GB Ram
Raid5
Regards, Jacob
-
Before posting, please check
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 wron
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
hello,
I want to change the varibale "max_connections" from 100 to 250. how can
I do that? I use MySQL 3.23.52 under Windows XP professional
Is the place I take the set-variable = max_connections=300 wrong?
I have the fallowing my.ini:
=== Begin
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
;
>> I've been running MySQL for 2 years with no problems. Yesterday, I
>> increased the max_connections because I was getting "too many
>> connections"
>> error. This morning, the server again reached its limit but it never
>> seemed to recover from it
; Pada Thu, 25 Jul 2002 09:48:40 -0700
> Troy Hakala <[EMAIL PROTECTED]> menulis :
>
>> I've been running MySQL for 2 years with no problems. Yesterday, I
>> increased the max_connections because I was getting "too many
>> connections"
>> error. Th
I've been running MySQL for 2 years with no problems. Yesterday, I
increased the max_connections because I was getting "too many connections"
error. This morning, the server again reached its limit but it never
seemed to recover from it and constantly gave the "too many co
louie,
Tuesday, June 18, 2002, 12:36:14 PM, you wrote:
lm> Yes, thanks a lot.
lm> I still have a question though.
lm> Up to how many connection can mysql handle?
The maximum number of connections depends not only on max_connections
value. It also depends on thread library on yo
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
Yes, thanks a lot.
I still have a question though.
Up to how many connection can mysql handle?
Thanks,
Louie...
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 18, 2002 3:29 PM
Subject: Re: How to a
Liu,
Monday, June 17, 2002, 8:33:46 AM, you wrote:
LQq> Please tell me how to add the max_connections of mysql. Please give me a example.
max_connections is a mysqld variable. You can't add\drop
max_connections, you can only increase\decrease its value. If you want
to change default va
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.
;
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, June 12, 2002 1:29 PM
Subject: max_connections
> I've written a small port monitor in perl, just to check and make sure
> something
> is responding on the port. I don't want to do anything fancy, but it
> appears
I've written a small port monitor in perl, just to check and make sure
something
is responding on the port. I don't want to do anything fancy, but it
appears that
MySQL doesn't like this. It doesnt block connections from localhost (thank
goodness), but my remote port monitor gets locked out.
Rekha,
Tuesday, June 11, 2002, 8:17:01 PM, you wrote:
RD> Where can I get a sample my.cnf?
You can find examples of *.cnf in /usr/doc/MySQL-X.XX.
RD> Thanks,
RD> Rekha
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://
Rekha,
Tuesday, June 11, 2002, 8:48:12 PM, you wrote:
RD> Do I need to have some kind of permissions to change a variable ?
No, you should have permissions to run mysqld.
RD> Thanks,
RD> Rekha
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is spons
Do I need to have some kind of permissions to change a variable ?
Thanks,
Rekha
-Original Message-
From: Steve Katen [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 10, 2002 6:17 PM
To: Rekha Das; '[EMAIL PROTECTED]'
Subject: Re: How to set max_connections ?
what do you mean
Where can I get a sample my.cnf?
Thanks,
Rekha
-Original Message-
From: Steve Katen [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 10, 2002 6:17 PM
To: Rekha Das; '[EMAIL PROTECTED]'
Subject: Re: How to set max_connections ?
what do you mean it doesn't do anything?
you
ne as:
>
> --set-variable=max_connections=200
>
> or you could edit the my.cnf file that mysql is using when it
> starts-up. if you can't find the my.cnf, then you should create one. here
> is a link to the manpage and some default entires on mysql.com:
> http://www
what do you mean it doesn't do anything?
you should be able to set it on the command line as:
--set-variable=max_connections=200
or you could edit the my.cnf file that mysql is using when it
starts-up. if you can't find the my.cnf, then you should create one. here
is a link to t
Hi all,
I am trying to set max_connections to 200 on my server. Currently it is 100.
My mysql version 3.22.32. My problem is I am not able to find my.cnf. And if
I set the variable on command line like this:
--set-variable = max_connections=200;
Then it does not do anything.
What am I doing
Hello list,
I am running mysql-3.23.49 on Linux 2.4.18 for production purpose.
Now I want to define a proper max_connections value in mysql. The
document said,
"The maximum number of connects MySQL is depending on how good the thread library is
on a
given platform. Linux or Solaris shou
You can set your max_connections variable thusly:
mysqld -O max_connections=1000
(That's an upper-case letter "O" and the above needs to be appended to the
other options that start mysqld
-Original Message-
From: Mitch Fournier [mailto:[EMAIL PROTECTED]]
Sent: Thurs
Mitch,
You need to set the max_connections variable to something in you my.cnf
file. This number is really determined by your OS/Memory etc. but I
think the MySQL manual says somewhere about 500 to 700 being possible
with Solaris. Currently we use a figure of 220, but I got to that number
by
Hi,
i've been googlizing for a while now and can't find a straight answer to
this question:
- what is the optimal setting for "max_connections" in mysql?
- how do i start the server w a higher number?
stats on my db setup:
- database machine has 384MB of ram
- clie
Thanks, got it.
On Wed, 31 Oct 2001, Wouter de Jong wrote:
> Date: Wed, 31 Oct 2001 09:19:14 +0100
> From: Wouter de Jong <[EMAIL PROTECTED]>
> To: "William R. Mussatto" <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: Can't set max_connect
<[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: Can't set max_connections on debian version
>
> On Tue, Oct 30, 2001 at 11:31:12AM -0800, William R. Mussatto wrote:
> > Thanks but it doesn't work...
> >
> > Below is the extract of the configu
"failed" There is no entry in the error log. Commenting out the
> line results in a successful restart. I am probably missing something
> basic but...
> set-variable= key_buffer=16M
> set-variable= max_allowed_packet=1M
> set-variable= thread_stack
successful restart. I am probably missing something
basic but...
On 30 Oct 2001, Tonu Samuel wrote:
> Date: 30 Oct 2001 21:21:32 +0200
> From: Tonu Samuel <[EMAIL PROTECTED]>
> To: "William R. Mussatto" <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subjec
I realize this is not the current version, but debian stable is stuck on:
3.22.32.
mysqld does not start when I enter
max_connections 200
although it reports max_connections 100
Sincerely,
William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27
ld] group:
[mysqld]
set-variable = max_connections=xxx
>Thank You
>
>Mark
>- Original Message -
>From: "John Barton" <[EMAIL PROTECTED]>
>To: "Mark Lo (3)" <[EMAIL PROTECTED]>
>Cc: "ComMysql@Lists. Mysql." <[EMAIL PROTECTED]>
>
what I did wrong.
Thank You
Mark
- Original Message -
From: "John Barton" <[EMAIL PROTECTED]>
To: "Mark Lo (3)" <[EMAIL PROTECTED]>
Cc: "ComMysql@Lists. Mysql." <[EMAIL PROTECTED]>
Sent: Friday, May 11, 2001 12:53 AM
Subject: Re: set variable
including 3.23.37
>
> set-variable = max_connections=
>
> John Barton
> Unix Systems Administrator
> Primary Networks, Inc.
> [EMAIL PROTECTED]
>
> On Thu, 10 May 2001, Mark Lo (3) wrote:
>
> > Hi,
> >
> > I would like to set a higher values in m
Try putting a line like the following in your my.cnf file:
This has always worked for me, including 3.23.37
set-variable = max_connections=
John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]
On Thu, 10 May 2001, Mark Lo (3) wrote:
> Hi,
>
> I w
Hi,
I would like to set a higher values in max_connections for mysql.
I have tried to use the following command "mysqld --set-variables
max_connections=900 -u root -ppassword". Then, it shows that I have
successfully changed the variable of max_connections. But, when I check i
out, that I have to set the
variable max_connections at a higher value. I did it in a separate file,
called my.ini:
[mysqld]
basedir=D:\\Programme\\MySQL
set_variable = max_connections=300
I started MySQL with:
D:\Programme\MySQL\bin\mysqld-shareware.exe
--defaults-file=d:\winnt\my.ini
89 matches
Mail list logo
