June 19, 2013

Post: Analyzing air traffic performance with InfoBright and MonetDB

October 2, 2009 By 50 Comments

… InfoBright (see http://www.mysqlperformanceblog.com/2009/09/29/quick-comparison-of-myisam-infobright-and-monetdb/) this week. And following Baron…: Conclusions: This experiment was not really about InfoBright vs MonetDB comparison. My goal was to check how available OpenSource software is… if you want to compare or get info about air performance.

Filed Under: Benchmarks, MySQL Tagged With: , , ,

Comment: Cache Performance Comparison

August 10, 2006 By 74 Comments

… is quite offtopic from Cache Performance Comparison discussion but anyway, We’re now working on FullText Search Engine comparison for MySQL and test MySQL Build in Full Text Search, Siena, Sphinx, Lucene indexing Wikipedia database and performing appropriate…

Filed Under: Insight for Developers Tagged With:

Post: MySQL performance on EC2/EBS versus RDS

August 4, 2011 By 11 Comments

… Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t always great in comparison to what you can get… you have, the higher probability that one of them will perform unpredictably, and you are essentially bound by the weakest link… and reduced mutex contention. The performance improvements I got with Percona Server were similar to the performance improvements I saw versus stock…

Filed Under: Benchmarks, Cloud and NoSQL, MySQL

Post: MySQL Users Conference Presentation Proposals

October 24, 2007 By 12 Comments

… to implement them most efficiently with MySQL. MySQL Performance Landscape This presentation compares MySQL Performance with different CPUs, Operation systems, RAID Configuration… for MySQL. Performance comparison of MySQL 5.0, MySQL 5.1 and MySQL 6.0 Come to see how performance of MySQL 5… over billion of forum posts. Transactional Storage Engines Performance We’re looking at performance at Open Source Transactional Storage engine MySQL – Innodb…

Filed Under: Events and Announcements Tagged With:

Post: Impact of memory allocators on MySQL performance

July 5, 2012 By 11 Comments

… going to check impact of several memory allocators on the performance/scalability of MySQL server in the read-only workloads. For… with MySQL so i decided to include old one to comparison as well. I used glibc-2.13 for that purpose… case innodb_buffer_pool_size=52G For every malloc allocator perform the following steps: start Percona server either with LD_PRELOAD…

Filed Under: Benchmarks, MySQL

Post: Drop table performance

April 20, 2011 By 22 Comments

… Peter’s post http://www.mysqlperformanceblog.com/2011/02/03/performance-problem-with-innodb-and-drop-table/ and these bug reports… Server 5.1.56 has a better result. The relative comparison for the 104GB case: Pecona Server is 3.5x better…

Filed Under: Benchmarks, Insight for DBAs, Insight for Developers, MySQL, Percona Software

Comment: Cache Performance Comparison

January 3, 2008 By 74 Comments

[...] lookups? It is all depending on your setup/server, if you want uber-performance, consider this: Cache Performance Comparison | MySQL Performance Blog But I am assuming that you mean >10ms … in which case, I would think to look at what else is [...]

Filed Under: Insight for Developers Tagged With:

Comment: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown

March 17, 2013 By 2 Comments

… checked without reading rows (from Index only). The difference in performance comes from the fact where the checks are made – by… would be to have SQL level to be able to perform comparison on the data directly in Innodb buffer pool without copying…

Filed Under: Events and Announcements, Insight for Developers, MySQL Tagged With: , ,

Post: Webinar for Full Text Search Throwdown

August 21, 2012 By 1 Comment

… called Full Text Search Throwdown.  This is a no-nonsense performance comparison of solutions for full text indexing for MySQL applications, including… indexes Apache Solr Sphinx Search Trigraphs I’ll compare the performance for building indexes and querying indexes. If you’re developing…

Filed Under: Events and Announcements, Insight for Developers, MySQL Tagged With: , ,

Post: Quick comparison of MyISAM, Infobright, and MonetDB

September 29, 2009 By 30 Comments

… (the same one Peter wrote about recently). The client’s performance is suffering in part because of the number of columns…), sum(c129) from t where c11 < 5; Graphs of query performance time for all three databases are really not very helpful…

Filed Under: MySQL Tagged With: , , ,
« Older Posts
Newer Posts »