June 19, 2013

Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see

February 12, 2013 By 4 Comments

… the very bottom for the chance to win a free full pass to the conference! When picking talks to attend, I… moved to Sphinx - (Vladimir Fedorkov, PalominoDB) Now that Innodb supports Full-text indexing, I’m interested in other good discussion points about when…

Filed Under: Events and Announcements, MySQL, Percona Live Tagged With: , ,

Comment: Sphinx search performance optimization: attribute-based filters

January 15, 2013 By 11 Comments

… like Sphinx could be made to automagically use Fastbit to index low-selectivity words… For my relatively-low-volume insert-only… (private trouble ticket messages), I’ll probably go for regular full-text indexing (probably Sphinx or MySQL), sharded by year. And let users…

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

Comment: Sphinx search performance optimization: attribute-based filters

January 15, 2013 By 11 Comments

A full text index maps lexical tokens to documents. So when you do a boolean AND against a FTS index of just about any…

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

Comment: How to load large files safely into InnoDB with LOAD DATA INFILE

October 3, 2008 By 29 Comments

Only MyISAM supports full-text indexing in MySQL. If you have a lot of content to index (bigger than your available memory) and you need high performance, you probably need an external solution such as Sphinx or Lucene. Sphinx has a storage engine for easy integration with MySQL.

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

Comment: Percona XtraDB Cluster 5.5.20 - Beta release

February 25, 2012 By 10 Comments

We’ll I’m not going to wait for 5.6, just wishing it was out already. The thing I want most is the built in Full Text indexing, of course I would probably use Sphinx for larger projects. I will be testing out 2.x (I have 1.x in production now) when I get some time (3 or 4 weeks from now).

Filed Under: MySQL, Percona Software, XtraDB Cluster

Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1

July 21, 2009 By 117 Comments

[...] be making a mistake. InnoDB is superior in several areas (Reliability, Backups, Foreign Keys, and Performance in many situations) and while maybe not always the best option (Full Text Indexing), you should know why you’re [...]

Filed Under: Benchmarks Tagged With: ,

Comment: How to load large files safely into InnoDB with LOAD DATA INFILE

October 2, 2008 By 29 Comments

What’s the best way to load lots of large and small files for full text indexing? Which database engine is best suited for FTI? of large files?

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

Comment: MySQL Performance Blog now uses Sphinx for Site Search

February 16, 2008 By 52 Comments

Hi guys, I’m experiencing some performance issues with full-text indexes on MySQL, and I’m actually studying Sphinx as an …

Filed Under: Insight for Developers Tagged With: , ,

Comment: MySQL Error control changes

February 20, 2007 By 4 Comments

Innodb does not support full text indexes, the work is on a way thought. For smaller projects you can use shadow MyISAM table, for larger I would use sphinx (http://www.sphinxsearch.com)

Filed Under: Insight for Developers Tagged With:

Comment: MySQL Error control changes

February 20, 2007 By 4 Comments

“o I’ve seen people thinking they have converted things to Innodb while they really did not because it was substituted back to MyISAM.” What about full text indexes in InnoDB?

Filed Under: Insight for Developers Tagged With:
« Older Posts
Newer Posts »