about 150 mysql connection

Discussion in 'Installation/Configuration' started by topedge, Jan 23, 2014.

  1. topedge

    topedge New Member

    I show that ISPConfig has over 150 connections on one of my servers.
    The other only has about 4+/- so what do you thing is wrong with the other?
    I also have webmin installed and it said:
    4 ispconfig localhost dbispconfig Sleep 00:00:14
    867 ispconfig localhost:48202 dbispconfig Sleep 00:10:41
    873 ispconfig localhost:48213 dbispconfig Sleep 00:09:46
    882 ispconfig localhost:48226 dbispconfig Sleep 00:09:44
    902 ispconfig localhost:48258 dbispconfig Sleep 00:10:43
    934 ispconfig localhost:48308 dbispconfig Sleep 00:10:22
    1375 ispconfig localhost:55563 dbispconfig Sleep 00:00:58
    1381 ispconfig localhost:55572 dbispconfig Sleep 00:00:30
    1382 ispconfig localhost:55573 dbispconfig Sleep 00:00:30
    1383 ispconfig localhost:55579 dbispconfig Sleep 00:01:29
    1385 ispconfig localhost:55584 dbispconfig Sleep 00:01:29
    1386 ispconfig localhost:55585 dbispconfig Sleep 00:00:31
    1387 ispconfig localhost:55586 dbispconfig Sleep 00:00:31
    1388 ispconfig localhost:55587 dbispconfig Sleep 00:00:15
    1389 ispconfig localhost:55590 dbispconfig Sleep 00:00:58
    1394 ispconfig localhost:55606 dbispconfig Sleep 00:00:58
    1404 ispconfig localhost:55628 dbispconfig Sleep 00:00:39
    1405 ispconfig localhost:55629 dbispconfig Sleep 00:00:30
    1410 ispconfig localhost:55634 dbispconfig Sleep 00:00:01
    1412 ispconfig localhost:55641 dbispconfig Sleep 00:00:30
    1414 ispconfig localhost:55643 dbispconfig Sleep 00:00:29
    1415 ispconfig localhost:55644 dbispconfig Sleep 00:00:28
    1416 ispconfig localhost:55645 dbispconfig Sleep 00:00:28
    1417 ispconfig localhost:55657 dbispconfig Sleep 00:01:09
    1428 ispconfig localhost:55687 dbispconfig Sleep 00:00:45
    1430 ispconfig localhost:55689 dbispconfig Sleep 00:00:30
    1433 ispconfig localhost:55692 dbispconfig Sleep 00:00:31
    1439 ispconfig localhost:55700 dbispconfig Sleep 00:00:31
    1441 ispconfig localhost:55704 dbispconfig Sleep 00:00:30
    1442 ispconfig localhost:55705 dbispconfig Sleep 00:01:28
    1443 ispconfig localhost:55706 dbispconfig Sleep 00:00:30
    1444 ispconfig localhost:55710 dbispconfig Sleep 00:00:20
    1446 ispconfig localhost:55712 dbispconfig Sleep 00:00:35
    1451 ispconfig localhost:55720 dbispconfig Sleep 00:01:30
    1458 ispconfig localhost:55773 dbispconfig Sleep 00:00:31
    1460 ispconfig localhost:55784 dbispconfig Sleep 00:01:29
    1461 ispconfig localhost:55785 dbispconfig Sleep 00:01:30
    1462 ispconfig localhost:55800 dbispconfig Sleep 00:00:25
    1463 ispconfig localhost:55804 dbispconfig Sleep 00:00:06
    1465 ispconfig localhost:55877 dbispconfig Sleep 00:00:59
    1469 ispconfig localhost:55910 dbispconfig Sleep 00:00:31
    1472 ispconfig localhost:55946 dbispconfig Sleep 00:01:29
    1473 ispconfig localhost:55973 dbispconfig Sleep 00:00:31
    1474 ispconfig localhost:56002 dbispconfig Sleep 00:00:28
    1476 ispconfig localhost:56036 dbispconfig Sleep 00:00:09
    1503 ispconfig localhost:56596 dbispconfig Sleep 00:01:29
    1508 ispconfig localhost:56651 dbispconfig Sleep 00:02:30
    1509 ispconfig localhost:56655 dbispconfig Sleep 00:00:25
    1538 ispconfig localhost:56762 dbispconfig Sleep 00:00:30
    1542 ispconfig localhost:57162 dbispconfig Sleep 00:00:59
    1544 ispconfig localhost:57175 dbispconfig Sleep 00:00:30
    1545 ispconfig localhost:57188 dbispconfig Sleep 00:00:31
    1546 ispconfig localhost:57207 dbispconfig Sleep 00:01:29
    1548 ispconfig localhost:57221 dbispconfig Sleep 00:00:30
    1551 c1mailer localhost c1mailer Sleep 00:00:00
    1556 ispconfig localhost:57250 dbispconfig Sleep 00:00:00
    1557 ispconfig localhost:57255 dbispconfig Sleep 00:00:00
    1577 ispconfig localhost:57888 dbispconfig Sleep 00:00:30
    1578 ispconfig localhost:57889 dbispconfig Sleep 00:00:31
    1579 ispconfig localhost:57901 dbispconfig Sleep 00:01:05
    1581 ispconfig localhost:57939 dbispconfig Sleep 00:00:31
    1584 ispconfig localhost:57954 dbispconfig Sleep 00:01:09
    1586 ispconfig localhost:57994 dbispconfig Sleep 00:00:30
    1587 ispconfig localhost:57995 dbispconfig Sleep 00:00:30
    1588 ispconfig localhost:58000 dbispconfig Sleep 00:00:30
    1589 ispconfig localhost:58012 dbispconfig Sleep 00:00:24
    1592 ispconfig localhost:58051 dbispconfig Sleep 00:00:01
    1593 ispconfig localhost:58053 dbispconfig Sleep 00:00:05
    1594 ispconfig localhost:58054 dbispconfig Sleep 00:00:30
    1595 ispconfig localhost:58055 dbispconfig Sleep 00:00:16
    1596 ispconfig localhost:58063 dbispconfig Sleep 00:00:18
    1597 ispconfig localhost:58064 dbispconfig Sleep 00:00:26
    1598 ispconfig localhost:58065 dbispconfig Sleep 00:00:30
    1599 ispconfig localhost:58066 dbispconfig Sleep 00:00:11
    1600 ispconfig localhost:58067 dbispconfig Sleep 00:00:12
    1601 ispconfig localhost:58068 dbispconfig Sleep 00:00:12
    1602 ispconfig localhost:58069 dbispconfig Sleep 00:00:14
    1603 ispconfig localhost:58070 dbispconfig Sleep 00:00:16
    1604 ispconfig localhost:58074 dbispconfig Sleep 00:00:30
    1605 ispconfig localhost:58075 dbispconfig Sleep 00:00:17
    1606 ispconfig localhost:58076 dbispconfig Sleep 00:00:13
    1607 ispconfig localhost:58077 dbispconfig Sleep 00:00:13
    1610 ispconfig localhost:58089 dbispconfig Sleep 00:00:30
    1611 ispconfig localhost:58117 dbispconfig Sleep 00:01:13
    1612 ispconfig localhost:58389 dbispconfig Sleep 00:00:00
    1613 ispconfig localhost:58391 dbispconfig Sleep 00:00:00
    1621 ispconfig localhost:58763 dbispconfig Sleep 00:00:02
    1622 ispconfig localhost:58768 dbispconfig Sleep 00:00:02
    1623 ispconfig localhost:58810 dbispconfig Sleep 00:00:34
    1624 ispconfig localhost:58909 dbispconfig Sleep 00:00:30
    1626 ispconfig localhost:59054 dbispconfig Sleep 00:00:22
    1627 ispconfig localhost:59073 dbispconfig Sleep 00:00:21
    1628 ispconfig localhost:59080 dbispconfig Sleep 00:00:21
    1629 ispconfig localhost:59172 dbispconfig Sleep 00:00:01
    1630 ispconfig localhost:59174 dbispconfig Sleep 00:00:01
    1631 ispconfig localhost:59190 dbispconfig Sleep 00:00:01
    1632 ispconfig localhost:59192 dbispconfig Sleep 00:00:01
    1633 ispconfig localhost:59272 dbispconfig Sleep 00:00:10
    1634 ispconfig localhost:59312 dbispconfig Sleep 00:00:09
    1635 ispconfig localhost:59317 dbispconfig Sleep 00:00:08
    1636 ispconfig localhost:59338 dbispconfig Sleep 00:00:06


    You can see some of them are 10 minutes running while others are just seconds old.

    Any ideas?
     
  2. topedge

    topedge New Member

    Sorry ISPConfig 3.0.5.3
    Centos 6.4
     
  3. topedge

    topedge New Member

    I also did a restart of apache and that cleared them up for a minute then they immediately came back
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    The connections are not from the software ispconfig, they are from the user ispconfig. the user ispconfig is used by all software on your server that has to connect to mysql lile postfix, amavis, docvet, pure-ftpd etc. so a higher number of sleeping connections can be ok. it depends on the usage of the server like incoming emails etc.
     

Share This Page