Submit your comments on this article |
Database crashed... |
2005-11-30 |
The MySQL databased crashed on us yesterday at around 5 pm. I wasn't able to fix it remotely — couldn't get into the blasted thing. The box spent the evening in my office, while I chased down bad indexes, deleted all the spam from the comments table, and generally fiddled it a half dozen other ways. I put a filter in that'll hopefully keep the spammers out, at least for awhile, and I cleaned up a little bit of SQL on the main page. It now runs lightnin' fast as a stand-alone, but I've no idea what it's going to be like when I put it under load tomorrow. I'm hoping it'll perform the same. My apologies to all. |
Posted by:Fred |
#31 You mean I sent my computer to the repair shop for nothing yesterday? Rantburg is the only internet site I go to. |
Posted by: RG 2005-11-30 18:18 |
#30 Good grief, Fred! That was a close one! (At least I won't have to try moveoff/on/over/whatever.org for information and news now.) |
Posted by: mjslack 2005-11-30 17:01 |
#29 Oracle Express is designed to compete with MySQL and Postgres. It's f-r-e-e. I can afford that. |
Posted by: Fred 2005-11-30 15:54 |
#28 Does this mean I'll have to hit the tip jar? That PC on the pic doesn't seem very user-friendly to me. For now, I'll just hit the blog ads, I'm broke until I'm paid in a couple of days (curse my under-achiever, low-ambition, not goal-driven lifestyle!!!), I've only money left to buy unnecessary and uneeded stuff on the internet (and RB is both NECESSARY and NEEDED, dammit!). |
Posted by: anonymous5089 2005-11-30 15:04 |
#27 Great Fred! I guess I can stop drinking now. Fred puts a much work into keeping Rantburg going. It's apprecated by me. There in no resource like Rantburg anywhere. Oracle is a superior database product. The big thing with it is the cost. It's hard to resist except for that one fact. SPo'D is happy the burg is flying again. |
Posted by: Mahou Sensei Negi-bozu 2005-11-30 15:02 |
#26 The MySQL serotonin databased crashed. stood by the freeway exit yesterday w/ sign, will work for pain meds. |
Posted by: Red Dog 2005-11-30 13:50 |
#25 Fred, I missed my news and commentary fix. Sorry about the computer. Looks like it got hit by an RPG. Thanks for what you do here. |
Posted by: John Q. Citizen 2005-11-30 13:44 |
#24 I was worried there for a while, Fred. Not because my site, Sundries, is currently being advertised on BlogAds. *g* But because you provide an invaluable Blogosphere service. Keep up the fantastic work! Cheers, Victoria |
Posted by: Victoria 2005-11-30 12:27 |
#23 Oh good, The Rant is back. While the site was down I discovered that typing from the fetal position is really awkward. We'll all check the cushions of the couch for some spare change so you can get Oracle, Fred. |
Posted by: Jonathan 2005-11-30 12:17 |
#22 wat frank sed |
Posted by: muck4doo 2005-11-30 11:56 |
#21 PostGRE, maybe? Oracle betas - (shudder) |
Posted by: mojo 2005-11-30 11:50 |
#20 Oracle has Oracle Express in beta, for Win and Linux. Must... resist... urge... to... install... But it'd be nice to use the same database at work and on the Burg. And when it behaves, I really like Oracle. |
Posted by: Fred 2005-11-30 11:44 |
#19 I'm just glad to discover the the "new improvements" didn't include blocking me :-) |
Posted by: 2b 2005-11-30 11:11 |
#18 I kinda knew you were working on things, and that these sorts of things happen, Fred. Thanks again for all your hard work, and when my budget lightens somewhat next year, I'll hit the tip jar. |
Posted by: Ptah 2005-11-30 11:10 |
#17 stopped shaking now thanks fred |
Posted by: pihkalbadger 2005-11-30 10:56 |
#16 Ditto! Here, here. |
Posted by: Secret Master 2005-11-30 10:54 |
#15 Try going around to other sites and getting relevant news. Rantburg is definitely the full meal deal, hands down! Your dedication to the site, Fred, is much appreciated and not taken for granted. |
Posted by: Alaska Paul 2005-11-30 10:48 |
#14 I had to turn to other sources for news. Did you know Iraq is a QUAGMIRE! BUSH APPROVAL NUMBERS NEGATIVE!? |
Posted by: Frank G 2005-11-30 10:40 |
#13 Fred: Thanks for the update, I was beginning to think the gov'ment was blocking me. |
Posted by: Besoeker 2005-11-30 10:30 |
#12 Thanks for storing the gold that is the burg's witty and erudite comments. |
Posted by: Master of Obvious 2005-11-30 10:29 |
#11 I'm glad you're back up -- I can cut my meds in half now. |
Posted by: Steve White 2005-11-30 10:10 |
#10 Almost caused to me to seek the answers to life in the bottom of a bottle (again). Thanks for all Fred. |
Posted by: Doc8404 2005-11-30 09:35 |
#9 Fred...sincerely...we appreciate all of your time and energy! |
Posted by: anymouse 2005-11-30 09:32 |
#8 Me too, Sea. |
Posted by: lotp 2005-11-30 09:32 |
#7 Thank god you're back up. This was worse than running out of coffee! |
Posted by: Steve 2005-11-30 09:31 |
#6 No apologies needed. Thanks for all your hard work! /coming in off the ledge now |
Posted by: Seafarious 2005-11-30 09:30 |
#5 Fast as hell tho.... |
Posted by: Shipman 2005-11-30 09:28 |
#4 Weird, no articles three comments.... creepy. |
Posted by: Shipman 2005-11-30 09:28 |
#3 So much hard work goes into rantburg! I don't know why you do it Fred, but I'm grateful that you do. |
Posted by: 2b 2005-11-30 09:27 |
#2 you're back up. Woo Hoo! I missed my news fix and had to satisfy it by surfing multiple other sites. Rantburg is the best by far. Thanks Fred! |
Posted by: 2b 2005-11-30 09:26 |
#1 Whew. That was scary. |
Posted by: Dave D. 2005-11-30 09:24 |