The ERD tools I use are MySQL Workbench and SchemaSpy. The anomalies tab of SchemaSpy has been quite helpful. However both tools can’t really cope with really large schemas.
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona is glad… available here and from the Percona Software Repositories). Based on MySQL 5.6.11, including all the bug fixes in it… #1177780, bug fixed #1154954. Release notes for Percona Server for MySQL 5.6.11-60.3 are available in our online…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still… queries. The query optimizer analyzes queries for common patterns the MySQL designers know can be improved. But there’s a finite…-12, 2013. We also look forward to the Percona Live MySQL Conference and Expo in Santa Clara, California starting March 31…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; Those of you who… try! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the…. This can even be made easier with mysqlfailover from the MySQL Utilities (this will be the topic of a future post…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… server can easily handle the write load of all the MySQL instances. The original idea was to configure them with raid… together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using… almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a… slave status\G [...] Auto_Position: 1 -> GTID-based positioning # Slave #2 mysql> show slave status\G [...] Auto_Position: 0 -> File-based positioning Conclusion…
Comment: Performance Schema overhead
June 12, 2013 By 22 Comments
Great test and report Vadim! I think the performance schema will be a great addition to MySQL once it’s more established. Just starting with MySQL after retiring from handling oracle databases – now volunteering 
Thanks for sharing.
Comment: Converting Character Sets
June 12, 2013 By 22 Comments
… correct. There was no truncation: MEDIUMTEXT is bigger than TEXT. MySQL does this to make sure there’s *no* truncation, as explained in the manual – http://dev.mysql.com/doc/refman/5.1/en/alter-table.html “For…
Comment: Impact of logging on MySQL’s performance
June 11, 2013 By 8 Comments
… large (but not necessarily slow) queries. It’s a good tool but it should only be used when needed, and that…
