Joined: May 25, 2003 Posts: 4752 Location: Santa Barbara, CA
Posted: Mon Sep 22, 2003 10:47 pm Post subject: New database server for trinity...please look for SQL errors
OK, the database size tripled in the last month and, since she was having so much issues with life, I split trinity up across two machines. There's one doing the database side of things and one doing the PHP processing. Please let me know if you notice any SQL timeouts or other issues with the setup.
The hope is that this configuration will be a bit more tolerant of multiple simultaneous users, not give as many SQL timeouts, and hopefully will be able to handle heavier loads. Or at least be able to have more then 8 hours of uptime which was about the average recently.
Let me know of any errors that you see so I can tune the setup
This was one of the problems I noticed with Nuke. For some reason the data base is huge. Though I never ran the Nuke/PHPBB combo like this, the Nuke vs PHPBB was PHPBB hands down in performance (even though it is a bit of a monster at times).
(that and i am not fond of Nuke, but that is a personal preference...)
Joined: May 25, 2003 Posts: 4752 Location: Santa Barbara, CA
Posted: Sun Sep 28, 2003 4:58 pm Post subject:
Well, it seems for the meantime that the new database backend has been happy, which is good news More on the database size...
Since running Nuke I've found some potential culprits...one, the nuke database holds one table that gets a new entry per database access. As time goes on, this table will get huge! Nuke uses it to generate its referrers lists, statistics, etc. I don't think it's necessary and may be able to be disabled.
I've also noticed that the MySQL (not nuke) access logs also tend to grow pretty hardcore large, even a bit faster then apache access.log.
Aside from the sendmail dependencies that throw OpenBSD for a loop, I'm not sure if these two would help other nuke users.
For the record, I'm also not a nuke fan...I just happened to use it since it was what was running a number of other portals I used at the time and happened to have an integration with a halfway-decent forum system. I'm not fully sure I agree with some of its technical underpinnings, but it did definitely help me to have an OSS project that I could start off from instead of having to try to write something from scratch...and one that's more useful to average users then collabnet
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum