… it convenient to set it up on crontab so that schema changes are automatically picked up. Nice, eh? Usage of this tool…/schemaspy driverPath=/usr/share/java/mysql-connector-java.jar Example Schema CREATE TABLE `parent` ( `parent_id` int(10) unsigned NOT NULL… value. This is basically a quick sanity check of your schema for any significant errors or items requiring review. Columns – a…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
… application evolves, additional requirements will appear like hot backups, online schema changes, replication based high availability (which has some caveats). Also, because…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…fixed #1108613. Percona Server wouldn’t start if the XtraDB changed page tracking was enabled and variable innodb_flush_method was… 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
…intensive workloads. Bug fixed #1171699. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS…indicate an incomplete result set. Bug fixed #1185040. The INNODB_CHANGED_PAGES table couldn’t be queried if the log tracker…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer improvements… a series of posts on the small but handy improvements – changes and bug corrections – in MySQL 5.6 that can make…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
….1, but some tools were changed significantly (e.g. pt-query-digest, pt-upgrade, and pt-online-schema-change). Here are some highlights… evolve to support it. pt-online-schema-change (pt-osc) is much more resilient pt-online-schema-change 2.1 has been a great… affect you, see Ovais’s article. In short: pt-online-schema-change 2.2 is far more resilient out of the box…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… can measure how a server or database upgrade, change in my.cnf or schema change can affect the overall performance of your MySQL… to allow users to make an informed choice about deploying changes to their database infrastructure. This release should be considered BETA…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… performance problems happen randomly or are very short pt-online-schema-change, to run ALTER TABLE statements on large tables without downtime…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…-schema schema_name –query-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set innodb_fake_changes=1…-query command-line option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and DELETEs from corrupting the data… will need Percona Server in order to use innodb_fake_changes. Thread pool Percona Playback added a connection pool option via…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… node. This should prevent the deadlock errors, but will not change the lock waiting that your application will need to do… that is not safe to retry after the database state changes. retry deadlocks Now we start to get into (*gasp*) territory… achievements SET count = $last_count where achievement = ‘killed_troll’”; } change your schema In Example 2, above, how above moving the ‘joined’ column…
