MySQL Performance Blog now uses Sphinx for Site Search

MySQL Performance Blog now uses Sphinx for Site Search

PREVIOUS POST
NEXT POST

I never liked how build in WordPress search works. it shows full documents rather than snippets it does not search comments and it does not have any query language so I always used Google search if I wanted to find something on MySQL Performance Blog.

Today we have published new search functionality for our site which is based on Sphinx. We have developed it as WordPress plugin which will be available as open source software in a few weeks – just want to test it a bit more and write proper documentation before announcing. If you would like to test it however let us know.

As you can see search functionality allows you to specify what would you like to search (Posts, Pages or Comments) as well as if you would like to sort results be relevance of freshness. You can also use query standard Sphinx query language to search phrases or Search MyISAM in post title.

Besides basic search functionality we’ve implemented list of last searches and Top searches which if both nice for fun and for SEO.

Hope this addition will make MySQL Performance Blog more useful for you.

UPDATE: For those looking to download plugin code it is here:
https://launchpad.net/wp-sphinx-plugin/+download

PREVIOUS POST
NEXT POST

Share this post

Comments (52)

  • sambaker67 Reply

    This NEW program allows homeowners to walk away from their underwater mortgage with absolutely no penalty from their mortgage lender and get $3000

    February 15, 2008 at 12:00 am
  • Sightline Payments Reply

    My choice is what I choose to do, and if I’m causing no harm it should not bother you.Your choice is who you choose to be, and if your causing no harm then your alright with me.

    February 15, 2008 at 12:00 am
  • Evan Reply

    Can the Sphinx plugin work on WordPress-MU?

    February 15, 2008 at 3:00 pm
  • Mathias Bank » neue Suche für Wordpress? Reply

    […] der mySQL-Volltextsuche berücksichtigen. Umso interessanter ist die Ankündigung auf dem mySQL Performance Blog, nach der demnächst ein Plugin veröffentlicht wird, das Sphinx verwendet. Ich bin sehr gespannt. […]

    February 15, 2008 at 3:06 pm
  • Carpii Reply

    Great to see you using Sphinx. I always used google to search your site too, but it was never that convenient

    February 15, 2008 at 3:30 pm
  • peter Reply

    Even,

    I do not know about WordPress-MU it likely would need some work.

    February 15, 2008 at 3:52 pm
  • paolo Reply

    Hi guys,

    I’m experiencing some performance issues with full-text indexes on MySQL, and I’m actually studying Sphinx as an alternative. On some tests I’ve done, I see a good performance, but was wondering ifyou could share some benchmarks comparing the two systems on your case. It would help me a lot to sell this change internally 😉

    February 16, 2008 at 4:17 am
  • samuel Reply

    Wow that’s great.

    I’ve heard that you have to use cronjob to make its indexes update periodically.
    Is there any search engine support that for realtime indexes ? That would be great.

    February 16, 2008 at 4:30 am
  • milos Reply

    Sphinx WP plugin sounds great. Usually all WP plugins works with WP-MU, but I don’t know how your plugin works. In WP-MU, tables are numbered, for example wp_1_posts, wp_2_posts etc. I believe you would just have to configure Sphinx index for each blog in Sphinx config and that is it.

    @samule Yes, there is a Lucene search engine but Sphinx is really great once you set it up right, with all updates etc.

    February 16, 2008 at 6:28 am
  • peter Reply

    Right it uses cron to update indexes which is good enough for the task.

    Sphinx will support real time updates in the future. It just takes a time to implement it without performance sacrifices.

    February 17, 2008 at 9:53 am
  • Sphinx + WordPress Reply

    […] a MySQL Performance Blog que aviat tindrem un plugin de WordPress que permetrà llençar cerques contra […]

    February 18, 2008 at 2:48 am
  • Aurimas Mikalauskas Reply

    Nice work, team!

    February 18, 2008 at 4:17 am
  • artnorm // Sphinx for Wordpress Search // simply perfect slim /// // / Reply

    […] Sphinx, a open-source SQL full-text search engine has been WordPress-Plugin-arized by the Folks of the MySQL Performance Blog. […]

    February 19, 2008 at 2:44 am
  • peter Reply

    Paolo,

    Please check presentation page. It has full text search benchmarks for Sphinx/Lucene/MySQL FT. Though all of them are somethat improved and we need to redo them the general idea stays the same.

    February 19, 2008 at 11:35 am
  • paolo Reply

    Thanks Peter… Sorry, I hadn’t noticed the link before.
    I’m a new fan of the blog 😉
    Keep up with the good work.

    February 19, 2008 at 12:45 pm
  • directory Reply

    Ein wirklich sehr Interessante Seite mit guten Informationen.

    February 20, 2008 at 12:17 pm
  • Thanh Hoàng Reply

    Test for fulltext search with Sphinx : Địt con mẹ…Không biết Sphinx có tìm kiếm được cái này không nhỉ ?

    February 22, 2008 at 9:43 am
  • Thanh Hoàng Reply

    Can’t search with keyword : “Địt”

    February 22, 2008 at 9:51 am
  • peter Reply

    Thanh,

    Thank you. I will check how our encoding tables are set up. For this blog we were mainly looking for english search.

    February 22, 2008 at 10:04 am
  • Hi Vietname Reply

    Hi Peter

    I hope Sphinx can support Unicode and Vietnamese.
    “Địt con mẹ” -> Vietnamese

    February 24, 2008 at 9:19 pm
  • Xaprb Reply

    The new search is nice to use. I especially like the phrase proximity relevance, so I see “group commit” results before results that have both “group” and “commit” somewhere in them. :o)

    February 24, 2008 at 9:33 pm
  • peter Reply

    Thanks Baron, Yes phrase proximity really helps with ranking in many cases.
    Group commit is a good example as both GROUP and COMMIT are frequent terms in SQL scripts 🙂

    February 24, 2008 at 10:05 pm
  • peter Reply

    We just updated sphinx tables now to be unicode and now Địt con mẹ is searchable whatever than means 🙂

    February 25, 2008 at 10:30 am
  • Hi Vietname Reply

    Tks Peter,
    Good job.

    February 25, 2008 at 9:28 pm
  • Propiedad Privada » Blog Archive » Plugin de búsqueda para Wordpress basado en Sphinx Reply

    […] gente de MySQL Performance Blog está desarrollando un plugin de búsqueda para WordPress basado en Sphinx, que planean distribuir […]

    February 27, 2008 at 5:13 am
  • fukVietnamese Reply

    peter,

    “Địt con mẹ” mean “Fuck You” in Vietnamese

    March 8, 2008 at 7:14 am
  • fukVietnamese Reply

    I mistake,

    It mean “Fuck your mother”

    Vietnamese very uncultivated!

    March 8, 2008 at 7:17 am
  • Thanh Hoàng Reply

    test for “Đ”.No fuk.
    Tks Peter.

    March 8, 2008 at 9:27 am
  • freeware blackjack kasino Reply

    My English not so good but thank for lovely site with information I looking for and need also.

    March 15, 2008 at 4:43 pm
  • Raymond Reply

    Sphinx is a wonderful full text engine and I recommend anyone wanting great flexibility and performance for full text searches to check it out! I am happy to hear about the WordPress plugin. Great blog BTW!

    March 17, 2008 at 12:27 pm
  • Evan Reply

    Is the plugin available yet?

    March 31, 2008 at 8:39 pm
  • peter Reply

    Evan,

    It is coming if you’re interested I can hook you up with developer for beta testing.

    March 31, 2008 at 8:53 pm
  • Evan Reply

    I’d like that, although I need it for WordPress-MU in an integrated environment with another site, so I’m not sure that I can give much useful feedback for the standard case.

    April 1, 2008 at 1:40 pm
  • Aikaz Reply

    It is likely to be little bit complicated for me to implement. Is there any simple thing other thank Sphinx? But It is worth to try.

    May 16, 2008 at 4:02 pm
  • Tournier Reply

    Hey, I’d like to know how you have handled the very recent post in the index. Are they directly available for search ?
    thanks,

    pierre-yves

    June 13, 2008 at 3:02 am
  • Patrick Reply

    Hi, This sounds great. I’ve wanted to fix my wordpress search for awhile now. Can I check out the beta version of the Sphinx plugin? I’d love to play around with it on my local instance.

    June 22, 2008 at 11:45 am
  • ceiling roses Reply

    nice work , very interesting 🙂 thanks

    July 24, 2008 at 12:05 pm
  • Lisa Reply

    Is your WordPress search plugin available for use by the general public? If so, where can it be downloaded?

    July 26, 2008 at 11:47 am
  • office clearance london Reply

    I think is nice site keep it on , very good

    July 29, 2008 at 1:31 am
  • amica Reply

    Thank you, friends, for your sharing your ideas

    July 30, 2008 at 8:04 pm
  • aarp dental insurance Reply

    Great site! Best wishes!

    August 11, 2008 at 12:28 am
  • william Reply

    great idea I was looking for this solution,where I sign for beta test?

    September 4, 2008 at 9:03 pm
  • Jordi Prats Reply

    This have been already released? I can’t find it neither on this blog neither on wordpress pluguins list… If it haven’t been released can I beta test it? I would be glad of it 🙂

    Jordi

    September 25, 2008 at 9:58 am
  • Ed Reply

    Where can I download the WordPress plugin?

    October 16, 2008 at 10:47 am
  • peter Reply

    Still not published. I passed your comment to developer so he might send you distribution as we have it now.

    October 17, 2008 at 12:56 am
  • yann Reply

    Hi,

    I’m also very interested in this project. Is it possible to have a distribution of this engine ?
    Thanks

    November 12, 2008 at 5:00 am
  • Philippe Reply

    Hi,

    I would be very interested into beta testing it as well,

    Thanks!

    December 15, 2008 at 12:25 pm
  • Walter Reply

    Any new Status for the WordPress Plugin? Any chances to get in contact with the original author?

    February 20, 2009 at 2:33 am
  • peter Reply February 20, 2009 at 4:08 pm
  • Kash Reply

    Hi there,

    This is exactly what I have been searching for 🙂 I downloaded the plugin and uploaded to my WordPress 2.7 site. Unfortunately I got the error below when trying to activate

    Plugin could not be activated because it triggered a fatal error.

    Parse error: syntax error, unexpected T_STRING in /home/dubaijob/public_html/dev/wp-content/plugins/wp-sphinx-plugin-1.0.tar.gz on line 45

    Can anyone help at all, please?

    Thanks

    Kash

    March 19, 2009 at 10:37 am
  • Ovidiu’s Blog » Blog Archive » Sphinx search as Wordpress plugin Reply

    […] I was reading MySQL Performance Blog and I came around an interesting post: MySQL Performance Blog now uses Sphinx for Site Search. […]

    June 23, 2009 at 10:34 am
  • iver Reply

    This plugin works with wordpress 2.9?

    Thanks

    January 11, 2010 at 12:22 am

Leave a Reply