Advertisement

Database Maintenance

This is the main board on The Outhouse, where Outhousers talk about everything. No topics are off limits, and it doesn't have to be about comics. All the topics from the other boards also show up in The Asylum, so you never have to leave1

Hey you! Reader! Want to be a part of the GREATEST COMIC BOOK AND GEEK COMMUNITY on the web?! Logged in users see WAY LESS ADS, so why not register? It's fast and it's easy, like your mom! Sign up today! Membership spots are limited!*

*Membership spots not really limited!

Psivage
User avatar
FROGMAN
 
Posts: 8346
Likes: 11 posts
Liked in: 14 posts
Joined: Wed Jun 11, 2008 3:05 pm
Title: shake it baby, shake it good!
Formerly: Cat-Psivage


Re: Database Maintenance

Postby Psivage » Mon Feb 11, 2013 6:23 pm

i keep having to logged in each time.
Image


Image

both made by Cat-Scratch

Advertisement

S.F. Jude Terror
User avatar
OMCTO
 
Posts: 76126
Likes: 429 posts
Liked in: 627 posts
Joined: Thu Jun 12, 2008 11:44 pm
Location: Up Your Ass
Title: Webmaster Supreme
Formerly: Dr. Jude Terror


Re: Database Maintenance

Postby S.F. Jude Terror » Mon Feb 11, 2013 6:45 pm

The logging in thing should only be an issue when the site is taken down. I moved the sessions to memory so they're faster. That usually never happens, but since I was rebuilding the database, I shut it down a few times.

covalesky
User avatar
Expert Post Whore
 
Posts: 5290
Likes: 0 post
Liked in: 1 post
Joined: Fri Sep 03, 2010 11:48 am


Re: Database Maintenance

Postby covalesky » Mon Feb 11, 2013 6:51 pm

S.F. Jude Terror wrote:The logging in thing should only be an issue when the site is taken down. I moved the sessions to memory so they're faster. That usually never happens, but since I was rebuilding the database, I shut it down a few times.


I want my search back, or there will be blood.

S.F. Jude Terror
User avatar
OMCTO
 
Posts: 76126
Likes: 429 posts
Liked in: 627 posts
Joined: Thu Jun 12, 2008 11:44 pm
Location: Up Your Ass
Title: Webmaster Supreme
Formerly: Dr. Jude Terror


Re: Database Maintenance

Postby S.F. Jude Terror » Mon Feb 11, 2013 7:31 pm

I'm bringing back search, don't worry. Better search that works faster and also allows posting to work faster. :-D


I deleted the indexes on 2.5 million posts, so now I have to rebuild those indexes, either in Sphinx or in another database table. Haven't quite decided yet. I'm thinking Sphinx though.
Image
I LOVE BLUD BLOOD! - Rob Liefeld

Victorian Squid
User avatar
YOU WILL NEED A NURSE
 
Posts: 31777
Likes: 0 post
Liked in: 2 posts
Joined: Sat Sep 27, 2008 10:04 am
Formerly: Schmormerly


Re: Database Maintenance

Postby Victorian Squid » Mon Feb 11, 2013 7:35 pm

Burn it! Burn it all! :smt074

Victorian Squid
User avatar
YOU WILL NEED A NURSE
 
Posts: 31777
Likes: 0 post
Liked in: 2 posts
Joined: Sat Sep 27, 2008 10:04 am
Formerly: Schmormerly


Re: Database Maintenance

Postby Victorian Squid » Mon Feb 11, 2013 7:38 pm

DO NOT delete my high score on Donkey Kong tho!

S.F. Jude Terror
User avatar
OMCTO
 
Posts: 76126
Likes: 429 posts
Liked in: 627 posts
Joined: Thu Jun 12, 2008 11:44 pm
Location: Up Your Ass
Title: Webmaster Supreme
Formerly: Dr. Jude Terror


Re: Database Maintenance

Postby S.F. Jude Terror » Mon Feb 11, 2013 7:39 pm

Hey, the site's been running great all day. No need to burn anything. :)
Image
I LOVE BLUD BLOOD! - Rob Liefeld

Victorian Squid
User avatar
YOU WILL NEED A NURSE
 
Posts: 31777
Likes: 0 post
Liked in: 2 posts
Joined: Sat Sep 27, 2008 10:04 am
Formerly: Schmormerly


Re: Database Maintenance

Postby Victorian Squid » Mon Feb 11, 2013 7:44 pm

S.F. Jude Terror wrote:Hey, the site's been running great all day. No need to burn anything. :)


Oh, there's always one. Who needs a reason? is what my old prof used to tell us in the old days, back in arson school.

sdsichero
User avatar
2k11 Outhouse People's Champion
 
Posts: 69652
Likes: 0 post
Liked in: 465 posts
Joined: Wed Jun 04, 2008 10:25 pm
Location: Secret Base, Honolulu, HI
Title: All the good ones were taken
Formerly: beta-ray


Online


Re: Database Maintenance

Postby sdsichero » Mon Feb 11, 2013 7:45 pm

Victorian Squid wrote:DO NOT delete my high score on Donkey Kong tho!


Oops first thing to go.
ImageImageImageImageImage

Victorian Squid
User avatar
YOU WILL NEED A NURSE
 
Posts: 31777
Likes: 0 post
Liked in: 2 posts
Joined: Sat Sep 27, 2008 10:04 am
Formerly: Schmormerly


Re: Database Maintenance

Postby Victorian Squid » Mon Feb 11, 2013 7:46 pm

sdsichero wrote:
Oops first thing to go.


That's okay, I memorized the whole thing.

covalesky
User avatar
Expert Post Whore
 
Posts: 5290
Likes: 0 post
Liked in: 1 post
Joined: Fri Sep 03, 2010 11:48 am


Re: Database Maintenance

Postby covalesky » Tue Feb 12, 2013 4:29 am

I can't navigate the forums without my new posts list!

HEEEEEEEEEEEEEEEELLLLLLLLLLLLLLLLLLLLLLLLLPPPPPPPPPPPPPPPPPPPPPPPPPPpppppppppppppppppppppppppp!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!111oneone

GiveWarAChance
User avatar
FROGMAN
 
Posts: 8228
Likes: 163 posts
Liked in: 723 posts
Joined: Thu Apr 28, 2011 12:06 am
Location: Watching you
Title: Unliving Legend
Formerly: GivePeaceAChance


Re: Database Maintenance

Postby GiveWarAChance » Tue Feb 12, 2013 5:25 am

This wouldn't have happened to you guys if you got the $9.95 a month premium plan. Besides having no problems, it allows me to have five different accounts to post under and the ability to edit all of the posts you guys make. On my birthday the mawds all sing me happy birthday. I also got 5 near mint copies of NFL Superpro #4 just for signing up. What are you guys waiting for?
Image

Schlemmer
User avatar
YOU WILL NEED A NURSE
 
Posts: 17958
Likes: 120 posts
Liked in: 141 posts
Joined: Tue Dec 14, 2010 1:48 pm
Title: Hot-Linker
Formerly: Schlemmer; spelled the same but sounds different


Re: Database Maintenance

Postby Schlemmer » Tue Feb 12, 2013 12:01 pm

Image

leave a comment with facebook

Previous

Return to The Asylum



Who is online

Users browsing this forum: FaceBook [Linkcheck], Google [Bot] and 51 guests

Advertisement