June 19, 2013

Post: MySQL Full Text Search in Action

February 7, 2008 By 9 Comments

… are shy in tuning their MySQL Full Text Search index configuration and setting proper ft_min_word_len value. Searching for Audi A6 will… (or shortcut) in MySQL Full Text Search configuration – relaying on minimum keyword length while their application has use cases when search for short keywords… frequently not the case with MySQL Full Text Search which both will skip to frequent keywords in natural language search and because it is…

Filed Under: Insight for Developers Tagged With:

Post: What to do with MySQL Full Text Search while migrating to Innodb ?

September 10, 2009 By 12 Comments

… Text Search indexes which are not supported for Innodb tables. So what can you do ? Leave Tables as MyISAM The beauty of MySQL storage engines is you do not have to convert all tables at once. In some cases full text search is…” MyISAM table which is used for full text search. In certain cases you can just use MySQL triggers to maintain such table, in…

Filed Under: Insight for Developers Tagged With: ,

Post: Full Text Search Webinar Questions Followup

August 24, 2012 By 5 Comments

… webinar this week to give an overview of several Full Text Search solutions and compare their performance.  Even if you missed the… customization on the search algorithm. It would have taken me two to three weeks to do something equivalent with MySQL and it wouldn’t be as flexible and customizable as Solr. With Solr, I was able to fine tune search…

Filed Under: Events and Announcements, Insight for Developers, MySQL

Post: Percona Welcomes MySQL 5.6!

February 25, 2013 By Leave a Comment

… MySQL 5.5 was released, but MySQL 5.6 contains improvements started long before that – for example, work on the Innodb Full Text Search project was started over 6 years ago, in addition with many optimizer and replication features. We’re happy to congratulate MySQL… Oracle MySQL, MySQL 5.6 is fully supported by our MySQL Consulting,  MySQL Support, MySQL Server Development, and MySQL Remote DBA teams: Our MySQL Consulting Team and MySQL…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Percona Software, Percona Toolkit

Post: Percona's Sessions at the O'Reilly MySQL Conference and Expo

April 7, 2011 By Leave a Comment

… and Fixing MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa… (Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text Search Building on Strengths…

Filed Under: Events and Announcements, MySQL

Post: Friends of Percona Get 20% Off at the MySQL Conference!

February 24, 2011 By 5 Comments

… and Fixing MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa… (Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text Search Building on Strengths…

Filed Under: Events and Announcements, MySQL

Post: Sphinx search performance optimization: attribute-based filters

January 15, 2013 By 11 Comments

… Problem While Sphinx is great for full text search, you can certainly go beyond full text search, but before you go there, it is… Speaking in MySQL terms, Full text columns are always indexed and using the very powerful extended query syntax you can do search against… in queries without full text search keywords, having them full text indexed is a very good way to improve such Sphinx search query performance.

Filed Under: Insight for Developers, MySQL Tagged With: , ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… InnoDB. However, up until MySQL 5.6, MyISAM was the only storage engine with support for full-text search (FTS). And I’ve… that InnoDB full-text search in MySQL 5.6 (part 1) in MySQL 5.6 is syntactically identical to MyISAM full-text search, in the sense… a handful of references to FTS_DOC_ID found when searching the MySQL 5.6 manual, and the only page which appears…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…caption id=”attachment_13334″ align=”alignright” width=”214″] InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries![/caption] This is… front of our search term, then that term *must* appear in the search results. But does it? With 5.5: mysql: SELECT id… used double quotes to group the search terms as a single phrase: With 5.5: mysql: SELECT id, full_name, MATCH(full…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Sphinx: Going Beyond full text search

July 23, 2007 By 18 Comments

… using Sphinx with MySQL for scalable Full Text Search applications. For example on BoardReader we’re using this combination to build search against over… many search URLS, such as “dev.mysql.com/download/mysql-5.1.html” would match “mysql.com”, “dev.mysql.com”, “dev.mysql.com/download/” and “dev.mysql…

Filed Under: Insight for Developers Tagged With: ,
« Older Posts