… RPM based or other packaged MySQL Binary you may have a problem if you would like to rebuild binary for some reason – change some… you would like to keep the same as in original binary to minimize the change and finding this was not pleasant…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… refeshed. The incremental method is somewhat conceptually similar to using mysql binary logs for point-in-time recovery after a restoring a… based. The cost of the query The complete method completely rebuilds an MV from scratch at each refresh. This means that… is actually quite simple in its operation. It will completely rebuild a view based on the SQL which defines it, each…
Post: MySQL Releases first real Community Release
March 18, 2007 By 2 Comments
… for production servers, which is effectively rebuild of RedHat Enterprise Version. Community Version of MySQL has all chances to be as stable… MySQL applies reasonable quality assurance to accepted code. What is about binaries ? MySQL 5.0.37 was rare exception of community release with binaries and if MySQL follows its promises we…
Post: New MySQL Community Release Policies published
August 9, 2007 By 9 Comments
… main issue for me is Change policy for MySQL Community version. We are patching MySQL with minor extension so this concerns us… to mention as Source Tree is available you can rebuild and rename binaries same as CentOS does for RedHat Enterprise Linux. Dorsal… you can pick up the choice of binaries already. There is always and argument MySQL is Commercial Company and has to make…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
Dealing with MySQL you might need to deal with RAID recovery every so … backup setup only takes you to the point where last binary log was backed up. I wanted for a chance to… for a way to tell mdadm to change status of rebuilding drive into “failed” and removed in “active sync” but I…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
…). Bugs Fixed InnoDB requires a full table rebuild for foreign key changes. This unnecessarily…851674 (Alexey Kopytov). Backported fix for MySQL bug #53761 (Wrong estimate for … please see the following links: Downloads: Binary distributions, Percona Software Repositories Installation instructions …
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
…the Percona Software Repositories). Based on MySQL 5.5.16, including all the…Kopytov). Bugs Fixed InnoDB requires a full table rebuild for foreign key changes. This unnecessarily…, please see the following links: Downloads: Binary distributions, Percona Software Repositories Installation instructions …
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
… (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 23 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…
