May 26, 2012

Post: Percona Live MySQL Conference & Expo Was A Great Event

… be Percona Live New York, which will be held October 1-2, 2012 at the Sentry Conference Center in New York… milestone release for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking better and better. The SkySQL/MariaDB, Sphinx, and Drizzle day… also recorded some of the breakout sessions, so watch Planet MySQL for an announcement when she posts those online. Presentation slides…

Post: Sphinx: Going Beyond full text search

…’ve already wrote a few times about various projects using Sphinx with MySQL for scalable Full Text Search applications. For example on… as “dev.mysql.com/download/mysql-5.1.html” would match “mysql.com”, “dev.mysql.com”, “dev.mysql.com/download/” and “dev.mysql.com/download/mysql-5.1.html” we could…

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

… Stable Sphinx 2.0 within next 3 to 6 months. In fact Sphinx 2.0.3-rc is promised within 1 month. What MySQL Users will find interesting in this release is a lot of work on SphinxQL the Sphinx‘s… MySQL 5.6 and Claimed to be faster than MyISAM’s I really would like to see some benchmarks comparing it to Sphinx

Post: MySQL Users Conference Presentation Proposals

MySQL. Performance comparison of MySQL 5.0, MySQL 5.1 and MySQL 6.0 Come to see how performance of MySQL 5.1 and forthcoming MySQL 6.0 are different from MySQL 5… of documents with MySQL and Sphinx Learn how to build large scale Full Text Search solutions with MySQL and Sphinx. This presentation …

Post: Top 5 Wishes for MySQL

… (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes – now there are plugable storage engines…’m especially interested about it is Sphinx which is currently implemented as storage engine for MySQL but this role does not suite… Query Cache support for Prepared Statements is only fixed in MySQL 5.1 and Most of other items are still open. Well may…

Post: Power of MySQL Storage Engines

Where does real power of MySQL Storage Engines, and pluggable storage engines as MySQL 5.1 lays ? It is very much advertised this allows… sensor data, talk to memcache or external search engine . As MySQL 5.1 and plugable storage engine interface matures I hope we’ll… had the same problem with SphinxSphinx can run sorting and group by operations much faster than MySQL can and it can do…

Post: Using Flexviews - part two, change data capture

… Flexviews (the primary purpose of FlexCDC). Feed search engines like Sphinx or Solr only the rows that change. Feed third party… MySQL 5.1 or aren’t using RBR, then it is possible to set up a dedicated MySQL slave which has log_slave_updates=1…: MySQL 5.1+ row based logging (binlog_format=1) unique server_id in the my.cnf log_slave_updates=1, if this is a MySQL slave…

Post: Full text search for all MySQL Storage Engines

… as well as has few other limits. Today Sphinx Search plugin for MySQL was released which now provides fast and easy to… and distributed searching. A while ago I already wrote about Sphinx Search Egine, comparing it to built in FullText search and… if you do not feel like patching MySQL or use MySQL 5.1 beta to use sphinx as MySQL Storage Engine you can still use it…

Post: Talking MySQL to Sphinx

…id` int(10) unsigned NOT NULL, `num_links` smallint(5) unsigned NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=…Sphinx mysql> select forum_id as f from sptest order by author_id desc limit 10; +————+——–+———-+ | id | weight | forum_id | +————+——–+———-+ | 6739362135 | 1

Comment: Full text search for all MySQL Storage Engines

… 200 best matches). Sphinx is really promising specially now when it will be available as a direct plugin for mysql (I assume this means that the sphinx index can be created directly from within mysql just as with mysql own fulltext…” ? :P Also, does the implementation of sphinx as plugin for mysql 5.1 mean that mysqls own fulltext engine will/might be replaced shortly by sphinx ?