Try the domain www.koptalk.org and the entrance link, think they need changing back Allen? It will be stable now as there is no traffic here - it's 11.49pm <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br />The minute I say the the site is open I expect the same will happen again. The hosts rebooted the machine several times and it was fine for about ten minutes then crashed each time. Because of the time difference it's probably hard to work out the peak times etc to compare with what you are used to.<br /><br />The site was fine this time last night etc, it was just in the morning when the traffic picked up that it went pear shaped and crashed leaving me sat all day scratching my head <img src="/forum/images/graemlins/frown.gif" alt="" /><br /><br />I wonder what's causing this?

We'll turn IIP options on gradually... for now make sure 'welcome newest member' and 'featured member' are turned off, I remember someone saying how those were hard on the server... we'll turn the debugging info on at the bottom and watch. <img src="/forum/images/graemlins/smile.gif" alt="" />

The problems are very similar to those a site on my server had. That had nothing to do with threads though, it was a loop that was badly written, causing it to go on infinately. And this code was run on almost every page on the site, which is very active. I spent ages trying to find the problem, asking the site owner several times if they had changed anything and they promised me that they had done nothing. Had to get outside help eventually and he managed to find the problem script.

Thanks Gardener <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br />This is the only script on the site right now... possibly it was a fluke table-lockup, we'll know tomorrow when there's 3-400 people online <img src="/forum/images/graemlins/smile.gif" alt="" />

Seems to be doing well with 145 people online right now.. will check back after some :zzz:

It's just gone down again <img src="/forum/images/graemlins/frown.gif" alt="" /><br /><br />It was working fine with around 350 on at one point and most of the IIP disabled as you know Allen.<br /><br />It was going fine until around 12.20pm UK time and then I just got the screen below. I have emailed support at the hosts again:<br /><br />Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (61) in /usr/local/psa/home/vhosts/koptalk.org/httpdocs/forum/mysql.inc.php on line 35<br /><br />Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (61) in /usr/local/psa/home/vhosts/koptalk.org/httpdocs/forum/mysql.inc.php on line 35<br />SQL ERROR: Database error only visible to forum administrators<br /><br />Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /usr/local/psa/home/vhosts/koptalk.org/httpdocs/forum/mysql.inc.php on line 45<br /><br />Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /usr/local/psa/home/vhosts/koptalk.org/httpdocs/forum/mysql.inc.php on line 105<br />SQL ERROR: Database error only visible to forum administrators<br /><br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/koptalk.org/httpdocs/forum/mysql.inc.php on line 131<br /><br />Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /usr/local/psa/home/vhosts/koptalk.org/httpdocs/forum/mysql.inc.php on line 105<br />SQL ERROR: Database error only visible to forum administrators<br /><br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/koptalk.org/httpdocs/forum/mysql.inc.php on line 131<br /><br />Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /usr/local/psa/home/vhosts/koptalk.org/httpdocs/forum/mysql.inc.php on line 105<br />SQL ERROR: Database error only visible to forum administrators<br /><br />Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/koptalk.org/httpdocs/forum/mysql.inc.php on line 131<br />

It's working now with about 250 online.

Duncan - as this is a new server, you might like to ask your hosting company, why you are on a standard copy of PSA and not an RPM version. Plesk are dropping the standard version, and moving over entirely to RPM's. Also as your paths are different, it will give you headaches with regards to upgrades & patches.<br /><br />Plesk 6 will be out soon, so you might have problems upgrading - worth enquiring now, about having the RPM version of 5.0.5.

Just checked in on the site. Chugging along fine with about 500 people online right now.

Hi guys<br /><br />This is the latest email from Digital Princeton who have been great so far:<br /><br />Dunk, <br /> <br />We run a custom kernal FreeBSD that is made to handle a very high server load. From what I see in the logs there are 2 problems. The first is that there is some PHP recusivly calling it self and spawning new processes which don't get closed. This is what is taking up all the RAM and killing the box. The second is that there is no my.cnf for MySQL, this is something that you have to have Allen or whoever make. Its not really needed unless you like to tweak MySQL. I have other customers on 500Mhz Box's with 512 MB RAM running threads and they have 600+ users online at any given time. <br /><br />As Mike said to you there is deffinatly some script killing the box, hes the PHP master and I would have Allen or INFO pop look at that. <br /><br />We can add another 512MB RAM to your box, Mike also suggested that HD access times might becausing alittle bit of an issue als, but not much. <br /><br />We have some SCSI servers coming in Monday and could move you to one of them if you like. They are alittle more pricy though. I would be able to cut you a deal on one of them though if you wanted to try that. <br /><br />I want to have your site up and flying, but I feel right now its software more than hardware and I could put you on a DUAL XEON and it would still die. <br /><br />I just had the box rebooted again, the load goes to 5.0 after less than a minute on. When I show a process list, there are 1,000 + httpd process running using .05 % CPU there is way to many processes running because they are not closing, they are taking up the CPU and never giving it back to the system so it runs out and then dies. <br /><br />When you had the first page off yesterday the server ran just fine. Could you just run thr threads and not all the other stuff for a day and see how that goes. Have the index page go right to the forum. <br /><br />Steve Klenert<br />

