… to allow triggers on views, specially INSTEAD OF triggers so you could write triggers to perform insert inserts to base tables instead of views. BEFORE INSERT triggers would not help because the column user_id is not part of the view so would not be available even if MySQL…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… has changed. Maintain materialized views with Flexviews (the primary purpose…triggers must be changed. The work in the trigger is immediate and affects every transaction. Finally, MySQL has limited trigger…automatically be captured. Insert data in one transaction (two rows): mysql> insert into test…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and …commanual delayed_insert_limitblogpercona.commanual Delayed_insert_threadsblogpercona.commanual delayed_insert_timeoutblogpercona.commanual…commanual unique_checksblogpercona.commanual updatable_views_with_limitblogpercona.commanual Uptimeblogpercona….
Comment: Using VIEW to reduce number of tables used
October 5, 2007 By 12 Comments
… of views? At the start of the script you do: [CODE]SET @owner_id = 12345[/CODE] Then use a BEFORE INSERT trigger for the shared table (owner_id field should be in the view as well): [CODE]CREATE TRIGGER post_insert BEFORE INSERT ON… used inside a view definition. I have [URL=http://omelnyk.net/blog/2007/06/18/using-views-with-variables-in-mysql/]outlined[/URL…
Post: Preprocessing Data
August 8, 2011 By 3 Comments
… submit the message. It also means that when a user views their messages, they quickly get results from prepared tables. 3… Insert This is when you insert data into the database. Your application or the database itself (using TRIGGERs) does additional calculations or data insertions…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…” which is quite helpful for MySQL Performance optimization tasks but there…does not work for subselects, inline views, parts of the UNION. This …inserts so you can see how much of inserted queries are used: Qcache_hits/Qcache_inserts… fragmentation lowmem_prunes can be triggered even if there is some …
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
… The server could crash when executing an INSERT or UPDATE statement containing BLOB … used to print the open read view list without taking the kernel mutex…line option innodb_changed_pages_limit. MySQL option handling would then shadow …errors. Errors would happen if a trigger is fired while a slave …
Post: Can Innodb Read-Ahead reduce read performance ?
June 26, 2007 By 2 Comments
… views open inside InnoDB Main thread process no. 3956, id 1157658976, state: sleeping Number of rows inserted…were inserted in PK order we have relatively sequential IO and so read-ahead is constantly triggered …doing (I was adviseor in this project from MySQL AB side) – to improve how Innodb read-…
