… 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…
Post: Sphinx 0.9.8 reaches RC stage, Docs updated
March 6, 2008 By 1 Comment
Andrew Aksenoff is pretty slow with release numbers for Sphinx. By MySQL Users Conference 2007 Sphinx version 0.9.7 was released and today… (looking at download size) and major rewrite for many portions. Sphinx 0.9.8 snapshots were more stable than 0.9… for MySQL Users Conference. BTW Andrew will be speaking at MySQL Users Conference so if you wanted to learn more about Sphinx it…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
…though Table Locks is probably the most important issue – with modern multi core servers not only the fact… search. In certain cases you can just use MySQL triggers to maintain such table, in other cases… search results it can work pretty well. Use Sphinx or other external full text search engine This…
Post: Sphinx at MySQL Meetup at San Francisco
August 10, 2009 By 9 Comments
… be presenting at upcoming MySQL Meetup at San Francisco this Thursday, August 13. I will talk about Sphinx covering the new cool… how simple it is to use Sphinx to implement high performance full text search for your MySQL driven application. We also will have the raffle for 2 tickets for Performance Optimization for MySQL with Innodb and…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… on! How to determine which MySQL High-Availability solution is best? What is really tricky with MySQL is the number of possible HA solutions. From the simplest the most complex let’s list the most common ones: – MySQL… “MySQL replication” and “Master-Master with MMM manager” Don’t use any special MyISAM feature All Can change MyISAM Full text to Sphinx…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
… most efficiently with MySQL. MySQL Performance Landscape This presentation compares MySQL Performance with different CPUs, Operation systems, RAID Configuration, File Systems to assist you with your…. Searching Billions of documents with MySQL and Sphinx Learn how to build large scale Full Text Search solutions with MySQL and Sphinx. This presentation will talk…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… to MySQL you of course may consider to delay migration but if you’re already with MySQL and requiring transactions you’re stuck with… of queries with MySQL, it is not easy to do however as there is no interface. We had the same problem with Sphinx – Sphinx can run sorting and group by operations much faster than MySQL can and it can do…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
… fill in gaps in my knowledge (especially with topics that have come up repeatedly) with sessions on topics that I already specialize… that talk from Seppo (Codership) before. MySQL Query Anti-Patterns that can be moved to Sphinx - (Vladimir Fedorkov, PalominoDB) Now that Innodb…’m interested in other good discussion points about when selecting Sphinx would still be useful. Tracking Page Changes for Your Database…
Post: MySQL Full Text Search in Action
February 7, 2008 By 9 Comments
… kinds of shortcuts) This however is frequently not the case with MySQL Full Text Search which both will skip to frequent keywords… worse. Looking at alternative solution, which we’re often using with MySQL – Sphinx Search we still tend to use stop word list for… in time. From Relevance standpoint “stop words” rarely cause problems with sphinx because it uses word position based ranking not just frequency…
Post: MySQL net_write_timeout vs wait_timeout and protocol notes
July 8, 2007 By 1 Comment
… leaving server with partial query received. Result set however comes back in multiple pieces and if you’re using mysql_use_result… cause of aborted connections while using Sphinx with large data sets and large buffers. While indexing Sphinx performs sorts and flushes buffers to… you’re fetching data because there is buffering happening inside MySQL client library so you never know when real network read…
