Higher MySQL RAM usage, need to optimize

cbu

• February 12, 2014 20:51

Hello all! I have VPS with running 2.5GB RAM, Intel(R) Xeon(R) CPU E5-2630 0 @ 2.30GHz (cache 15360 KB). It front end Nginx and backend Apache. This VPS run two wordpress sites. First site page preview 3,000-3,500 (daily) second site 500-600 (daily). First site mysql database size is 56.1MB and 2nd site MySQL database size is 10.3MB. root@host [~]# mysql --version mysql Ver 14.14 Distrib 5.5.35, for Linux (i686) using readline 5.1
When I'm running ps -aux command, I can see higher RAM usage root@host [~]# ps -aux Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.8/FAQ USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND mysql 11980 0.4 3.5 755956 93016 ? Sl 07:50 0:05 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql -
When I'm running free -m I receive following output. root@host [~]# free -m total used free shared buffers cached Mem: 2560 1927 632 0 0 1516 -/+ buffers/cache: 410 2149 Swap: 0 0 0
When I'm running MySQL tuner, I get following output. root@host [~]# ./mysqltuner.pl >> MySQLTuner 1.2.0 - Major Hayden >> Bug reports, feature requests, and downloads at http://pastebin.com/x5FwuKiK How do I reduce MySQL memory usage? Thanks!

• 

  thinkbot

  • March 08, 2014 13:52

  you can reduce your VPS to 1GB RAM or 768

  0
• 

  euro-space

  • March 24, 2014 07:59

  I think MySQL Tuning Primer also can be very useful tool, so you can compare results and make proper adjustment. Available to download here - /https://launchpad.net/mysql-tuning-primer Cheers!

  0

Please sign in to leave a comment.