put increases almost linearly with the number
> of C# threads, until I reach 100 threads, which is the maximum number
> of connections allowed by my server.
>
> This is quite unexpected, since the server has only two processors. I
> expect the throughput to grow from one connection to
number of C# threads I found that the time
taken to finish the benchmark decreases, thus increasing the
throughput. The throughput increases almost linearly with the number
of C# threads, until I reach 100 threads, which is the maximum number
of connections allowed by my server.
This is quite
On Mon, 11 Jun 2007, Dave Shariff Yadallee - System Administrator a.k.a. The
Root of the Problem wrote:
> REcently my mysql server has been overload with a lot
> of connections; in fact losing the mysql.user table and
> one whole database.
Define "losing". You lost access, or the tables got co
REcently my mysql server has been overload with a lot
of connections; in fact losing the mysql.user table and
one whole database.
How can this be prevented?
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailin
Brian Dunning wrote:
In one case I do need to jump back and forth between databases that are
on different physical servers. What's the most efficient way to handle
this?
On Aug 2, 2005, at 11:14 AM, Devananda wrote:
Brian Dunning wrote:
My RaQ4 is throwing the "Too many connections" erro
In one case I do need to jump back and forth between databases that
are on different physical servers. What's the most efficient way to
handle this?
On Aug 2, 2005, at 11:14 AM, Devananda wrote:
Brian Dunning wrote:
My RaQ4 is throwing the "Too many connections" error. Now, it is
getti
My RaQ4 is throwing the "Too many connections" error. Now, it is
getting hit pretty hard by traffic, but I wonder if my coding might
be exacerbating this error.
Due to my relatively lazy structure of includes and functions, my
pages might have half a dozen or so of these (most are to the sa
The number of connections touches several areas. Fortunately there is
very little overhead in creating MySQL connections. Connection pooling
hits a few snags in MySQL in the area of session and user variables.
Anything set inside a session will stick when the next thread picks up
a connection
Our Java application has several threads that use JDBC to write to several
tables. Currently, we use one JDBC connection. Would performance improve if
we used a connection per table? Is a single connection bad for some reason?
Since connection pooling is a hot topic, I'm wondering if we're mis
Hi Marcelo,
> Hi I was wondering if there is a way to give the a number of
> connections that I want simultaniusly to the database, supose
> I only want that 8 computers to access the database at the same time
try "max_connections" to limit the connections the s
Hi I was wondering if there is a way to give the a number of connections that I
want simultaniusly to the database, supose I only want that 8 computers to
access the database at the same time
Regards
Marcelo
Date: Mon, 29 Nov 2004 14:03:32 +0100
To: [EMAIL PROTECTED]
From: Philippe de Rochambeau <[EMAIL PROTECTED]>
Subject: Number of connections to a database
Message-Id: <[EMAIL PROTECTED]>
Hello,
is there any way to tell the number of simultaneous connections to a
mysql database at
Philippe de Rochambeau wrote:
Hello,
is there any way to tell the number of simultaneous connections to a
mysql database at a given time, using SQL or a scripting language such
as php, perl, etc. ?
Many thanks.
Philippe
show status is your friend:
show status like "Connections"
HTH,
Wolfram
--
Hello,
is there any way to tell the number of simultaneous connections to a
mysql database at a given time, using SQL or a scripting language such
as php, perl, etc. ?
Many thanks.
Philippe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
On Tue, 26 Mar 2002 22:45:18 -0300
"Edilson Vasconcelos de Melo Junior" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a client BD application that access a remote MYSQL server and its job
> is 4-7hours long and it should be connected to the server all this time :(
> My question is: how many simult
At 22:45 -0300 3/26/02, Edilson Vasconcelos de Melo Junior wrote:
>Hi,
>
>I have a client BD application that access a remote MYSQL server and its job
>is 4-7hours long and it should be connected to the server all this time :(
Why is that a problem?
>My question is: how many simultaneous connect
Hi,
I have a client BD application that access a remote MYSQL server and its job
is 4-7hours long and it should be connected to the server all this time :(
My question is: how many simultaneous connections the mysql server can
handle? And what does happen when this limit is overstepped?
Thank u
On Wed, 12 Dec 2001, Jari =?iso-8859-1?Q?M=E4kel=E4?= wrote:
> Date: Wed, 12 Dec 2001 13:25:09 +0200
> From: Jari =?iso-8859-1?Q?M=E4kel=E4?= <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: changing allowed number of connections
>
> Hi,
>
> Where one can a
Hi,
Where one can alter the number of connections going to MySQL?
Jari Mäkelä
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
nection.
> for example, below is the snippet from one of my pages content.jsp :
>
> <% if (stmt!=null) { // actually this is a curly left brace
> stmt.close(); } // actually this is a curly right brace
> if (conn!=null){ // stmt is a Statement object
> conn.close(); // conn
lly this is a curly right brace
if (conn!=null){ // stmt is a Statement object
conn.close(); // conn is a Connection object
} %>
whenever i call this page , number of connections inreases by one
it seems that the connections can not be closed
Any idea or suggestions ?
thanks a lot in a
Hello Raj!
> What is the command to list all the users connected to mysql server?
Type mysqladmin with no parameters for command line help and a list of
options. The one you need is processlist.
Have a :) day!
jb
--
jim barchuk
[EMAIL PROTECTED]
What is the command to list all the users connected to mysql server?
Thanks
Raj
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To req
On Wed, 28 Feb 2001, Decasto David wrote:
> can u tell us how to configure mysql , to support more
> connections.
safe_mysqld --set-variable=max_connections=n
--
/"\
\ /ASCII RIBBON CAMPAIGN
X AGAINST HTML EMAIL
/ \AND POSTINGS
Hello,
I am using Poolman 1.4.1 , and trying to make 100
connections to mysql server.
ITs throwing an excepiton that cannot make connection
to mysql. We reached to a conclusion that mysql
supports 100 at a time connecdtions.
can u tell us how to configure mysql , to support more
connections.
25 matches
Mail list logo
