…-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other accounts efficiently. This… log system mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Missing path separator… #1153651. Release notes for Percona Server for MySQL 5.1.69-17.4 are available in our online documentation. Bugs can be…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… of a series of articles focused on MySQL 5.6 GTIDs. You can find part one here. …s2. This scenario can happen when you want to perform a planned failover. With GTIDs, all the operations …-0800272864ba:1 or 3d3871d1-c3ae-11e2-b986-0800272864ba:4 ? A ‘Last_Executed_GTID’ column would have been useful…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… actual physical volume. So, in effect, you’re adding performance hit to performance hit. The other reason is because virtual machines tend… you want two identical physical boxes with at least 4 NIC ports. Why 4? Two of those NICs should be directly connected… that’s using 5.6), is that I question its readiness. There have been some unfortunate performance regressions compared to 5.5, such as…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… substantially faster than InnoDB both cold and hot. SSB Flight #4 There is one query in this flight, Q4.3, which… operations and is not ACID compliant. MyISAM and InnoDB may perform differently under concurrency, which this benchmark does not cover. I… almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
…; “High Performance MySQL” 1st edition written by Jeremy and Derek was also available. MySQL 4.0.18 was GA and 4.1.1… the Drizzle project participates in the conference. Percona runs Percona Performance Conference as a free event going concurrently with the conference… MySQL Alternatives including keynotes for Drizzle and MariaDB. MySQL 5.5 replaced MySQL 5.4 as next planned GA release. Percona releases GA version…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. This release of Percona… it and on Codership wsrep API 5.5.30-23.7.4, Percona XtraDB Cluster 5.5.30-23.7.4 is now the current stable…-source and free. Release notes for Percona XtraDB Cluster 5.5.30-23.7.4 are available in our online documentation. We did…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…,mid,id) ). Also please note the transaction produces 4 INSERTs and workload is very write intensive. …InnoDB and TokuDB performs if PK is (`id`,`hid`,`mid`). This also will affect select performance, so we…safe] numa-interleave malloc-lib=/usr/local/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/lib…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…device. EXT4 is the filesystem, and CentOS 6.4 the operating system, although the pre-release …. The benchmark tool used was sysbench 0.5 and the version of MySQL used …config) which shows the most consistent performance. The others all have assorted performance drops scattered throughout the graph. …
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
Swapping has always been something bad for MySQL performance but it is even more important for HA systems. It … 27143 27637 8 7 80 5 0 Fri Mar 22 10:03:28 UTC 2013 1 4 291992 219104 138832 7262820 0 0 174854 160 18893 17002 6 5 83 6 0 Fri…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… hoc query leads to scanning the entire last two partitions, performance is not bad. (The last 2-3 partitions tend to… like this is being fixed in 5.6; not sure about Percona or MariaDB. (Re #4) There are _no_ parallel queries (within…) table will, at worst, hit the disk only 5 times. (Usually 4 of the 5 are cached from previous queries.) (Re #2) I…
