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

Älphämönkëy · July 2005

I'm fixing them.

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

Hardtarget · July 2005

sweet

Mgcw · July 2005

Hey... It's daylight time not standard time!

Orikaeshigitae · July 2005

oh god i'm bad at converting between timezones

Red Zone · July 2005

CST time doesn't exist.

redfenix · July 2005

Which is weird, 'cause i'm in it.

DJ Eebs · July 2005

CST is the best.

Red Zone · July 2005

Nope. It doesn't.

Orikaeshigitae · July 2005

Guys, what is 2pm CST in EST?

Älphämönkëy · July 2005

Now.

Orikaeshigitae · July 2005

Oh.

Älphämönkëy · July 2005

Elki · July 2005

Orikaeshigitae · July 2005

Elkamil wrote:

omgboomlol · July 2005

Älphämönkëy · 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.

Henroid · July 2005

Thanks again Alpha! :^:

mcc · 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.

Penny Arcade

Quick Links

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

Posts