Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
Photo

Unexpected downtime 07-03-2008


  • This topic is locked This topic is locked

#1
admin

admin

    Founder Geek

  • Community Leader
  • 24,639 posts
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:

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
  • 0

Advertisements


#2
jt1990

jt1990

    Member 1K

  • Member
  • PipPipPipPip
  • 1,519 posts
No prob! :)
  • 0

#3
Rorschach112

Rorschach112

    Ralphie

  • Retired Staff
  • 47,710 posts
I did some baking while the forum was down

Turned out beautiful :)
  • 0

#4
Chopin

Chopin

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,639 posts
Well, at least it's back up :)
  • 0

#5
dsenette

dsenette

    Je suis Napoléon!

  • Community Leader
  • 26,047 posts
  • MVP
being the day before the fourth i just figured you had a little TUI (tinkering under the influence) hehe
  • 0

#6
BHowett

BHowett

    OT Moderator

  • Moderator
  • 4,649 posts
Nothing wrong with a few hours off :) I 'm just glad you got it sorted :)
  • 0

#7
Mike

Mike

    Malware Monger

  • Retired Staff
  • 2,745 posts
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.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP