June 19, 2013

Post: Percona Welcomes MySQL 5.6!

February 25, 2013 By Leave a Comment

… 2 years after MySQL 5.5 was released, but MySQL 5.6 contains improvements started long before that – for example, work on the Innodb Full Text Search project… Plugins are also MySQL 5.6 compatible. Percona Xtrabackup support for MySQL 5.6 is coming next month with Percona Xtrabackup 2.0.6.  Though…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Percona Software, Percona Toolkit

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…InnoDB full-text search in MySQL 5.6 (part 1) in MySQL 5.6 is syntactically identical to MyISAM full-text … sec) Records: 245051 Duplicates: 0 Warnings: 0 mysql> select * from information_schema.innodb_ft_config; +—————————+———+ | KEY | VALUE | …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…caption id=”attachment_13334″ align=”alignright” width=”214″] InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries![/caption] This is part 2…, we took a quick look at some initial configuration of InnoDB full-text search and discovered a little bit of quirky behavior; here…: 0 Warnings: 0 As far as I can tell, this little gotcha doesn’t appear to be mentioned anywhere in the MySQL 5.6…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Updated msl (microslow) patch, installation walk-through!

April 20, 2008 By 17 Comments

…5-10 minutes, depending on the hardware, you will be sitting idle and watching tons of text…string. [qc_miss, full_scan, full_join, tmp_…MySQL 5.0.54a msl patch for MySQL 5.0.56 msl patch for MySQL 5.0.45 with InnoDB extensions msl patch for MySQL 5.0.51a with InnoDB extensions msl patch for MySQL 5.0…

Filed Under: Percona Software Tagged With:

Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see

February 12, 2013 By 4 Comments

…MySQL Query Anti-Patterns that can be moved to Sphinx - (Vladimir Fedorkov, PalominoDB) Now that Innodb supports Full-text…InnoDB features in MySQL 5.6 - (Vadim Tkachenko, Percona) – Tuning Innodb is a huge part of my job, and getting up to 5… exciting things for their 3.0 release. Day 3 Migrating to…

Filed Under: Events and Announcements, MySQL, Percona Live Tagged With: , ,

Post: Sphinx 2.0.2 Beta is released, Sphinx Users Conference in December

November 17, 2011 By 6 Comments

… Technologies have finally released new beta of Sphinx – Sphinx 2.0.2. It includes about 6 months of development and includes… 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.

Filed Under: Cloud and NoSQL, MySQL

Post: MySQL Users Conference Presentation Proposals

October 24, 2007 By 12 Comments

… Innodb Scalability Limits You may have heard Innodb has limited scalability with multiple CPUs and some of these were fixed in recent MySQL 5.0…. Searching Billions of documents with MySQL and Sphinx Learn how to build large scale Full Text Search solutions with MySQL and Sphinx. This presentation…

Filed Under: Events and Announcements Tagged With:

Post: Top 5 Wishes for MySQL

June 29, 2007 By 10 Comments

…MySQL 5.1 the situation is changes – now there are plugable storage engines (something even PostgreSQL does not have) as well as Full Text… most common cases. Innodb scaling issues are the…MySQL 5.0 without consistent work with MySQL close Partner – Innobase to ensure Group Commit still works in 5.0…

Filed Under: Insight for DBAs Tagged With:

Post: Blob Storage in Innodb

February 9, 2010 By 13 Comments

…are stored in Innodb ? This depends on 3 factors. Blob size; Full row size and Innodb row format. … (MySQL 4.1 and below) and COMPACT (MySQL 5.0 and above) format and the fix comes with Innodb Plugin…, TEXT as well as long VARCHAR are handled same way by Innodb. This is why Innodb manual calls…

Filed Under: Insight for DBAs, MySQL Tagged With:

Page: Presentations

May 3, 2006 By

… covering Innodb specific application design recommendations as well as Innodb MySQL Server Settings and Hardware selection aspects. Download Effective Full Text …’re planing on upgrading to MySQL 5.0 Download Optimizing MySQL on Source Code Level MySQL Users Conference 2006, Santa Clara, …

Filed Under:
« Older Posts