Could a news site that checks my site every 5 minutes for updates cause any of this?<br /><br />When I update a news item I edit a page which can be found here:<br /><br />http://www.koptalk.com/regulars/newsnow.shtml<br /><br />Those items then appear at:<br /><br />http://www.newsnow.co.uk/newsfeed/?name=Liverpool<br /><br />It was just a thought.<br /><br />Threads is great when it's working fine. I just wish I could solve this. I wonder what this spawning thing is? The majority of IIP features are turned off.<br /><br />I don't mind upgrading the box if it will resolve the problem but as Steve says it wouldn't.<br /><br />Could it be the beta?<br /><br />I'd like to feed my kids next month, please help me out guys as this could destroy my business...Grrrr...I'll buy you a beer and treat you if I win the lottery <img src="/forum/images/graemlins/wink.gif" alt="" /><br /><br />I wish there was something I could do to fix it but I'm so lame it's untrue <img src="/forum/images/graemlins/smile.gif" alt="" />

The 6.3 beta and the stable 6.2.3 version aren't too much different. At least not enough to cause these types of problems. To try and isolate this I'd do as he suggests. First, totally disable the IIP, just have the index be the forums. Then just to be safe you might want to disable this news checker you're refering to.<br /><br />1000+ httpd connections is definitely not normal as far as I'm aware and like I said earlier. There is nothing in threads that does recursive calls that would spawn additional httpd children.

Perhaps you should move to using UBB.threads 6.2.3 without IIP and see how things go. On the other machines your host mentions handling 600+ users with .threads what version are they running for software?<br /><br />Just a thought... <img src="/forum/images/graemlins/smile.gif" alt="" />

I'll see what Allen says when he's online later today...the time difference is a killer for me <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br />The news checker thing just checks that one page to see if I have provided any new updates (I manually add each item whenever a new news item has been created/published). <br /><br />As I'm not tech minded I have no idea what 1000+ httpd connections are <img src="/forum/images/graemlins/frown.gif" alt="" /><br /><br />Such is life eh <img src="/forum/images/graemlins/smile.gif" alt="" />

How does this news checker work? You said it checks every 5 minutes? Does it use Conditional Gets? Perhaps the script doing the fetching isn't closing the connection after each fetch?<br /><br />Just more guessing... <img src="/forum/images/graemlins/smile.gif" alt="" />

To be honest I'm not sure. They just asked me to provide a hidden page which is the newsnow.shtml link and they spider it every 5 minutes or so. I've always used this system on my normal site and I may be way off here. I'm maybe clutching at straws.

[]Duncan said:<br />Hosts:<br />PLESK PSA 5.0.5<br />Apache: 1.3.27<br />MySQL: 3.23.55<br /><br />Some people are going to probably tell you that those are not the latest builds, but these are the latest builds that PLESK uses and they are all stable and secure."<br /> [/]<br /><br />There's a whole page of bugfixes and security fixes for 3.23.56 released more than 2 months ago:<br />http://www.mysql.com/doc/en/News-3.23.56.html - including some issues with database corruption. Just because it's what's in the released version of plesk doesn't mean it's the best option for you... you are the one paying the bill.

11.39am in the UK and it's just gone again...this is doing my shed in <img src="/forum/images/graemlins/frown.gif" alt="" />

Re-booted (again) 500+ members online browsing.<br /><br />last chat by IM with hosts:<br /><br />spiders could be doing that and they create httpd requests and its not like a browser that someone closes <br /> and 5 min could be to short of an interval and the process never closes on its own. <br /> its taking much longer for the box to die now so its a slow thing <br /> as far as the mysql goes, Plesk knows about the patches and they have released hot fixes for PSA <br /> which we have applied. <br /> no need to worry about that.

Have you thought of changing your apache configuration to limit the number of httpd processes and to change the timeout for http processes to a lower value?<br /><br />Maybe logging the slow mysql queries would help to determine the bottleneck also.