…to the following: SELECT key_column, pk_column FROM tbl WHERE key_column=x ORDER BY key_column (Note that secondary keys in InnoDB contain primary key…how counter is calculated inside MariaDB? Other Observations Sometimes both for MariaDB 5.5 and MySQL 5.6, the optimizer chooses…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… dicing. And as a result, one of the most common questions we hear is how to build high-performance systems to do this work…. Choose primary keys very carefully, especially with InnoDB tables — don’t use GUIDs. Which brings me to my next point: Use InnoDB Assuming that… have to do with InnoDB? Data clustering. InnoDB‘s primary keys define the physical order rows are stored in. That lets you choose which…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…to a mechanical disk. I do not know how it is for sequential writes, like log flushes. A question is why to use a…on this this matter the other day – choosing innodb_buffer_pool_size Q36: There have …PRIMARY KEY, then InnoDB should have placed the rows in contiguous blocks of 64 pages == 1 MB. Then a…
Post: Innodb row size limitation
April 7, 2011 By 11 Comments
… TEXT, fcopyright TEXT, fstylesheet TEXT, fterms TEXT, PRIMARY KEY (id) ) Engine=InnoDB; Now you insert some test data into…have a modular data access API, you shouldn’t have to change code in a lot of places. How …. You can limit the changes to your application if you choose XML as format and you …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…a ranking function automatically. In cases where this is not useful, simply ignore this column. It is used to prevent wide innodb primary keys…how you can combine both types of views together. The complete method examples show how to create a…
