… actual physical volume. So, in effect, you’re adding performance hit to performance hit. The other reason is because virtual machines tend to handle… set up replication filters on the slave, as described in the MySQL manual. You can configure the slave to only replicate a specific…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… Cluster (PXC) for MySQL is a hot thing right now and some …wsrep_certify_nonPK is enabled, you can still hit issues like when automatic creation of primary …performance is somewhat dependent on the slowest node – this overhead can easily become visible on the whole cluster and your async replication…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance…
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
… complex situations which happen with databases such as performance problems, running out of connections and so …person to check what is going on and hit the button to initiate failover. Lets say … are very good. When we apply them to MySQL replication we can use these simplified principles – we only…
Post: What is innodb_support_xa?
March 2, 2011 By 3 Comments
… and performance research on this option in the past (see also: post 1, post 2). This was motivated by the severe performance hit… the second is important for replication. However, it is not as simple as “if you want higher performance, disable innodb_support_xa… flushes and get better InnoDB performance. Having innodb_support_xa enabled on a replication master—or on any MySQL server where binary logging…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… want to see what sort of performance we can see compared to MySQL and Memcached, and later …but native support is lacking. It does support replication which could make some rather interesting architectures … Also interesting is I started to hit bottlenecks in MySQL/Innodb when I had enough memory …
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… a second as they can also be a performance killer for a busy application. Recently I have …: 56 Rows_examined: 1113 LOGGING OF THE REPLICATED STATEMENTS Normally MySQL will not write into slow log any …Disk_filesort: No Merge_passes: 0 QC_Hit tells whether query cache hit occurred or not. If it says …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…database About the cluster For best performance, there should be an even … 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘…”shard1″. Now, in the EC2 console hit CTRL-A to select all …-recovery-update-relay-log innodb-replication-delay=# innodb-rollback-on-timeout …
Comment: Thoughts on MySQL Replication
July 16, 2006 By 18 Comments
… makes great addition to MySQL replication, however it is not alternative if you’re also looking for increased performance, not only high availability… partitioning and having different languages in different replication groups otherwise at some point in time replication will not be able to keep… users which can be served by caching proxies not even hitting web servers. Language provide very good partitioning as there is…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
MySQL Server has tons of variables which may be adjusted to change behavior or for performance purposes. …is MyISAM related. expire_logs_days This is replication/binlogging related options – when to delete binary logs… or anything like it to make sure data hits the disk ft_boolean_syntax, ft_max_word_…
