Re: [Phplib-users] MySQL Overload

[Richard A. <rh...@ju...>]

At 9:45 PM +0200 28/3/02, <pis...@al...> wrote:

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

More RAM never hurts. Upgrade that machine to the max it can handle
(probably only 768 MB).


>The MySQL crashes very often, and i need to /etc/rc.d/init.d/mysqld
>stop-start about 5 times a day.

Sounds like you have a corrupt table there.

Are you running the latest MySQL?

Did you compile it yourself or install from a package?
 (hint: you almost always have to compile your MySQL, Apache, PHP
 and kernel yourself to get the options and optimizations you want)

After you stop MySQL, do you run a verification/repair on all the
databases?

See the manual, section 4.4.6. This should do the trick (assuming
all your tables are MyISAM format):

myisamchk --silent --force --fast --update-state -O key_buffer=64M
-O sort_buffer=64M -O read_buffer=1M -O write_buffer=1M
/path/to/datadir/*/*.MYI

 ...R.