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

Älphämönkëy

I'm fixing them.

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

Hardtarget

sweet

Mgcw

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

Orikaeshigitae

oh god i'm bad at converting between timezones

Red Zone

CST time doesn't exist.

redfenix

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

DJ Eebs

CST is the best.

Red Zone

Nope. It doesn't.

Orikaeshigitae

Guys, what is 2pm CST in EST?

Älphämönkëy

Now.

Orikaeshigitae

Oh.

Älphämönkëy

Elki

Orikaeshigitae

Elkamil wrote:

omgboomlol

Älphämönkëy

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

Thanks again Alpha! :^:

mcc

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.