… happening, InnoDB would be the way to go from what I read, But want if you want to use mysql ‘full text search‘ which… 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… 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
… 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… well as it exercises not so common paths in the MySQL server – in particular Optimizer may have harder time because costs…) for logging. Innodb Needs Tuning As a final note about MyISAM to Innodb migration I should mention about Innodb tuning. Innodb needs tuning. Really…
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: 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… 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
…-text search. Understand when to leverage MySQL features such as stored procedures, triggers and events. Operating and Troubleshooting for MySQL …system 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
…January I have created the outline of improvements available in MySQL 5.6 which I thought was worth sharing to …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… 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
… upcoming MySQL Meetup at San Francisco this Thursday, August 13. I will talk about Sphinx covering the new cool features this search… 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 …
