ur sql" does
>> not,
>> because this same area of code works perfectly Many times throughout the
>> day, and I or no one else has changed it. Plus, the one stating ''SHOW
>> VARIABLE'' makes no sense at all. I have not executed such a
>> functi
Sent: Thursday, February 25, 2010 6:28
PM
Subject: Re: What is "unusually high" for
the # of connections to MySQL?
It depends, but 100 is not strange at all, particularly if
you have sleeping connections
(usually due to slow page loading (ajax?) and/or persistent connections
fro
;'SHOW VARIABLE''
makes no sense at all. I have not executed such a function in my code.
Thanks,
Jesse
- Original Message -
From: Claudio Nanni
To: Jesse
Cc: mysql@lists.mysql.com
Sent: Thursday, February 25, 2010 6:28 PM
Subject: Re: What is "unusually
It depends, but 100 is not strange at all, particularly if you have sleeping
connections
(usually due to slow page loading (ajax?) and/or persistent connections from
the app)
and any number of connections cannot crash a server, can make it slow or
unusable, but not crash it.
Watch the app, you coul
I was wondering what would be considered "unusually high" for the # of
connections to a MySQL Server? Also, if a high number of these are in
"sleep" mode,does it make a difference?
We have a web site (a few, actually) and MySQL (Version
5.0.67-community-nt-log) running on a WS08 server, and
Hello.
I don't remember any built-in capability of MySQL to provide such
information. But it seems as not a difficult task to write a script
which will gather it.
"todd hewett" <[EMAIL PROTECTED]> wrote:
> Thanks Gleb,
>
> That was educational.
>
> Is there a way to log connecti
@lists.mysql.com
Subject: Re: "tracing" connections to mysql.
Hello.
See:
http://dev.mysql.com/doc/mysql/en/mysql-threads.html
Please, next time answer to the list as well.
>Gleb thankyou.
>
>That was exactly what I thought I was looking for.
>
>It reve
Hello.
See:
http://dev.mysql.com/doc/mysql/en/mysql-threads.html
Please, next time answer to the list as well.
>Gleb thankyou.
>
>That was exactly what I thought I was looking for.
>
>It revealed two connections when logged in as admin through CLI: admin
>and
>the connection f
Hello.
> Is there a way to determin what connectiions to MySQL are being used by whom?
SHOW PROCESSLIST could be helpful. See:
http://dev.mysql.com/doc/mysql/en/show-processlist.html
[EMAIL PROTECTED] wrote:
> Howdy Folks,
>
> I have an app that cannot get information from mysql d
Howdy Folks,
I have an app that cannot get information from mysql database for some reason.
Here is an query which application is trying to run but after some timeout
(something about 2-3 minutes):
11 Jul 2005 03:32:18,485 DEBUG [Thread-20] (PressReleaseDAO.java:328) -
sqlselect prd.press_release
Are there any ways to remotely connect to MySQL besides TCP/IP? Also,
what are the 'bad' implications for allowing to connect to MySQL via TCP
remotely?
Thanks for your advice in advance.
-
Before posting, please check:
h
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
Lonnie,
Friday, February 15, 2002, 8:11:59 PM, you wrote:
LC> Hello All,
LC> I am new to this list and hope that someone could answer this
LC> question for me.
LC> I am running on a fresh install of Redhat 7.2 and am trying to
LC> connect to MySQL from a program that I have to test the connect
does your test app connect with root as the user?
-Original Message-
From: Lonnie Cumberland [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 12:12 PM
To: [EMAIL PROTECTED]
Subject: connections to MySQL
Hello All,
I am new to this list and hope that someone could answer this
Hello All,
I am new to this list and hope that someone could answer this
question for me.
I am running on a fresh install of Redhat 7.2 and am trying to
connect to MySQL from a program that I have to test the connections,
but am getting error messages saying that the host in not allowed to
conne
17 matches
Mail list logo