© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
bbfa235
(Get the code!)
Elena, this is what we had yesterday with MariaDB 5.3 (atop stats):
ATOP - db5 2012/03/15 12:15:05 600 seconds elapsed
PRC | sys 14m21s | user 64m24s | #proc 3488 | #zombie 0 | #exit 49112 |
CPU | sys 139% | user 650% | irq 12% | idle 0% | wait 0% |
cpu | sys 14% | user 86% | irq 0% | idle 0% | cpu002 w 0% |
cpu | sys 17% | user 83% | irq 0% | idle 0% | cpu001 w 0% |
cpu | sys 20% | user 80% | irq 0% | idle 0% | cpu004 w 0% |
cpu | sys 18% | user 82% | irq 0% | idle 0% | cpu005 w 0% |
cpu | sys 20% | user 80% | irq 0% | idle 0% | cpu006 w 0% |
cpu | sys 17% | user 82% | irq 0% | idle 0% | cpu007 w 0% |
cpu | sys 13% | user 87% | irq 0% | idle 0% | cpu003 w 0% |
cpu | sys 19% | user 69% | irq 11% | idle 0% | cpu000 w 0% |
CPL | avg1 24.64 | avg5 26.89 | avg15 24.74 | csw 21167815 | intr 13843e3 |
MEM | tot 39.4G | free 17.9G | cache 9.9G | buff 177.5M | slab 561.8M |
SWP | tot 1.9G | free 27.2M | | vmcom 42.3G | vmlim 21.5G |
PAG | scan 0 | stall 0 | | swin 2787 | swout 0 |
DSK | cciss/c0d0 | busy 34% | read 25152 | write 62378 | avio 2 ms |
And this is the total activity of mysqld processes at the same moment:
NPROCS SYSCPU USRCPU VSIZE RSIZE RDDSK WRDSK RNET SNET MEM CMD 1/9
539 11m33s 63m40s 98.5G 11.5G 785e3 828e3 0 0 29% mysqld
Now, the following is the same stats for today, same time, MariaDB 5.2
ATOP - db5 2012/03/16 12:20:41 10 seconds elapsed
PRC | sys 6.81s | user 22.06s | #proc 3472 | #zombie 0 | #exit 668 |
CPU | sys 72% | user 223% | irq 9% | idle 460% | wait 37% |
cpu | sys 16% | user 52% | irq 0% | idle 29% | cpu001 w 3% |
cpu | sys 13% | user 49% | irq 0% | idle 35% | cpu002 w 3% |
cpu | sys 11% | user 49% | irq 0% | idle 39% | cpu003 w 0% |
cpu | sys 16% | user 26% | irq 8% | idle 49% | cpu000 w 0% |
cpu | sys 5% | user 22% | irq 0% | idle 64% | cpu004 w 9% |
cpu | sys 7% | user 15% | irq 0% | idle 69% | cpu005 w 8% |
cpu | sys 2% | user 4% | irq 0% | idle 85% | cpu006 w 9% |
cpu | sys 1% | user 4% | irq 0% | idle 91% | cpu007 w 4% |
CPL | avg1 1.84 | avg5 2.06 | avg15 2.20 | csw 386363 | intr 168596 |
MEM | tot 39.4G | free 232.0M | cache 26.6G | buff 478.1M | slab 757.1M |
SWP | tot 1.9G | free 1.3G | | vmcom 41.2G | vmlim 21.5G |
DSK | cciss/c0d0 | busy 26% | read 22 | write 1129 | avio 2 ms |
NPROCS SYSCPU USRCPU VSIZE RSIZE RDDSK WRDSK RNET SNET MEM CMD 1/10
540 7m47s 27m13s 94.8G 13.4G 112e3 810e3 0 0 34% mysqld
So, memory usage is about the same.