… (16384 bytes): … A LOT OF HEX AND BINARY DATA… 080703 23:46:16 InnoDB: Page …case simple OPTIMIZE TABLE could be enough to rebuild it, but it is much better compared … getting: mysql> check table test; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> check table test;…
Comment: Upgrading MySQL
January 17, 2010 By 24 Comments
… replicated environment) and then upgrade to the newer binaries and run mysql_check followed by mysql_upgrade. That works pretty well as long… by the mysql_upgrade binary is to dump the tables and then load them back. Of course to run mysql_upgrade you are… ENGINE=INNODB rebuilds the table under 5.1 and MySQL is happy… (why this is not done as part of the mysql_upgrade…
Post: Small things are better
October 8, 2006 By 15 Comments
… of MySQL bugs, OS Bugs or hardware bugs, misconfiguration or failures. Sometimes corruption kind be mild, so ALTER TABLE to rebuild the… restore, especially if you do point in time recovery using binary log to get to actual database state. The good practice… it will take less times. Smaller RAID volumes would typically rebuild faster, smaller database size per system (yet another reason to…
Comment: Should we proclaim MySQL Community Edition Dead ?
July 20, 2008 By 34 Comments
Bob, 1) These are the same binaries. ProvenScaling does not rebuild binaries themselves but simply republish enterprise binaries which they allowed to do because… problem is mainly you can’t get MySQL Enterprise Monitor just by itself from MySQL). We use set of open source tools…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… Now back to our question of space requirements for MySQL Backups using LVM. As you can see from …traffic. You can use other techniques to get consistent binary logs in the backup and you do not … Running ALTER TABLE or OPTIMIZE TABLE will cause table rebuild and use a lot of space. Batch jobs such…
Comment: Should we proclaim MySQL Community Edition Dead ?
July 20, 2008 By 34 Comments
Peter> ProvenScaling does not rebuild binaries themselves but simply republish enterprise binaries which they allowed to do because they are distributed under … made by Percona? http://www.mysqlperformanceblog.com/2008/07/16/mysql-releases-with-percona-patches/
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… one of our MySQL support customers as they were upgrading their application and mysql schema. We deployed and used MySQL Master-Master replication… logical replication if tables on master and replica are different. binary log should be a good place to look for these… replication mysql> START SLAVE; db1 will receive the updates that were executed by changes.sql or some other script and rebuild its…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 84 Comments
… Recompile the same version of mysql, with this patch applied (we compile mysql from source ourselves anyway, so…extract the rest of the data from the binary logs, up until the start point. I could… to work acceptably well in our case. It rebuilds the timing, connections, and queries the server saw,…
