… a lot slower than 1 for some N. Eventually you change from having all index blocks for all tables in memory… was your problem or something else. PMP stacks or perf schema output might help debut it.
Post: Knowing what pt-online-schema-change will do
November 1, 2012 By 1 Comment
pt-online-schema-change is simple to use, but internally it is complex. Baron’s webinar about pt-online-schema-change hinted at several of the tool’s complexities. Consequently, users often want to know before making changes what pt-online-schema-change…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 10 Comments
…. A schema migration is an instant blocker in the critical path of your project plan. No more! The pt-online-schema-change tool… new pt-online-schema-change tool and how it enables zero-downtime schema changes on May 2nd. In addition to pt-online-schema-change, we have completely redesigned and rebuilt the pt-summary and pt-mysql-summary tools. The changes are not…
Post: pt-online-schema-change and default values
June 21, 2012 By 1 Comment
…. This however does not work for pt-online-schema-change: root@smt2:~# pt-online-schema-change –execute –alter=”add column v varchar(100) not…
Post: Give feedback on a pt-online-schema-change update
March 14, 2012 By 4 Comments
… am writing a specification for updating pt-online-schema-change. The outline of the changes I want to make is here: http://www.percona.com/docs/wiki/ptdev:blueprints:redesign-pt-online-schema-change The…
Post: Zero-downtime schema changes webinar recording
May 8, 2012 By Leave a Comment
The recording and slides for my webinar on zero-downtime schema changes with MySQL are available now. Don’t miss Vadim’s webinar tomorrow!
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… mysql schema. We deployed and used MySQL Master-Master replication manager (MMM) ever since we started working so doing all the schema changes…,..)”), deletes or updates of rows that will not exist after schema changes and other things that would break logical replication if tables…’t want schema changes to be replicated to db1 now. 3. on db2: load the sql scripts $ mysql -u root db < changes.sql…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… employs a data generator which produces data for a star schema. Star schema are commonly used for analytics because it is extremely… .; make; make install) Only changes from defaults was that both servers are compiled without the PERFORMANCE_SCHEMA, and paths are unique for… how many page requests their were: mysql> select * from information_schema.global_status where variable_name like ‘%innodb%read%’; +—————————————+—————-+ | VARIABLE_NAME…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…) to identify rows that have changed Triggers to capture changes synchronously Database log reading to capture the changes asynchronously The first method has… change into special tables called changelogs. Each changelog is located in the flexviews database and is named $SCHEMA_$TABLE where $SCHEMA is the schema… –schema=test –table=demo success Note that you can enable auto_changelog=true in the config file to automatically record changes for…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
… the schemas I want to consider dropping indexes in). Let’s keep using views so this dynamically updates as our schema changes over time: mysql> create view all_indexes as select t.table_schema as TABLE_SCHEMA, t.table_name… the normal tricks and tips about doing a long blocking schema change without affecting your production environment apply here and is out…
