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… Sphinx Search Day hosted by Sphinx Technologies (April 13) All these events are free to attend (registration needed) whenever you’re attending MySQL…
Post: Community events around Percona Live MySQL Conference and Expo 2012
March 26, 2012 By 1 Comment
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
… in years.” Darren Cassar called it “one of the best MySQL conferences since I started attending four years ago,” while Marco… release for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking better and better. The SkySQL/MariaDB, Sphinx, and Drizzle… also recorded some of the breakout sessions, so watch Planet MySQL for an announcement when she posts those online. Presentation slides…
Comment: MariaDB 5.3 is released as GA!
March 6, 2012 By 17 Comments
… microsecond timestamp support in version 5.6, yes. MySQL is unlikely to be a usable solution for GIS anytime … than some of the big expensive closed-source databases’ too. Sphinx is a technology to consider for some applications, though. I…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… MySQL Storage Engines, some of which as InfoBright or KickFire take over execution after parsing, Sphinx MySQL support has nothing to do with MySQL… only number of rows it needs to reach the LIMIT Sphinx mysql> select forum_id as f from sptest order by author… full text search applications when exact number is not important. Sphinx mysql> select max(forum_id) as m,author_id as a…
Post: Sphinx 2.0.2 Beta is released, Sphinx Users Conference in December
November 17, 2011 By 6 Comments
… Sphinx 2.0 within next 3 to 6 months. In fact Sphinx 2.0.3-rc is promised within 1 month. What MySQL… to Sphinx as if it were MySQL Server with more advanced connectors which issue such commands when they set up connection. Sphinx Team also announced Sphinx Users…
Post: Can we get faster expression handling in MySQL
March 30, 2010 By 7 Comments
… he published benchmarks comparing arithmetic expression handling in Sphinx to one in MySQL. The result ? Sphinx scored 3x to 20x faster. Andrew goes… are even different) and some performance can be attributed to Sphinx using different typing for expression. Though I’m wondering how… goes on to explain there are further optimizations possible for Sphinx such as JIT compilation and expression optimization which he claims…
Post: Schedule for MySQL Conference 2012 is Published
January 25, 2012 By 3 Comments
… selection of talks with something for MySQL Developers, DBAs, Managers, people just starting to use MySQL as well as looking for advanced… the Enterprise Environments. Some speakers have spent over decade pushing MySQL to its limits, others have in depth experience working on… to migration to MySQL and about NoSQL technologies such as Memcached,Redis,Sphinx which are commonly used to supplement MySQL. The space was…
Post: UDF -vs- MySQL Stored Function
September 6, 2010 By 6 Comments
… pushing it to sphinx – MySQL did not have a function to do the thing so I thought I’ll write MySQL Stored Function… long it took to process 100k rows: mysql> select ltrim_junk_mysql(author), ltrim_junk_mysql(title) from paintings limit 100000; 100000 rows in set (2.97 sec) mysql> select remove_dups_mysql(author), remove_dups_mysql(title) from paintings limit 100000; 100000 rows…
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… Optimization (Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text Search Building…
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… Optimization (Monday Tutorial) Using MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text Search Building…
