Percona's MySQL & InnoDB performance and scalability blog
…MySQL terms, Full text columns are always indexed and using the very powerful extended query syntax you can do search…be using SphinxQL protocol which looks like talking to MySQL server, but it’s not. …emphasize – while it is a neat performance optimization for highly selective attributes, this is …
… making it unusable to check the optimizer performance. Solution for this problem was to use set optimizer_search_depth=0, rarely used option which as per manual will chose best value automatically. Making this change I could bring optimization… MySQL 5.6 things are likely to get even better handling joins of many tables as optimizer heuristics are improved so much higher search…
… glance, this might not look too bad. MySQL is using three different indexes to search approximately 8100 out of 4.5M rows… the context of index merge, it means that MySQL is really looking at a search space closer to 8.5M rows, not… hints. Index hints are exactly what they sound like – “help” for the optimizer to favor or disfavor a particular index or set…
… will need to have your queries do something like SELECT * FROM TBL WHERE hash=crc32(‘string’) AND … fragmented. I also would note there are some MySQL optimizer restrictions in how well it can deal with …as a search condition WHERE A=5 ORDER BY B will use index (A,B) for sorting optimization, for …
Queries in MySQL, Sphinx and many other database or search engines are typically single-threaded. That is when you issue … in MySQL to define those ranges, mixing it with sql_query_range or something else, depending on how your data looks like… nearly as often as I should. Well, it’s not like it is slow or anything, but queries are never too…
…, Analyzing Percona’s TPCC-like Workload on MySQL 5.5, which was a response to my post, MySQL 5.5.8 and Percona… for the initial run. Later I will change them in searching for optimal values. innodb_file_per_table = true innodb_data_file… line in MySQL 5.5.8. But, finally, let me show the result I got running Percona Server in optimized mode: innodb…
… even PostgreSQL does not have) as well as Full Text Search parses but there is very long way to go before… engine for MySQL but this role does not suite it well as well for our performance optimization works – we would like to get much more stats from MySQL and it would be great…
… InnoDB full-text search in MySQL 5.6 (part 1) in MySQL 5.6 is syntactically identical to MyISAM full-text search, in the… a handful of references to FTS_DOC_ID found when searching the MySQL 5.6 manual, and the only page which appears… expect some changes in total_word_count, or optimize_(start|end)_time, and the like. However, if I check some of the…
… Server Side optimization – the Client Side Optimization is …type=’search‘ and wtime>1; +———-+—————–+——————+——————+——————+——————+ | count(*) | avg(wtime) | cpu_ratio | mysql_… components (like sphinx and MySQL) or multiple MySQL Servers …
… know on high end custom search solutions can be developed, but if we stick to simple MySQL using multiple indexes on most… JOIN MySQL still will not be able to use it as Optimizer is not smart enough yet to detect such cases: mysql> explain… be likely selected even if it leads to filesort. The solution for this problem is ether extending your indexes so MySQL Optimizer does…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.