… to go through these basics. log_slave_updates is REQUIRED You need to have log_slave_updates enabled on the cluster node acting… will not be written to the slave’s binary unless log_slave_updates is enabled, this is similar to Percona XtraDB Cluster in… because the storage engine is non-transactional and so PXC cannot guarantee the data will remain consistent within the cluster. Also…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… database configuration, specifically you need to enable slow logging (see Configuration section for details). Then rename the binary, which can be safely done… option which you cannot change at runtime from MySQL console wit SET or SET GLOBAL command. log_slow_filter=name Log only the…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…binary log breaking locking semantics and contrary to serialization concepts. For example take a look at the following excerpt from the binary log…the transaction, hence any DDL operation cannot commence till all the transactions … important question. If Query Cache is enabled and the SELECT can be …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… of the analysis for last. You cannot consider any one of these factors (schema, …log, is one of the more fruitful ways to analyze the system. What I usually do is ask the client to enable…binary, we can use MySQL Proxy, packet sniffing, or other techniques to get more information than the slow log…
Post: Announcing Percona Server 5.5.25a-27.1
July 21, 2012 By Leave a Comment
…secure-file-priv option so it cannot execute this statement”. LOAD DATA… Server would crash if userstats were enabled with any replication configured. This… directories in 32bit and 64bit binary tarballs. Bug fixed #1007271 (Ignacio … (Stewart Smith). Fixed typo for log_slow_verbosity in the code….
