… data is necessary to define the same Triggers in Master and Slave servers. Example: mysql> create trigger Copy_data AFTER INSERT on t… same auto incremental values on master and slaves the actual used auto incremental value is logged as an extra event just before the statement. MySQL…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
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…. allow_suspicious_udfsblogpercona.commanual ansiblogpercona.commanual auto_increment_incrementblogpercona.commanual auto_increment_offsetblogpercona.commanual autocommitblogpercona.commanual automatic_sp_…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…changed, the triggers must be changed. The work in the trigger is immediate and affects every transaction. Finally, MySQL has limited trigger support, some…: mysql> create table > test.demo ( > c1 int auto_increment primary key, > c2 int > ) > engine=innodb; Query OK, 0 rows affected (0.00 sec) mysql…
Post: MySQL Quality of old and new features
October 4, 2007 By 24 Comments
… in both MySQL Quality Control and bug fix promptness. Let me just take couple of bugs as examples: Triggers broken with auto-increment columns… questions in my head: What is MySQL Current Bug Policy ? A long time ago MySQL had Monty’s bug policy of “no… you’re using will not break. You would not catch trigger bug this way but it can be helpful for basic…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
… prefix of another command line option innodb_changed_pages_limit. MySQL option handling would then shadow the former with the latter… caused spurious duplicate key errors. Errors would happen if a trigger is fired while a slave was processing replication events for… which is used in that trigger. For this to happen master needs to have more than one auto-increment table and the slave…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… triggers. The problem should be fixed by upgrade so we just have to keep this into account. We move database to MySQL… query instances, and only one of them into table with AUTO_INCREMENT column (and so affected by this bug). It was easy… being trivial. This was the best choice as with New MySQL version upgrade involves new Operating System and hardware and any…
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… I’m extending the VARCHAR column to trigger table rebuilds without affecting the table size. mysql> SET expand_fast_index_creation=ON… the restore slower; mysqldump –innodb-optimize-keys ignores indexes on AUTO_INCREMENT columns, because they must be indexed, so it is impossible…
Comment: Why audit logging with triggers in MySQL is bad for replication
September 30, 2008 By 10 Comments
… trigger definition, it looks like it is comes from the table being updated, but from the result it looks like an auto_increment… issue here), as I believe MySQL doesn’t support having two auto_increments in the same “statement” (including triggers). Of course, one should remember…
Comment: How to find wrong indexing with glance view
March 8, 2010 By 27 Comments
… but not so much in 2010. MySQL surprisingly supports declarative integrity constraints. But wait being MySQL there must be something about it… table create table orders( order_id int unsigned not null auto_increment primary key, item_type_id tinyint unsigned not null, locale…’s way of writing triggers to implement referential integrity but I hear triggers are also pretty slow themselves in MySQL too and writing…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
… mode. The row-based format does offer advantages particularly if triggers or stored procedures are used, or if non deterministic functions… on a MySQL master database and populate it with some data. CREATE TABLE `t1` ( `c1` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY… currently executing at relay log file: mysql_sandbox25162-relay-bin.000002 at position: 340718. MySQL 5.1 ships with a new version…
