Great article. Did you do a part 3-6? I did not see them in your posts. I would appreciate an email if you did. Thanks.
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 17, 2013 By 3 Comments
Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572
Comment: MySQL 5.6.7-RC in tpcc-mysql benchmark
June 3, 2013 By 22 Comments
Hy, I’m new to TPC-C benchmarking and i would like to know how and what are the steps for testing MySQL with TPC-C benchmark. My goal is to compare VoltDB and MySQL under TPC-C benchmark. Thanks
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… two in what is now a continuing series on the Star Schema Benchmark. In … challenge to the database optimizer. The SSB benchmark consists of four sets of queries…the hot test, the data fits in the buffer pool and has been loaded by the cold test already. The buffer pool and adaptive hash index are…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… server. Also note that since I created the mysql.properties file in the same directory as the jar file, I don’t need to… the time spent maintaining SchemaSpy to his wife 
Finally don’t forget to automate SchemaSpy via crontab once you’re done. What are some ERD tools you use and how do they compare with SchemaSpy? Feel free to answer via the comments. Thanks…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… 2005!). The report explains more in detail what the “will be disallowed in a future release” means. In MySQL 5.7 the checks will be stricter: in the default… it has the exact column definition in the same order. In other words, it checks for duplicate keys, but not redundant ones. What is the difference… warnings and no errors in 5.6, as the indexes are different. But as you may know, we can use the second index not…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… the server’s functionality with their own code, and this is what the McAffee plugin does. Installation and configuration are straightforward following the available instructions. The… control what is logged by the plugin: – audit_record_cmds : This is the list of commands you want written to the log (all the lists in… events written to the log. Just for reference, these are the lines I had to add to my config file for the plugin to…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… #893860. The log tracker thread was unaware of the situation when the oldest untracked log records are overwritten by the new log data. In some corner cases this could lead to assertion errors in the…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… in this post, along with providing a bit more detail on some of the questions that I did cover during the session. Q: What… over the manual’s description of how replication filtering rules are processed. There are some informative flowcharts in addition to the textual explanation. Q: What is…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… has arrived it is time to plan what you will do over the summer months. In addition to your summer vacation plans, give… is the time to brush up on those critical skills needed to ensure all systems are ready for the holiday shopping season. In addition to our revised courses, that I talked about in a previous post, we are also…
