…a single mutex. On servers with many cores, a high volume of queries can …single request is not very efficient. Use multi_get when possible. Once again, caching …CPU usage. Disk IO is expensive, and even if the disk bottleneck is eliminated, the sorting, aggregation and join operations are still CPU…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… outperforms InnoDB 1.4-2.5x times, but CPU-bound is not so good. I think there…multi-cores even in only SELECT queries. What this practically means it that you can’t get benefit of multi-core… advantages and drawbacks, I see a good practical usage of TokuDB for log analyzing and log reporting queries…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…CPU bound workload in this case (no disk IO) to see how efficient storage engines are in terms of CPU usage…Ñ… Dual Core Intel XEON 5130 model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz stepping : 6 cpu MHz : …as this is specific Falcon’s way to handle multi-versioning. I think this is a big weakness …
Post: Index lock and adaptive search - next two biggest InnoDB problems
February 25, 2010 By 12 Comments
Running many benchmarks on fast storage (FusionIO, SSDs) and multi-cores CPUs system I constantly face two contention problems. So I …. This is also reason why in benchmarks I posted previously CPU usage is only about 50%, leaving other 50% in idle state…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… for years. The good thing is now with multi-cores coming even on laptops these issues can’t … queries well, being able to use only one CPU effectively on single node and no true federation support… MySQL customers and myself based on long MySQL usage for Web. Later I stopped adding these because …
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…uncompression happening in parallel, improving buffer pool usage (currently you may need to both …threads – using multiple cores becomes increasingly important as their number per CPU just keeps doubling. It…for full statement duration. The problem with multi value inserts however is the following – …
