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]
