June 19, 2013

Post: An update on Percona Live MySQL Conference & Expo 2012

November 30, 2011 By 2 Comments

… a cadre of the core MySQL developers to submit talks about what is new in MySQL, the MySQL roadmap for the future, and… on DRBD, partitioning, community toolkits, security, using MySQL with NoSQL, geospatial functionality, cloud computing, Cluster, search, sharding, memcached, high availability, DevOps, Big…

Filed Under: Events and Announcements, MySQL

Post: Announcing Percona Live MySQL Conference and Expo 2012

August 9, 2011 By 11 Comments

… planning several months ago and have been in intensive venue searches and contract negotiations ever since then. We have checked and… are a vitally important part of the MySQL ecosystem, they cannot — cannot — replace the traditional MySQL conference and expo. The “and expo” is crucial here — the O’Reilly MySQL conference has occupied the crossroads of open-source, MySQL, community, and business. Emphasis on business…

Filed Under: Events and Announcements, MySQL

Post: Percona's Sessions at the O'Reilly MySQL Conference and Expo

April 7, 2011 By Leave a Comment

… and Fixing MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa… Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text Search Building on Strengths…

Filed Under: Events and Announcements, MySQL

Post: Friends of Percona Get 20% Off at the MySQL Conference!

February 24, 2011 By 5 Comments

… and Fixing MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa… Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text Search Building on Strengths…

Filed Under: Events and Announcements, MySQL

Post: Community events around Percona Live MySQL Conference and Expo 2012

March 26, 2012 By 1 Comment

We’re very pleased with community support for Percona Live MySQL Conference and Expo. We’ve got wonderful speakers providing content… should not miss: Pythian is stepping in to organize traditional MySQL Community Dinner event during Tutorial Day of the conference (April… Search Day hosted by Sphinx Technologies (April 13) All these events are free to attend (registration needed) whenever you’re attending MySQL…

Filed Under: Events and Announcements, MySQL

Post: Ultimate MySQL variable and status reference list

January 8, 2011 By 4 Comments

… referring to the amazing MySQL manual, especially the option and variable reference table. … Opened_tablesblogpercona.commanual optimizer_prune_levelblogpercona.commanual optimizer_search_depthblogpercona.commanual optimizer_switchblogpercona.commanual partitionblogpercona.commanual performance…

Filed Under: Insight for DBAs, MySQL

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

March 4, 2013 By 7 Comments

… id=”attachment_13334″ align=”alignright” width=”214″] InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries![/caption] This is… front of our search term, then that term *must* appear in the search results. But does it? With 5.5: mysql: SELECT id… used double quotes to group the search terms as a single phrase: With 5.5: mysql: SELECT id, full_name, MATCH(full…

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

Post: MySQL Full Text Search in Action

February 7, 2008 By 9 Comments

… is powered by MySQL but unlike craigslist it looks like they are shy in tuning their MySQL Full Text Search index configuration and setting proper ft_min_word_len value. Searching for Audi A6 will… not the case with MySQL Full Text Search which both will skip to frequent keywords in natural language search and because it is…

Filed Under: Insight for Developers Tagged With:

Post: Sphinx: Going Beyond full text search

July 23, 2007 By 18 Comments

….mysql.com” or “dev.mysql.com/download/” as well as they are all considered to belong to mysql.com domain, while searching for “dev.mysql.com/download”" will only match dev.mysql.com domain and files… many search URLS, such as “dev.mysql.com/download/mysql-5.1.html” would match “mysql.com”, “dev.mysql.com”, “dev.mysql.com/download/” and “dev.mysql…

Filed Under: Insight for Developers Tagged With: ,

Post: Sphinx search performance optimization: attribute-based filters

January 15, 2013 By 11 Comments

… common causes of a poor Sphinx search performance I find our customers face is misuse of search filters. In this article I… While Sphinx is great for full text search, you can certainly go beyond full text search, but before you go there, it… in MySQL terms, Full text columns are always indexed and using the very powerful extended query syntax you can do search against…

Filed Under: Insight for Developers, MySQL Tagged With: , ,
« Older Posts
Newer Posts »