…Triggers in Master and Slave servers. Example: mysql> create trigger Copy_data AFTER INSERT on t FOR EACH ROW INSERT INTO t_copy VALUE(NEW.i); mysql> insert into…/*!*/; INSERT INTO y (value) VALUES(LAST_INSERT_ID()) That was for a insert with only one value. What is the behavior if we insert multiple…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
Post: Why audit logging with triggers in MySQL is bad for replication
September 29, 2008 By 10 Comments
… the update trigger: Create Trigger Foo_Update After UPDATE on Foo For Each Row INSERT into Foo_History (Foo_History_ID, Name, Value, Field_Id) Values… Transaction; Update Foo set Value=6 Where Field_Id = 51; Commit; Transaction 1 commits last. Commit; Now when these statements get run…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
…advantages particularly if triggers or stored…Insert a single “seed” row into the table: INSERT INTO repl.t1 VALUES (); Query OK, 1 row affected (0.00 sec) INSERT…mysql_sandbox25162-relay-bin.000002 Relay_Log_Pos: 340718 Slave_SQL_Running: No Last_Errno: 1032 Last…#100506 12:42:56 server id 1 end_log_…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…mysql> CREATE TABLE t(id INT AUTO_INCREMENT PRIMARY KEY, c FLOAT) ENGINE=InnoDB; Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO…column to trigger table rebuilds without affecting the table size. mysql> SET…last test with innodb_buffer_pool_sizeset to approximately 1/10th of the dataset: mysql…
Post: Bug#12704861
November 20, 2011 By 1 Comment
…that is fixed in MySQL 5.1.60. I…_cur_pessimistic_update()” (revision id: marko.makela@oracle.com-…file bounds. This should trigger an assertion failure in fil…will itself crash. The last sentence (“there is no…of us who are into InnoDB internals: The fix… made off-page in insert-by-update, invoke btr_…
Post: Can Innodb Read-Ahead reduce read performance ?
June 26, 2007 By 2 Comments
…into…to 586 10447960 Last checkpoint at 586 …id 1157658976, state: sleeping Number of rows inserted 60790248, updated 11571576, deleted 0, read 63850963520 0.00 inserts…inserted in PK order we have relatively sequential IO and so read-ahead is constantly triggered… this project from MySQL AB side) – to…
