… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take… the part on which range condition is applied cannot be used for filtering records. For example, suppose you have a key…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
Comment: InnoDB's gap locks
April 13, 2012 By 15 Comments
…DEFAULT NULL, KEY `i` (`i`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 mysql> select * from t; +——+——–+ | i | c | +——+——–+ | 1… write queries behaves as if you were using READ COMMITTED in spite …| +——+——-+ Now go back to session1 and try to search the row with the value “andy”: …
Post: BoardReader - Forum Search Engine
November 29, 2006 By 12 Comments
… is because we were quite busy, mainly building BoardReader.com – Search Engine which indexes tens of thousands of forums from all over… S Stands for Sphinx – Full Text Search Engine which we love to use where large scale search is needed. At this point we have… can use it to Search MySQL Forums Notice simple link structure – you can replace mysql.com in it with any other domain to search forums…
Post: Full text search for all MySQL Storage Engines
June 26, 2006 By 37 Comments
… full text search is currently limited only to MyISAM search engine as well as has few other limits. Today Sphinx Search plugin for MySQL was released which now provides fast and easy to use… do not feel like patching MySQL or use MySQL 5.1 beta to use sphinx as MySQL Storage Engine you can still use it old fashion way…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… also storage engines out where to read sensor data, talk to memcache or external search engine . As MySQL 5.1 and plugable storage engine interface matures I hope we’ll see more storage engines which are… and LIMIT implementation – these can optimized but not by use of MySQL Storage Engine interface, which means it is also has to be…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
… materialized views with Flexviews (the primary purpose of FlexCDC). Feed search engines like Sphinx or Solr only the rows that change. Feed… requires that you use row-based binary logs (RBR). If you don’t have MySQL 5.1 or aren’t using RBR, then…_increment primary key, > c2 int > ) > engine=innodb; Query OK, 0 rows affected (0.00 sec) mysql> insert into test.demo values (1…
Post: Yahoo Search Suggestions for MySQL
August 16, 2007 By 5 Comments
…MySQL to Search field it gives you suggestions for MySQL, which are: * loading javascript arrays with mysql data * mysql performance blog * mysql download * mysql administrator download * mysql… top of the list. Too bad few Geeks use Yahoo for search so most of our search engine traffic comes from …
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
… works, new features in the query optimizer, the storage engine architecture, and so on. The point is that this … on DRBD, partitioning, community toolkits, security, using MySQL with NoSQL, geospatial functionality, cloud computing, Cluster, search, sharding, memcached, high availability, DevOps, …
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
… for index process. With Sphinx which talks directly to the MySQL database we can get some 10.000 of documents indexed… is often supported by search engine directly and it is good idea to see if that can be used The other one is post filtering and post sorting, meaning we simply use search engine to do “boolean search” (or other…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
… MySQL build in full text search. I was rather interested to look performance of other queries, not using Full Text Search. [root@r27 sp]# mysql –host 127.0.0.1 –port 3307 Welcome to the MySQL monitor. Commands…’ to clear the buffer. For the tests I used the table from the forum search engine, leaving just bunch of ids in it…
