…unlike craigslist it looks like they are shy in tuning their MySQL Full Text Search index configuration and setting proper ft_min_word_len value. Searching for… using with MySQL – Sphinx Search we still tend to use stop word list for…query execution it is rather safe to search a very complex query and…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… for MySQL wire protocol and SphinxQL – SQL-like language to query Sphinx…unlike MySQL Storage Engines, some of which as InfoBright or KickFire take over execution after parsing, Sphinx MySQL…likely stabilize soon. Sphinx also offers number of extensions to the SQL which are helpful for search use…
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
…for multiple value attributes which can be used for storing tags or list of friends. We’re now adding support for search by distance and…for some usages. We also already make sure Sphinx can be used efficiently to perform queries going beyond full text search…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…queries which only use vendor_id but unlikely significantly. It is likely…and “`id` IN (5)” regarding indexes and performance? A: Recent MySQL versions are smart enough to convert id IN (5) to ID=5 (for…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…Unlike many OpenSource projects MySQL was single chunk of code and for years the only way you could officially extend it was using…Search…for very long time. For example Query Cache support for Prepared Statements is only fixed in MySQL 5.1 and…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…MySQL Instance without getting in too much trouble with backups etc – because Sphinx is doing all search…for example these 50 drives will unlikely be helpful solving replication delay or speeding up this 3 hours reporting query…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… 1. Using mysql_* functions directly This is probably bad but I do not like >…are not, and so using IN() list of values derived > by previous query. For example you … are potentially very valuable if searches are done against that information….on a Boolean column for example) is unlikely to be helpful …
Post: Can Innodb Read-Ahead reduce read performance ?
June 26, 2007 By 2 Comments
…and reload large database and we had pretty good IO subsystem so we started number of mysqldump processes in parallel. Unlike…used cells 1303661, node heap has 1974 buffer(s) 867.08 hash searches/s, 532.42 non-hash searches…queries inside Innodb and…MySQL…
