May 23, 2012

Post: BoardReader - Forum Search Engine

November 29, 2006 By 12 Comments

… were quite busy, mainly building BoardReader.com – Search Engine which indexes tens of thousands of forums from all over the world. This project… in this project only on database Backend and full text search engine implementation. In this part it is standard LAMPS application. I… S Stands for Sphinx – Full Text Search Engine which we love to use where large scale search is needed. At this point we…

Filed Under: Events and Announcements Tagged With:

Post: Talking MySQL to Sphinx

April 19, 2009 By 4 Comments

… buffer. For the tests I used the table from the forum search engine, leaving just bunch of ids in it, removing everything else…, `forum_id` int(10) unsigned NOT NULL, `author_id` int(10) unsigned NOT NULL, `num_links` smallint(5) unsigned NOT NULL ) ENGINE… 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:

Page: Presentations

May 3, 2006 By

…search functionality using real medium size text collection – Wikipedia Articles dump, when we compare it to other opensource full text search search engines…) Download Scaling and Performance Issues in MySQL MiracleAS Database Forum 2003, Denmark Presentation speaks about benchmarking issues and …

Filed Under:

Comment: Cache Performance Comparison

August 10, 2006 By 73 Comments

The search engine uses chunked bitvectors where each chunk is 10kbit (1250 bytes … chunk in common the search is halted and the engine reports “0 hits”. Currently it is only indexing the forum of www.tbg…. The engine itself is currently available at http://www.tbg.nu/cgi-bin/news_search.cgi and works like google (AND search) with…

Filed Under: Insight for Developers Tagged With:

Comment: Full text search for all MySQL Storage Engines

June 27, 2006 By 37 Comments

… engines since the mysql fulltext has it limitations specially when used in boolean mode on large results (for example a boolean search… fulltext engine ?). However I found some issues with the standalone testversions which ended up with that I created my own fulltext search engine… could do it any better for my case (fulltext search engine for a forum). What I have done is to mix reversed index…

Filed Under: Insight for DBAs Tagged With: ,

Comment: EuroOSCON 2006 - High Performance FullText Search

September 23, 2006 By 4 Comments

… to 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… how large the difference would be if I created a search engine written only in perl with mysql as backend for the…

Filed Under: Events and Announcements Tagged With: ,

Comment: Full text search for all MySQL Storage Engines

July 2, 2006 By 37 Comments

… to the mask and perform the search. I would suggest to write request on sphinx Forum. Andrew is very considerable to user… other full text search system with MySQL as plugin (not hack with storage engine) – for this to happen fulltext search interface would need to be rewritten to support multiple full text search engines behind it…

Filed Under: Insight for DBAs Tagged With: ,

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… wanted to use in-memory engine, but for some reason I got empty results when querying the forum-category table when in…

Filed Under: Insight for Developers Tagged With:

Comment: Using MyISAM in production

June 20, 2006 By 35 Comments

Hi peter, I came across your performance blog while searching through performance forum on MySQL site It is a great blog with… mode We are suspecting ,based on some thread on MyISAM engine forum, that it may be some sort of “garbage collector” problem… you need. I also posted this on forum and here is the link http://forums.mysql.com/read.php?21,85701,96186…

Filed Under: Insight for DBAs Tagged With: ,

Post: MySQL Users Conference Presentation Proposals

October 24, 2007 By 12 Comments

… Search solutions with MySQL and Sphinx. This presentation will talk about architecture of BoardReader.com which indexes over billion of forum posts. Transactional Storage Engines Performance We’re looking at performance at Open Source Transactional Storage engine MySQL – Innodb, …

Filed Under: Events and Announcements Tagged With: