(thing) by jaybonci Thu Jul 03 2003 at 7:07:47
  • July 02, 2003: Quick general announcements.
    • I made some major changes to the apache config files and was able to trim down about 7 megs of general usage per fork. While this isn't a HUGE amount in the long run, it will keep us from hitting swap earlier than normal. If you see features suddenly not working (ekw schemes are a possibility), let me know, and I'll do what I can to revert the changes. Otherwise, hopefully it'll be a tad more responsive.
    • I also added more index keys to the message dbtable, to reflect how it is commonly sorted. This should help make things faster.
    • Added a theoretical hack to NodeCache.pm that'd forbid caching writeups. We carry an extra 60-100 writeups around with us in each apache fork, with the likelihood of a good cache hit being somewhat low. I put this on hold for a bit to see how the other changes work out
    • Added an index to the nodelock table
    • Put index lookup inside the softlinks htmlcode to actually match the way it is indexed inside of mysql
  • July 10th, 2003: More indexes on commonly sorted-by fields, database cleanups
    • Added index to orderby field in nodegroup
    • Added index to experience field in room
    • Added index to parent_e2node field in writeup
    • Dropped the vote_temp table after not finding it in any docs or scripts. That's 4,664,247 lines we don't need to keep around, reducing our database footprint
    • Dropped the bestnodes table. It wasn't full with very much, but it's one less table to move over to the new db layout.
    • Dropped the book_temp table. 75522 lines from our footprint gone.
    • Wiped out the original "bug" nodetype. bug maintenance create bug display page bug edit page bug (nodetype) bug (dbtable) and 53 "bug"s are all gone
    • Dropped the errorlog table. 623 lines wiped out. It was an old idea by me to have e2 parse it's own errorlogs, but I never really followed through with it.
    • Dropped the links_temp table. 5736193 lines gone, cleaning up our db footprint even more.
    • Dropped the secretsanta table. Was used for the old secret santa orginization from a couple of years ago.
    • Carved out the old clan system and tossed it away. displayclanmotions clanmotiontype (nodetype and dbtable),clanmotion (nodetype and dbtable),clan display page,clan (nodetype and dbtable), meta-clantype all hit the editing room floor.
    • Prevented caching of users because it may not be necessary. It's easily 80% of our nodecache, which really isn't good. Reduced the max caching threshold by half to account for the slack so it doesn't fill up with other junk.
    • Compacted the message table so that archived is a TINYINT, or a single bit, allowing possibly smarter optimization, since that's a common query component.
  • July 20, 2003 - More database slimming
    • Dropped the coolwriteups2 table
    • Dropped the docrevision table. This was my beta for a feature that will make it into the new site.
del.icio.us Furl Facebook Digg StumbleUpon Reddit   (I like it!)
Y'know, if you log in, you can write something here, or contact authors directly on the site. Create a New User if you don't already have an account.