Re: [Phplib-users] MySQL Overload

[Roberto M. <rm...@cc...>]

On Thu, Mar 28, 2002 at 11:59:33AM -0800, Paul Wolstenholme wrote:

<snip>

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

Even if your server was not "strong enough", MySQL should not be crashing.
It should be getting slow, or giving you warnings, but not crashing.

You should really think about migrating to a real RDBMS. One that
withstands ACID requirements. 

-Roberto

-- 
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ 
       http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer    
A poor excuse is better than no excuse!