…. 2. OmniOS rocks. It is the only stable illumos distro designed for server usage, and it can be bought with an…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… 5.6, migration planning, and application verification. This class was designed with the experienced MySQL DBA in mind–so it is…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… both HTML links and entity-relationship diagrams. It’s also designed to help resolve the obtuse errors that a database sometimes…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…. The query optimizer analyzes queries for common patterns the MySQL designers know can be improved. But there’s a finite amount…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… a fundamental (and in my opinion bad) part of the design of MySQL 5.6 global transaction ID. In general, there…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
…, because MySQL 5.6 GTID is fundamentally broken in the design. You don’t want to be compatible with it. I…
Comment: Be careful when joining on CONCAT
May 24, 2013 By 16 Comments
…+acc.number+sufix country number (3 separate columns that by design can only be separate). And cast or convert isn’t…
Post: Webinar: Best Practices for MySQL Scalability on May 1
April 30, 2013 By Leave a Comment
…, hardware, operating system, MySQL version, MySQL configuration, schema design and indexing, and query design. To avoid having any one of them become…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…. vCache vs. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… software, which is a kernel module and set of utilities designed to provide functionality similar to that of FlashCache. In particular…
