… most interesting one is the new Global Transaction ID (GTID) support in replication. This post is … are many documents about that: http://dev.mysql.com/doc/refman/5.6/en/replication-… from the master: # mysqldump –all-databases –single-transaction –triggers –routines –host=127.0.0.1 –port=18675…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…, the triggers must be changed. The work in the trigger is immediate and affects every transaction. Finally, MySQL has limited trigger support…c2: 2 *************************** 2. row *************************** dml_type: 1 uow_id: 10 fv$server_id: 999 c1: 3 c2: 3 *************************** 3. row …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… referring to the amazing MySQL manual, especially the option and variable reference table….table_sizeblogpercona.commanual tmpdirblogpercona.commanual transaction_alloc_block_sizeblogpercona.commanual transaction_isolationblogpercona.commanual transaction_prealloc_sizeblogpercona.commanual tx_…
Post: Why audit logging with triggers in MySQL is bad for replication
September 29, 2008 By 10 Comments
…using two triggers on that table. select trigger_name, event_object_table, Event_Manipulation from information_schema.triggers where trigger_schema = ‘mydb’…_ID, Name, Value, Field_Id) Values (Old.Foo_History_ID, Old.Name, Old.Value, Old.Field_Id); Transaction 1 starts and updates. Start Transaction;…
Post: Bug#12704861
November 20, 2011 By 1 Comment
… problem that is fixed in MySQL 5.1.60. I’ll …after btr_cur_pessimistic_update()” (revision id: marko.makela@oracle.com-20110616072721-8bo92ctixq6eqavr … tablespace file bounds. This should trigger an assertion failure in fil_io()… mini-transaction of the BLOB write, not to the mini-transaction of the …
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
… with caution. Note disabling binary logs is not enough to trigger relaxed locks. You have to set innodb_locks_unsafe_for… SHOW INNODB STATUS: —TRANSACTION 0 42304626, ACTIVE 14 sec, process no 29895, OS thread id 2894768 updating or deleting mysql tables in use…; asc ;; —————— —TRANSACTION 0 42304624, ACTIVE 37 sec, process no 29895, OS thread id 4058032 fetching rows, thread declared inside InnoDB 3 mysql tables…
Comment: Drilling down to the source of the problem
November 14, 2008 By 7 Comments
… release, and I have some tables that use BEFORE INSERT triggers to update another value in a different table. I was… InnoDB. TRANSACTION 1 2897690526, not started, process no 17811, OS thread id 1197627712, thread declared inside InnoDB 499 MySQL thread id 243641148, query id 2415637111…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…” which is quite helpful for MySQL Performance optimization tasks but there… implement. Might not work with transactions – Different transactions may see different states … such as UUID(), RAND(), CONNECTION_ID() etc it will not be …to fragmentation lowmem_prunes can be triggered even if there is some …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mining stock market transactions,” or whatever the…power management: processor : 7 vendor_id : GenuineIntel cpu family : 6 …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…_SCHEMA query will surely trigger errors about this.)…
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
…id=”attachment_13824″ align=”alignright” width=”300″] Percona’s Kenny Gryp leads a recent MySQL…triggers and events. Operating and Troubleshooting for MySQL on Wednesday & Thursday, April 10 & 11 This MySQL workshop will cover: Understand MySQL…and how features like the transaction log files and undo …
