…of improvements available in MySQL 5.6 which I…logs support Optimizer and Execution – Index Condition pushdown (ICP) – Multi-Range-Read (MRR) – Faster ORDER BY nidxcol LIMIT… Replication Event Checksums – Time Delayed Replication – Server UUID – Improved Logging for Row based Replication – Replication…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…mysql server, no replication setup) [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql server-id=1 #replicate-same-server-id=0 log…query_cache_limit = 254M …log-slow-queries = /var/log/mysql-slow-query.log # Default to using old password format for compatibility with mysql…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… that mean a 0.25 as from logs can be an issue ? A: My demo … despite the response time limitations. Even with parallel replication, the response time limits the number of transactions / … or a slave on asynchronous replication, galera and built-in mysql replication are independent from each other. Q…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 7 Comments
… result in low hanging fruit troubleshooting MySQL Replication Lag First fact you absolutely need to remember is MySQL Replication is single threaded, which means… write query it clogs replication stream and small and fast updates which go after it in MySQL binary log can’t proceed. It… ? Use Query Chopping – this can be running update/delete with LIMIT in the loop, controlling maximum amount of values per batch…
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
…Control The control environment was simply a Master with log-bin enabled and one slave connected (not semi-… cluster contained the tuning: wsrep_provider_options = “gcs.fc_limit = 256; gcs.fc_factor = 0.99; gcs.fc…high availability and disaster recovery than semi-synchronous replication in stock MySQL…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…instead of how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be …not have to replicate everything 
There are also cases when storage size becomes the limit rather than number…for Operating system and another one for Transactional Logs you will often wast 4 hard drives …
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…HEAP for in memory tables. So first MySQL versions did not bother naming variables …be badly corrupted on crash. delayed_insert_limit, delayed_insert_timeout, delayed_queue_size Delayed …related. expire_logs_days This is replication/binlogging related options – when to delete binary logs from master….
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… drift. This is conceptually similar to a replication slave that is behind. Until it catches …method is somewhat conceptually similar to using mysql binary logs for point-in-time recovery after a… from orders: mysql> delete -> from order_lines -> where order_id -> between 1 and 100 -> limit 500; Query…
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
… everything would like, moreover you might have limited information about how exactly things are set… to detect the problem report in the logs what decisions it would take but rather… availability solutions for MySQL such as Clustrix, Tungsten Replicator, PRM, Percona XtraDB Cluster, MySQL and DRBD as…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… storage format so MySQL has to do a lot of copying and conversions while accessing the data, which significantly limits performance compared… cases. Replication Support for different storage engines is a pain in replication. To start we have to write second binary log file when… dictionary instead of Innodb files. We would use Innodb transactional log for replication (which could be extended a bit for this purpose…
