… in the questions our MySQL Support customers ask is MySQL Replication Lag. The story is typically along the…MySQL is doing to IO going to devices from OS standpoint. If this is external and not recorded…- some may see only modest slowdown when data doubles, while in other case 10-20% difference in…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
…replication or on estimating replication capacity, I don’t think we have one that covers the very basics of how MySQL replication…records, sort of row diffs if you will But other than that, I won’t be going back to differences in replication… double check. You can do that by comparing the replication…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… doubling. It is also rather interesting how is sort file structured for building the indexes – does it uses dynamic or static record… born same as bunch of others due to statement level MySQL Replication which among other requirements, needs all auto-increment values in… have the problems because they target at least MySQL 5.1 with row level replication readily available. Speaking about community items the…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… need to know the whole record R. Also, a gzip …replication, and remember that the execution is not serializable. PZ: Cool. This is one of little known new features in MySQL…double buffering. In distant future, I would like to have the memlock also. PZ: memlock already works – it is global MySQL…
Comment: MySQL Partitioning - can save you or kill you
June 28, 2012 By 45 Comments
… base mysql version (5.1.56) supports partitions, but does not support partition pruning. 3. The records…4. The underlying disk partition is DRBD, with replication to a second standby server for failover.. … the Database and So, RAM would be doubled and processor cores increased (new server).. Another…
