… gracefully while interupted? The tool doesn’t clean up the temporary table or triggers. It is designed to be resumable, although we… any replication filters or relevant args, the replication breaks reliably on the __tmp_x table why ? The first question sounds like a potential MySQL…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… including Percona Xtrabackup, MyLVMBackup and others use FLUSH TABLES WITH READ LOCK to temporary make MySQL read only. In many cases the period… no MYISAM like table lock priority problem with pending WRITE query blocks any READ queries to execute on the table. mysql> show processlist… writes to the slave can be done by simply pausing replication.
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… MySQL replication reliable, part of which is to eliminate temporary tables. The idea is this: if a slave is stopped (or crashed) while a temporary table… these tables. Thus, I claimed, there’s no alternative but to eliminate temporary tables. This problem may not exist for row-based replication in MySQL…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
…temporary tables (unless they are used to populate normal tables…replicate-do-table, replicate-ignore-table, replicate-wild-do-table and replicate-wild-ignore-table options which act differently. Instead of looking at the query and analyzing which tables…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…. You still have some tables in MyISAM format in “mysql” database. Plus HEAP/MEMORY tables are used for temporary tables which may become MyISAM if… example Innodb tables do not support them. So in practice it is MyISAM related. expire_logs_days This is replication/binlogging related…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… Rows_sent: 56 Rows_examined: 1113 LOGGING OF THE REPLICATED STATEMENTS Normally MySQL will not write into slow log any queries executed… a table. Full_join means any of the joins didn’t use indexes. If a temporary table is required for query execution Tmp_table will be set. Sometimes that table must be created on disk…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…to create or drop a table, or the database itself. Likewise, if a system administrator leaves a temporary file in the database…failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is functioning correctly. …
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… MySQL Replication for upgrade. Once you have setup slave with new version and made it to caught up you can use mk-table… to temporary get extra boxes for time of upgrade. Swapping master. Finally as you have your slave running on new MySQL version… possible as MySQL only fully support slaves newer than the master. Older slaves may have issues unable to interpret new replication stream…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G … This frees disk to use on-disk temporary storage for hash joins and other background …stats innodb-recovery-update-relay-log innodb-replication-delay=# innodb-rollback-on-timeout innodb-…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… close another if the table cache is full. If the closed table was on the FEDERATED engine and a replication environment, its client… #61790 in MySQL (Alexey Kopytov). Uninitialized values in the Slow Query Log patch. Bug Fixed: #794774 (Oleg Tsarev). Querying global_temporary_tables caused…
