Percona's MySQL & InnoDB performance and scalability blog
…course, the only difference is that the…index on it, and then I create one, the following warning is generated: mysql> alter table dir_test_innodb ADD FULLTEXT KEY…and dropping FT indexes, it’s entirely possible to DROP multiple FT indexes… several more times, and each execution took between 6 and 8…
…and index) you would need 2+ IOs to retrieve the row which means you get about 100 rows/sec. Note multiple…different selectivity might show benefit from using indexes. In fact even MySQL…mysql> select count(pad) from large where val between 1 and…
…BETWEEN 5 AND 10 predicate because it is not index prefix. It is important to look at key…MySQL is only reading index and not accessing rows you will see “using index” in EXPLAIN output. These are the main “core” use for indexes…
…different types of ranges in MySQL. IN range allows to optimize lookups on the second key part, while BETWEEN and…. Basically MySQL started scanning Index with age>=18 and continue scanning …multiple ages to deal with ether as BETWEEN range or as IN filesort appears and query becomes very slow: mysql…
…key! Mario asked: Q: Did you compare relevancy of search results between…and indexes. Have you benchmarked it? According to their documentation, MemSQL supports hash indexes and skip list indexes, but not full-text indexes…
…differences between a data warehouse and a data mart. (this post) Introduction to MDX and… of OLAP with and without aggregation over multiple MySQL storage engines … There are a few key points here. First, data… bitmap indexes, table partitioning, parallel query execution, clustered tables and …
…multiple table and the column type was inconsistent between…different data when your application requests without throwing the error is not good idea in most cases, yet MySQL…
…and loading it back. If performance is of importance I would recommend using Percona Server with enabled expand_fast_index…MySQL Replication to work. You might need to inject MySQL 5.0 in between…multiple instances of different MySQL…
…index | +—-+————-+——-+——-+—————+———+———+——-+——+————-+ 2 rows in set (0.01 sec) The difference between these cases is “i” is primary key while “k” is simply indexes…
… previous key part. So if you have INDEX(A,B) and have a where clause A BETWEEN 5 and 10 AND B=… cardinality by having all rows to have different group_id and it still does not work. The trick … it does not work for multiple group remains question to check with MySQL Optimizer team 
UPDATE: I just …
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.