…much larger than table itself) The index build speed is however not only reason I can’…as bunch of others due to statement level MySQL Replication which among other requirements, needs all auto-…of “Gotches” while many of them come from MySQL limits at the time when Innodb was first implemented….
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
…, which highlighted replication could be the limiting factor for this system quite soon, so I decided to check what is limiting MySQL Replication speed. My first idea was to check it based on slow query log, happily the server was running MySQL with…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…checking your progress along the way. There is no limit as Safe you can get so I would …queries with good speed is not enough. You also need to perform stress testing to ensure both MySQL does …want to minimize downtime it is best to use MySQL Replication for upgrade. Once you have setup slave with …
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… you would not have to replicate everything 
There are also cases when storage size becomes the limit rather than number of IOs… BoardReader for example we’re limited by space and how much data we can comfortably put in MySQL Instance without getting in… example these 50 drives will unlikely be helpful solving replication delay or speeding up this 3 hours reporting query or 5 hours…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
…_file_per_table=1 your recovery speed will depend on number of Innodb … database content. This will sometimes break replication but if you’re just planning … dictionary may cause MySQL to fail with wierd error messages. In MySQL 4.1 … might run select 1 from _table_ limit 1 for each table or any other…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
… a slave server in a replication environment, the process can be speed up by having prefetch … yet suited for production environments. This feature limits the age of idle |XtraDB| transactions. If … KEY. #851674 (Alexey Kopytov). Backported fix for MySQL bug #53761 (Wrong estimate for RANGE query …
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
…and from the Percona Software Repositories). Based on MySQL 5.5.16, including all the bug …restarting a slave server in a replication environment, the process can be speed up by having prefetch …not yet suited for production environments. This feature limits the age of idle |XtraDB| transactions. If …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… if the page data size drops below this limit, merging it to a neighbor is tried */ #define…replication, and remember that the execution is not serializable. PZ: Cool. This is one of little known new features in MySQL…so that we can see the full write speed of the disk for throughput. INNODB uses …
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… buffered already. This means your backup speed can be slower than you … our question of space requirements for MySQL Backups using LVM. As you can…need 10GB of undo space. Second, limit batch activities – Backups are often …and you would like to setup replication for large database with little no -…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
…_log_file_size – This depends on your recovery speed needs but 256M seems to be a good …=8 Even with current Innodb Scalability Fixes having limited concurrency helps. The actual number may be higher …0 and even more to come with MySQL 5.1 and row level replication. There are bunch of other …
