Advertisement

Database Maintenance

[ Facebook comments]

Talk about news, politics, pop culture, entertainment and everything geek with your fellow comic book fans!

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: 8037
Joined: Wed Jun 11, 2008 4:05 pm
Title: shake it baby, shake it good!
Formerly: Cat-Psivage


Re: Database Maintenance

Postby Psivage » Mon Feb 11, 2013 7: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: 69733
Joined: Fri Jun 13, 2008 12:44 am
Location: Up Your Ass
Title: Webmaster Supreme
Formerly: Dr. Jude Terror


Re: Database Maintenance

Postby S.F. Jude Terror » Mon Feb 11, 2013 7: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: 5266
Joined: Fri Sep 03, 2010 12:48 pm


Re: Database Maintenance

Postby covalesky » Mon Feb 11, 2013 7: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: 69733
Joined: Fri Jun 13, 2008 12:44 am
Location: Up Your Ass
Title: Webmaster Supreme
Formerly: Dr. Jude Terror


Re: Database Maintenance

Postby S.F. Jude Terror » Mon Feb 11, 2013 8: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
some idiot on facebook wrote:I don't like your belittling tone, Jude. Just because I don't know how to spell the language of some tiny African nation doesn't mean that I'm wrong in thinking that your attitude towards women is 100% wrong. Obviously, you're some skinny, single nerd living on the East Coast who probably derives value in life from wrestling matches, hoping that Wolverine gets to sleep with teenagers and engaging in casual drug use. You're literally the worst thing to happen to comics since Stan Lee.

Victorian Squid
User avatar
YOU WILL NEED A NURSE
 
Posts: 30309
Joined: Sat Sep 27, 2008 11:04 am
Formerly: Schmormerly


Re: Database Maintenance

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

Burn it! Burn it all! :smt074

Victorian Squid
User avatar
YOU WILL NEED A NURSE
 
Posts: 30309
Joined: Sat Sep 27, 2008 11:04 am
Formerly: Schmormerly


Re: Database Maintenance

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

DO NOT delete my high score on Donkey Kong tho!

S.F. Jude Terror
User avatar
OMCTO
 
Posts: 69733
Joined: Fri Jun 13, 2008 12:44 am
Location: Up Your Ass
Title: Webmaster Supreme
Formerly: Dr. Jude Terror


Re: Database Maintenance

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

Hey, the site's been running great all day. No need to burn anything. :)
Image
I LOVE BLUD BLOOD! - Rob Liefeld
some idiot on facebook wrote:I don't like your belittling tone, Jude. Just because I don't know how to spell the language of some tiny African nation doesn't mean that I'm wrong in thinking that your attitude towards women is 100% wrong. Obviously, you're some skinny, single nerd living on the East Coast who probably derives value in life from wrestling matches, hoping that Wolverine gets to sleep with teenagers and engaging in casual drug use. You're literally the worst thing to happen to comics since Stan Lee.

Victorian Squid
User avatar
YOU WILL NEED A NURSE
 
Posts: 30309
Joined: Sat Sep 27, 2008 11:04 am
Formerly: Schmormerly


Re: Database Maintenance

Postby Victorian Squid » Mon Feb 11, 2013 8: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: 61181
Joined: Wed Jun 04, 2008 11:25 pm
Location: Secret Base, Honolulu, HI
Title: 直接! Chokusetsu!
Formerly: beta-ray


Re: Database Maintenance

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

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


Oops first thing to go.

Victorian Squid
User avatar
YOU WILL NEED A NURSE
 
Posts: 30309
Joined: Sat Sep 27, 2008 11:04 am
Formerly: Schmormerly


Re: Database Maintenance

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

sdsichero wrote:
Oops first thing to go.


That's okay, I memorized the whole thing.

covalesky
User avatar
Expert Post Whore
 
Posts: 5266
Joined: Fri Sep 03, 2010 12:48 pm


Re: Database Maintenance

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

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

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

GiveWarAChance
User avatar
Motherfucker from Hell
 
Posts: 2652
Joined: Thu Apr 28, 2011 1:06 am
Location: Watching you
Title: Unliving Legend


Re: Database Maintenance

Postby GiveWarAChance » Tue Feb 12, 2013 6: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: 15361
Joined: Tue Dec 14, 2010 2:48 pm
Title: Hot-Linker
Formerly: Schlemmer; spelled the same but sounds different


Re: Database Maintenance

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

Image

leave a comment with facebook

Previous

Return to The Asylum



Who is online

Users browsing this forum: Amoebas, FaceBook [Linkcheck], Jack Burton, oogy, Stalzer2002, TimDrake'sDumbWings, vu3730 and 50 guests

Advertisement