MySQL persistent conections

General Discussion
1

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…

2

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…