From: Gleb Paharenko (gleb.paharenkoensita.net)
Date: Mon Jul 11 2005 - 15:48:16 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

todd.hewettregalhost.com 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
 / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenkoensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
       <___/ www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]