…to a standalone Innodb instance Let’s break it down a bit. Our unit of locking in Innodb is a single row (well, the PRIMARY KEY…id=100 WHERE id=1; COMMIT; How often might multiple users join …Choosing a system to replicate your data to a distributed system requires tradeoffs. Most of us are used to…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…PRIMARY KEY (`o_orderkey`), KEY `i_o_orderdate` (`o_orderDATE`), KEY `i_o_custkey` (`o_custkey`) ) ENGINE=InnoDB…to manually enable and disable the join algorithms for the optimizer to choose from. In MariaDB, every algorithm has a number given to…
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 12 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 20 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…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…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: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…to memory was that when I tried to create an InnoDB FT index before declaring the `FTS_DOC_ID` primary key…choosing a full-text solution, because updating the index can become quite complex. Solr is easier to add documents to…
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
…so a good choice of memory…choose with configure option –enable-experimental-malloc. (You can find details about new malloc here). Many distros switched to…50G data / CPU bound case innodb_buffer_pool_size=…) from sbtest$i FORCE KEY (PRIMARY)’ and then OLTP_… below you will see how mysqld footprint is …
