Advertisement:

Author Topic: What about this MySql config?  (Read 6452 times)

Offline Webrunner

  • Full Member
  • ***
  • Posts: 525
  • Gender: Male
    • Vrouwenpower
What about this MySql config?
« 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
« Last Edit: September 19, 2005, 11:22:38 PM by Amacythe »
There is a difference between knowing the path and walking the path.

=========================================
Vrouwen Power! | Sprintweb: No nonsense e-Business consultancy

Offline forsakenlad

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 7,134
  • Gender: Male
  • aka forsakenlad
    • erenyasarkurt on Facebook
    • erenyasarkurt on LinkedIn
    • @erenyasarkurt on Twitter
Re: What about this MySql config?
« Reply #1 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 ;)
Eren "forsakenlad" Ya┼čarkurt
SMF Friend & Former Team Member

Offline Webrunner

  • Full Member
  • ***
  • Posts: 525
  • Gender: Male
    • Vrouwenpower
Re: What about this MySql config?
« Reply #2 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 ???
There is a difference between knowing the path and walking the path.

=========================================
Vrouwen Power! | Sprintweb: No nonsense e-Business consultancy

Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: What about this MySql config?
« Reply #3 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?

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]

Offline Webrunner

  • Full Member
  • ***
  • Posts: 525
  • Gender: Male
    • Vrouwenpower
Re: What about this MySql config?
« Reply #4 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.
« Last Edit: September 19, 2005, 04:16:59 PM by Webrunner »
There is a difference between knowing the path and walking the path.

=========================================
Vrouwen Power! | Sprintweb: No nonsense e-Business consultancy

Offline Webrunner

  • Full Member
  • ***
  • Posts: 525
  • Gender: Male
    • Vrouwenpower
Re: What about this MySql config?
« Reply #5 on: September 19, 2005, 04:15:33 PM »
Ok, i installed eaccelerator and it immediatly speeded things up.  :D
Thanx  for your help Unknown :)
There is a difference between knowing the path and walking the path.

=========================================
Vrouwen Power! | Sprintweb: No nonsense e-Business consultancy