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 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_id, pr.start_date,  prd.attention_title,

> prd.headline, prd.sub_headline, prd.summary, prd.company_name, prd.body,

> prd.city, prd.state, ind.industry_id, ind.industry_name from

> press_release_detail prd, press_release pr, industry ind where pr.active_flag 
> =

> 'Y' and pr.press_release_id = prd.press_release_id  and prd.industry =

> ind.industry_id and start_date <= date_add(current_timestamp(), INTERVAL 3

> HOUR) order by pr.start_date desc

> 

> Then errors follows:

> 

> 11 Jul 2005 03:38:24,125 ERROR [Thread-18] (PressReleaseDAO.java:357) -

> SQLException:java.sql.SQLException: Communication link failure:

> java.net.SocketException

> 11 Jul 2005 03:38:24,126 ERROR [Thread-18] (BaseAction.java:75) -

> com.flierwire.common.FlierwireSystemException: A system error has occurred,

> please send an email to support at flierwire.com with details of what 
> occurred.

> 

> I've tried to run this request in mysql and it has been ran fine.

> 

> After that I've increased max_connections limit in /etc/my.cnf and app runs

> fine.

> 

> 

> 

> Is there a way to determin what connectiions to MySQL are being used by whom?

> 

> Thanks,

> 

> Todd

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to