… 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 59 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: 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…
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 Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
… full-text search. Understand when to leverage MySQL features such as stored procedures, triggers and events. Operating and Troubleshooting for MySQL… snapshot, InnoDB hot backup). Setup and administer MySQL replication. Monitor MySQL servers in production. Discuss security issues with MySQL. Solve…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
… I have created the outline of improvements available in MySQL 5.6 which I thought was worth sharing to …DIRECTORY for Innodb Tables – Connection Attributes New Functionality for Developers – MemcacheD API in Innodb – Explicit Partition Selection in queries – Full Text Search index for Innodb – …
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…
Post: Sphinx at MySQL Meetup at San Francisco
August 10, 2009 By 9 Comments
… search engine has as well as showing the demo on how simple it is to use Sphinx to implement high performance full text search for your MySQL driven application. We also will have the raffle for 2 tickets for Performance Optimization for MySQL with Innodb and…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… even PostgreSQL does not have) as well as Full Text Search parses but there is very long way to…least it should happen for most common cases. Innodb scaling issues are the most common problem (and…can figure things out and even patch MySQL if needed. So MySQL went to chase Enterprise market and…
