Percona's MySQL & InnoDB performance and scalability blog
…Search in MySQL 5.6: Part 2, The Queries![/caption] This is part 2 in a 3 part series. In…in a single blog post) than what MyISAM gives us. Recall that we have two different sets of data…
…search in MySQL 5.6 (part 1) in MySQL 5.6 is syntactically identical to MyISAM full-text search, in…table by querying the various I_S.INNODB_FT_* tables. In particular, the INNODB_FT_CONFIG table…
…MySQL queries would make them even slower, I’m sure. Indeed, the result set of 20 rows from SphinxQL queries…searching data without touching the disk, but I assume the search would necessarily do table…different application types. There are books that describe how…
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 a look at and benchmarking optimizer enhancements one by one. So in… new optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
…from data clustering in the different…table in recent MySQL…table. It also will help the query you’re mentioning allowing group by to be performed without temporary table or external sort. Q: How…table, not other index, also you only can have equality comparison as a search…
…tables and Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table…how much total gain I can get from it. Queries…
…data differently? We can “compress” the table in the database by removing the duplicates: mysql> create table ex2 as select val, count(*) from ex1 group by val; Query…
…search engine marketing. I’ll do that throughout this article. Requirements The words “need” and “want” are different…tables in a complex query with many joins. I have never seen this approach scale well. Use The Best Technologies You Can MySQL…
…MySQL could only use one index per table in a given query…MySQL is using three different indexes to search approximately 8100 out of 4.5M rows to return the data…query (it did), but it might also negatively impact other queries which were benefitting from…
…difference between “rate” and “ratio”. In…from the standpoint of response time measurements, which you should, you will eventually arrive at this question. “I have a query…how important those tables are to you, how…in MySQL to guide your decisions. It is also not the be-all and end-all of MySQL…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.