…, when the slave is catching up after lagging behind, will become a gentler and gentler slope. Two: deliberately make a slave fall behind, then see how fast it can catch up. This is sort… two replication threads on the slave) to see how much of the time the slave thread was actively processing statements. If the slave threads…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… at once. Among other things, you’ll make replication lag badly. More about this later. Another … server (or if you’re using replication, the capacity of a single slave). Sharding can also help you …, but star schemas are not intended to be fast. The star schema is essentially “I admit defeat …
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…very fast. Often the limiter of how fast this can be restored to another server, is how fast …of restore needed, so it’s important to make this operation as painless as possible. Compressed …point in time Restoring data while automatically replicating out to all slaves mysqlbinlog 5.6 Last year …
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
… the master. Writing to slaves is the #1 cause I have seen for replication problems, so it only makes sense that the tools… be fast, but as it needs to lock the table, long running transactions that lock (part of) the table can make the…_per_table. Q: Does pt-online-schema-change work for fast index drops and creates? Yes, though you may want to…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…instance of MySQL. If nothing else, it makes replicating a subset of the data much easier. >…replicating from a master to a slave, there is no reason why you can’t remove the foreign key references on the slave…pass customer QA – it will work quite fast > with almost empty database. With database …
Comment: Living with backups
November 18, 2008 By 28 Comments
… performing server upgrades… My new backup slave performs the whole backup (~60GB uncompressed … I/O in the Idle was making *both* dd (Idle class) and MySQL (…fast and MySQL starts lagging slightly. – Using CFQ with default class, side read operation is about twice as fast while MySQL replication…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
… InnoDB Fake Changes When restarting a slave server in a replication environment, the process can be… statements and then rollback at commit. That makes prefetch simple but has high overhead from…Alexey Kopytov). After adding an index using Fast Index Creation, statistics for that index provided…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… InnoDB Fake Changes When restarting a slave server in a replication environment, the process can be… statements and then rollback at commit. That makes prefetch simple but has high overhead from…Alexey Kopytov). After adding an index using Fast Index Creation, statistics for that index provided…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… myisam_recover option which will make sure all improperly closed MyISAM … you need to be recovered fast is better solution. Innodb Recovery – …database content. This will sometimes break replication but if you’re just …are most vulnerable. master.info corruption – If slave happens to crash you can …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… similar to a replication slave that is behind. Until it catches up, the view of the data on the slave is “behind” the… easier, it includes a script called ‘convert.php’. This script makes it easy to create incrementally refreshable views from SQL statements… helps you understand how Flexviews can help you ensure fast response times in your application by making access to summary data efficient.
