We didn't had any trouble (those of us, who made a cache a little bit bigger than usual). So we are glad that everything become better then it was. Could you explain us a little bit more about what have been done with the database (may be even with some numbers)?
Project up again
)
We didn't had any trouble (those of us, who made a cache a little bit bigger than usual). So we are glad that everything become better then it was. Could you explain us a little bit more about what have been done with the database (may be even with some numbers)?
The database server and the
)
The database server and the database server backup have been replaced with new and better hardware. The new hardware is
Four CPUs (4 cores each)
72 GB of memory
Very fast disk array
Here's the output of 'TOP' on the new DB server.
Cheers,
Bruce
top - 01:12:10 up 85 days, 6:38, 7 users, load average: 0.43, 0.27, 0.20
Tasks: 284 total, 3 running, 281 sleeping, 0 stopped, 0 zombie
Cpu0 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 1.0%us, 0.7%sy, 0.0%ni, 96.7%id, 0.7%wa, 0.3%hi, 0.7%si, 0.0%st
Cpu2 : 0.7%us, 0.0%sy, 0.0%ni, 98.7%id, 0.3%wa, 0.0%hi, 0.3%si, 0.0%st
Cpu3 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu4 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu5 : 0.0%us, 0.3%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu6 : 0.3%us, 0.0%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu7 : 0.3%us, 0.7%sy, 0.3%ni, 98.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu8 : 0.0%us, 0.0%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.3%si, 0.0%st
Cpu9 : 2.7%us, 0.3%sy, 0.0%ni, 95.7%id, 0.7%wa, 0.3%hi, 0.3%si, 0.0%st
Cpu10 : 1.0%us, 0.0%sy, 0.0%ni, 98.0%id, 1.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu11 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu12 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu13 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu14 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu15 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 74172728k total, 73982472k used, 190256k free, 15518616k buffers
Swap: 0k total, 0k used, 0k free, 8373736k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
14472 mysql 15 0 47.0g 44g 5140 S 6.3 63.5 289:35.13 mysqld
10922 nobody 15 0 46164 5188 1364 S 1.7 0.0 18:14.78 openvpn
5877 root 15 0 12868 1232 816 R 0.7 0.0 0:00.09 top
26713 root 26 10 113m 19m 2544 S 0.7 0.0 0:44.88 innotop
1 root 15 0 10344 676 568 S 0.0 0.0 0:15.43 init
2 root RT -5 0 0 0 S 0.0 0.0 0:00.25 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0
5 root RT -5 0 0 0 S 0.0 0.0 0:00.03 migration/1
6 root 34 19 0 0 0 S 0.0 0.0 0:00.01 ksoftirqd/1
7 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/1
8 root RT -5 0 0 0 S 0.0 0.0 0:00.04 migration/2
9 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/2
10 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/2
11 root RT -5 0 0 0 S 0.0 0.0 0:00.02 migration/3
12 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/3
13 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/3
14 root RT -5 0 0 0 S 0.0 0.0 0:00.61 migration/4
15 root 34 19 0 0 0 S 0.0 0.0 0:00.02 ksoftirqd/4 16 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/4
Director, Einstein@Home
RE: top - 01:12:10 up 85
)
Good load average. It's not even breaking a sweat.