MySQL Performance Blog now uses Sphinx for Site Search
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.
Print This Post
del.icio.us :: 
digg Comment RSS :: Trackback URI
34 Comments
Can the Sphinx plugin work on Wordpress-MU?
Comment :: February 15, 2008 @ 3:00 pm
[…] 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. […]
Pingback :: February 15, 2008 @ 3:06 pm
Great to see you using Sphinx. I always used google to search your site too, but it was never that convenient
Comment :: February 15, 2008 @ 3:30 pm
Even,
I do not know about WordPress-MU it likely would need some work.
Comment :: February 15, 2008 @ 3:52 pm
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
Comment :: February 16, 2008 @ 4:17 am
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.
Comment :: February 16, 2008 @ 4:30 am
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.
Comment :: February 16, 2008 @ 6:28 am
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.
Comment :: February 17, 2008 @ 9:53 am
[…] a MySQL Performance Blog que aviat tindrem un plugin de WordPress que permetrà llençar cerques contra […]
Pingback :: February 18, 2008 @ 2:48 am
Nice work, team!
Comment :: February 18, 2008 @ 4:17 am
[…] Sphinx, a open-source SQL full-text search engine has been Wordpress-Plugin-arized by the Folks of the MySQL Performance Blog. […]
Pingback :: February 19, 2008 @ 2:44 am
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.
Comment :: February 19, 2008 @ 11:35 am
Thanks Peter… Sorry, I hadn’t noticed the link before.
I’m a new fan of the blog
Keep up with the good work.
Comment :: February 19, 2008 @ 12:45 pm
Ein wirklich sehr Interessante Seite mit guten Informationen.
Comment :: February 20, 2008 @ 12:17 pm
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ỉ ?
Comment :: February 22, 2008 @ 9:43 am
Can’t search with keyword : “Địt”
Comment :: February 22, 2008 @ 9:51 am
Thanh,
Thank you. I will check how our encoding tables are set up. For this blog we were mainly looking for english search.
Comment :: February 22, 2008 @ 10:04 am
Hi Peter
I hope Sphinx can support Unicode and Vietnamese.
“Địt con mẹ” -> Vietnamese
Comment :: February 24, 2008 @ 9:19 pm
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)
Comment :: February 24, 2008 @ 9:33 pm
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
Comment :: February 24, 2008 @ 10:05 pm
We just updated sphinx tables now to be unicode and now Địt con mẹ is searchable whatever than means
Comment :: February 25, 2008 @ 10:30 am
Tks Peter,
Good job.
Comment :: February 25, 2008 @ 9:28 pm
[…] gente de MySQL Performance Blog está desarrollando un plugin de búsqueda para Wordpress basado en Sphinx, que planean distribuir […]
Pingback :: February 27, 2008 @ 5:13 am
peter,
“Địt con mẹ” mean “Fuck You” in Vietnamese
Comment :: March 8, 2008 @ 7:14 am
I mistake,
It mean “Fuck your mother”
Vietnamese very uncultivated!
Comment :: March 8, 2008 @ 7:17 am
test for “Đ”.No fuk.
Tks Peter.
Comment :: March 8, 2008 @ 9:27 am
Nice work chief
Comment :: March 9, 2008 @ 4:11 am
nice site indeed
Comment :: March 11, 2008 @ 6:43 am
My English not so good but thank for lovely site with information I looking for and need also.
Comment :: March 15, 2008 @ 4:43 pm
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!
Comment :: March 17, 2008 @ 12:27 pm
nice site keep it on
Comment :: March 18, 2008 @ 6:39 am
Is the plugin available yet?
Comment :: March 31, 2008 @ 8:39 pm
Evan,
It is coming if you’re interested I can hook you up with developer for beta testing.
Comment :: March 31, 2008 @ 8:53 pm
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.
Comment :: April 1, 2008 @ 1:40 pm