… see where this leads us but I believe on multiple CPU systems you need some spinning done, at least for some… now even laptops are getting multi cores so we can forget about spinlocks wasting CPU time on single CPU boxes without much of the…
Post: Compression for InnoDB backup
March 16, 2009 By 19 Comments
… data having some new information. In current multi-core word the compression utility should utilize several CPU to speedup operation, and another my… and faster than pbzip2 but still not so fast; however multi-threaded processing may be OK, especially if you need to…
Comment: TPC-H Run on MySQL 5.1 and 6.0
May 14, 2012 By 16 Comments
Hi Peter, Re utilising multi cores, MySQL does claim to be capable of utilising multiple CPU cores. (http://dev.mysql.com/doc/refman/5.5/en/faqs-general.html#qandaitem-B-1-1-8). Is that a different kind of assessment or different benchmarking? Cheers.
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…
Comment: What time 18446744073709550.000 means
May 17, 2009 By 25 Comments
Good post. Does this also apply to multi-core machines with just one physical CPU?
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… were known for years. The good thing is now with multi-cores coming even on laptops these issues can’t be under… handle complex queries well, being able to use only one CPU effectively on single node and no true federation support. 4…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…’t get use of more than 8 cores effectively (which would correspond to single CPU socket these days) Here are some more…,ha_innobase::index_read,handler::read_range_first,handler::read_multi_range_next,QUICK_RANGE_SELECT::get _next,rr_quick,sub…,row_search_for_mysql,ha_innobase::general_fetch,handler::read _multi_range_next,QUICK_RANGE_SELECT::get_next,rr_quick,sub…
Post: Scaling to 256-way the Sun way
November 11, 2008 By 13 Comments
… is not exactly the same thing. Each T2 Plus CPU has 8 cores, which with 8 threads each giving 64 threads per… setup 32! MySQL instances on this box (approximately one per core). Comparing single instance performance (4350 statements/sec) to the total… on 8 cores (and close to 40.000 queries/sec on 4 slow AMD cores). Do not get me wrong. The multi-threading…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… “max_connections” threshold (650) connections. Cpu is fine (about 100% of 400% available, MPM and dual core reports 4 processors). We have…’, ’0′ ‘Com_unlock_tables’, ’102′ ‘Com_update’, ’15146253′ ‘Com_update_multi‘, ’0′ ‘Connections’, ’263413′ ‘Created_tmp_disk_tables’, ’0′ ‘Created_tmp…
Comment: HandlerSocket on SSD
November 20, 2010 By 9 Comments
… said that “Talking about NIC port to CPU core ratio, so far I think 2 cpu cores per NIC port is enough for HandlerSocket read-only workloads. %us+%sy was almost 100% when using 3 ports / 8 cores… a single round-trip is there but no specific number. “multi_get operations (similar to IN(1,2,3..), fetching multiple…
