… _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT… _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF For full disclosure, here are the versions I…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… on the same machine if you use the BLACKHOLE storage engine) in between the actual master and the slaves at the…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… can be improved. But there’s a finite amount of engineer-years spent developing and testing the query optimizer. The developers…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…, PRIMARY KEY (`id`), KEY `col2` (`col2`), KEY `col2_2` (`col2`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.00…, pt-duplicate-key-checker will detect subtle redundancies that are engine-dependent, like redundant suffixes for secondary keys in InnoDB. As…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… Connection ID (thread ID): 3 Status: NOT_KILLED You may download the Percona Server operations manual by visiting http://www.percona…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
… cost of the others, the resulting system may be over-engineered, poorly-performing, and/or various other flavors of suboptimal. On…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… it is a copy on write filesystem, the snapshots are free, no performance penalty. You can easily run a server with… the impact is up front and the backups are almost free.
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… in 5.5. Here is the related output from show engine innodb status: —TRANSACTION BB0E42A, ACTIVE 3 sec fetching rows, thread…
Post: Percona MySQL University @Portland: June 17
May 22, 2013 By 1 Comment
… moved to the area. Percona MySQL University is a daylong, free, fast-paced and very technical MySQL educational event for wide…
Comment: How to calculate a good InnoDB log file size
May 22, 2013 By 38 Comments
…_logfile* && date && mysql -BNe’show engine innodb status\G’ | grep sequence && sleep 60 && date && mysql -BNe’show engine innodb status\G’ | grep sequence && ls…
