Percona's MySQL & InnoDB performance and scalability blog
…how to make InnoDB FTS blazingly-fast, but simply to get a sense of how it works compared to traditional MyISAM FTS. We’ll get to performance in the…in the documentation mention the notion of a “document ID” that “might reflect the value of an ID column that you defined for the underlying table…
…the buffer pool, then worst case you could be reading the same page multiple times into the…of this that the query on MariaDB 5.5 is slow as compared to MySQL 5.6. Next interesting thing are the last two columns of the table above and the values…
…value of ‘pk_column‘ which is a part of the secondary key tuple, a point primary key lookup is made against base table, the number of…how the counters behave with MRR, but the value for counter Handler_read_key is more or less the same for MariaDB 5.5 when compared to MySQL…
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking…. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5…
…columns represent the type of change (insert is 1, delete -1), the transaction order and the source of the changes, respectively. Finally, note that the two insertions happened inside of the same…
…in another attempt, I tried just making the “value” column the PK, but neither of those worked. Also, trying to set innodb_ft_user_stopword_table produced the same…the record from Arizona to be towards the top of the list. With 5.5, this is exactly what happens: mysql…
…The view type does not usually* affect the time it takes to build the MVs the first time. Both of these views build in about the same about of time: mysql…
…the same for both row formats. (Speaking very strictly, the VM Peak value is not comparable due to slightly different number of rows inserted). In the…
…in the hash table by using values of the columns participating in the equijoin condition. The hash table is accessed by using a hash function on the values of the…
…How much space InnoDB allocates for each blob outside of the page? HT: For each column that InnoDB needs to…MySQL‘s binlog and InnoDB’s log must have the transactions in the same order, for a recovery based on MySQL‘s binlog to work. Of…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.