Having a bit of an issue with my Linux server and figured I would toss it in here to see if anyone could help. We're seeing MySQL progressively take more and more CPU and memory. We're not exactly sure what is causing it but in TOP it is reporting the following:
CPU - 8.4 Memory - 1.8 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/***.***.com.pid --skip-external-locking
It started off very low but over the last two months it has become worse. Since I am sort of a Linux newbie I am looking for anything that might be causing the issue or suggestions to how I could alleviate it or if this is normal. Any help would be much appreciated.
Intel Xeon 3110 (Dual Core)
4 GB RAM
2x 250 GB (dual) HD
PHP version 5.3.2
Apache version 2.2.15
Please copy and paste the results of
total used free shared buffers cached
Mem: 4151928 1815052 2336876 0 243520 1211448
-/+ buffers/cache: 360084 3791844
Swap: 5678936 0 5678936
That looks fine to me. Most of the memory is being used as beffers and cache to speed things up. When it's needed for "real work" it will be automatically used.