…buf_LRU_free_block(buf_page_t*, unsigned long) | | | |–100.00%– buf_LRU_scan_and_free_block(buf_… second for MySQL 5.6.11. Conclusion: In CPU-bounds case MySQL performs quite well, though we … innodb_flush_neighbor_pages=none command line to load 10x dataset: ./bin/linkbench -D dbid=linkdb -D …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…ran tests on Dell PowerEdge R720 box and varied cpu combinations with taskset. The following chart shows a… concurrent threads each SELECT has to scan about 100 update transactions to create a read view: I… performance_schema=0 warmup To warmup server and load data and indices to the buffer pool we…
Post: Are you designing IO bound or CPU bound application ?
December 20, 2006 By 10 Comments
… on the site – generating much more load than average user, so their contribution to the load my be significant plus you do… to piss of your most loyal users with slow page load times. So for IO bound applications you will need to… with such design in CPU bound case – yes you will but it will happen with 100.000 messages not 100 messages as in…
Post: Scaling: Consider both Size and Load
July 13, 2010 By 5 Comments
… of CPUs and number of concurrent requests. Reduced efficiency of CPU cache, Mutex contention and database lock contention all come here… fits in memory, hence having CPU bound workload. As your data growths you may frequently find load becoming IO bound and hence… get response fast. This means you can’t plan on loading system 100%. There is a nice paper by Cary Millsap explaining…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… that executing pt-query-digest can be pretty CPU and memory consuming, so ideally you would want … which typically (not always) shows queries causing highest load on the server. As we can see here … 0 # Boolean: # Filesort 100% yes, 0% no # Tmp table 100% yes, 0% no # Tmp table on 100% yes, 0% no …
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… ran few CPU-bound tasks there. The goal of benchmarks was investigation of InnoDB-plugin and XtraDB scalability in CPU-bound load. CPU specification: processor : 23 vendor_id : GenuineIntel cpu family : 6 model : 29 model name : Intel(R) Xeon(R) CPU E7450… (you can get it on https://launchpad.net/perconatools), with 100 Warehouses (about 9.5GB datasize). The result is: Here the…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… world when we have significant variance in the load and many things can be happening concurrently. It … disk IO and mysqldump should have relatively little CPU needs and be bound by disk. Also these … about 325 req/sec for sysbench and some 100 seconds for mysqldump which is a dramatic improvement …
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
Henrik, mike: Indeed, for 100% write load scalability will be far from linear or maybe even negligible (100% inserts is very hard to…. For example in master-slave sysbench benchmarks I observed slave CPU load to be 1/10 of master’s (to surprisingly good… almost 25% writes (we don’t know how much of CPU they take though), we can speculate that RBR event is…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
… done for i in `seq 1 15` do numconn=$((i*100)) echo “Doing $numconn idle connections” php ./make_conn.php $numconn… reinitialized to ensure consistent benchmarks. During all the benchmarks, the CPU load on the laptop was never above 10%. I also hacked… the “run_mysql.sh” script to allow more processing threads (100) instead of the max of 20. This is required for…
Comment: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
… if you’re using 8K page sizes. Speaking about CPU info – the 80-100% “CPU” load I guess is a bit misleading – you probably… with a lot of “iowait” (which is also corresponds to CPU being free)
