… percona3 Master/Slave Set: ms_MySQL [p_mysql] Masters: [ percona2 ] Slaves: [ percona3 ] Stopped: [ p_mysql:2 ] After the update and after fixing some small…/cluster/cluster.conf –addnode percona3 Node percona3 added. we need then to delegate the fencing to pacemaker (adding a fence device…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it,…key solution for random selection only work when the IDs for movies are distributed uniformly… certain insert/update/delete operations. If you have a dataset that changes infrequently, then this might…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…) is tested with a cold buffer pool. Then the query is tested again without restarting the…when the working set fits in memory, InnoDB almost always performs better, at least for this workload. Notes MySQL…links=0 innodb_stats_persistent innodb_stats_auto_update=off [mysqld_safe] log-error=/var/log/…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… (PXC) for MySQL is a hot thing right now and … basics. log_slave_updates is REQUIRED You need to have log_slave_updates enabled on the…you still have tables without PRIMARY KEYs, then its time to make one for them….enabled, you can still hit issues like when automatic creation of primary keys for use…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… (bug 1024001) * pmp-check-mysql-replication-running reported OK when a slave is in “Connecting” state (bug 1089506) Update note: Cacti templates have to be re-imported together with the updating of ss_get_*.php scripts. Then make sure…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…with an empty transaction list when creating read views. However, … the results difference. We then compared results across all … –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock …-index-updates=0 –oltp-non-index-updates=0 run POINT_SELECT + UPDATE QPS…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… only one more bug fix release (as 2.1.10) then retire. 2.2 is largely backward-compatible with 2.1… written once long ago and not updated since. Now that we have four base versions of MySQL (5.0, 5.1, 5… for updates, but it’s also more: it’s a free service from Percona that advises when certain programs (Percona Toolkit tools, MySQL…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… (within a single connection) anywhere in any ‘free’ variant of MySQL. PARTITIONs are scanned one at a time. (Please provide specific…, UPDATE) are similar in speed between PARTITIONed or non-PARTITIONed. When PARTITIONed, first it has to find and open the required partition, then… also BTrees, so they need updating (although delayed). Yes, their BTrees may be one level shallower when partitioned, hence slightly faster. Conclusion…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…spend time on it internally for every update, or pay for some else to … changes) it’d become impossible. And then it’s a dead piece of … is classic MySQL replication, which was implemented by Sasha Pachev at MySQL AB around …out that entire chunk of code when working on Drizzle. Stored Procedures have …
Post: Distro Packages, Pre-built Binaries or Compile Your Own MySQL
September 4, 2012 By 7 Comments
…. Running MySQL with pre-built binaries is seldom to run into dependency problems, but then you also have to be careful when running… can be as easy as stopping MySQL, updating symlinks or your my.cnf basedir, starting MySQL and running mysql_upgrade. Unlike package managers, you do not have to worry about accidentally updating from one version…
