 Looks like we're back up now, I was in withdrawal... |
|
|||||||||
 Jan 23 2006, 09:28 PM
Post
#1
|
|
|
Engine and Tools Moderator  Group: Advanced Members Posts: 1,859 Joined: 23-December 03 From: Lebanon TN Member No.: 6  |
(IMG:http://www.frrax.com/rrforum/style_emoticons/default/smile.gif)
Thanks for all your work on getting it back! |
 |
 
|
 |
Replies
|
Jan 24 2006, 03:26 AM
Post
#2
|
|
|
Co-Admin and PHP dude. Group: Advanced Members Posts: 31 Joined: 23-December 03 From: Middle Tennessee Member No.: 10 |
QUOTE (rushman @ Jan 23 2006, 19:27) hehe, you need shell access to run mysql.... You might be able to make your own php.ini file and increase the timeout as well. Unfortunately, shell access would not have helped us in this case. The problem was in the way we backed up the database. We used "extended" inserts, which combined all 70k+ posts into a single insert statement. That proved to be too much for the server to deal with. So I had to break it up into more managable chunks of 1000 posts each. Next time, I'll leave it with a single insert per record and it should run better. |
|
|
|
Posts in this topic
John_D. Looks like we're back up now Jan 23 2006, 09:28 PM
CMC #37 Aaaah! That's better! Jan 23 2006, 09:40 PM slowTA Same here... it was touch and go for a while but I... Jan 23 2006, 09:43 PM 35th_Anniversary_AS_Camaro_SS RE: Looks like we're back up now Jan 23 2006, 10:06 PM Chris 96 WS6 That was quite the outtage (since 5pm-ish yesterda... Jan 23 2006, 10:08 PM trackbird Thanks Guys! Sorry about that.
I sent this re... Jan 23 2006, 10:10 PM LWillmann I can't let Kevin take all the blame for the d... Jan 23 2006, 11:53 PM CMC #37 No problemo! Being an admin is not always a pi... Jan 24 2006, 12:25 AM rushman hehe, you need shell access to run mysql.... You ... Jan 24 2006, 01:27 AM Rob Hood QUOTE LWillmann Posted on Jan 23 2006, 17:53
-----... Jan 24 2006, 02:02 AM mitchntx Don't worry about the down time .... my boss a... Jan 24 2006, 02:09 AM trackbird QUOTE (LWillmann @ Jan 23 2006, 18:53)I can... Jan 24 2006, 02:49 AM firehawkclone I felt like this for 2 day's, now it this
... Jan 24 2006, 03:07 AM trackbird Experience is the best teacher.... We learned a to... Jan 24 2006, 03:28 AM Eugenio_SS Kevin, here is the hero of the day
Hero -----... Jan 24 2006, 03:38 AM trackbird QUOTE (Eugenio_SS @ Jan 23 2006, 22:38)
Kevi... Jan 24 2006, 03:40 AM Eugenio_SS ... oh forgot, that was on the 44th beer in the wa... Jan 24 2006, 03:41 AM Eugenio_SS QUOTE (trackbird @ Jan 23 2006, 22:40)QUOTE (... Jan 24 2006, 03:45 AM v7guy Appreciate both of your guys work! Jan 24 2006, 01:39 PM Eugenio_SS QUOTE (v7guy @ Jan 24 2006, 08:39)Appreciate ... Jan 24 2006, 10:40 PM trackbird QUOTE (Eugenio_SS @ Jan 24 2006, 17:40)QUOTE ... Jan 24 2006, 10:45 PM Eugenio_SS it's so confusing to know who is referring to ... Jan 24 2006, 11:01 PM Teutonic Speedracer Glad to see us back up! Jan 25 2006, 12:27 AM v7guy I need to work on this whole communication thing Jan 25 2006, 07:50 AM Eugenio_SS QUOTE (v7guy @ Jan 25 2006, 02:50)I need to w... Jan 25 2006, 08:36 AM v7guy RE: Looks like we're back up now Jan 25 2006, 03:59 PM rmackintosh Good job guys....you managed to schedule this outa... Jan 25 2006, 04:49 PM
trackbird QUOTE (rmackintosh @ Jan 25 2006, 11:49)Good ... Jan 25 2006, 05:00 PM |
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 19th June 2025 - 11:50 AM |