… and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log with an incorrect… #1171941. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… Debian due to missing libdbd-mysql-perl package. Fixed by adding the package dependency. Bug fixed #1003776. Rebuilding Debian source package would…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…rebuilding secondary indexes on innobackupex –apply-log –rebuild-indexes. This allows parallel processing of individual tables when rebuilding… DBD::MySQL package for server communication instead of spawning the MySQL command … (neither master nor slave in replication) and binlog information wasn’t …
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… the replication method between servers? A: If you would like to switch back and forth between galera and built-in mysql replication (asynchronous… be a master or a slave on asynchronous replication, galera and built-in mysql replication are independent from each other. Q: I installed… show you that during the SST the node is actually rebuilding, also you can force an SST this way (although for…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…. This is conceptually similar to a replication slave that is behind. Until it …of the query The complete method completely rebuilds an MV from scratch at each refresh…155187034 | <-- too high +------------------+ 1 row in set (0.68 sec) mysql> select sum(total_lines) from dashboard_customer_sales ;…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
… just a slave somewhere (just be careful not to break replication!). mysql> create schema index_analysis; If our index_statistics are collecting… droppable_indexes view to use that information: mysql> drop view if exists droppable_indexes; mysql> create view droppable_indexes as select all…_file_per_table, then you can rebuild the tablespace for your table by simply doing: mysql> alter table mytable ENGINE=Innodb; However…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
…When restarting a slave server in a replication environment, the process can be speed up… Kopytov). Bugs Fixed InnoDB requires a full table rebuild for foreign key changes. This unnecessarily delays…KEY. #851674 (Alexey Kopytov). Backported fix for MySQL bug #53761 (Wrong estimate for RANGE query…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… schema or queries. In general cross storage engine replication is not my favorite approach but sometimes it … search. In certain cases you can just use MySQL triggers to maintain such table, in other cases… the writes. In this case you can just rebuild the table from Innodb source on regular basics. …
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… from the Percona Software Repositories). Based on MySQL 5.5.16, including all the bug … When restarting a slave server in a replication environment, the process can be speed up …(Alexey Kopytov). Bugs Fixed InnoDB requires a full table rebuild for foreign key changes. This unnecessarily delays …
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… of our MySQL support customers as they were upgrading their application and mysql schema. We deployed and used MySQL Master-Master replication manager (MMM…: start replication mysql> START SLAVE; db1 will receive the updates that were executed by changes.sql or some other script and rebuild its tables. When replication on db1 has caught-up: 6.2 on…
Comment: Upgrading MySQL
January 17, 2010 By 24 Comments
… are working in a replicated environment) and then upgrade to the newer binaries and run mysql_check followed by mysql_upgrade. That works… ENGINE=INNODB rebuilds the table under 5.1 and MySQL is happy… (why this is not done as part of the mysql_upgrade… replicated environment. It would also be nice if mysql_upgrade finally works for all engine types (within reason), and also if somehow mysql…
