… joins or leaves the cluster. Seeing high values here may indicate you have nodes frequently dropping out and rejoining the cluster…/F) for wsrep_ready and wsrep_connected. These are somewhat redundant with the local_state value, so I may remove them…) queue is inbound replication. Positive values here can be an indicator that this node is slow to apply replication writesets. Ops…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult… because they’re in Locked status, which might be an indication that it’s time to convert MyISAM tables to InnoDB… checking for default users in the mysql.* tables, running mk-duplicate-key-checker to find redundant indexes, and so on. As with…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
…% reduction when the TEXT field was compressed which we felt indicated there would be a benefit derived from table compression. With… default after MySQL 5.0.3 and has a more compact representation for nulls and variable-length fields than REDUNDANT. Using InnoDB’s new Barracuda file format (available since InnoDB plugin 1.1 or MySQL 5.5) you…
Post: Finding out largest tables on MySQL Server
February 4, 2008 By 27 Comments
Finding largest tables on MySQL instance is no brainier in MySQL 5.0+ thanks to Information Schema but I still wanted … data size often indicates there is a lot of indexes (so it is well possible there are some duplicates, redundant or simply… whatever database you have active. It does not work with MySQL before 5.0 still of course 
