Simple Machines Community Forum

SMF Support => Server Performance and Configuration => Topic started by: Webrunner on September 16, 2005, 07:49:51 PM

Title: What about this MySql config?
Post by: Webrunner on September 16, 2005, 07:49:51 PM
My forum is slowing down rapidly with 30+ users online.
I have 700 members and about 350.000 posts in the forum.

The server is a dual PIII 800 Mhz with 1 GB of memory.

What about this MySql config?
http://beta.vrouwenpower.nl/status.php?mysql_info=1
Title: Re: What about this MySql config?
Post by: forsakenlad on September 16, 2005, 09:51:39 PM
Your server seems to be set up correctly, also the load is really low. Do you regularly optimize your tables? Also I would advise you to install some accelerator software, eaccelerator would be a good choice ;)
Title: Re: What about this MySql config?
Post by: Webrunner on September 17, 2005, 03:40:22 AM
The load is low because it was in the middle of the night here ;)
I tried to install eAccelerator using URPMI (i'm on Mandrake) but it gives an error (due to unsatisfied php-cli)
I have installed php-cli but maybe not the right version :(
I'm no Linux wiz so i don't wanna take an risk in breaking the config :o

Autop optimisation is set in SMF to be done every 7 days.
That should be enough in my opinion or not ???
Title: Re: What about this MySql config?
Post by: [Unknown] on September 19, 2005, 02:39:53 AM
The load is low because it was in the middle of the night here ;)
I tried to install eAccelerator using URPMI (i'm on Mandrake) but it gives an error (due to unsatisfied php-cli)
I have installed php-cli but maybe not the right version :(
I'm no Linux wiz so i don't wanna take an risk in breaking the config :o

For most things, package managers are amazing.  But when it comes to PHP and Apache, they all seem to fall short.  Does this topic help at all?

What is eAccelerator? (http://www.simplemachines.org/community/index.php?topic=49995.0)

Quote
Autop optimisation is set in SMF to be done every 7 days.
That should be enough in my opinion or not ???

That should be fine.  As for your server configuration.... ram and load looks fine, but I'm not sure what the peak times are for you.  Try posting it using the [time](time)[/time] tag.  For example, if I put "2005-09-18 11:37:00 pm" (my current time), it shows September 19, 2005, 02:37:00 AM.  This will show in your timezone, or in my timezone, or in whoever looks at it's timezone.

Then, I (or someone) can take a look to see what might be wrong at that time of day.

-[Unknown]
Title: Re: What about this MySql config?
Post by: Webrunner on September 19, 2005, 02:42:52 PM
Now is a peek time: September 19, 2005, 02:37:00 PM
I will take a look at that topic, Thanks.
Title: Re: What about this MySql config?
Post by: Webrunner on September 19, 2005, 04:15:33 PM
Ok, i installed eaccelerator and it immediatly speeded things up.  :D
Thanx  for your help Unknown :)