… TABLES WITH READ LOCK to temporary … is example how it can look: mysql> show processlist; …from the slave with –safe-slave-backup option, as preventing 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
…ago I wrote about how to make MySQL replication reliable, part of which is to eliminate temporary tables. The idea is this… from the temporary table into a non-temporary InnoDB table: master > delimiter // master > create procedure test_temp() begin -> start transaction; -> create temporary table …
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… for example dealing with temporary tables (unless they are used to populate normal tables using SQL). … how one can break filtered replication by executing some statements on the master. Even though replicate-*-table…all binary logs from the master, filter out only what you need replicated and pass …
Post: Percona-XtraDB-9.1: released and new coming features
March 17, 2010 By 14 Comments
… was temporary table used, was it disk table or in-memory, and how big was temporary table. Also you can profile each individual query from stored …of buffer_pool Import / export of dedicated tables Import / export of buffer_pool Transactional replication Show internal InnoDB data dictionary Show …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…table, or the database itself. Likewise, if a system administrator leaves a temporary…replication can fail silently and data can diverge or drift on a replica. The pt-table-checksum tool from Percona Toolkit can generate table… restarted recently. It is surprising how often a server crashes, perhaps …
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
…56 Rows_examined: 1113 LOGGING OF THE REPLICATED STATEMENTS Normally MySQL will not write …from a table. Full_join means any of the joins didn’t use indexes. If a temporary table is required for query execution Tmp_table… how much time (in seconds) it took InnoDB to actually read the data from …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… some interesting information about how Shard-Query will perform … to use on-disk temporary storage for hash joins …table innodb-flush-log-at-trx-commit=1 innodb-flush-method=O_DIRECT innodb-ibuf-active-contract=1 innodb-import-table-from…update-relay-log innodb-replication-delay=# innodb-rollback-on…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…The Writer transfers data from the transaction log to the database table files. This … supports row-based replication which makes it possible to do replication while using … UPDATE or DELETE only acquires a temporary row-lock. This lock is … then have to be fixed. How to optimize the program without…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
…no matter how heavy IO is. Also if you know the IO pattern, say most of traffic comes from …LVM undo space. For example MySQL on disk temporary files and tables can waste quite a lot of such space….zero free space and you would like to setup replication for large database with little no – connect USB …
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… ‘–with-csv-storage-engine’ (…) From that output you can learn how to run configure command,… use on-disk temporary storage for intermediate results “tmp_table_on_disk,filesort_…replication thread. Can be changed at run time with both SET SESSION and SET GLOBAL. log_slow_verbosity=name Choose how…
