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...


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.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to