…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…drop temporary table test.t *************************** 7. row *************************** Log_name: mysql…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…drop a table, or the database itself. Likewise, if a system administrator leaves a temporary…-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication … handle or log this error appropriately. The pmp-check-mysql-status plugin can be…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…replication environment, its client connection to the remote server was closed leading to an unappropriated network error…MySQL (Alexey Kopytov). Uninitialized values in the Slow Query Log patch. Bug Fixed: #794774 (Oleg Tsarev). Querying global_temporary_tables…
Post: Percona Server 5.5.14-20.5
August 17, 2011 By 4 Comments
…table cache is full. If the closed table was on the FEDERATED engine and a replication…error and stopping the Slave SQL thread. Bugs Fixed #813587 / #51196 and#61790 in MySQL (Alexey Kopytov). Querying global_temporary_tables…_lazy_drop_table option led to an assertion error when truncating a table in…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…fact data): DROP TABLE IF EXISTS `dim_airport`; CREATE TABLE `dim_airport` (…to 2010′; mysql> use ontime1; Database changed mysql> show table status like … to use on-disk temporary storage for hash joins…update-relay-log innodb-replication-delay=# innodb-rollback-…-timeout=300 log-error=/var/log/mysqld-…
