June 19, 2013

Post: Sphinx 0.9.8 is released just in time for OSCON 2008

July 20, 2008 By 2 Comments

… should be the best printed material about Sphinx out there, though as of now Sphinx has surely grown into the size to….6 seconds to do using Sphinx, compared to 7.5 seconds using MySQL with best covering index (so no temporary table or sorting is needed for group by). Note that with Sphinx you can easily…

Filed Under: Insight for Developers Tagged With:

Comment: Full text search for all MySQL Storage Engines

June 29, 2006 By 37 Comments

… with query when full text scan will be faster than index access but would you claim you do not need any… it. Now speaking about index sizes – Sphinx always stores word positions which would take over half of the sphinx index. Plus MySQL stores timestamp… matching clause. I guess removing them would half index size again. Storage sphinx is using is doclist+hitlist with crc32 used as…

Filed Under: Insight for DBAs Tagged With: ,

Post: Innodb Undelete and Sphinx Support

November 12, 2007 By 4 Comments

… tables. We also can get some data recovered from covering indexes and other areas, continually improving our tool set. This service… services for Sphinx. We can support your production Sphinx installation help you with development or organize custom feature development for Sphinx project. We…

Filed Under: Insight for DBAs Tagged With:

Comment: Full Text Search Webinar Questions Followup

August 27, 2012 By 5 Comments

…, many thanks for mentioning Sphinx, and everything else seems good, but this particular bit: > Since RT indexes are in volatile memory, not stored on disk, you are responsible for integrating new data with the on-disk Sphinx index periodically by reindexing the whole collection. is, well, not entirely right. ;) First, by default RT indexes are safe…

Filed Under: Events and Announcements, Insight for Developers, MySQL

Comment: BoardReader - Forum Search Engine

June 26, 2008 By 13 Comments

… are now about 1,2 Billion of indexed forum posts ! I know that with Sphinx you can do distributed searching along the nodes! My questions are : – what is the size of sphinx index you use and what is their number per machine? – Does one index is fully allocated to one…

Filed Under: Events and Announcements Tagged With:

Comment: MySQL Performance Blog now uses Sphinx for Site Search

February 16, 2008 By 52 Comments

Sphinx WP plugin sounds great. Usually all WP plugins works with … configure Sphinx index for each blog in Sphinx config and that is it. @samule Yes, there is a Lucene search engine but Sphinx is…

Filed Under: Insight for Developers Tagged With: , ,

Comment: Full Text Search Webinar Questions Followup

August 27, 2012 By 5 Comments

… some of your insight into the nuances of Sphinx. It remains true that keeping Sphinx indexes synchronized with the source data is a more complex story than keeping MySQL’s built-in FULLTEXT indexes synchronized…

Filed Under: Events and Announcements, Insight for Developers, MySQL

Post: Using index for ORDER BY vs restricting number of rows.

February 16, 2007 By 8 Comments

… decision when it comes to choosing between using index for ORDER BY or using index for restriction. Consider we’re running web… to use index for further restriction and than using file sort, rather than using index for sorting and doing non-index based filtering… a lot of rows. Another interesting technique is to use sphinx search to accelerate sorting and retrieval which I should explain…

Filed Under: Insight for Developers Tagged With:

Comment: Full text search for all MySQL Storage Engines

June 29, 2006 By 37 Comments

Apachez, I doubt MySQL will include Sphinx storage engine in 5.1 GA or even in 5.2. Unfortunately sphinx index cannot be created directly from within mysql, MySQL pluginable architecture does not allow that yet.

Filed Under: Insight for DBAs Tagged With: ,

Comment: Sphinx search performance optimization: multi-threaded search

January 16, 2013 By 10 Comments

… do you think? Does it make sense to distribute my index? I have an 4 Core CPU (Intel(R) Core(TM… only with an RAID-1 system (containing 2 disks). My sphinx index contains about 12 millions records with a disk size of…

Filed Under: MySQL Tagged With: , , ,
« Older Posts
Newer Posts »