… presentation, it’s currently up and available for viewing over at percona.com. My apologies if we …, and went to try to install MySQL. It failed miserably on the mysql_install_db process. Every time I tried… insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung on me…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still register to view… storing another column, and reinitializing the sequence after making certain insert/update/delete operations. If you have a dataset that changes…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…row affected (0.01 sec) and on node2 you can also add records: percona2 mysql> insert into percona values (0,’percona2′,’jay’); Query…f7c4916d8330, } joined { 7e6d285b-d56d-11e1-0800-2491595e99bb, } left { } partitioned { }) to view: view(view_id(TRANS,7e6d285b-d56d-11e1-0800-2491595e99bb,2) memb { …
Post: Using VIEW to reduce number of tables used
September 28, 2007 By 12 Comments
…not insert data in the view which will be invisible. The VIEW approach works for SELECT, UPDATE, DELETE queries but not for INSERT: mysql> insert … triggers on views, specially INSTEAD OF triggers so you could write triggers to perform insert inserts to base tables instead of views. BEFORE INSERT …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… Unlike views which use the complete refresh method, incrementally refreshable views are not built directly from SQL. Instead, Flexviews includes a MySQL stored… incrementally refreshable views from SQL statements. It reads one or more “CREATE TABLE db.schema … AS SELECT” and/or “INSERT INTO db…. It is used to prevent wide innodb primary keys on the MV. mysql> select mview$pk as rank, customer_id, total_price…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… the data which has changed. Maintain materialized views with Flexviews (the primary purpose of FlexCDC). … tables, and you want to track changes on all of them. You may have also …`.`demo` will automatically be captured. Insert data in one transaction (two rows): mysql> insert into test.demo values (…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table. But just as frequently, I want to look up blog posts on…insert_idblogpercona.commanual interactive_timeoutblogpercona.commanual join_buffer_sizeblogpercona.commanual keep_files_on….commanual updatable_views_with_limitblogpercona….
Post: A workaround for the performance problems of TEMPTABLE views
May 19, 2010 By 7 Comments
… over the rows of the view and we add a filter condition on c1, the view is accessed quicky: mysql> select c1, count(*) from… the second view using a filter on c1, performance is not good. MySQL is scanning the entire table to produce the result: mysql> select… those which belong to this connection. When the table is inserted too (see below) the connection_id() function will be used…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS volumes…. Here is the chart of rows inserted per minute (click on the image for a bigger view): We can deduce a few things… go from a solely in-memory bottleneck to solely on-disk. The insert performance is quite variable, more so than I would…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… KEY (`i`) node2 mysql> insert into autoinc (j) values (‘node2′ ); Query OK, 1 row affected (0.00 sec) node2 mysql> insert into autoinc (j….01 sec) node2 mysql> insert into autoinc (j) values (‘node2′ ); Query OK, 1 row affected (0.00 sec) Now, on two different nodes… 1 MySQL thread id 3972, OS thread handle 0x7fddb84e0700, query id 16408 localhost root sleeping show engine innodb status Trx read view…
