… 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: 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
… being faster than MySQL full text search in my tests. Speaking about Wildcards – as I know it is on the way. Wildcard search requires “proper… 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…
Comment: Why MySQL could be slow with large tables ?
July 30, 2008 By 139 Comments
… reads happening, InnoDB would be the way to go from what I read, But want if you want to use mysql ‘full text search‘ which… the same table, one using InnoDB for main reading purposes and one for MyISAM for searching using Full text search and every time you do… hour to keep MyISAM table in sinc or somthing, meaning search would be out of date by one hour – which I…
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: 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
… to work together to produce better talk instead. Hidden Innodb Tuning Options Innodb Storage Engine has a lot of tuning options hardcoded… and see that. Searching Billions of documents with MySQL and Sphinx Learn how to build large scale Full Text Search solutions with MySQL and Sphinx. This…
