Koozali.org: home of the SME Server

mysql and apache performance

Offline jameswilson

  • *
  • 795
  • +0/-0
    • Security Warehouse, professional security equipment
mysql and apache performance
« on: November 04, 2007, 04:57:25 PM »
Hi
I run a zen cart very successfully on a sme server, It is in an ibay and works greatish.
The other night whilst repairing the usb dar backup drive psu cable i checked the machine was ok by checking the ram was in etc (dont ask why i wish i hadnt) at that moment the machine rebooted and wouldnt come back. I swapped the ram, pulled one of the raid 1 drives in the hope it would come back. Thank god it did and i love sme so so much lol (backup drive hadnt been working for 2 weeks so id have been right in it.....)

anyway after upgrading the ram to 2Gig, (it was 1 gig before) i hoped all would be ok. In a way it is but it seems i know have (or have had for a while maybe) speed issues with parse and query time.
Basically pages are taking .6-.8 s to parse and the queries id say are about .2s.
It appears that apache is taking a while to parse the pages and im wondering if i can speed this up in anyway. I am using the eAccelerator contrib that helps a lot but wondered if there is more i can do (or if this is early warning of a problem?)
Hardware wise its on raid 1 wd 160Gb PATA drives, 2gig of 333 ram (2 x 1gig) and an athlon 2800+ (the old socket a type)

Previously i was getting parse times of .2-.3 second.

Any advise gratefully recieved

James

Offline mmccarn

  • *
  • 2,656
  • +10/-0
Re: mysql and apache performance
« Reply #1 on: November 05, 2007, 05:12:45 AM »
Does your speed go back to to what it was if you put back the old RAM? 

Offline jameswilson

  • *
  • 795
  • +0/-0
    • Security Warehouse, professional security equipment
Re: mysql and apache performance
« Reply #2 on: November 05, 2007, 09:42:23 AM »
Does your speed go back to to what it was if you put back the old RAM? 
no. I think i was wrong tbh i think that i was looking at different catagories (which have more or less items) as some of them are in the .3-.4s bracket.
So the question now should be can i make it any faster but id say its just as fast as it was.
I have spare hardware (4800 x2 and board) and i even have a baby quad core intel i could use, but im guessing i wont get huge gains over the current socket a athlon? maybe im wrong here?

Should have known it wouldnt be sme shouldnt i really with how well it 'just works'