…-sphinx_time-utime)/wtime) lost_ratio from performance_log_081221 where page_type=’search’ and wtime>1; +———-+—————–+——————+——————+——————+——————+ | count(*) | avg(wtime) | cpu_ratio | mysql_ratio | sphinx… above for example: mysql> select date_format(logged,’%H’) h,count(*),avg(wtime),avg(sphinx_time/wtime) sphinx_ratio from performance_log_081221 where page…
Post: Sphinx 0.9.8 is released just in time for OSCON 2008
July 20, 2008 By 2 Comments
…we included Sphinx chapter in High Performance MySQL book – check out Appendix C. This should be the best printed material about Sphinx out there…ranking. Another interesting point is Sphinx grouping performance. For example on the same 15M document collection counting number of documents per site_id…
Post: Using Sphinx as MySQL data retrieval accelerator
October 30, 2006 By 25 Comments
… following thread couple of days ago: Basically someone is using sphinx to perform search simply on attributes (date, group etc) and get… may be slower than MySQL. MySQL Make it so one would not need to use sphinx to get great performance for such kind of queries. This includes parallel processing, fast count(*) and bitmap indexes…
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
… for index process. With Sphinx which talks directly to the MySQL database we can get some … depending on how search is implemented is counting number of results matched. FaceBook does not …usages. We also already make sure Sphinx can be used efficiently to perform queries going beyond full text…
Post: BoardReader - Forum Search Engine
November 29, 2006 By 12 Comments
…. For example you can use this link to search our MySQL Performance Forums Second – note the graph which shows how many results… performance reasons – there is too much data to group and quite a hassle to build summary tables as we want to count uniques, but it should be fixed once we rewrite it using sphinx. From that page you…
Comment: Full text search for all MySQL Storage Engines
June 29, 2006 By 37 Comments
…to check if there is the match. Sphinx would count relevance even if sorting is done by SPH… to build very dynamic sort criterias. Speaking about MySQL performance you’re right. There are two pieces which…be really slow. About sphinx – it would be interesting to see which performance do you get if you…
Comment: Full text search for all MySQL Storage Engines
June 28, 2006 By 37 Comments
…of storage (to make it easier to count I leave out the mysql codes needed to store these bytes)…. but also how the search itself will be performed is changed. With a regular lookup table you… Vectorbased search: 0.01 seconds I dont know how sphinx stores data internally but hopefully something of what…
Post: Using index for ORDER BY vs restricting number of rows.
February 16, 2007 By 7 Comments
…of fields which sorting can be performed on such as seller, price, date …quite serious. To fix this issue MySQL would need to better take … you may have however is calculating count of matching rows which may … Another interesting technique is to use sphinx search to accelerate sorting and retrieval…
