… Server for MySQL version 5.1.69-14.7[/caption] Percona is glad to announce the release of Percona Server 5.1.69-14.7… 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 3 Comments
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: 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: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… InnoDB. SSB Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB when the database is cold…. It seems that InnoDB performs better when a larger number of rows must be joined together (Q4.1, Q4.2) but worse… 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
…with a two-NIC bonded pair you’ll get roughly 1.67x the throughput of a single port. [Don’t …being able to retract them. MHA should work fine with 5.6 if you’re not using GTID-based replication. …you ever want to use MySQL on top of something like that? I can’t imagine the performance being all that …
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 …
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…
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: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
…. This time I want to target an opposite question: why MySQL performance at low concurrency is important for you. I decided to… posts and articles look at MySQL performance starting with certain concurrency as the low point. For example, MySQL 5.6 DBA and Developer Guide… would love to see results published starting from concurrency of 1 if possible so we can see the full picture. In…
