Hi all!
I would like know if there are any calculatios for
specifying the maximum number of the 'max_connections' value.
I understand that max_connections should be decided by the remaining RAM size
of the system. But exactly how should it be actually calculated?
I am currently using RHEL 5.3 3
:wleut...@columbus.rr.com]
> Sent: Friday, September 21, 2012 7:04 AM
> To: mysql@lists.mysql.com
> Subject: Default Values for Max User and Max Connections.
>
> Hello All,
>
> Question. In mysql 5.5 what are the defaults for these values:
>
> max_connections = ? (is
Hello All,
Question. In mysql 5.5 what are the defaults for these values:
max_connections = ? (is this set to 151 in 5,5)
max_user_connections = ?(is this set to unlimited unless you provide
the exact number)?
Thank you so much.
Wayne Leutwyler, RHCT
Open Source + Open M
On Dec 22, 2007 10:55 AM, Moon's Father <[EMAIL PROTECTED]> wrote:
> how big your mysql connections's users.
How big users? don't know what you said.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi...
i can modify the max_connections param in the my.cnf file...
does mysql provide a way for me to essentially guarantee that a given
process/user can always access the db, so the process/user doesn't get the
'max connection' error...
i thought i had seen something regarding this awhile back,
I had done a test on Linux2.6. I got the max connections of 1079 when I
> complied the MySQL with static link. But I got the max connections of 7159
> when I complied the MySQL with dynamic link. Why has so much difference
> between the static link and dy
Hi, everyone:
I had done a test on Linux2.6. I got the max connections of 1079 when I
complied the MySQL with static link. But I got the max connections of 7159
when I complied the MySQL with dynamic link. Why has so much difference
between the static link and dynamic link? Has anybody know
huang leo 写道:
> hi,everyone,
> I just did a test to find out the MySQL4.1.12 max connections on
> FreeBSD 5.4 Release and FreeBSD 4.11 Release. The first test, the
> MAXSSIZ is default(64MB), and MAXSDIZ is 1GB because I have 1GB
> memory. The second test, I setted the MAXSS
hi,everyone,
I just did a test to find out the MySQL4.1.12 max connections on FreeBSD
5.4 Release and FreeBSD 4.11 Release.
The first test, the MAXSSIZ is default(64MB), and MAXSDIZ is 1GB because
I have 1GB memory. The second test, I setted the MAXSSIZ=1GB, and the
MAXDSIZ is also 1GB. The
Hi,
My original query was a UNION query :) and that one is really fast.
The problem i had was that every 8-12 day mysql sad that all of my
max_connections was in use. I think i will stick with my UNION query it
seems faster.
// Fredrik.
Bill Easton wrote:
Fredrik,
I haven't read all of th
ED]>
To: Donny Simonton <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: Max connections being used every 10-12 day.
I really appreciate your help :)
I did some cleanup of my indexes(there are a c
I really appreciate your help :)
I did some cleanup of my indexes(there are a couple of them left to
clean out but it takes so long time):
mysql> show index from
art;
+++--
x. This
is covered by 1st_2 or 1st_3.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Tom Crimmins
Sent: Monday, January 03, 2005 2:49 PM
To: Donny Simonton; 'Fredrik Carlsson'
Cc: mysql@lists.mysql.com
Subject: RE: Max connections being
onday, January 03, 2005 1:12 PM
To: 'Fredrik Carlsson'
Cc: mysql@lists.mysql.com
Subject: RE: Max connections being used every 10-12 day.
Frederik,
I may be losing my mind, but I don't think I am according to your show
index, you have multiple indexes on the same fields which is abso
g (id)
where A.id=60 or B.parent=60
order by A.date
Donny
> -Original Message-
> From: Fredrik Carlsson [mailto:[EMAIL PROTECTED]
> Sent: Monday, January 03, 2005 11:08 AM
> To: Donny Simonton
> Cc: mysql@lists.mysql.com
> Subject: Re: Max connections being used every 10-12 da
mysql> describe art;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-++
| id | int(11) | | PRI | NULL| auto_increment |
| parent
; From: Fredrik Carlsson [mailto:[EMAIL PROTECTED]
> Sent: Sunday, January 02, 2005 4:45 PM
> To: mysql@lists.mysql.com
> Subject: Re: Max connections being used every 10-12 day.
>
> The inner join statement returned the same stuff but it was not as fast
> as the union is and the inne
The inner join statement returned the same stuff but it was not as fast
as the union is and the inner join seems to use more cpu resources.
Could these union queries really be the problem behind my occasional
lock ups and that 200 connections being used? i mean the server is not
that loaded and
rom: Fredrik Carlsson [mailto:[EMAIL PROTECTED]
> Sent: Sunday, January 02, 2005 5:18 AM
> To: Donny Simonton
> Cc: mysql@lists.mysql.com
> Subject: Re: Max connections being used every 10-12 day.
>
> It is a single PIII 500MHz, so i just changed thread_concurrency to 2
> :), than
Fredrik Carlsson wrote:
It is a single PIII 500MHz, so i just changed thread_concurrency to 2
:), thanks
The slow query log don't show that many slow queries, but they did
show alot of queries that was'nt using any index, can these queries
cause some kind of occasional lock up?
Is there a fas
It is a single PIII 500MHz, so i just changed thread_concurrency to 2
:), thanks
The slow query log don't show that many slow queries, but they did show
alot of queries that was'nt using any index, can these queries cause
some kind of occasional lock up?
Is there a faster way to perform this
e awful queries or you have some tables that are
getting corrupted and are being repaired during that time.
Donny
> -Original Message-
> From: Fredrik Carlsson [mailto:[EMAIL PROTECTED]
> Sent: Saturday, January 01, 2005 4:37 AM
> To: mysql@lists.mysql.com
> Subject: Max c
mysql has about 50GB of temp space to work with so thats not the problem.
Its strange because the server is not that loaded and around 12-04 at
night no cronjobs that affects mysql or general server performance are
being run.
Is is possible to se how many queued up questions mysql has at the mom
age-
> From: Fredrik Carlsson [mailto:[EMAIL PROTECTED]
> Sent: 01 January 2005 10:37
> To: mysql@lists.mysql.com
> Subject: Max connections being used every 10-12 day.
>
>
> Hi list,
>
> I have a rather serious problem that i really dont know how to solve,
>
>
are closed
properly and they are. No persistent connections are being used and the
max connections error allways occures at night 02:00->03:00, my httpd
logs shows no unnormal amount of traffic at the time.
The last time this happend i tuned the wait_timeout down to 15 seconds
to se if t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi
I have a mySQL database thats taking a bit of a hammering - enough so that the
number of connections spirals up and out of control.
max_connections was originally at the default of 100 - but rising above 50 or
so meant actual throughput dropped s
Hello list,
I'd like to increase the number of max connections above 1024 in Linux.
I think I have to increase PTHREAD_THREADS_MAX in
/usr/include/bits/local_lim.h
/* The number of threads per process. */
#define _POSIX_THREAD_THREADS_MAX 64
/* This is the value this implement
n 2002, Patrick Hsieh wrote:
>
> > Hello,
> >
> > I want to raise the max connections in mysql. Due to the linux limix
> > thread limitation, I can only increase the number to around 1024. How
> > can I break the limitation?
>
> This is topic of glibc (assum
again.
Which one should I choose?
On Thu, 13 Jun 2002 08:55:35 +0200 (EET)
Tonu Samuel <[EMAIL PROTECTED]> wrote:
>
>
> On Thu, 13 Jun 2002, Patrick Hsieh wrote:
>
> > Hello,
> >
> > I want to raise the max connections in mysql. Due to the linux limix
PROTECTED]> wrote:
>
>
> On Thu, 13 Jun 2002, Patrick Hsieh wrote:
>
> > Hello,
> >
> > I want to raise the max connections in mysql. Due to the linux limix
> > thread limitation, I can only increase the number to around 1024. How
> > can I break the
On Thu, 13 Jun 2002, Patrick Hsieh wrote:
> Hello,
>
> I want to raise the max connections in mysql. Due to the linux limix
> thread limitation, I can only increase the number to around 1024. How
> can I break the limitation?
This is topic of glibc (assuming you are using kern
Hello,
I want to raise the max connections in mysql. Due to the linux limix
thread limitation, I can only increase the number to around 1024. How
can I break the limitation?
--
Patrick Hsieh <[EMAIL PROTECTED]>
GPG public key http://pahud.net/pubkeys/pahudatpah
s" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 29, 2001 6:07 PM
Subject: Max connections on Freebsd
> Hi,
> Is there someone who incremented the max_connection
> value to something above 100 (200) (300) on Freebsd 4.2?
>
> I had problems with my
Hi,
Is there someone who incremented the max_connection
value to something above 100 (200) (300) on Freebsd 4.2?
I had problems with mysql on freebsd 4.0, hooked up
after some days without any good reason :).
Some people told me thread libraries on freebsd
el Conde" <[EMAIL PROTECTED]> wrote:
To:"vinod panicker" <[EMAIL PROTECTED]>
From:"Jorge del Conde" <[EMAIL PROTECTED]>
Date:Sat, 3 Mar 2001 03:51:30 -0600
CC:<[EMAIL PROTECTED]>
Subject: Re: Re: max connections
Hi,
If you want to have 1000+ connecti
quot;vinod panicker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, March 03, 2001 2:52 AM
Subject: Re: Re: max connections
> hey,
> thanks for replying so soon. the max limit of files and inodes have
been increased on the syste
tance).
Tx.
Vinod
- Original Message --
"Jorge del Conde" <[EMAIL PROTECTED]> wrote:
To:<[EMAIL PROTECTED]>,
"vinod panicker" <[EMAIL PROTECTED]>
From:"Jorge del Conde" <[EMAIL PROTECTED]>
Date:Sat, 3 Mar 2001 01:17:41 -060
TED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\/ Mexico City, Mexico
<___/
- Original Message -
From: "vinod panicker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 1:09 PM
Subject: max connections
> hey,
&
hey,
i'm developing a product that heavily utilizes mysql databases through PHP. The
max number of connections that any server can handle is needed as i have to think of
scaleability issues. The servers are pretty powerful - it maxes out at 4G's 2x850
P-III. I need max performance out of
39 matches
Mail list logo
