… called SchemaSpy. SchemaSpy is a Java-based tool (requires Java 5 or higher) that analyzes the metadata of a schema in a… Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql-connector-java.jar Example Schema CREATE TABLE `parent` ( `parent_id` int(10) unsigned NOT NULL AUTO…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
… be over-engineered, poorly-performing, and/or various other flavors of suboptimal. On Wednesday, June 5, at 10 a.m. PDT (1700 UTC), I will be presenting a webinar entitled, Choosing a MySQL HA Solution, in… use cases where a given approach may be well-suited or particularly contraindicated. If this topic interests you, then register today…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB…}.{QUERY_NUMBER}. In general, each flight examines different time periods or different regions. The flights represent the type of investigations and…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 4 Comments
… release of Percona Server 5.1.69-14.7 on June 10, 2013. A drop in replacement for MySQL, downloads are available here and from the Percona Software Repositories. Based on MySQL 5.1… this could lead to assertion errors in the log parser or bad changed page data. Bug fixed #1108613. Percona Server wouldn…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…to clone a server (for replication or migration) or migrate an existing schema to …statements for steps 7 and 10 in two scripts: mysql -N -B <<'EOF' > …on my test VM: Percona Server 5.5.30 Xtrabackup 2.0.6 …with –replicate-rewrite-db Daily backups from production to staging with different db names (i…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…write load of all the MySQL instances. The original idea was to configure them with raid-10 + LVM, making sure to… We got decent tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then, since ZFS on …will still be working. Also, instead of having 1 or 2 spare drives per controller, I have 2 …
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… pleased to feature 10 technical talks by members of Team Percona as well as local members of the MySQL Community: Vadim Tkachenko…, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson, a member of Percona’s RemoteDBA team…… 
So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… regressions compared to 5.5, such as bug #69258, and bug #69318, and I think it might take one or two more point… mounted, and went to try to install MySQL. It failed miserably on the mysql_install_db process. Every time I tried, I got…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I saw…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… also running our new Moving to MySQL 5.6 class. This class covers new features in MySQL 5.6, migration planning, and application verification… summer MySQL training schedule. In June we have: Moving to MySQL 5.6 – Austin, TX Begins Monday, June 10, 2013 , 9am – 5pm Moving to MySQL 5… August we have: Moving to MySQL 5.6 – Miami, FL Begins Monday, August 5, 2013 , 9am – 5pm Moving to MySQL 5.6 – Minneapolis, MN Begins…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a… the small but handy improvements – changes and bug corrections – in MySQL 5.6 that can make our lives easier and have passed… try to do something like this in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE test ADD INDEX (col2); Query…
