Welcome Guest ( Log In | Join )

Discover the best free computer help!
Learn more about Geeks to Go by taking the tour. Spyware, virus, trojan, fake security or privacy alerts? Read the malware cleaning guide. Want to reply to a topic, start a new one, or remove the advertising? Join today (always free).
      
 
 Closed TopicStart new topic
Unexpected downtime 07-03-2008
admin
post Jul 3 2008, 12:16 PM
Post #1


Site Administrator
Group Icon
Posts: 17,476
From: 127.0.0.1
OS: Windows Vista Ultimate
We had to take down the forums to perform some unexpected database management from about 9am - 1pm CDT today.

MySQL has a known "table full" issue when a table reaches 4GB. We thought running 64-bit software we'd be unaffected, but this morning we exceeded the maximum number of rows allowed by a table, and that prevented people from posting. It appears only one post was lost and that person has been notified.

It was corrected by running a backup and then an SQL command:
QUOTE
mysql> ALTER TABLE ibf_posts MAX_ROWS=1000000000 AVG_ROW_LENGTH=3411;
Query OK, 1259009 rows affected, 3 warnings (1 hour 26 min 57.10 sec)
Records: 1259009 Duplicates: 0 Warnings: 0


Thanks for your understanding and patience as we resolved this issue. smile.gif

Your Geeks to Go admin team
Go to the top of the page
 
+Quote Post
jt1990
post Jul 3 2008, 12:35 PM
Post #2


Geek in Training
***
Posts: 982
From: The middle of Nowhere (Maine, USA
OS: Windows XP Home, Pro SP3, Windows Vista Business SP1
No prob! smile.gif
Go to the top of the page
 
+Quote Post
Rorschach112
post Jul 3 2008, 12:39 PM
Post #3


GeekU Teacher
Group Icon
Posts: 19,795
From: Dublin
OS: XP
I did some baking while the forum was down

Turned out beautiful smile.gif
Go to the top of the page
 
+Quote Post
Fredil
post Jul 3 2008, 01:20 PM
Post #4


Trusted Helper
Group Icon
Posts: 1,983
From: Wait, wait, I know this!
OS: Windows XP Professional SP2
Well, at least it's back up biggrin.gif
Go to the top of the page
 
+Quote Post
dsenette
post Jul 3 2008, 01:36 PM
Post #5


Ruler of Omicron Persei 8
Group Icon
Posts: 20,688
From: kn-ARGH!-xville Tenn-ARGH!-see
OS: 3.1, 95, 98SE, xp, 2000, NT4, 2003 Standard Edition, linux (various flavors)
being the day before the fourth i just figured you had a little TUI (tinkering under the influence) hehe
Go to the top of the page
 
+Quote Post
BHowett
post Jul 3 2008, 04:57 PM
Post #6


Moderator / Malware Staff
Group Icon
Posts: 2,030
From: USA
OS: Windows XP professional



Nothing wrong with a few hours off whistling.gif I 'm just glad you got it sorted thumbsup.gif
Go to the top of the page
 
+Quote Post
Mike
post Jul 4 2008, 04:17 AM
Post #7


Malware Monger
Group Icon
Posts: 2,722
OS: XP Professional SP3
Thanks for the hard work,

Sari and I were debating whether to get you a cold beer, or a trip to a beer factory in Germany tongue.gif

*Mike thinks the latter would be better.
Go to the top of the page
 
+Quote Post
 

Closed TopicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Collapse

> Similar Topics

    Topic Title Replies / Views Topic Information
No New Posts   0 / 715 25th August 2007 - 12:33 AM
admin started - last by admin
No New Posts   4 / 1,452 11th January 2008 - 01:34 AM
admin started - last by admin
No New Posts   0 / 501 30th April 2008 - 10:08 AM
admin started - last by admin
No New Posts   0 / 160 20th October 2008 - 10:35 PM
DeviousTrap started - last by DeviousTrap

RSS Time is now: 3rd December 2008 - 12:27 AM
Advertisements do not imply our endorsement of that product or service. The forum is run by volunteers who donate their time and expertise. We make every attempt to ensure that the help and advice posted is accurate and will not cause harm to your computer. However, we do not guarantee that they are accurate and they are to be used at your own risk.
Powered By IP.Board © 2008  IPS, Inc.