… a lot of CPU resources but none of disk IO and mysqldump should have relatively little CPU needs and be bound by disk. Also… buffer pool with only 12MB remaining. This makes workload extremely IO bound hence such drop in performance. The performance of mysqldump is… happen the workload which is normally in memory becomes disk IO bound which can slow it down more than 100 times. The…
Post: Scaling: Consider both Size and Load
July 13, 2010 By 5 Comments
… server handling 100.000 user accounts. You can see the CPU,IO and Network usage is below 10% of capacity – does it… of CPUs and number of concurrent requests. Reduced efficiency of CPU cache, Mutex contention and database lock contention all come here… in memory, hence having CPU bound workload. As your data growths you may frequently find load becoming IO bound and hence things becoming 10x…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… are completely CPU bound test conditions, data fits to buffer pool furthermore data and logs are on ramfs so no IO is ever needed. UPDATE: Some people are asked about CPU usage in this condition. Here is the graph: The CPU usage… usually shows synchronization is the issue. Barracuda format uses more CPU while delivering better performance so it is probably better with…
Comment: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… is however bunch of things which can be hardware related (CPU and disk concurrency), some are environment related – log flushing on… main benefit is actually dramatically reducing number of IOs needed for range scan for IO bound queries. Yes I see there is tradeoff… my consulting practice comes from the cases which corresponds to IO bound workloads. With modern CPUs if you data is in memory…
Comment: T2000 CPU Performance - Watch out
May 1, 2008 By 12 Comments
… this little “Benchmark” test on your T2000 or new generation CPU and tell me what you get. It is not very… case. Regarding database – it was CPU bound “cached” workload which we’re speaking about – if things are IO bound it is strange to compare…
Post: Looking on 5.4 - IO bound benchmarks
April 30, 2009 By 5 Comments
… in our benchmarks. For first shoot I took tpcc-like IO-bound benchmark (100W, ~10GB of data, 3GB buffer_pool) and tested… Google Spreadsheet (it is also being update with my next CPU benchmarks, and benchmark on SSD & FusionIO), also I post graph…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
… different InnoDB buffer was used. In CPU-bound case innodb_buffer_pool_size=2G In IO-bound case innodb_buffer_pool_size=512M innodb…=O_DIRECT DBT2 settings For CPU-bound case number of warehouses was 10(1.31GiB). In case of IO-bound load – 100 warehouses… about performance impact in case of CPU-bound workload. The performance impact is negligibly small in IO-bound workload even if all queries are…
Post: Using LoadAvg for Performance Optimization
December 4, 2006 By 5 Comments
… it does not really tell you if it is CPU bound load or IO bound load. For example if you have LoadAvg of 10 it may mean there are 10 processes/threads actively consuming CPU… it is CPU bound – because the system can execute much more CPU bound tasks in parallel or High if it is Disk Bound LoadAvg. Low…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
… have benchmarked two different kinds of workloads, IO bound and in-memory. Benchmark on IO bound workload was performed with a buffer pool size… a dual core machine with the following CPU configuration: 2xIntel(R) Core(TM)2 CPU 6600 @ 2.40GHz. The amount of memory… actuality the query took 31654 seconds to finish in the IO bound workload. Again here hash join beats BKA and BNL comprehensively…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… estimate capacity of MySQL system ? We can look at CPU and IO consumption per Query and compare it to estimated (or benchmarked… examines 20 rows, which means about 1 IO per 40 rows… which amounts to pretty IO bound load for me. But average is… less than 1 row in average which makes it very IO bound. So what If I am planning for load growth and…
