… times pt-archiver, to efficiently purge purge data from huge tables pt-table-checksum/pt-table-sync, to check if data on replicas is… purge data from a huge table without putting too much load on your server How to check which tables are affected when someone… a few seconds How to run ALTER TABLE on your largest tables without downtime REGISTER NOW for this MySQL webinar DOWNLOAD Percona Toolkit for MySQL
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… really require table to be rebuilt – adding/dropping columns or indexes, changing data type, converting data to different character set – MySQL master… one of our MySQL support customers as they were upgrading their application and mysql schema. We deployed and used MySQL Master-Master replication… assigned to db1 at this stage. If you’re altering gigabyte size tables, this step may take some time. Go get a…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
… have 100M records, it can make a huge difference! And when you write queries, …alter the table, which may be difficult if the table is big. So the best solution is sometimes to have an external tables…Are these recommendations true of all versions of MySQL? If not which versions? The recommendations …
Post: Hacking to make ALTER TABLE online for certain changes
October 29, 2007 By 26 Comments
… from the table. As a rule of thumb, this usually involves altering huge InnoDB tables and huge tables take time to…mysql test # mv huge_table.frm huge_table_old.frm && mv huge_table_new.frm huge_table.frm && mv huge_table_old.frm huge_table_new.frm # fg mysql test — 4. mysql> UNLOCK TABLES…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…cases. Especially on huge tables, it lets you scan portions of a table instead of the whole table if you a…doesn’t save you from the downtime caused by ALTER TABLE — a typical reason to think about master-master … work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… | 255868807 | 11893 | | Com_alter_db…tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table…huge tables that should be archived, tables…
Comment: Using MMM to ALTER huge tables
April 4, 2008 By 11 Comments
[...] huge queries to huge tables. On the MySQL performance blog, Aurimas Mikalauskas walks us through using MMM to ALTER huge tables. He writes, “When it comes to changes that really require table to be rebuilt – [...]
Post: Be productive with the MySQL command line
December 21, 2012 By 14 Comments
… ALIEN CENTER | | ALLEY EVOLUTION | | ALONE TRIP | | ALTER VICTORY | | AMADEUS…huge), you can call pager to the rescue: mysql> pager grep sequence PAGER set to ‘grep sequence’ mysql…mysql> tee queries.log Logging to file ‘queries.log’ mysql> use sakila Reading table information for completion of table…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… trigger table rebuilds without affecting the table size. mysql> SET expand_fast_index_creation=ON; Query OK, 0 rows affected (0.00 sec) mysql> ALTER TABLE…) So, as expected, a small buffer pool had a huge impact on ALTER TABLE with the optimization disabled, and absolutely no effect on…
Post: Percona Toolkit 2.1.9 is ready
February 15, 2013 By Leave a Comment
…of pt-heartbeat, made the tool report a huge amount of replication lag. This release makes …. * Fixed bug 918056: pt-table-sync false-positive error “Cannot nibble table because MySQL chose no index instead …primary key is tricky, the tool stops if –alter contains “DROP PRIMARY KEY”, and you have to…
