…auto_increment value to be reused too. Can you use AUTO_INCREMENT clause in CREATE TABLE to get different auto_increment values ? I guess not: mysql> alter table am auto_increment=1000; Query…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…_customer_sales’, ‘INCREMENTAL‘); SET @mvid := LAST_…of the view, making it available for querying: mysql> call flexviews.enable( -> flexviews.get_id(‘demo’,'dashboard_customer_sales’)); Query…gets a special column `mview$pk` which is an auto_increment BIGINT surrogate key… is the value proposition for…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…MySQL will fail to start on a micro instance, simply decrease the values…of the last post. ICE does not have any indexes (not even primary keys…free: 4194304 Auto_increment: NULL…query/ $ ./run_query < queries.sql | tee raw |./pivot_results & [1] 12359 $ tail -f ./raw — Q1 … At the end, you will get…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…query date ranges most of the time, you should define the primary key as (day, ad). Don’t use an auto-increment primary key…get there, it can change the lifecycle of your application in advance. What about partitioning in MySQL…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 27 Comments
… sets of possible values. These are “state”, … auto_increment, `name` char(40) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY … to get 5 names of …of the join in this case because there is really no join: mysql…last test – selecting city and name in arbitrary order, skipping first 10000 rows to make query…
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
…MySQL master database and populate it with some data. CREATE TABLE `t1` ( `c1` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) ) ENGINE=InnoDB; Query…VALUES (); Query OK, 1 row affected (0.00 sec) INSERT … SELECT a few times to get…
