Re: Re: What is "unusually high" for the # of connections to MySQL?

2010-02-25 Thread Ananda Kumar
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

Re: Re: What is "unusually high" for the # of connections to MySQL?

2010-02-25 Thread claudio . nanni
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

Re: What is "unusually high" for the # of connections to MySQL?

2010-02-25 Thread Jesse
;'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

Re: What is "unusually high" for the # of connections to MySQL?

2010-02-25 Thread Claudio Nanni
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

What is "unusually high" for the # of connections to MySQL?

2010-02-25 Thread Jesse
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

Re: "tracing" connections to mysql.

2005-07-13 Thread Gleb Paharenko
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

RE: "tracing" connections to mysql.

2005-07-12 Thread todd hewett
@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

Re: "tracing" connections to mysql.

2005-07-12 Thread Gleb Paharenko
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

Re: "tracing" connections to mysql.

2005-07-11 Thread Gleb Paharenko
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

"tracing" connections to mysql.

2005-07-11 Thread todd . hewett
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

Different Connections To MySQL

2002-07-23 Thread Otoniel Cantu`
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

Re: Number of connections to mysql server

2002-03-26 Thread Dicky Wahyu Purnomo
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

Re: Number of connections to mysql server

2002-03-26 Thread Paul DuBois
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

Number of connections to mysql server

2002-03-26 Thread Edilson Vasconcelos de Melo Junior
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

connections to MySQL

2002-02-16 Thread Egor Egorov
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

RE: connections to MySQL

2002-02-15 Thread Rick Emery
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

connections to MySQL

2002-02-15 Thread Lonnie Cumberland
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