…drop in replacement for MySQL, downloads are available here and from the Percona Software Repositories. Based on MySQL 5.1.69, this release will…the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other accounts efficiently…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 4 Comments
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication…# Summary of indexes # ######################################################################## # Size Duplicate Indexes 9 # Total Duplicate Indexes 1 # Total Indexes 2 By the way, if…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… for the test (5.5.28-29.1). This is needed as the plugin needs the offset to some MySQL data structures that, the… this socket and process the audit records as you wish. Performance-wise, I did basic tests on the VM I was… advantage of the plugin is its flexibility, and not its performance, which seems to be on par with having the general…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… focused on MySQL 5.6 GTIDs. You can find part one here. Our goal will be to go from setup #1 to setup… to s2. This scenario can happen when you want to perform a planned failover. With GTIDs, all the operations are straightforward…_auto_position=1; s0> start slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the… InnoDB. SSB Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB when the database is cold… almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…-NIC bonded pair you’ll get roughly 1.67x the throughput of a single port. [… my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, … 5.6), is that I question its readiness. There have been some unfortunate performance regressions compared to 5.5…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… correctly. We got decent tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then, …write cache use. Even the fairly slow gzip-1 mode works well. The tpcc database, which …very interesting solution for MySQL backup servers. All backup solutions have an impact on performance with ZFS …
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
… /var/lib/mysql/ib_logfile* -rw-rw—- 1 mysql mysql 536870912 May 21 22:23 /var/lib/mysql/ib_logfile0 -rw-rw—- 1 mysql mysql 536870912 May 21 22:23 /var/lib/mysql/ib…_now_faster And from the manual: http://dev.mysql.com/doc/refman/5.5/en/innodb-performance-recovery.html “If you kept the size…
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 as alpha… later evolved into “MySQL Enterprise,” and MySQL 5.0 is finally available as GA with version 5.0.20a… MySQL 5.1 is in development (5.1.9) 2007… version, MySQL 5.1 is FA with 5.1.34 and MySQL 5.4.0 is in a nonGA version. The MySQL Enterprise model is changed… now MySQL Community…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…MySQL version 5.5.30-30.2[/caption] Percona is glad to announce the release of Percona Server for MySQL 5.5…MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance… was incompatible with automake 1.12. Bug fixed #1099387…
