June 19, 2013

Post: Statement based replication with Stored Functions, Triggers and Events

December 16, 2011 By 4 Comments

… event_scheduler = OFF; ENABLE every event with “ALTER EVENT event_name ENABLE” Enable again the event_scheduler. …logged as an extra event just before the statement. MySQL uses the INSERT_ID variable to store that…. What is the behavior if we insert multiple values and we have gaps? Example: Imagine …

Filed Under: MySQL

Post: MySQL Upgrade Webinar Questions Followup

June 28, 2012 By 7 Comments

…I would recommend using Percona Server with enabled expand_fast_index_creation feature, as … using STATEMENT or ROW replication. MIXED mode means you will have to deal with STATEMENT and…available. Another thing to mention having multiple instances of different MySQL versions on the same box typically…

Filed Under: Insight for DBAs, MySQL

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…inserting one row at a time with AutoCommit enabled – remember, the focus here isn’t on… column, however, MySQL apparently has no problem with either of the following statements: mysql> insert into dir_…entirely possible to DROP multiple FT indexes with InnoDB in the same ALTER TABLE statement, but it…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: MySQL 4 to MySQL 5 Upgrade performance regressions

June 6, 2007 By 8 Comments

… durable. You have to have log-bin enabled to get replication or point in time recovery…stage or have “commit” queries in the processlist for multiple statement transactions. Looking at SHOW INNODB STATUS you … MySQL 4.1 until MySQL has taken it away from you as already happened with MySQL 4.0. MySQL…

Filed Under: Insight for DBAs Tagged With: ,

Post: Flexviews - part 3 - improving query performance using materialized views

April 4, 2011 By 20 Comments

… changes in multiple transactions. After…statements from standard input, and outputs the SQL_API statements representing the original SQL statements…mysql> call flexviews.enable( -> flexviews.get_id(‘demo’,'complete_example2′)); Query OK, 0 rows affected (42 min 42.14 sec) mysql> call flexviews.enable…

Filed Under: Insight for DBAs, MySQL

Post: MySQL Query Cache

July 27, 2006 By 70 Comments

… Other portion of overhead comes from modification statements which you can calculate by (Com_insert+… how it works with MySQL to add caching but you can enable query cache so it works…Distirbuted caching systems can effectively use memory on multiple systems so there is no duplication. Memcached …

Filed Under: Insight for DBAs Tagged With:

Post: Using Flexviews - part one, introduction to materialized views

March 23, 2011 By 3 Comments

…MySQL 2011 CE, and I figured I should blog about it before then. For those unfamiliar, Flexviews enables…statements is a table, so conceptually so too is the output of a SQL statement. MySQL even includes a SQL statement… the view is accessed. If multiple statements access the same view repeatedly or…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , ,

Post: MySQL Users Conference - Innodb

May 9, 2007 By 6 Comments

… of others due to statement level MySQL Replication which among other requirements, needs all auto-increment values in multiple value insert to be… such as multiple purge threads or parallel log recovery features, which he however needs to test properly before really enabling it. Innodb…

Filed Under: Events and Announcements Tagged With:

Post: Announcing Percona XtraDB Cluster 5.5.28-23.7

November 15, 2012 By 9 Comments

…) addresses in the cluster component. Multiple addresses can now be specified…real abort for the SQL statement. If statement itself enters into …with option wsrep_start_position enabled. Bug fixed #1075495. SST …regular MySQL replication slave configured, could cause intermittent failure to start MySQL…

Filed Under: MySQL

Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster

March 3, 2013 By 13 Comments

… updates are done on multiple nodes. There is an option you can enable to get fully synchronous replication behavior: mysql> set global wsrep_causal_reads=1; Query OK, 0 rows affected (0.00 sec) When this option is enabled the…. Lets do the run again now running the same update statement on the different cluster node: per-request statistics: min: 0…

Filed Under: Benchmarks, Insight for DBAs, MySQL, XtraDB Cluster Tagged With: , ,
« Older Posts