May 23, 2012

Post: BoardReader - Forum Search Engine

November 29, 2006 By 12 Comments

… it to Search MySQL Forums Notice simple link structure – you can replace mysql.com in it with any other domain to search forums from that domain. For example you can use this link to search our MySQL Performance Forums Second – note the graph which shows how many results were found matching this terms right from search…

Filed Under: Events and Announcements Tagged With:

Post: Sphinx: Going Beyond full text search

July 23, 2007 By 18 Comments

… Full Text Search applications. For example on BoardReader we’re using this combination to build search against over 1 billion of forum posts totaling over 1.5TB of data handling hundreds of thousands of search queries per day. The count of forum posts…

Filed Under: Insight for Developers Tagged With: ,

Post: Talking MySQL to Sphinx

April 19, 2009 By 4 Comments

… Sphinx is much faster than MySQL build in full text search. I was rather interested to look performance of other queries… buffer. For the tests I used the table from the forum search engine, leaving just bunch of ids in it, removing everything… is geared towards full text search applications when exact number is not important. Sphinx mysql> select max(forum_id) as m,author…

Filed Under: Insight for Developers Tagged With:

Post: MySQL Performance Forums

August 10, 2006 By 16 Comments

… Forum for Web Application scaling and performance topics, whatever database you’re using and Full Text Search Forum for discussion of Full Text Search applications, whatever database and search application you’re using. We will add more forums over…

Filed Under: Events and Announcements Tagged With:

Post: MySQL Performance Forum: Hot Topics

August 18, 2006 By Leave a Comment

As I already announced last week I started MySQL Performance Forums project focusing on MySQL Performance discussions as it names says… the list for last week: Ways to perform full text search on Chinese texts with MySQL Replication of Summary tables only…

Filed Under: Events and Announcements Tagged With:

Page: Presentations

May 3, 2006 By

…dump, when we compare it to other opensource full text search search engines such as lucene,sphinx,tbgsearch,sienna, mnogosearch and perform…(Outdated) Download Scaling and Performance Issues in MySQL MiracleAS Database Forum 2003, Denmark Presentation speaks about benchmarking issues and MySQL …

Filed Under:

Comment: Four ways to optimize paginated displays

October 3, 2008 By 26 Comments

… on inserts: statistics_table(serviceid, count, lastinsert): +——–+———+—————-+ | SERVICE| COUNTER | LASTINSERT | |——–|———|—————-| | forum | 10020202| 2008-10-03…. | | users | 10002| 2008-09-13…. | (I… counter from the forum-category table if filtered on a category. If its anything else, like free text search or filtered on…

Filed Under: Insight for Developers Tagged With:

Comment: Cache Performance Comparison

August 10, 2006 By 73 Comments

… in common the search is halted and the engine reports “0 hits”. Currently it is only indexing the forum of www.tbg… http://www.tbg.nu/cgi-bin/news_search.cgi and works like google (AND search) with the addition that it is also… indexed etc… What I have found currently is that wildcard searches are those which are somewhat slow (usually more than 5…

Filed Under: Insight for Developers Tagged With:

Comment: EuroOSCON 2006 - High Performance FullText Search

September 23, 2006 By 4 Comments

… build a complete standalone search engine solution but to find a replacement of mysql fulltext for the forum at http://www.tbg.nu In my case the problem with mysql fulltext were that my searches performed: * Using boolean search… mysql fulltext to virtually puke when a client performed a search which contained several commonly existing word. I assume the reason…

Filed Under: Events and Announcements Tagged With: ,

Comment: Full text search for all MySQL Storage Engines

July 2, 2006 By 37 Comments

… Wildcards – as I know it is on the way. Wildcard search requires “proper” dictionary to be implemented in sphinx. Currently (0… to the mask and perform the search. I would suggest to write request on sphinx Forum. Andrew is very considerable to user… (not hack with storage engine) – for this to happen fulltext search interface would need to be rewritten to support multiple full…

Filed Under: Insight for DBAs Tagged With: ,