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