… MySQL performance but it is even more important for HA systems. It is so important to avoid swapping with HA that… part of the swapping issue but not all. With Numa systems, the picture is more complex and swapping can occur because… 22 10:03:22 UTC 2013 procs ———–memory———- —swap– —–io—- –system– —–cpu—– Fri Mar 22 10:03:22 UTC 2013 r b…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… a lot with today versions. Results are as follows: The system was 2* Quad Core Xeon E5310, CentOS 5, Data stored… ramfs. We controlled number of cores used with /sys/devices/system/cpu/cpuX/online Maximum performance for each number of cores was… usually shows synchronization is the issue. Barracuda format uses more CPU while delivering better performance so it is probably better with…
Post: How Innodb Contention may manifest itself
July 28, 2011 By 1 Comment
… the different form from the system monitoring standpoint. In many cases as heavy contention happens user CPU will be very high, and… see the CPU usage being low with a lot of CPU being idle, increased compared to normal workload portion of system CPU and high… how much context switches you can get from the system, as unlike CPU usage it is not obvious what to consider a…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… 32 bit? Some stats at writing time (18:37 friday) System copes fine with these figures. Queries/sec: 265 Traffic: 1Mb…: 326 sleeping, 2 running, 0 zombie, 0 stopped CPU states: cpu user nice system irq softirq iowait idle total 15.0% 0.0….00 248 0 # vmstat 5 2 procs memory swap io system cpu r b swpd free buff cache si so bi bo…
Post: XtraDB in CPU-bound benchmark
December 18, 2008 By Leave a Comment
… see XtraDB delivers 2.5% better performance with 10% lower CPU usage…. which is more than the measurement error. So we…_at_trx_commit=1) which causes some overhead even though system has BBU installed. Other is simply properties of TPC-C… contention issues which also may serialize things not allowing full CPU usage. Enjoy. BTW if somebody has 16 core box he…
Post: RAID System performance surprises
March 5, 2008 By 7 Comments
… case, for example CPU will perform with same performance day and night (unless system management software decides to lower CPU frequency due to… of remapped sectors etc. There is also database and file system fragmentation however these also tend to accumulate in predictable fashion… this time battery backed up cache will be disabled and system will operate with write through cache possibly slowing down write…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… course this is much more powerful system but still you can get an idea – This system has geomean of 7.7 sec… would allow MySQL to use CPUs and hard drives this system has more efficiently. Parallel query will be growing issue for… 2 CPUs and being able to use only half of system CPU resources for query processing was not too bad, however with…
Comment: Load management Techniques for MySQL
May 24, 2012 By 3 Comments
For linux-based systems one of easiest ways to check if concurrency level needs tuning is user/system cpu usage ratio. Server running at it’s optimal load should have roughly 80-90% userspace cpu usage and less than 10% system.
Post: Three ways that the poor man's profiler can hurt MySQL
December 2, 2011 By 19 Comments
… slow-running server that was using tons of CPU time and lots of system CPU, and exhibiting the classic signs of InnoDB kernel…
Post: Finding an optimal balance of I/O, CPU, and RAM for MySQL
May 16, 2011 By 4 Comments
… memory and CPU core count. He looked for a balance between utilizing the hardware as much as possible, limiting the system complexity…
