… due to older OpenSSL version. Bug fixed #1183610. If a slave was running with its binary log enabled and then restarted… #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… server (neither master nor slave in replication) and binlog information…
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 catches …of the query The complete method completely rebuilds an MV from scratch at each …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
… be a master, or just a slave somewhere (just be careful not to break replication!). mysql> create schema index_analysis; If our… 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: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… mysql> STOP SLAVE; we don’t want schema changes to be replicated to db1 now. 3. on db2: load the sql scripts $ mysql…. When new changes are loaded: 4. on db2: start replication mysql> START SLAVE; On step #1 MMM should have stopped db1 => db2… replication mysql> START SLAVE; db1 will receive the updates that were executed by changes.sql or some other script and rebuild its tables…
Post: The #1 mistake hosting providers make for MySQL servers
July 25, 2008 By 30 Comments
… gladly install 8 or 16GB of memory for you, but MySQL can’t use it because it runs in a single… about 2.5GB of memory. And then you have to rebuild the whole operating system from scratch. But you don’t… server, set it up as a slave, switch your site to use it, and then rebuild the old server. That 32-bit…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… to switch back and forth between galera and built-in mysql replication (asynchronous) for a given node, it’s not possible… PXC can be a master or a slave on asynchronous replication, galera and built-in mysql replication are independent from each other… show you that during the SST the node is actually rebuilding, also you can force an SST this way (although for…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
…keep table as MyISAM on one or several of slaves and use it for full text search queries. This… text search. In certain cases you can just use MySQL triggers to maintain such table, in other cases this… on the writes. In this case you can just rebuild the table from Innodb source on regular basics. In…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
… Features InnoDB Fake Changes When restarting a slave server in a replication environment, the … 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 …
Post: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
…years back. We wrote about it, other people from MySQL Community too. The situation did not get better, …going to be with failed hard drive (and during rebuild stage), what overhead LVM takes for backup etc. … might need to do something such as getting Slave out of rotation when it is going through …
