… size for fast index creation…makes a proxy (ie HAProxy) capable of monitoring Percona XtraDB Cluster nodes properly. Bugs fixed: Increasing the number of slave threads doesn’t require provider reloading anymore. Bug fixed #852094. No other SQL statement except INSERT…SELECT would replicate…
Post: devops webinar - follow up Q&A
November 6, 2012 By 5 Comments
… don’t want to receive alerts if replication is lagging on a slave used for backup for example is to … be equivalent. A full table scan could be very fast on a table of 1M but when the table … that removes a column, moving the database first would make the old code break. How would you overcome this? …
Comment: Innodb Performance Optimization Basics
April 29, 2008 By 75 Comments
… set up replication such that the MASTER database does not have any indexes (except those required for updates), and the SLAVE has all the required indexes for the web clients? This should theretically get faster inserts/updates on MASTER, and fast retrievals on the SLAVE. Please advise. 2- How much of a difference does it make to have the MySQL…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
….1.0 (rev. 83d8f3af176e1698acd9eb3ac5174700ace40fe0). Fast InnoDB Checksum feature has now …Mark Callaghan, Laurynas Biveinis). Crash-resistant replication would break with binlog XA…transaction would not have the slave position recorded and thus …, when set to FALSE, makes fake transactions not to …
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… the time. Happily inserts in MyISAM are rather fast so it rarely is the problem The other …statistical data. Data on slave servers. If it crashes you can simply re-clone it. Make sure however to have at least one proper master to fall back to. Also be worried about replication …
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
…into the binary log. While this is generally a fast way to load data (especially if you disable …and slows replication down. If the load takes 4 hours on the master, it will cause the slave to fall…have to clean these up. This is how you make InnoDB behave like PostgreSQL 
If the undo log space…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… pages == 1 MB. Then a full table scan would be fast. Maybe the table has become fragmented? Or maybe you have… reorganizing that table on a separate computer, maybe a replication slave. Can you make the reorganization run in a tolerable time? PZ: Indeed…
