Club PA 2.0 has arrived! If you'd like to access some extra PA content and help support the forums, check it out at patreon.com/ClubPA
The image size limit has been raised to 1mb! Anything larger than that should be linked to. This is a HARD limit, please do not abuse it.
Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!

You know all those weird bugs(7/17/05 Work)

ÄlphämönkëyÄlphämönkëy Registered User regular
I'm fixing them.

The entire site will be down for about 45minutes.
-Alpha

Älphämönkëy on

Posts

  • HardtargetHardtarget There Are Four Lights VancouverRegistered User regular
    edited July 2005
    sweet

    Hardtarget on
    steam_sig.png
    kHDRsTc.png
  • MgcwMgcw Registered User regular
    edited July 2005
    Hey... It's daylight time not standard time!

    Mgcw on
  • OrikaeshigitaeOrikaeshigitae Registered User, ClubPA regular
    edited July 2005
    oh god i'm bad at converting between timezones

    Orikaeshigitae on
  • Red ZoneRed Zone Registered User regular
    edited July 2005
    CST time doesn't exist.

    Red Zone on
    1vqtC.jpg
  • redfenixredfenix Registered User regular
    edited July 2005
    Which is weird, 'cause i'm in it.

    redfenix on
  • DJ EebsDJ Eebs Moderator mod
    edited July 2005
    CST is the best.

    DJ Eebs on
  • Red ZoneRed Zone Registered User regular
    edited July 2005
    Nope. It doesn't.

    Red Zone on
    1vqtC.jpg
  • OrikaeshigitaeOrikaeshigitae Registered User, ClubPA regular
    edited July 2005
    Guys, what is 2pm CST in EST?

    Orikaeshigitae on
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited July 2005
    Now.

    Älphämönkëy on
  • OrikaeshigitaeOrikaeshigitae Registered User, ClubPA regular
    edited July 2005
    Oh.

    Orikaeshigitae on
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited July 2005
    :wink:

    Älphämönkëy on
  • ElkiElki get busy Moderator, ClubPA mod
    edited July 2005
    <3

    Elki on
    smCQ5WE.jpg
  • OrikaeshigitaeOrikaeshigitae Registered User, ClubPA regular
    edited July 2005
    Elkamil wrote:
    <3

    Orikaeshigitae on
  • omgboomlolomgboomlol __BANNED USERS
    edited July 2005
    thankulanguages8by.jpg

    omgboomlol on
    omgboomlolud1.gif
  • ÄlphämönkëyÄlphämönkëy Registered User regular
    edited July 2005
    For the curious, I converted back from InnoDB tables (on highly updated tables) to MyISAM tables. By all accounts this should make the site less stable, but given the problems we had last week, I'm not going to argue.
    Here are the commands I ran for the techies out there.
    # mysqldump --opt -Qe --all-databases -p > ./mysql_innodb-myisam_conversion.dump.sql
    Enter password:
    
    # du -h mysql_innodb-myisam_conversion.dump.sql
    954M    mysql_innodb-myisam_conversion.dump.sql
    
    # #Yikes! We have almost a gig of just data, this does not include indexes
    
    # cat mysql_innodb-myisam_conversion.dump.sql | sed -e '/ENGINE=InnoDB/ s/ENGINE=InnoDB/ENGINE=MyISAM/g' > ./mysql_innodb-myisam_conversion.dump.runnable.sql
    
    Time spent in user mode   (CPU seconds) : 5.789s
    Time spent in kernel mode (CPU seconds) : 5.759s
    Total time                              : 0:58.86s
    CPU utilisation (percentage)            : 19.5%
    Times the process was swapped           : 0
    Times of major page faults              : 0
    Times of minor page faults              : 18128
    
    # mysql -p < mysql_innodb-myisam_conversion.dump.runnable.sql
    Enter password:
    
    Time spent in user mode   (CPU seconds) : 21.796s
    Time spent in kernel mode (CPU seconds) : 4.091s
    Total time                              : 6:32.83s
    CPU utilisation (percentage)            : 6.5%
    Times the process was swapped           : 0
    Times of major page faults              : 28
    Times of minor page faults              : 1730
    
    # /usr/local/etc/rc.d/mysql-server.sh stop
    Starting mysql.
    # cd /var/db/mysql/
    # find . -name '*.MYI' -exec myisamchk -p {} \;
    
    Time spent in user mode   (CPU seconds) : 96.813s
    Time spent in kernel mode (CPU seconds) : 8.101s
    Total time                              : 2:27.59s
    CPU utilisation (percentage)            : 71.0%
    Times the process was swapped           : 0
    Times of major page faults              : 19
    Times of minor page faults              : 250459
    
    # /usr/local/etc/rc.d/mysql-server.sh start
    Starting mysql.
    
    # mysqlcheck -p -o --all-databases
    Enter password:
    

    Let me know if things are still breaking.

    Älphämönkëy on
  • HenroidHenroid Radio Demon Internet HellRegistered User regular
    edited July 2005
    Thanks again Alpha! :^:

    Henroid on
    Centrism is just the cowardly way to be a bigot w/o being explicit about it.
    American politics isn't 4D chess, it's just if you give a shit about other people or not.
  • mccmcc glitch Registered User, ClubPA regular
    edited July 2005
    That's awesome but it seems to have created at least one new bug. Post in this thread and you will see that the old post-time-travel thing is happening.

    EDIT: Never mind, it's fixed itself somehow.

    mcc on
Sign In or Register to comment.