Our forums at http://forums.overclockers.co.uk are in need of some help I think.
They're down today for some harsh pruning (30 days), but I'm more interested in mySQL configration - there's so much in it that I don't even begin to understand (and my host is useless) but I'm sure we could reap great benefits from optimising it a little.
We have about 800,000 posts (atm), 1GB ram, Dual P3-600, SCSI 10k - dedicted server (freeBSD) which runs both apache/php and mysql. I loaded the medium cnf to get going and it seems okay but I awnt to make sure we're getting everything we can (every time I say anything to hour host I get told the prices for RAM and CPU upgrades - very helpful).
I'm also wondering how to turn off mySQL's logging - we just don't need a log, I wouldn't know how to rollback even if we did have a problem and we have a daily backup of the DB anyway - I'm thinking saving on that disc access would be a bit of a boost?
Also - with all the talk of slow deleting threads I've noted a lot of stuff about attachments - they're disabled on our forums, totally - I'm assuming they're still being checked for even though we don't use them? Any suggestions where I could 'tweak' to save on that wasted process?
At busy periods TOP shows mysqld using about 70% of the CPU, with apache eating the rest - aout 100-200MB free (varies).
They're down today for some harsh pruning (30 days), but I'm more interested in mySQL configration - there's so much in it that I don't even begin to understand (and my host is useless) but I'm sure we could reap great benefits from optimising it a little.
We have about 800,000 posts (atm), 1GB ram, Dual P3-600, SCSI 10k - dedicted server (freeBSD) which runs both apache/php and mysql. I loaded the medium cnf to get going and it seems okay but I awnt to make sure we're getting everything we can (every time I say anything to hour host I get told the prices for RAM and CPU upgrades - very helpful).
I'm also wondering how to turn off mySQL's logging - we just don't need a log, I wouldn't know how to rollback even if we did have a problem and we have a daily backup of the DB anyway - I'm thinking saving on that disc access would be a bit of a boost?
Also - with all the talk of slow deleting threads I've noted a lot of stuff about attachments - they're disabled on our forums, totally - I'm assuming they're still being checked for even though we don't use them? Any suggestions where I could 'tweak' to save on that wasted process?
At busy periods TOP shows mysqld using about 70% of the CPU, with apache eating the rest - aout 100-200MB free (varies).
Comment