June 20, 2013

Post: Friends of Percona Get 20% Off at the MySQL Conference!

February 24, 2011 By 5 Comments

… and Fixing MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa… Optimization (Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text Search Building…

Filed Under: Events and Announcements, MySQL

Post: Sphinx search performance optimization: attribute-based filters

January 15, 2013 By 11 Comments

… still want to take advantage of otherwise superb Sphinx performance. The Problem While Sphinx is great for full text search, you can… right way. In Sphinx, columns are basically one of two kinds: a) full text b) attributes Speaking in MySQL terms, Full text… which looks like talking to MySQL server, but it’s not. It is me talking to Sphinx server. First of all, let…

Filed Under: Insight for Developers, MySQL Tagged With: , ,

Post: Sphinx: Going Beyond full text search

July 23, 2007 By 18 Comments

…’ve already wrote a few times about various projects using Sphinx with MySQL for scalable Full Text Search applications. For example on… site or forum from the global sphinx index. So in general we find parallel processing using sphinx pretty good solution for many data crunching needs especially when lack of parallel abilities in MySQL makes its…

Filed Under: Insight for Developers Tagged With: ,

Post: Full Text Search Webinar Questions Followup

August 24, 2012 By 5 Comments

… SQL and 20 on Sphinx). Also Sphinx does the relevance sorting by default, adding relevance sorting to the MySQL queries would make them… multiple terms, can you get Sphinx to report which matched? The SHOW META command in Sphinx shows how many rows each keyword…? No, only the documents included in the Sphinx Search indexes will be returned by Sphinx Search queries. Mike W. also asked: Q…

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

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, though as of now Sphinx… takes 3.6 seconds to do using Sphinx, compared to 7.5 seconds using MySQL with best covering index (so no temporary…

Filed Under: Insight for Developers Tagged With:

Post: Sphinx search performance optimization: multi-threaded search

January 16, 2013 By 10 Comments

Queries in MySQL, Sphinx and many other database or search engines are typically single-… matter). Let me put it another way. If your MySQL or Sphinx query takes 10s to run on a machine with a… your data looks like. Finishing line I always loved how Sphinx scales out easily with as many machines you need and…

Filed Under: MySQL Tagged With: , , ,

Post: Sphinx Technologies launches Sphinx Support

March 24, 2009 By 1 Comment

A couple of weeks ago Sphinx Technologies, a company behind Sphinx Full Text Search Engine launched Sphinx Support Packages which I think is a great value for everyone using Sphinx in… for accounting people. The Support approach was closely modeled from MySQL Support of the early days – simple service lever differentiation with…

Filed Under: Events and Announcements Tagged With:

Post: Innodb Undelete and Sphinx Support

November 12, 2007 By 4 Comments

… of services which should be helpful to MySQL Community and which are not offered by MySQL, Oracle and other companies I know… services for Sphinx. We can support your production Sphinx installation help you with development or organize custom feature development for Sphinx project. We have been active Sphinx users from…

Filed Under: Insight for DBAs Tagged With:

Post: Introducing our Percona Live speakers

May 10, 2011 By 4 Comments

… the things you don’t know about Sphinx’s capabilities. Many people think of Sphinx as a great search engine, but it… MySQL — and that’s just for performing this task on a single server, not to mention a cluster of servers. Well, Sphinx… a good time to mention that Sphinx’s author Andrew Aksyonoff just published a book on Sphinx with O’Reilly! Congratulations Andrew…

Filed Under: MySQL

Post: First Sphinx Conference is Announced

September 10, 2010 By Leave a Comment

… on using Sphinx Together and instead of MySQL. There are going to be number of talks which describe Sphinx deployment alongside with MySQL so this conference should be interested to a lot of MySQL users. This is going to be predominately Russian speaking event. Sphinx…

Filed Under: Events and Announcements Tagged With: , , ,
« Older Posts
Newer Posts »