…: What is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based on what I… response back in a reasonable (what is reasonable is determined by your environment), it’s a safe bet that MySQL is up and running. That… involved if that’s what you need. Q: What MySQL HA solution is most similar to Oracle RAC? A: Oracle RAC is a “shared everything…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1831 Message: Duplicate index ‘col2_2′ defined on the table ‘test.test’. This is… report explains more in detail what the “will be disallowed in a future release” means. In MySQL 5.7 the checks will… keys, but not redundant ones. What is the difference? Let’s see an example. If we execute: mysql> ALTER TABLE test ADD INDEX…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… post is part two in what is now a continuing series on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…
Comment: Profiling MySQL Memory Usage With Valgrind Massif
June 5, 2013 By 3 Comments
…. I was wondering – what is the performance penalty of running mysqld (or any other program) under Massif/Valgrind ? It is probably going to…, but I wonder if it’s like barely noticeable or is it more like you-don’t-run-that-in-production…
Comment: Experiences with the McAfee MySQL Audit Plugin
May 29, 2013 By 4 Comments
Fernando, And what is about it (most confusing option): audit_offsets=6464, 6512, 4072, 4512, 104, 2584
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… is time to plan what you will do over the summer months. In addition to your summer vacation plans, give thought to MySQL… the experienced MySQL DBA in mind–so it is a fast paced 2-day course. Percona has a packed summer MySQL training schedule. In June we have: Moving to MySQL…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… Creating a mysql.properties file While not explicitly required, I prefer to create this once so that the command line is shorter… is the properties file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql… forget to automate SchemaSpy via crontab once you’re done. What are some ERD tools you use and how do they…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… Server for MySQL version 5.5.31-30.3[/caption] Percona is glad to announce the release of Percona Server for MySQL 5… on MySQL 5.5.31, including all the bug fixes in it, Percona Server 5.5.31-30.3 is now the…-5615 vulnerability. This vulnerability would allow remote attacker to detect what user accounts exist on the server. This bug fix comes…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… you’re in the Portland area and work with MySQL, then this is an event you can’t afford to miss… 
So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the ideal of Percona MySQL University and…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…=”alignright” width=”247″] Percona Server for MySQL version 5.1.69-14.7[/caption] Percona is glad to announce the release of… on MySQL 5.1.69, this release will include all the bug fixes in it. All of Percona’s software is open… #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on…
