May 23, 2012

Post: Updated msl (microslow) patch, installation walk-through!

… describing the method that is simple, non-intrusive to the system and additionally allows marginal database downtime. It should also work….diff patching file include/my_time.h patching file scripts/mysqldumpslow.sh patching file sql-common/my_time.c patching file sql/filesort.cc patching file

Post: Thoughs on Innodb Incremental Backups

… to the separate file. Because pages already have position information in them there is no need to have complex “diff” meta data. For recovery we can simply read this new pages file and put the pages back to their original places. Of course this means .frm files and Innodb logs and MyISAM system

Post: The story of one MySQL Upgrade

…checksums while running SELECT INTO OUTFILE and diffing these files reported no changes. It turns out there are …. We used mk-table-sync –print as a diff tool for MySQL to see what is different …as with New MySQL version upgrade involves new Operating System and hardware and any of them could be …