June 20, 2013

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

May 22, 2013 By Leave a Comment

… a relatively fast machine with a Xeon E5-2680 (8 cores, 16 threads) with fast IO (OCZ R4 1.6TB) and 128GB… than MyISAM when the database is cold, but uses less CPU time when the database is hot. I am only speculating…

Filed Under: Benchmarks, MySQL Tagged With: , , , , , , ,

Post: Why use encrypted backup with Percona XtraBackup 2.1 for MySQL?

April 10, 2013 By 2 Comments

… multiple CPU cores can be used for encryption (with the –encrypt-threads option). You can also combine compression and encryption, each using multiple CPU cores…

Filed Under: Cloud and NoSQL, Insight for DBAs, MySQL, Percona Software Tagged With: , , , ,

Post: More on MySQL transaction descriptors optimization

April 26, 2013 By Leave a Comment

… ProLiant DL380 G6 (8cores/16 cpu threads) Cisco UCS C250 (12cores/24 cpu threads) Dell PowerEdge R720 (16 cores/32 cpu threads) All are NUMA boxes, but… used 16 threads (8 cores on a single socket x 2 threads per socket), while the second one use 16 cores (8 cores per socket… innodb_file_per_table = true innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000…

Filed Under: Benchmarks, MySQL Tagged With: ,

Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server

December 29, 2008 By 6 Comments

… some benchmarks on 24-core (intel cpu based) server, and I could not miss it and ran few CPU-bound tasks there. The…) CPU E7450 @ 2.40GHz stepping : 1 cpu MHz : 2394.011 cache size : 12288 KB physical id : 3 siblings : 6 core id : 5 cpu cores : 6…_locking sort_buffer_size=64K table_cache=2048 thread_cache_size=16 thread_concurrency=16 thread_stack=196K tmp_table_size=64M transaction…

Filed Under: Benchmarks Tagged With: ,

Post: Sphinx search performance optimization: multi-threaded search

January 16, 2013 By 10 Comments

… are typically single-threaded. That is when you issue a single query on your brand new r910 with 32 CPU cores and 16… a machine with a single CPU core and single disk, putting it on a machine with 32 such cores and 16 such disks… = plain source = src1 } searchd { dist_threads = 0 # default } And now we want it to utilize 3 CPU cores and/or disks on a…

Filed Under: MySQL Tagged With: , , ,

Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency

December 3, 2008 By 15 Comments

…: The CPU usage is normalized to match number of CPU cores used, so 100% in 2 cores case is 100% of two cores in case of 8 cores it is 8 cores etc… not enough runnable threads to cause full CPU usage, or you may be waiting by spinning on the spinlock wasting CPU cycles. Detailed…

Filed Under: Benchmarks Tagged With:

Post: Percona Server scalability on multi-cores server

September 29, 2010 By 14 Comments

… two Intel Westmere CPUs (X5670 @ 2.93GHz). Each CPU has 6 cores and 12 threads. The most amazing part is the amount of… what we can get from “threads“, as there are only 12 “real” cores, with each core having two “threads“. So, I took Percona Server… up to 24 threads, despite the fact that half of them are not real CPU cores. For up to 10 threads, the scale factor…

Filed Under: Benchmarks, MySQL

Post: MySQL Limitations Part 1: Single-Threaded Replication

October 20, 2010 By 16 Comments

… is single-threaded replication. It is severe and getting much worse as servers get more and more CPUs and CPU cores. The replication replay process executes in a single thread on the replicas, and thus has… the replication events to the appropriate thread. A pool of threads on the replica, and a coordinating thread that hands work to each…

Filed Under: Insight for Developers, MySQL Tagged With:

Post: MyISAM Scalability and Innodb, Falcon Benchmarks

October 12, 2007 By 10 Comments

… box with 1 CPU Core is able to handle more queries per second than identical box, but with 4 CPU Cores. The main query… 4 Core System: Threads queries/sec 1 161 2 107 4 110 8 121 16 138 As you see running 2-4 threads… at 16 threads, showing 50% gain from 4 threads – which is quite unexpected for CPU bound load on system with 4 Cores. Here is…

Filed Under: Uncategorized Tagged With: , , , ,

Post: How Innodb Contention may manifest itself

July 28, 2011 By 1 Comment

… only one thread can be working at the time you should expect a lot of threads waiting and the more CPU cores you have available the less CPU utilization you can have. Sometimes… version or doing application/architecture changes. Reducing number of competing threads (such as limiting number of Apache Children) as well as…

Filed Under: Insight for DBAs, MySQL
« Older Posts