… 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… properly link child_A to parent table: 1.0″ encoding=”UTF-8“?>
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… into the target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the…_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE… versions I was using on my test VM: Percona Server 5.5.30 Xtrabackup 2.0.6 Some other use cases that…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… glad to announce the release of Percona XtraBackup 2.1.3 for MySQL on May 22, 2013. Downloads are available from our… Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL Support contracts include support for XtraBackup. We…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… Stack: cman Current DC: percona1 – partition with quorum Version: 1.1.8-7.el6-394e906 3 Nodes configured, 3 expected votes…_MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
… Wednesday, June 5, at 10 a.m. PDT (1700 UTC), I will be presenting a webinar entitled, Choosing a MySQL HA Solution…. We will then explore some of the more well-known MySQL HA tools and technologies available today (largely grouped into those which use traditional MySQL replication, those which use some other MySQL-level replication, and those which replicate at…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…We got decent tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then, since ZFS on … write cache use. Even the fairly slow gzip-1 mode works well. The tpcc database, which contains … ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact …
Post: Private, custom Percona MySQL Training
June 7, 2013 By Leave a Comment
…”] Alexei Rodriguez presenting at PLMCE13[/caption] During the Percona Live MySQL Community Event this year we had the pleasure of Alexei Rodriguez discussing why Evernote uses Percona’s Private Custom MySQL Training. Alexei is VP of operations there and you can…
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… the IDs for movies are distributed uniformly over the range 1..MAX(id)? Yes, there’s a risk if you have…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
…Wrong, it’s still the same in 5.5. Here is the related output from show engine innodb status…struct(s), heap size 440760, 799203 row lock(s) MySQL thread id 38, OS thread handle 0x2b3c1c776940, query id…as SELECT ld.label_id, cai.inventory_id, COUNT(1) as installed_count from client_app_inventory cai …
Post: Percona MySQL University @Portland: June 17
May 22, 2013 By 1 Comment
…, free, fast-paced and very technical MySQL educational event for wide range of people interested in MySQL – Developers, System Administrators, DBAs, etc… speaking opportunities available – if you would like to share your MySQL story at this event please email Matthew Dowell by Tuesday…
