… is Full 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 used… data in Innodb but build a “shadow” MyISAM table which is used for full text search. In certain cases you can just use MySQL triggers…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
Post: Sphinx 2.0.2 Beta is released, Sphinx Users Conference in December
November 17, 2011 By 6 Comments
… it possible to connect to Sphinx as if it were MySQL Server with more advanced connectors which issue such commands when… something like it in 2012. Another thought – with Innodb Full Text Search coming up in MySQL 5.6 and Claimed to be faster than MyISAM… be the main thing on smaller collections but its various full text search features.
Post: Percona's Sessions at the O'Reilly MySQL Conference and Expo
April 7, 2011 By Leave a Comment
…Innodb and XtraDB Architecture and Performance Optimization (Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text Search Building…
Post: Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
…Innodb and XtraDB Architecture and Performance Optimization (Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text Search Building…
Comment: Full text search for all MySQL Storage Engines
July 2, 2006 By 37 Comments
… Sphinx or other full text search system with MySQL as plugin (not hack with storage engine) – for this to happen fulltext search interface would need… this would happen sooner or later especially as there is Innodb full text search in works by Innodb team.
Page: Consulting for MySQL
July 31, 2006 By
… MySQL ? Need help with deadlocks, understanding how Innodb locking works or having Innodb performance issues ? We can help. Full Text Search applications. Need help with implementing Full Text Search solution ? We can help with fine tuning MySQL build in Full Text Search…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… upon upgrading to Innodb. Features The MyISAM features which forbid moving to Innodb are typically Full Text Search and RTREE indexes/GIS with Full Text being much… well as it exercises not so common paths in the MySQL server – in particular Optimizer may have harder time because costs…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… between MyISAM and Innodb though well it is typically easily spotted by converting tables to Innodb on restored backup. Full text search indexes, GIS, multi… table/index scan for Innodb. Defaults You need to know two things about defaults for Innodb. First Depending on MySQL version they may…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
… see that. Searching Billions of documents with MySQL and Sphinx Learn how to build large scale Full Text Search solutions with MySQL and Sphinx. …MySQL – Innodb, Falcon, SolidDB, PBXT and analyzing how things have changed since last summer. Using Slave Server Without Breaking User Experience MySQL…
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… the list for last week: Ways to perform full text search on Chinese texts with MySQL Replication of Summary tables only Overhead of enabled general… many queries Emulation of two Column AUTO_INCREMENT key with Innodb Hope these were helpful, and you’re welcome to post…
