… huge problems (it’s anyway no longer supported from MySQL 5.5). If you want to know more details, please read on! MySQL… sec) mysql> reset slave; Query OK, 0 rows affected (0.04 sec) mysql> show slave status\G Empty set (0.00 sec) mysql> start… set master-xxx variables in my.cnf! From MySQL 5.5 Starting with MySQL 5.5, the situation has slightly changed. First…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
…. Truncation can block MySQL because the OS serializes access to the inode during the truncate operation. This problem is particularly evident when… practices: /var/mysql/slow_query.log { nocompress create 660 mysql mysql size 1G dateext missingok notifempty sharedscripts postrotate /usr/local/bin/mysql -e ‘select…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…-30.2 milestone at Launchpad. New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey…_list scan in read_view_open_now() which is another problem originally reported as upstream bug #49169. This also provides much… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: What I'm looking forward to at Percona Live (MySQL Users Conference)
April 4, 2013 By 1 Comment
… 10th year attending and speaking at the MySQL Users Conference (as the Percona Live MySQL Conference and Expo was originally called back… the audience I get someone who is aware of the problem and is able to answer it… as opposed to many… about Goal-Driven Performance Optimization and Choosing storage systems for MySQL Do Business. This conference was also been a very successful…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
… that transaction 5 is the one that is causing the problems. Since SQL_SLAVE_SKIP_COUNTER doesn’t work with GTID… is found in Percona Toolkit for MySQL. Last week I gave a talk at Percona MySQL University @Toronto about GTID. It includes an overview of MySQL 5.6 GTID that can…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… our repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. This release of… leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started before running wsrep recovery, this would… online documentation. We did our best to eliminate bugs and problems, but this is a software, so bugs are expected. If…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
….m. Pacific, I’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In… Schema, focusing on new features that have been added in MySQL 5.6, go over the configuration and spend most time… bottlenecks. Other areas of focus include: Bottlenecks with Disk IO Problems with excessive temporary tables and external sorts Excessive internal mutex…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… affects MySQL performance – for every transaction InnoDB creates a read view and allocates memory for this structure from heap. The problem is… and if memory allocator has scalability problems (like allocator from glibc) this will notably slowdown MySQL-transaction creation and many threads will… list causes performance drop = MySQL 5.6.10 – in autocommit mode 5.6.10 has no problem with transaction list scanning (due…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
One major problem in terms of MySQL performance that still stands in the way of InnoDB scalability …, even within the same transaction. Why is that a major problem for MySQL scalability? The scan is performed under kernel_mutex (or… practice. The “trx descriptors” optimization in Percona Server attacks this problem from a different (and a wider!) angle. It requires neither…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…, and MariaDB Galera Cluster), upgrades are fashionable, so to speak. Problem is: “original” pt-upgrade was too noisy and too complex…, general, binary, and tcpdump), so you shouldn’t have a problem finding queries to run and compare. pt-query-digest is… two versions of the DBD::mysql Perl module that have problems. And there are certain versions of MySQL that have critical bugs. Version…
