Percona's MySQL & InnoDB performance and scalability blog
… an aggregator node that receives the request from application, issues search requests to all data nodes in parallel, merges results from…, you get a bonus: once you configure server for distributed search, you can do indexing in parallel too! Word of caution: while this technique will improve most types of search queries, there are some that aren’t going to benefit…
…. We often deal with people with less than optimized backends with some pages (search,reports etc) taking minutes to load which makes these few seconds you can shave off by client side optimization secondary. Second – The stakes for backend optimization are higher. If you do not optimize your web site on…
… applications you would see main (fact) table which contains search fields and dimension tables which contain more information about facts …
…) is how one can optimize searches using LIKE on a table with singlewords? In my case my search engine has extracted all unique searchwords into its own searchword table. Searching with “WHERE searchword = ‘abc… along with “WHERE searchword LIKE ‘abc%’”, but how to boost searches which are something like “WHERE searchword LIKE ‘%abc%’” ? I tried…
… for the initial run. Later I will change them in searching for optimal values. innodb_file_per_table = true innodb_data_file… me show the result I got running Percona Server in optimized mode: innodb_buffer_pool_size = 26G innodb_buffer_pool_instances…
… to be performed such as report generation or search. It is just unacceptable if search takes a minute even if system has… Efficiency term comes from the fact you can set the optimization goals very differently. Some are concerned about development time and…
….commanual Opened_table_definitionsblogpercona.commanual Opened_tablesblogpercona.commanual optimizer_prune_levelblogpercona.commanual optimizer_search_depthblogpercona.commanual optimizer_switchblogpercona.commanual partitionblogpercona.commanual performance_schemablogpercona.commanual…
… quite typical you also would see external queue, message parsing, search systems etc being important components besides MySQL. MySQL is important… the client prospective where our new service – front end performance optimization comes to play. We look to reduce number of requests… perform any slower in this case. By adding front end optimization services we are able to help to deliver great performing…
When optimizing queries for customers, the first thing I do with a … what it’s trying to do. You can’t fully optimize a query unless you know how to consider alternative ways… optimize it. A good coding standard can help here — you can quickly write a tool to grep your source code and search…
… ending story, you can virtually always find something else to optimize but while on generic system, not tuned by expert you… be throughput rather than latency problems – for example if your search is taking 10 seconds for the single user on idle… is worth to spend time and money implementing things as optimal as possible. If you’re using 50 5000$ database servers…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.