Re: ghost server?

Hello hex, Monday, September 10, 2001, 8:40:16 PM, you wrote: hPF> hi. hPF> i menage quite popular internet wortal (http://hip-hop.pl) and I use mysql and hPF> php 4.0 as the main generator of all webpages. hPF> since few months every day i have some problems with the server (AMD Duron hPF> 700MHz, 256 Mb RAM, ABIT KT7-RAID, Intel Ether Express 100+). operating system hPF> is FreeBSD 4.3 hPF> the internet provider is checked, fast and good. i know this because on this hPF> internet connection is linked another server (rather low traffic) and it works hPF> non-stop. hPF> this problem grow every day. the problem is that this server disapears for few hPF> minutes, and then it apears again. it happens only in hours of main usage (i hPF> know it from hourly satistics). when it apears it works rather fast. the problem hPF> is growing every month because our statistics go up. when the server stops none hPF> of the installed services works. and what is amazing there is no errors nor hPF> warnings in the logs. It could be a lot of things; just some random things to check mysqladmin extended-status might give you an idea of things going on, doublecheck the uptime value, is it the same as the uptime of the machine? sometimes mysql crashes and restarts itself. It could take minutes before the databaseserver is back. This could be your problem. You can also check processes within myqsl with mysqladmin processlist Further the unix: is it tuned? FreeBSD out of the box is good but it can be tuned quite a bit, I've run sites on similar hardware with 1000+ users hitting the server more or less at the same time with a mysql based web-application. The box was tuned quite a bit but could handle the load without any problems. Doublecheck your application and database design, sometimes adding an index can increase performance 100x. If you need more info let me know... Brgds hPF> i was wondering if its is because of mysql or other service installed on the hPF> server. has anyone the same problem in the past? what is the reason? please hPF> help. -- Paul Jongsma WEBtic Internet Consultancy @ http://www.webtic.nl/ Change is inevitable, except from vending machines.