… use DTrace with MySQL and InnoDB at a very deep level in the storage engine — not the… will be about benchmarks of replication alternatives for MySQL. Hasn’t this been done before, and…search engine, but it’s much more powerful than just that. It has all kinds of features that let it do things MySQL…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
… links: InnoDB Flushing theory and solutions MySQL 5.5.8 in search of stability This was not often…as storage, then I would recommend it. Vanilla MySQL performs equally bad on SSD and HDD, while for SSD… may hear in this case from the Oracle/MySQL engineers is to decrease “innodb_max_dirty_pages_pct”,…
Comment: Sphinx: Going Beyond full text search
July 24, 2007 By 18 Comments
…? SphinxSE as a pluggable storage engine for mysql? Currently we have a forum with about 17million posts, and a dedicated search server (a supercomputer, SGI… data. I’m thinking of migrating vbulletin to use sphinx for searching. http://sphinxsearch.com/doc.html#sphinxse Michael
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take… on which range condition is applied cannot be used for filtering records. For example, suppose you have a key defined as: KEY…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… importance to this ratio. The MySQL manual doesn’t fall into this trap, but if you search Google for Key_read_requests, you… that’s dedicated to MyISAM tables. Consider your mixture of storage engines (some InnoDB, some MyISAM, which is more important to you… results to your IO system’s capabilities. MySQL doesn’t have good instrumentation for scientifically choosing a key_buffer_size setting, but…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… and what works well for Oracle,MS SQL, PostgreSQL may not work well for MySQL and other way around. Even storage engines have very important… applications, however for OLTP applications with queries examining only few rows it is less of the problem. Data retrieval, search, DSS, business…
Post: Percona talks at OSCON
July 16, 2009 By Leave a Comment
… Text Search with Sphinx, MySQL Community Patches and Extensions and Goal Driven Performance Optimization. Vadim and Ryan have a talk XTraDB OpenSource Storage Engine for MySQL. This month OSCON is taking place in Silicon Valley which is good for me as I do…
Comment: Full text search for all MySQL Storage Engines
June 27, 2006 By 37 Comments
[...] http://www.mysqlperformanceblog.com/2006/06/26/full-text-search-for-all-mysql-storage-engines/ [...]
Page: Presentations
May 3, 2006 By
…yours! We can also give internal presentations for your company or group. Sphinx search engine for RDBMS Egypt, December 2007 Presentation …of OpenSource Transactional storage engines for MySQL OSCON 2007 , Portland,OR , July 2007 Presentation looks into PBXT, Falcon and SolidDB Storage engines and …
Post: Report from OSCON 2008
July 27, 2008 By 7 Comments
… the design consideration which was built well exactly for the task while full text search in database systems if often afterthought. At… speak. My talk on MySQL Storage Engines was pretty well received and I had interesting crowd attending. Speaking about MySQL vs PostgreSQL it is…
