….6, yes. MySQL is unlikely to be a usable solution for GIS anytime soon, because adding a new index type to InnoDB… than some of the big expensive closed-source databases’ too. Sphinx is a technology to consider for some applications, though. I…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… MySQL Storage Engines, some of which as InfoBright or KickFire take over execution after parsing, Sphinx MySQL support has nothing to do with MySQL… and no indexes there defined – Sphinx does not support explicit indexes and it is clear when you can use index for sort MySQL will be… full text search applications when exact number is not important. Sphinx mysql> select max(forum_id) as m,author_id as a…
Post: Sphinx 2.0.2 Beta is released, Sphinx Users Conference in December
November 17, 2011 By 6 Comments
… to Sphinx as if it were MySQL Server with more advanced connectors which issue such commands when they set up connection. Sphinx Team also announced Sphinx Users… like to see some benchmarks comparing it to Sphinx, especially to its Real Time indexes. Some easy to understand feature comparison table…
Post: UDF -vs- MySQL Stored Function
September 6, 2010 By 6 Comments
… pushing it to sphinx – MySQL did not have a function to do the thing so I thought I’ll write MySQL Stored Function… really – building the index, which was taking 10 minutes, was now taking 16 minutes. Then we added another MySQL function for different set of attributes and indexing speed went from 16 minutes to 26…
Post: Sphinx: Going Beyond full text search
July 23, 2007 By 18 Comments
… “dev.mysql.com/download/mysql-5.1.html” would match “mysql.com”, “dev.mysql.com”, “dev.mysql.com/download/” and “dev.mysql.com/download/mysql-5.1… for Sphinx attribute storage). It is especially great as there is still room for optimization – Sphinx stores word positions in the index, while… site or forum from the global sphinx index. So in general we find parallel processing using sphinx pretty good solution for many data…
Post: Using Sphinx as MySQL data retrieval accelerator
October 30, 2006 By 25 Comments
… efficient indexes so selectivity is done by index and index used to resolve order by. Funny enough to filter by attributes or sort sphinx does not use indexes – indexes are… databases which may be slower than MySQL. MySQL Make it so one would not need to use sphinx to get great performance for…
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… 3.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…
Post: Innodb Undelete and Sphinx Support
November 12, 2007 By 4 Comments
…be helpful to MySQL Community and which are not offered by MySQL, Oracle and… get some data recovered from covering indexes and other areas, continually improving our …Sphinx. We can support your production Sphinx installation help you with development or organize custom feature development for Sphinx…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… Full text indexes and GIS indexes that are supported only by MyISAM. The HA solutions that work well with MyISAM are “MySQL replication… the application, the MyISAM Full text indexes might be replaced by another search engine like Sphinx in order to remove the restriction… based on replication that handles GIS indexes. HA solutions Need MyISAM Full text or GIS indexes “MySQL replication” and “Master-Master with MMM…
Post: MySQL Full Text Search in Action
February 7, 2008 By 9 Comments
… is powered by MySQL but unlike craigslist it looks like they are shy in tuning their MySQL Full Text Search index configuration and…. Looking at alternative solution, which we’re often using with MySQL – Sphinx Search we still tend to use stop word list for… time. From Relevance standpoint “stop words” rarely cause problems with sphinx because it uses word position based ranking not just frequency…
