Unexpected downtime 07-03-2008 - Geeks to Go Forums

Jump to content

Log in Register Register Malware removal guide How it works

Unexpected downtime 07-03-2008

#1 admin

  • Group: Administrator
  • Posts: 23,520
  • Joined: 21-May 03

Posted 03 July 2008 - 12:16 PM

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. :)

Your Geeks to Go admin team

#2 jt1990

  • Group: Member
  • Posts: 1,519
  • Joined: 20-May 08

Posted 03 July 2008 - 12:35 PM

No prob! :)

#3 Rorschach112

  • Group: Retired Staff
  • Posts: 47,710
  • Joined: 23-March 07

Posted 03 July 2008 - 12:39 PM

I did some baking while the forum was down

Turned out beautiful :)

#4 Chopin

  • Group: Member
  • Posts: 2,639
  • Joined: 14-May 07

Posted 03 July 2008 - 01:20 PM

Well, at least it's back up :)

#5 dsenette

  • Group: Administrator
  • Posts: 25,650
  • Joined: 21-April 05

Posted 03 July 2008 - 01:36 PM

being the day before the fourth i just figured you had a little TUI (tinkering under the influence) hehe

#6 BHowett

  • Group: Retired Staff
  • Posts: 4,478
  • Joined: 08-May 07

Posted 03 July 2008 - 04:57 PM

Nothing wrong with a few hours off :) I 'm just glad you got it sorted :)

#7 Mike

  • Group: Retired Staff
  • Posts: 2,745
  • Joined: 03-January 08

Posted 04 July 2008 - 04:17 AM

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 :)

*Mike thinks the latter would be better.

Share this topic: