RE: [Phplib-users] MySQL Overload

[Brian P. <bp...@ct...>]

I would definitely start thinking about upgrading the server. Before you do
that, use a system profiling app to watch resource utilization and see if
CPU cycles/memory resources are getting tapped. I would bet they are. 

I just put a new CPU (1.4 Ghz Athlon)/Motherboard/and 512 MB of SDRAM in my
old PC for around $400. If nothing else, another 256/512 MB of RAM would
probably make a huge difference. 

-bpopp @ www.bpopp.net

-----Original Message-----
From: pis...@al... [mailto:pis...@al...]
Sent: Thursday, March 28, 2002 1:46 PM
To: php...@li...
Subject: [Phplib-users] MySQL Overload


Hello,

I've got a BIG problem, that the development team and I could not resolve.

I'm using a RedHat Linux, Apache+PHP4+MySql on a P2/500 with 256 MB RAM.

The website I talk about is a portal with many different services (search
engine, webmail, news, on-line games, web-directories, ads etc, etc, etc.).
Everything is hosted on a single server. The user system is entirely based
on PhpLib. 

The database files used by MySQL are large, with about 60 tables (approx.
500 MB)

The things were fine, until the last weeks, when the pageviews number was
growing fast (today i had about 100000 pageviews, but it's not very
relevant). The MySQL crashes very often, and i need to
/etc/rc.d/init.d/mysqld stop-start about 5 times a day.

Can anybody tell me, if this server is not strong enough, or it should face
the situation ?

Thank you for your time

Regards


________________________________________________________________________
Singurul serviciu 100% confidential din Romania : http://mail.alabala.ro

_______________________________________________
Phplib-users mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phplib-users