… text query matches, the faster the query will be. That’s self-evident, I guess. Every time a keyword matches a document, Sphinx needs… how long does it take to do a full scan: sphinx> select * from catalog; … 20 rows in set (0.70 sec) sphinx> show… run some different queries against the two: sphinx> select * from catalog where ancient = 1; | total_found | 1499266 | 14% | time | 0.552 | sphinx> select * from…
Post: How Percona does a MySQL Performance Audit
… of queries matter. Some may be extremely fast, but run very often; others may be run seldom but take a long time to…. Queries can be broken into pieces, combined, or even eliminated entirely (we may suggest caching, or tell the customer to evaluate Sphinx, or something like that.) In the common case, though, a query simply needs a rewrite or…
Post: Introducing our Percona Live speakers
…’s a nightmare of temp tables and filesorts and multiple queries and all sorts of things in MySQL — and that’s… might be a good time to mention that Sphinx’s author Andrew Aksyonoff just published a book on Sphinx with O’Reilly! Congratulations Andrew. It’s in my (long) list of reading. Well, that’s all for this time. If…
Comment: Full text search for all MySQL Storage Engines
… searches and running the benchmark a second time the result now is the opposite, sphinx is about twice as fast as TBGsearch. Looking for the reason its obvious that it is because most search queries are…-4 words in the search when TBGsearch outperforms sphinx but as long as the search query has fewer than roughly 4 words it…
Post: Top 5 Wishes for MySQL
…. Two aspects why I’m especially interested about it is Sphinx which is currently implemented as storage engine for MySQL but… really bad is Parallel query. Reporting with group by over 10.000.000 of rows in real time is one painful thing… if something is inconsistent it stays where for very long time. For example Query Cache support for Prepared Statements is only fixed in…
Post: MySQL net_write_timeout vs wait_timeout and protocol notes
…rather typical for some applications to have long delays between queries. If query is being read or result … indexing Sphinx performs sorts and flushes buffers to the disk every so often which can take long …way to tell the server you need more time besides increasing net_write_timeout ? Not what …
Comment: Beware of MyISAM Key Cache mutex contention
… end to a 3 weeks long 24×7 research. MySQL 5.0.81 … periods multiple copies of the same query, sometimes with also same parameters, and … a modern operating system wastes 90% time in rounding-robin and cannot manage…your opinion? What do you think of Sphinx to substitute the fulltext search on MyISAM …
Post: MySQL: Data Storage or Data Processing
…implemented, in other cases you would see Hadoop or Sphinx used to crunch data in parallel or it …if query has to analyze 10.000.000 of rows you’re busted – it simply will take too long …much shorter time. This is why we have to do careful indexing build summary/cache tables hunt queries which …
Post: Percona welcomes Ryan Lowe and Vladimir Fedorkov
… for years in past endeavors. Vladimir can make Sphinx do just about anything, and is an expert … to our clients? It’s not all about query optimization.) Vladimir is also the leader of one …been a MySQL Cluster Certified DBA for quite a long time now. OK, shameless plug over. And, congratulations …

