… thread. MySQL never takes advantage of more than a single CPU when aggregating data and fetching rows from the buffer pool… all cores for my workload, then this test would be CPU bound. What data did I use? I loaded 55GB of the… increasing the number of workers past 24. The query becomes CPU bound at that point. If I needed more performance I could…
Comment: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… of notes here 1) Even though Vadim called it IO bound benchmark, it is not completely the case. With data just… the memory size this is mixed benchmark which loads both CPU and IO subsystem intensively, so it both cares about IO…. It would be interesting to see results for completely CPU bound and IO bound benchmarks too. I would guess at this data size…
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… 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…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 48 Comments
… was fully 1 CPU bound during all queries. I think the problem that engine can use only single cpu/core is getting significant… need to enable MySQL optimizer. InfiniDB is otherwise was IO-bound, and processed data fully utilizing sequential reads and reading data… is better) Conclusions InfiniDB is doing just great using available CPU cores full IO bandwidth reading from disk. You can see…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… also use CPU bound workload in this case (no disk IO) to see how efficient storage engines are in terms of CPU usage… model : 6 model name : Intel(R) Xeon(TM) CPU 3.20GHz stepping : 8 cpu MHz : 3192.222 cache size : 8192 KB 32GB… Core release 5 (Bordeaux) 2 Ñ… Dual Core AMD Opteron cpu family : 15 model : 65 model name : Dual-Core AMD Opteron…
Comment: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… this should not be random IO bound workload. It should be mainly CPU bound. If you want IO bound workload you have to have… ad SHA1(id) as a key it would become io bound on insert at some time in the future.
Comment: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… this should not be random IO bound workload. It should be mainly CPU bound. If you want IO bound workload you have to have… ad SHA1(id) as a key it would become io bound on insert at some time in the future.
Post: Just do the math!
July 6, 2009 By 4 Comments
…/sec scanned if data is in memory. In this case CPU is normally the limiting factor. In case we hit the… may be slowed down 100-1000 then going from CPU bound to IO bound workload. You can get approximate numbers for other parts…
Comment: Looking on 5.4 - IO bound benchmarks
May 1, 2009 By 5 Comments
… present. One more thing – I’d be careful calling benchmarks CPU bound – I assume you’re speaking “In memory” here – because there… bottleneck still. For read only benchmarks in-memory typically means CPU bound but it is not always so for write intensive.
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… CPU time during the loads. So not very much at all. Some interesting things to note: the load was probably mostly CPU-bound… also be interesting to try this on an I/O-bound server and see what the performance impact is, especially on…
