# MySQL persistent conections

**URL:** <https://forum.mautic.org/t/mysql-persistent-conections/7922>\
**Category:** General Discussion\
**Created:** [March 14, 2017, 12:22am UTC](https://forum.mautic.org/t/mysql-persistent-conections/7922 "2017-03-14T00:22:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![awurman](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/awurman/32/458_2.png) [@awurman](https://forum.mautic.org/u/awurman)\
**Post date:** [March 14, 2017, 12:22am UTC](https://forum.mautic.org/t/mysql-persistent-conections/7922/1 "2017-03-14T00:22:48Z")

</div>

Today i was looking for performance problems and a show processlist give me this result:  
  
  
  
99659 mautic 181.167.67.6:61597 mautic Sleep 7751  
  
99660 mautic 181.167.67.6:61598 mautic Sleep 7729  
  
99663 mautic 181.167.67.6:61613 mautic Sleep 7107  
  
99664 mautic 181.167.67.6:61614 mautic Sleep 7085  
  
99669 mautic 181.167.67.6:61725 mautic Sleep 6463  
  
99670 mautic 181.167.67.6:61726 mautic Sleep 6441  
  
99673 mautic 181.167.67.6:61746 mautic Sleep 5819  
  
99674 mautic 181.167.67.6:61749 mautic Sleep 5797  
  
99684 mautic 181.167.67.6:61911 mautic Sleep 5175  
  
99685 mautic 181.167.67.6:61912 mautic Sleep 5153  
  
99695 mautic 181.167.67.6:62112 mautic Sleep 4531  
  
99696 mautic 181.167.67.6:62115 mautic Sleep 4509  
  
99728 mautic 181.167.67.6:62407 mautic Sleep 3887  
  
99730 mautic 181.167.67.6:62408 mautic Sleep 3865  
  
99750 mautic 181.167.67.6:63533 mautic Sleep 3243  
  
99751 mautic 181.167.67.6:63535 mautic Sleep 3221  
  
99766 mautic 181.167.67.6:64124 mautic Sleep 2599  
  
99767 mautic 181.167.67.6:64131 mautic Sleep 2577  
  
99772 mautic 181.167.67.6:64862 mautic Sleep 1955  
  
99773 mautic 181.167.67.6:64863 mautic Sleep 1933  
  
99776 mautic 181.167.67.6:65013 mautic Sleep 1311  
  
99777 mautic 181.167.67.6:65014 mautic Sleep 1289  
  
99780 mautic 181.167.67.6:49239 mautic Sleep 667  
  
99781 mautic 181.167.67.6:49249 mautic Sleep 645  
  
99787 mautic 181.167.67.6:50045 mautic Query 0  
  
99795 mautic 181.167.67.6:50380 mautic Sleep 23  
  
  
  
  
  
it would be possible to kill the conecctions ? Maybe changin the wait\_timeout?  
  
maybe with this we can increase the performance a little…

---

<div class="post-metadata">

**Author:** ![awurman](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/awurman/32/458_2.png) [@awurman](https://forum.mautic.org/u/awurman)\
**Post date:** [March 14, 2017, 12:22am UTC](https://forum.mautic.org/t/mysql-persistent-conections/7922/2 "2017-03-14T00:22:48Z")

</div>

Today i was looking for performance problems and a show processlist give me this result:

99659 mautic 181.167.67.6:61597 mautic Sleep 7751  
99660 mautic 181.167.67.6:61598 mautic Sleep 7729  
99663 mautic 181.167.67.6:61613 mautic Sleep 7107  
99664 mautic 181.167.67.6:61614 mautic Sleep 7085  
99669 mautic 181.167.67.6:61725 mautic Sleep 6463  
99670 mautic 181.167.67.6:61726 mautic Sleep 6441  
99673 mautic 181.167.67.6:61746 mautic Sleep 5819  
99674 mautic 181.167.67.6:61749 mautic Sleep 5797  
99684 mautic 181.167.67.6:61911 mautic Sleep 5175  
99685 mautic 181.167.67.6:61912 mautic Sleep 5153  
99695 mautic 181.167.67.6:62112 mautic Sleep 4531  
99696 mautic 181.167.67.6:62115 mautic Sleep 4509  
99728 mautic 181.167.67.6:62407 mautic Sleep 3887  
99730 mautic 181.167.67.6:62408 mautic Sleep 3865  
99750 mautic 181.167.67.6:63533 mautic Sleep 3243  
99751 mautic 181.167.67.6:63535 mautic Sleep 3221  
99766 mautic 181.167.67.6:64124 mautic Sleep 2599  
99767 mautic 181.167.67.6:64131 mautic Sleep 2577  
99772 mautic 181.167.67.6:64862 mautic Sleep 1955  
99773 mautic 181.167.67.6:64863 mautic Sleep 1933  
99776 mautic 181.167.67.6:65013 mautic Sleep 1311  
99777 mautic 181.167.67.6:65014 mautic Sleep 1289  
99780 mautic 181.167.67.6:49239 mautic Sleep 667  
99781 mautic 181.167.67.6:49249 mautic Sleep 645  
99787 mautic 181.167.67.6:50045 mautic Query 0  
99795 mautic 181.167.67.6:50380 mautic Sleep 23

it would be possible to kill the conecctions ? Maybe changin the wait\_timeout?  
maybe with this we can increase the performance a little…
