Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 4th March 2009, 16:31
StrikerNL StrikerNL is offline
Member
 
Join Date: Feb 2009
Posts: 45
Thanks: 9
Thanked 10 Times in 8 Posts
Default Loads of mysql connections to dbispconfig

ISPconfig 3.0.0.0.9 rc2 has been working fine for about two weeks (upgraded from 3.0.0.8), however since today I am getting mysql errors on all sites and the admin panel, reporting something like 'mysql error: too many connections'. I checked out the process list in phpmyadmin and I'm seeing something like this, which I assume can't be right. How can I fix this?

FYI this is on Ubuntu Server 8.10.

Code:
Kill   	3  	ispconfig  	localhost  	dbispconfig  	Sleep  	16  	   	NULL
Kill 	21 	ispconfig 	localhost 	dbispconfig 	Sleep 	43 	  	NULL
Kill 	311 	ispconfig 	localhost 	dbispconfig 	Sleep 	57 	  	NULL
Kill 	337 	ispconfig 	localhost 	dbispconfig 	Sleep 	31 	  	NULL
Kill 	531 	ispconfig 	localhost 	dbispconfig 	Sleep 	50 	  	NULL
Kill 	743 	ispconfig 	localhost 	dbispconfig 	Sleep 	28 	  	NULL
Kill 	1577 	ispconfig 	localhost:44774 	dbispconfig 	Sleep 	1 	  	NULL
Kill 	1578 	ispconfig 	localhost:44775 	dbispconfig 	Sleep 	1 	  	NULL
Kill 	1579 	ispconfig 	localhost:44776 	dbispconfig 	Sleep 	1 	  	NULL
Kill 	1585 	ispconfig 	localhost:44780 	dbispconfig 	Sleep 	20 	  	NULL
Kill 	1588 	ispconfig 	localhost:44783 	dbispconfig 	Sleep 	53 	  	NULL
Kill 	1589 	ispconfig 	localhost:44784 	dbispconfig 	Sleep 	53 	  	NULL
Kill 	1593 	ispconfig 	localhost:44788 	dbispconfig 	Sleep 	19 	  	NULL
Kill 	1598 	ispconfig 	localhost:44792 	dbispconfig 	Sleep 	53 	  	NULL
Kill 	1607 	ispconfig 	localhost:44801 	dbispconfig 	Sleep 	0 	  	NULL
Kill 	1866 	ispconfig 	localhost:44932 	dbispconfig 	Sleep 	22 	  	NULL
Kill 	1867 	ispconfig 	localhost:44933 	dbispconfig 	Sleep 	22 	  	NULL
Kill 	1868 	ispconfig 	localhost:44934 	dbispconfig 	Sleep 	22 	  	NULL
Kill 	1869 	ispconfig 	localhost:44935 	dbispconfig 	Sleep 	22 	  	NULL
Kill 	1889 	ispconfig 	localhost:44958 	dbispconfig 	Sleep 	257 	  	NULL
Kill 	1890 	ispconfig 	localhost:44959 	dbispconfig 	Sleep 	256 	  	NULL
Kill 	1891 	ispconfig 	localhost:44960 	dbispconfig 	Sleep 	256 	  	NULL
Kill 	1892 	ispconfig 	localhost:44961 	dbispconfig 	Sleep 	256 	  	NULL
Kill 	1923 	ispconfig 	localhost:44977 	dbispconfig 	Sleep 	115 	  	NULL
Kill 	1924 	ispconfig 	localhost:44978 	dbispconfig 	Sleep 	115 	  	NULL
Kill 	1925 	ispconfig 	localhost:44979 	dbispconfig 	Sleep 	115 	  	NULL
Kill 	1967 	ispconfig 	localhost:45002 	dbispconfig 	Sleep 	55 	  	NULL
Kill 	1968 	ispconfig 	localhost:45003 	dbispconfig 	Sleep 	55 	  	NULL
Kill 	1969 	ispconfig 	localhost:45004 	dbispconfig 	Sleep 	55 	  	NULL
Kill 	1977 	ispconfig 	localhost:45009 	dbispconfig 	Sleep 	21 	  	NULL
Kill 	1978 	ispconfig 	localhost:45010 	dbispconfig 	Sleep 	117 	  	NULL
Kill 	1979 	ispconfig 	localhost:45011 	dbispconfig 	Sleep 	117 	  	NULL
Kill 	1980 	ispconfig 	localhost:45012 	dbispconfig 	Sleep 	117 	  	NULL
Kill 	1981 	ispconfig 	localhost:45013 	dbispconfig 	Sleep 	117 	  	NULL
Kill 	1999 	ispconfig 	localhost:45027 	dbispconfig 	Sleep 	115 	  	NULL
Kill 	2003 	ispconfig 	localhost:45030 	dbispconfig 	Sleep 	53 	  	NULL
Kill 	2004 	ispconfig 	localhost:45033 	dbispconfig 	Sleep 	39 	  	NULL
Kill 	2012 	ispconfig 	localhost:47919 	dbispconfig 	Sleep 	0 	  	NULL
Kill 	2020 	ispconfig 	localhost:47926 	dbispconfig 	Sleep 	7 	  	NULL
Kill 	2021 	ispconfig 	localhost:47927 	dbispconfig 	Sleep 	7 	  	NULL
Kill 	2022 	ispconfig 	localhost:47928 	dbispconfig 	Sleep 	7 	  	NULL
Kill 	2045 	ispconfig 	localhost:47938 	dbispconfig 	Sleep 	55 	  	NULL
Kill 	2046 	ispconfig 	localhost:47946 	dbispconfig 	Sleep 	54 	  	NULL
Kill 	2048 	ispconfig 	localhost:47967 	dbispconfig 	Sleep 	54 	  	NULL
Kill 	2049 	ispconfig 	localhost:47971 	dbispconfig 	Sleep 	53 	  	NULL
Kill 	2050 	ispconfig 	localhost:47972 	dbispconfig 	Sleep 	53 	  	NULL
Kill 	2051 	ispconfig 	localhost:47973 	dbispconfig 	Sleep 	53 	  	NULL
Kill 	2052 	ispconfig 	localhost:47974 	dbispconfig 	Sleep 	53 	  	NULL
Kill 	2053 	ispconfig 	localhost:47975 	dbispconfig 	Sleep 	53 	  	NULL
Kill 	2054 	ispconfig 	localhost:47976 	dbispconfig 	Sleep 	53 	  	NULL
Kill 	2055 	ispconfig 	localhost:47977 	dbispconfig 	Sleep 	53 	  	NULL
Kill 	2056 	ispconfig 	localhost:47978 	dbispconfig 	Sleep 	53 	  	NULL
Kill 	2057 	ispconfig 	localhost:47979 	dbispconfig 	Sleep 	20 	  	NULL
Kill 	2062 	ispconfig 	localhost:47980 	dbispconfig 	Sleep 	27 	  	NULL
Kill 	2063 	ispconfig 	localhost:47981 	dbispconfig 	Sleep 	27 	  	NULL
Kill 	2064 	ispconfig 	localhost:47982 	dbispconfig 	Sleep 	27 	  	NULL
Kill 	2065 	ispconfig 	localhost:47983 	dbispconfig 	Sleep 	27 	  	NULL
Kill 	2066 	ispconfig 	localhost:47984 	dbispconfig 	Sleep 	19 	  	NULL
Kill 	2067 	ispconfig 	localhost:47985 	dbispconfig 	Sleep 	19 	  	NULL
Kill 	2068 	ispconfig 	localhost:47986 	dbispconfig 	Sleep 	19 	  	NULL
Kill 	2070 	ispconfig 	localhost:47987 	dbispconfig 	Sleep 	43 	  	NULL
Kill 	2071 	ispconfig 	localhost:47988 	dbispconfig 	Sleep 	43 	  	NULL
Kill 	2072 	ispconfig 	localhost:47989 	dbispconfig 	Sleep 	43 	  	NULL
Kill 	2073 	ispconfig 	localhost:47990 	dbispconfig 	Sleep 	43 	  	NULL
Kill 	2074 	ispconfig 	localhost:47991 	dbispconfig 	Sleep 	20 	  	NULL
Kill 	2075 	ispconfig 	localhost:47992 	dbispconfig 	Sleep 	20 	  	NULL
Kill 	2078 	ispconfig 	localhost:47993 	dbispconfig 	Sleep 	7 	  	NULL
Kill 	2083 	ispconfig 	localhost:47995 	dbispconfig 	Sleep 	34 	  	NULL
Kill 	2084 	ispconfig 	localhost:47996 	dbispconfig 	Sleep 	34 	  	NULL
Kill 	2085 	ispconfig 	localhost:47997 	dbispconfig 	Sleep 	34 	  	NULL
Kill 	2086 	ispconfig 	localhost:47998 	dbispconfig 	Sleep 	34 	  	NULL
Kill 	2087 	ispconfig 	localhost:47999 	dbispconfig 	Sleep 	19 	  	NULL
Kill 	2089 	ispconfig 	localhost:48000 	dbispconfig 	Sleep 	34 	  	NULL
Kill 	2090 	ispconfig 	localhost:48001 	dbispconfig 	Sleep 	34 	  	NULL
Kill 	2091 	ispconfig 	localhost:48002 	dbispconfig 	Sleep 	34 	  	NULL
Kill 	2092 	ispconfig 	localhost:48003 	dbispconfig 	Sleep 	34 	  	NULL
Kill 	2096 	ispconfig 	localhost:48004 	dbispconfig 	Sleep 	25 	  	NULL
Kill 	2097 	ispconfig 	localhost:48005 	dbispconfig 	Sleep 	25 	  	NULL
Kill 	2098 	ispconfig 	localhost:48006 	dbispconfig 	Sleep 	24 	  	NULL
Kill 	2099 	ispconfig 	localhost:48007 	dbispconfig 	Sleep 	24 	  	NULL
Kill 	2100 	ispconfig 	localhost:48008 	dbispconfig 	Sleep 	24 	  	NULL
Kill 	2101 	ispconfig 	localhost:48009 	dbispconfig 	Sleep 	22 	  	NULL
Kill 	2104 	ispconfig 	localhost:48011 	dbispconfig 	Sleep 	19 	  	NULL
Kill 	2112 	ispconfig 	localhost:48018 	dbispconfig 	Sleep 	3 	  	NULL
Kill 	2113 	ispconfig 	localhost:48019 	dbispconfig 	Sleep 	3 	  	NULL
Kill 	2114 	ispconfig 	localhost:48020 	dbispconfig 	Sleep 	3 	  	NULL
Kill 	2119 	ispconfig 	localhost:48023 	dbispconfig 	Sleep 	0 	  	NULL
Kill 	2120 	ispconfig 	localhost:48024 	dbispconfig 	Sleep 	0 	  	NULL
Kill 	2121 	ispconfig 	localhost:48025 	dbispconfig 	Sleep 	0 	  	NULL
Kill 	2122 	ispconfig 	localhost:48026 	dbispconfig 	Sleep 	0 	  	NULL

