May 25, 2012

Post: BoardReader - Forum Search Engine

November 29, 2006 By 12 Comments

… 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 results… getting normal links as well as domains which have images on them referenced. There are still a lot things to do…

Filed Under: Events and Announcements Tagged With:

Post: MySQL Consulting - Being on your own

February 20, 2007 By 7 Comments

… billing hassles anyway. We also answer a lot of questions on our forum – if you can share your question we will try… to be on our own time. How are we helping people ? Even though we’re saying we’re focusing on MySQL Performance the… a lot of work is designing implementing and performance optimization of full text search applications, especially after we brought Andrew Aksyonoff to…

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. I spend planty…. Here is 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:

Post: Talking MySQL to Sphinx

April 19, 2009 By 4 Comments

… text search performance, we already know Sphinx is much faster than MySQL build in full text search. I was rather interested to look performance… buffer. For the tests I used the table from the forum search engine, leaving just bunch of ids in it, removing everything… to be able to talk to MySQL these days. Now on performance – for given class of queries Sphinx was just 1.5…

Filed Under: Insight for Developers Tagged With:

Post: MySQL Performance Forums

August 10, 2006 By 16 Comments

…m happy to announce availability of MySQL Performance Forums on MySQL Performance Blog. This forum is created as free alternative to MySQL Consulting… MySQL Performance topics. LAMP Forum for Web Application scaling and performance topics, whatever database you’re using and Full Text Search Forum for…

Filed Under: Events and Announcements Tagged With:

Comment: Using MyISAM in production

June 20, 2006 By 35 Comments

… performance blog while searching through performance forum on MySQL site It is a great blog with lot of good information. We are having a weird performance… comment on what might be happening? I’d love to provide more information if 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: ,

Comment: EuroOSCON 2006 - High Performance FullText Search

September 23, 2006 By 4 Comments

… the forum at http://www.tbg.nu In my case the problem with mysql fulltext were that my searches performed: * Using boolean search. * No… above made mysql fulltext to virtually puke when a client performed a search which contained several commonly existing word. I assume the… hits for each word (since it was boolean search), then sort the result on date and finally return top 200 matches (instead…

Filed Under: Events and Announcements Tagged With: ,

Page: Presentations

May 3, 2006 By

… FullText search techniques for content stored in database focusing on delivering high performance for large databases. We look at performance …Scaling and Performance Issues in MySQL MiracleAS Database Forum 2003, Denmark Presentation speaks about benchmarking issues and MySQL performance issues …

Filed Under:

Comment: Four ways to optimize paginated displays

October 3, 2008 By 26 Comments

… good performance and does NOT remove functionality as this article suggests is: I’ll explain how I do it for the forum: ———————————————– 1) I have a statistics table that is updated by triggers on inserts: statistics_table(serviceid, count, lastinsert): +——–+———+—————-+ | SERVICE| COUNTER | LASTINSERT | |——–|———|—————-| | forum… counter from the forum-category table if filtered on a category. If its anything else, like free text search or filtered on a user…

Filed Under: Insight for Developers Tagged With:

Comment: Full text search for all MySQL Storage Engines

July 2, 2006 By 37 Comments

… MySQL full text search in my tests. Speaking about Wildcards – as I know it is on the way. Wildcard search requires “proper” dictionary…_id matching 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: ,