…pages which are requested for real humans vs search engine bots (which are often …queries causing the problem you see the ones which cause the most impact and focus on optimizing them. There are multiple…needs attention. Though even for less complicated single MySQL server application there is often …
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…David S. asked: Q: If searching on multiple terms, can you get Sphinx to report… of any SQL query, and if you can form a SELECT query that returns the “… Q: Were these tests performed on a single machine and a common/share set of… announced the webinar: We evaluated MySQL vs Solr. I was able to index …
Post: Mystery Performance Variance with MySQL Restarts
February 20, 2013 By 18 Comments
…surprising comments about my MySQL 5.5 vs 5.6 performance post I decided …5 and MySQL 5.6 both with single thread and 64 threads run, though …slower with no changes to the query load or query plans, which can be solved by…careful with benchmarks. We need to do multiple runs with MySQL restarts in the …
