… TABLE `’, table_name, ‘` DISCARD TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF... TABLE `', table_name, '` IMPORT TABLESPACE;') AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF For full disclosure, here…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… any bitmap files. Bug fixed #1184427. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… write-intensive workloads. Bug fixed #1171699. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…/schemaspy driverPath=/usr/share/java/mysql-connector-java.jar Example Schema CREATE TABLE `parent` ( `parent_id` int(10) unsigned NOT NULL…, I don’t need to pass any host:port or schema name information. Viewing SchemaSpy output A completed Relationships view of these… value. This is basically a quick sanity check of your schema for any significant errors or items requiring review. Columns – a…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
… be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In this Webinar I will offer an overview of Performance Schema, focusing on new features that have been added in MySQL… most time showing how you can use the wealth of information Performance Schema gathers to understand some of the typical performance bottlenecks…
Comment: Mass killing of MySQL Connections
April 10, 2013 By 30 Comments
@Alon, You have a typo. Should be information_schema.processlist
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… server’s caches hot. (See my Fosdem 2013 slides for information about discarded designs and benchmarks.) First, we set long_query….0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread-pool –thread-pool…
Comment: Webinar: MySQL 5.6 Performance Schema
May 16, 2013 By 5 Comments
… watched some of the recorded webinar and it is very informative but I would also like to have a copy of… reference/search in directly while trying out the MySQL Performance Schema tool myself. Thanks for your help 
Zoe
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… great maxim that really helps encapsulate a lot of this information and puts it into context with your application workload: [In… SET count = $last_count where achievement = ‘killed_troll’”; } change your schema In Example 2, above, how above moving the ‘joined’ column…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… a server or database upgrade, change in my.cnf or schema change can affect the overall performance of your MySQL database… hardware against existing setups to allow users to make an informed choice about deploying changes to their database infrastructure. This release…
