… talk will be about Open Source Transactional Storage Engines meaning Innodb, Falcon, Solid and PBXT. We’ll look into architecture of…. We’re also organizing Open Source Full Text Search BOF to hear from people working developing or using Full Text Search and related solutions. One of…
Comment: Why MySQL could be slow with large tables ?
July 30, 2008 By 141 Comments
… 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…
Comment: My Innodb Feature wishes
May 5, 2006 By 30 Comments
Yes… FullText Search would be nice. I however would see MySQL to implement full text search on the top level and make interface all… related feature 
Also if you’re looking to do full text search with Innodb you may give a try to http://www.sphinxsearch.com… types and is normally much faster than build in FullText search. The integration is not as seemless as with build in…
Post: What did we want Interns to do
October 5, 2007 By 1 Comment
… you can do to improve performance monitoring in MySQL Innodb Performance Experiments – There are a lot of hard coded …present typical web LAMP application workloads Full Text Search Benchmark – we would like to get comparison for MySQL build in full text search, Sphinx, Lucene, PostgreSQL Searches.
Post: Sphinx 2.0.2 Beta is released, Sphinx Users Conference in December
November 17, 2011 By 6 Comments
…’ll see something like it in 2012. Another thought – with Innodb Full Text Search coming up in MySQL 5.6 and Claimed to be… be the main thing on smaller collections but its various full text search features.
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… you can get any additional performance. Investigating Innodb Scalability Limits You may have heard Innodb has limited scalability with multiple CPUs and… and see that. Searching Billions of documents with MySQL and Sphinx Learn how to build large scale Full Text Search solutions with MySQL and…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…) – Faster ORDER BY nidxcol LIMIT N – Persistent Statistics for Innodb – Improvements to Innodb Compression – Fast Page Checksums (CRC32) – 4K and 8K Page… 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 – Microsecond…
Post: MySQL Performance Forum: Hot Topics
August 18, 2006 By Leave a Comment
… is the list for last week: Ways to perform full text search on Chinese texts with MySQL Replication of Summary tables only Overhead of… many queries Emulation of two Column AUTO_INCREMENT key with Innodb Hope these were helpful, and you’re welcome to post…
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
…Solve some common application performance problems like paginating results and full-text search. Understand when to leverage MySQL features such as stored … advantages of common backup methods (mysqldump, file system snapshot, InnoDB hot backup). Setup and administer MySQL replication. Monitor MySQL …
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…
