…can skip replicating it specifying replicate-ignore-table=db.memory_table. Note you should not be using STATEMENT level replication with INSERT … SELECT into this…goes down MySQL crashes etc. If you however are using MEMORY table in replication and just want to do a restart without 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…pos: 198 Info: use `test`; insert into test.ins select * from test.t *************************** 6. row *************************** Log_name: mysql-bin.000011 Pos: 477 …
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…MySQL configurations for high availability is master-master replication, which is just like normal master-slave replication…insert buffer. As Peter explained in his recent post on the insert buffer, the other thing the SELECTs do is keep the insert…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…MySQL…inserts (multiple value inserts). Really helps if you have really bulk inserts 100-1000+ values per single insert statement. concurrent_insert – Enables concurrent insert (while Selects…crash. delayed_insert_limit, delayed_insert_timeout, delayed_queue_size Delayed inserts… replication/binlogging…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
…inserts which can go concurrently with selects. This is sometimes presented as great concurrency for inserts but in reality it means only one INSERT… danger if MySQL Server crashes or power goes down. In case crash happens … to. Also be worried about replication with different storage engines. Then …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…with INSERTS and UPDATES (but not SELECTS). That would make PBXT very interesting for non-SELECT-intensive…fortunately MySQL 5.1. supports row-based replication which makes it possible to do replication while …like backup, concurrency, ACID compliance and crash recovery. As a storage engine developer,…
Comment: Using MyISAM in production
June 19, 2006 By 35 Comments
…insert/update only on master anyway as otherwise it will not be replicated if you do not use bi-directional replication…selects you can get stuck. The row cache problem is actually partialy solved by using MMAP in MySQL…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…right, bugs that cause data corruption, crashes, or wrong query results get… MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, …a separate computer, maybe a replication slave. Can you make …in “show innodb statusâ€. select * from table where id=5…