Last edited by StrikerNL; 4th March 2009 at 16:44.
Reply With Quote
Sponsored Links
  #2  
Old 4th March 2009, 21:09
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,046
Thanks: 826
Thanked 5,386 Times in 4,231 Posts
Default

This is ok. the connections are from several services like postfix, pureftpd, courier, amavisd etc. which all connect with the ispconfig user to the mysql database. ISPconfig itself uses just one connetion when you are logged into the interface and another connection when the backend starts the processing. both connections are closed right after the page has been delivered or the data has been processed. If you reach the max connection limit of mysql, this happens most likely when a lot of spam comes in. You can set a higher connection limit in the mysql my.cnf file.

Add or edit the following lines in the [mysqld] section of the file:

max_connections=500
max_user_connections=500
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 5th March 2009, 14:31
StrikerNL StrikerNL is offline
Member
 
Join Date: Feb 2009
Posts: 45
Thanks: 9
Thanked 10 Times in 8 Posts
 
Default

Ah I see, I could have thought of that myself I've set the max connections higher and now everything's fine! Thanks!
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql max connections problem zucco Installation/Configuration 2 27th February 2009 10:50
Problem installing MySQL on suse 10.3 Txchaser Installation/Configuration 20 18th April 2008 01:05
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 02:29.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.