…’ > discard-ddl.sql SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` DISCARD TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql…’ > import-ddl.sql SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` IMPORT TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF For…
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 AUTO… any host:port or schema name information. Viewing SchemaSpy output A completed Relationships view of these three tables should look like this… tables with the string NULL instead of the actual SQL NULL value. This is basically a quick sanity check of your schema…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… database’s ability to optimize queries for a star schema. A star schema presents some unique challenge to the database optimizer. The… version used: 5.6.11, custom compiled to remove performance_schema For the InnoDB tests, a 64GB buffer pool was used… innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT…
Comment: Implementing SchemaSpy in your MySQL environment
June 5, 2013 By 2 Comments
…, thank you for your feedback. * How do you define large schemas, and what do you mean by can’t cope? * Is… of tables? In my experience, the schemas I have under SchemaSpy reach at max approximately 3,000 tables per schema and perhaps 10,000 tables… tried pulling this schema into Workbench so I can’t comment as to how well it scales at this volume of tables.
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…. Bug fixed #1171699. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER…. Bug fixed #1186831. Reduced the overhead from the Handle Corrupted Tables check as it was missing branch predictor annotations. Bug fixed…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…. Bug fixed #1184427. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER… tracking is enabled. Bug fixed #1184517. The INNODB_CHANGED_PAGES table couldn’t be queried if the log tracker wasn’t…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query …0 Warnings: 0 mysql> SHOW CREATE TABLE test\G *************************** 1. row *************************** Table: test Create Table: CREATE TABLE `test` ( `id` int(11) NOT …
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… with the fix for bug #710799. This regression caused mysql schema to be missing after the clean RPM installation. Bug fixed… the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
… showing how you can use the wealth of information Performance Schema gathers to understand some of the typical performance bottlenecks. Other… focus include: Bottlenecks with Disk IO Problems with excessive temporary tables and external sorts Excessive internal mutex contention Slow queries due…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…: I will use two different schemas. The first schema is from sysbench, and the table looks like: CREATE TABLE sbtest$I ( id BIGINT UNSIGNED… workload (which actually is closer to what I need). Tables looks like: CREATE TABLE `sbtest1` ( `hid` int(10) unsigned NOT NULL DEFAULT… –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on…
