…running with its binary log enabled and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log with …Debian due to missing libdbd-mysql-perl package. Fixed by adding the package dependency. Bug fixed #1003776. Rebuilding Debian source package …
Post: Rebuilding MySQL Binary
November 16, 2006 By 2 Comments
… RPM based or other packaged MySQL Binary you may have a problem if you would like to rebuild binary for some reason – change some… scalability and Vadim’s patches to get proper slow query log). There are number of things as default paths and GCC… 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 20 Comments
… refeshed. The incremental method is somewhat conceptually similar to using mysql binary logs for point-in-time recovery after a restoring a backup… changes that have happened in the database, instead of replaying binary logs directly. Selecting a refresh method The refresh method you select… based. The cost of the query The complete method completely rebuilds an MV from scratch at each refresh. This means that…
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 write… for a way to tell mdadm to change status of rebuilding drive into “failed” and removed in “active sync” but I…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… to our question of space requirements for MySQL Backups using LVM. As you can …binary logs, slow query log, general query log etc, if they get any serious traffic. You can use other techniques to get consistent binary logs… TABLE or OPTIMIZE TABLE will cause table rebuild and use a lot of space. …
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 to… it will take less times. Smaller RAID volumes would typically rebuild faster, smaller database size per system (yet another reason to…
Post: MySQL Releases first real Community Release
March 18, 2007 By 2 Comments
…In fact we have submitted our slow query log with microseconds patch so we’ll see …, which is effectively rebuild of RedHat Enterprise Version. Community Version of MySQL has all chances to …is about binaries ? MySQL 5.0.37 was rare exception of community release with binaries and if MySQL follows …
Post: Feature preview: Compact backups in Percona XtraBackup
January 29, 2013 By 11 Comments
… it takes time. The command to prepare is: innobackupex –apply-log –rebuild-indexes /data/backup As a bonus, secondary indexes are created… may result in an additional space saving. In fact this –rebuild-indexes can be used on a full backup, and it….launchpad.net/~percona-core/percona-xtrabackup/2.1, but preview binaries should be available soon.
Comment: Slow Query Log analyzes tools
June 10, 2008 By 84 Comments
… log without restarting mysql – i moved the log file aside, touched a replacement, but didn’t give the mysql…extract the rest of the data from the binary logs, up until the start point. I could … It rebuilds the timing, connections, and queries the server saw, based on the contents of query log – …
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… Software Repositories). Based on MySQL 5.5.16, including… Fixed InnoDB requires a full table rebuild for foreign key changes. …Log did not log the error number correctly. #830199 (Oleg Tsarev). Variable log…see the following links: Downloads: Binary distributions, Percona Software Repositories …
