top - 15:26:25 up 364 days, 8:10, 2 users, load average: 0.12, 0.13, 0.15
Tasks: 69 total, 2 running, 67 sleeping, 0 stopped, 0 zombie
Cpu0 : 8.3% us, 0.0% sy, 0.0% ni, 91.7% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu1 : 4.0% us, 4.0% sy, 0.0% ni, 92.0% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 4045224k total, 4027540k used, 17684k free, 24240k buffers
Swap: 2048276k total, 144k used, 2048132k free, 3654836k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
9220 mysql 16 0 610m 169m 4632 S 8 4.3 2363:47 mysqld
1 root 16 0 4756 516 428 S 0 0.0 0:17.24 init
Not to sure what some of the process output is about. Like NI, VIRT, RES, SHR.
Also I noticed that this machine is sucking up nearly all my ram... Which i hear is how Linux is supposed to be. But 4GB? That seems excessive to me.
My real problem relates to that mysqld process. This is off of my mysql machine, and it's running SLLOOOWWWWWW. The machines only responsibilities is running mysql. But runs slow when memory dips low to the point of 15mb or so left.
As you notice, there is almost a full year on the clock, and we've restarted mysql once, about 6 months ago when it was doing the same things.
Memory leak? Possible misconfiguration somewhere?