I still think there is bug in 5.5.30-30.2, because with previous version server was running fine.
2013-04-18 in the morning I added 4Gb ram to the server. Still after 24h server started to swap:
total used free shared buffers cached Mem: 17298188 17083796 214392 0 116888 752440 -/+ buffers/cache: 16214468 1083720 Swap: 4095992 2982920 1113072
root 960 0.0 0.0 108296 276 ? S Apr18 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/15min-newdb1.pid mysql 1483 102 89.4 22635872 15478480 ? Sl Apr18 1519:51 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/lib/mysql/15min-newdb1.pid root 14441 0.0 0.0 103236 864 pts/0 S+ 07:25 0:00 grep --colour=auto mysqld
Also I have attached Temporary Object graph for one month. There is no significant increase in created tmp tables, so I think that this increased memory usage is because of mysql version.
I still think there is bug in 5.5.30-30.2, because with previous version server was running fine.
2013-04-18 in the morning I added 4Gb ram to the server. Still after 24h server started to swap:
total used free shared buffers cached
Mem: 17298188 17083796 214392 0 116888 752440
-/+ buffers/cache: 16214468 1083720
Swap: 4095992 2982920 1113072
root 960 0.0 0.0 108296 276 ? S Apr18 0:00 /bin/sh /usr/bin/ mysqld_ safe --datadir= /var/lib/ mysql --pid-file= /var/lib/ mysql/15min- newdb1. pid /var/lib/ mysql --plugin- dir=/usr/ lib64/mysql/ plugin --user=mysql --log-error= /var/log/ mysqld. log --pid-file= /var/lib/ mysql/15min- newdb1. pid
mysql 1483 102 89.4 22635872 15478480 ? Sl Apr18 1519:51 /usr/sbin/mysqld --basedir=/usr --datadir=
root 14441 0.0 0.0 103236 864 pts/0 S+ 07:25 0:00 grep --colour=auto mysqld
Also I have attached Temporary Object graph for one month. There is no significant increase in created tmp tables, so I think that this increased memory usage is because of mysql version.