… 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…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
Post: BoardReader - Forum Search Engine
November 29, 2006 By 12 Comments
…Search Engine which we love to use where large scale search…to search forums from that domain. For example you can use this link to search our MySQL Performance Forums Second – note the graph which shows how…
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
…interesting) results, how to do super-advanced and extreme things with MySQL, how to use MySQL for …engine architecture, and so on. The point is that this year, we need to make… toolkits, security, using MySQL with NoSQL, geospatial functionality, cloud computing, Cluster, search, sharding, memcached,…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… it’s easy and familiar for me to use the example of search engine marketing. I’ll do that throughout this…growing data size forces it to. This goes back to what data you really need to make your business run. … but how much time do you have? And the gains are simply limited by some of MySQL‘s …
Post: FaceBook Search, Search for social networks
August 12, 2007 By 4 Comments
…to be indexed available for index process. With Sphinx which talks directly to the MySQL…search engine externals. Simple filtering/sorting though is often supported by search engine directly and it is good idea to…
Post: The case for getting rid of duplicate “sets”
May 17, 2011 By 2 Comments
… arithmetic to make the math faster, adding 10 + 10. This is a simple fact, that when you distribute computation you work faster. How…) to a “search set” table: CREATE TABLE `search_set` ( `val` bigint(20) DEFAULT NULL, `cnt` bigint(20) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; mysql…
Page: Consulting for MySQL
July 31, 2006 By
…to avoid downtime. Customized Training for MySQL Want your developers to learn MySQL best practices ? How to work with large data sets in MySQL or how to…to make sure their learning curve is as fast as possible. Data Recovery for MySQL Lost your data due to…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
…acted a lot as Sales Engineer. It turns out however …MySQL Related work – it is very hard to find people with good enough MySQL knowledge. MySQL themselves are searching for them, Google is searching…makes us more capable of solving customer problems because we have experience not only advising how to…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…with an overview of how to install and run …search engines like Sphinx or Solr only the rows that change. Feed third party replication systems. Provide data to…to consumer.ini and edit it, making appropriate changes. The file is well commented. The example settings file should work for most MySQL…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
…how it would compare to Innodb storage engine – old timer in this space. Does it add choice to…to customer winning. When Falcon looses to Innodb in certain cases it makes Jim to…engines out where to read sensor data, talk to memcache or external search engine . As MySQL 5.1 and plugable storage engine…
