Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Unexpected downtime 07-03-2008


  • This topic is locked This topic is locked

#1
admin

admin

    Founder Geek

  • Administrator
  • 24,504 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!

  • Administrator
  • 26,019 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,640 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