… no temporary table or sorting is needed for group by). Note that with Sphinx you can easily run the process on multiple cores/multiple nodes. Anyways I’m excited of this new Sphinx milestone, and…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… group by with on disk temporary table which will make Sphinx much faster and few others. The true gain from Sphinx however comes from its ability to scale almost linearly using multiple CPU cores and multiple nodes in the system…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… based on the search implementation, and that’s an important factor in choosing a solution. David S. asked: Q: If searching on multiple terms, can you get Sphinx to report which matched? The SHOW META command in Sphinx shows how many rows… the search would necessarily do table-scans. Jessy B. also asked: Q: Were these tests performed on a single machine and a…
Comment: Beware of MyISAM Key Cache mutex contention
January 12, 2010 By 10 Comments
… processes showed in issue periods multiple copies of the same query, sometimes with also same parameters, and on OS side I was… put on its knees a monster 16 Xeon cores 16gb box. What is your opinion? What do you think of Sphinx to substitute the fulltext search on MyISAM table? Peter, I owe you a beer, big…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… focus on hard data in your work. For small and medium size applications you can log all requests to MySQL table for… ones which cause the most impact and focus on optimizing them. There are multiple ways to optimize something, my checklist is usually… helpful for complex applications using mutliple components (like sphinx and MySQL) or multiple MySQL Servers because in these cases you often can…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… better data consistency guaranty or being bitten repairing multiple GB MyISAM table few times, though Table Locks is probably the most important issue… on regular basics. In case you can afford to have stale data in search results it can work pretty well. Use Sphinx… to. This eliminates the need to have MyISAM table anywhere. We use Sphinx in a lot of cases as it is very…
Post: Introducing our Percona Live speakers
May 10, 2011 By 4 Comments
… temp tables and filesorts and multiple queries and all sorts of things in MySQL — and that’s just for performing this task on a single server, not to mention a cluster of servers. Well, Sphinx is very good at… a good time to mention that Sphinx’s author Andrew Aksyonoff just published a book on Sphinx with O’Reilly! Congratulations Andrew. It…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… Can change MyISAM Full text to Sphinx All 4. What is the write …on the slave can handle the write operations. If the replication master is multi-cores servers and is heavily writing using multiple… expertise level is summarized in the table below. Expertise level MySQL replication Typical, average…
Comment: Using Sphinx as MySQL data retrieval accelerator
November 7, 2006 By 25 Comments
… selectivity (over 50% matching rows) simple full table scan with limit actually would offer best … agree with you. Everything has its purpose – sphinx is designed exactly for usages where relevance … use multiple CPUs for such query. Even with MySQL Cluster sort would be done on MySQL server …
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… why I’m especially interested about it is Sphinx which is currently implemented as storage engine …manually chop your data to the multiple databases and handle data merging on application together with high …in distributed manner. Of course there are summary tables and other tricks we use when such …
