…other drawbacks to using temporary tables in this way, for example when using replication, a temporary table could vanish if … writing a SQL query optimizer and see how easy it is? ;-) Generative grammars like SQL … keywords were returned in a different order from what you specify in the query? The …
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 8 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: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… 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: 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 11 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: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… a common trick to improve the performance of on-disk temporary tables. Servers usually have less RAM than disk space so those… see one example. We’re running a typical master-slave replication with ROW based binary log file. The application connects to… Nagios. Trending graphs from Cacti are also a very good option to know how and when the size of your temporary tables increases. We…
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…
