… comparing systems providing full text search systems. Unlike database management systems which normally should provide same result to same SQL query, for full text search systems results are often different, depending on relevance computing method. If you’ve been using sphinx in default search mode…
Post: MySQL Performance Forums
August 10, 2006 By 18 Comments
… 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…
Post: What did we want Interns to do
October 5, 2007 By 1 Comment
… workloads. Web Application Database Benchmark – we would like to get few benchmarks which present typical web LAMP application workloads Full Text Search Benchmark – we would like to get comparison for MySQL build in full text search, Sphinx, Lucene, PostgreSQL Searches.
Post: Report from OSCON 2008
July 27, 2008 By 7 Comments
… magnitude speedups people often experience compared to MySQL build in full text search look too good to be true. I’ve clarified this… consideration which was built well exactly for the task while full text search in database systems if often afterthought. At the same time I…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… with Innodb. For example binary copy of one of the databases from the Slave to the dev envinronment works great for… features which forbid moving to Innodb are typically Full Text Search and RTREE indexes/GIS with Full Text being much more common. There are workarounds… work well with defaults. I’ve seen hundreds of GB databases ran with MyISAM with default settings and it worked reasonably…
Comment: Cache Performance Comparison
August 10, 2006 By 74 Comments
… working on FullText Search Engine comparison for MySQL and test MySQL Build in Full Text Search, Siena, Sphinx, Lucene indexing Wikipedia database and performing appropriate… still OK for some of applications. Also I have little database with over 150 millions of posts which I could help…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… this topic about Moving MyISAM to Innodb as well as searching the blog – We’ve blogged so much on this topic… as a probability as long as you write to the database. They may be rate but it is rather hard to… easily spotted by converting tables to Innodb on restored backup. Full text search indexes, GIS, multi-column auto increment keys are great examples…
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
… that make the most sense, including caching, message queuing, database sharding, and replication. Optimize MySQL schema and indexes to … Solve some common application performance problems like paginating results and full-text search. Understand when to leverage MySQL features such as stored …
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… engines (something even PostgreSQL does not have) as well as Full Text Search parses but there is very long way to go before… normally need to manually chop your data to the multiple databases and handle data merging on application together with high availability… forget about the roots. MySQL has gained its popularity as database for Web but web users do not pay much because…
Post: Percona Welcomes MySQL 5.6!
February 25, 2013 By Leave a Comment
… started long before that – for example, work on the Innodb Full Text Search project was started over 6 years ago, in addition with…, we have customers backing up and restoring MySQL 5.6 databases in standard configuration successfully with the current version. The largest…
