RESET MASTER doesn't work

2010-08-12 Thread Joe Hammerman
Hello MySQL-users list, We are having an issue with replication and binlog files and I was hoping that this list could shed a little light on the issue for us. We have a pair of 5.1.41-community MySQL servers. We attempted to restore from the slave server, and in the process I zeroed out the my

Recommended swap partition size

2010-04-13 Thread Joe Hammerman
Hello all, My organization has a dedicated MySQL server. The system has 32Gb of memory, and is running CentOS 5.3. The default engine will be InnoDB. Does anyone know how much space should be dedicated to swap? Thanks!

Upgrade question

2009-07-01 Thread Joe Hammerman
Hello MySQL users, My company is planning to upgrade from MySQL 5.0.51a to a more recent version. Which version of MySQL offers the best balance between stability and currency? Is there a discussion of the tradeoffs involved between different recent version that I could be direc