[rt-users] Reduce RAM usage of mysql and apache on RT install 1GB Ram vps

[Gilbert Rebeiro]

Hi,

We have about 20 users and I have access to a virtual server with 1GB ram.
I notice we are running out of memory.
Any suggestions on how to reduce the memory requirements would be 
appreciated.

Here are the packages for apache and mysql also the mods-enabled for apache.

please let me know if you need the apache2.conf or the my.conf

We run on Debian Squeeze
dpkg -l|grep apache2
ii  apache2                             2.2.16-6+squeeze1            
Apache HTTP Server metapackage
ii  apache2-mpm-worker                  2.2.16-6+squeeze1            
Apache HTTP Server - high speed threaded model
ii  apache2-utils                       2.2.16-6+squeeze1            
utility programs for webservers
ii  apache2.2-bin                       2.2.16-6+squeeze1            
Apache HTTP Server common binary files
ii  apache2.2-common                    2.2.16-6+squeeze1            
Apache HTTP Server common files
ii  libapache2-mod-perl2                2.0.4-7                      
Integration of perl with the Apache2 web server
ii  libapache2-reload-perl              0.10-2                       
Reload Perl modules when changed on disk

dpkg -l|grep mysql
ii  libdbd-mysql-perl                   4.016-1                      
Perl5 database interface to the MySQL database
ii  libmysqlclient16                    5.1.49-3                     
MySQL database client library
ii  mysql-client-5.1                    5.1.49-3                     
MySQL database client binaries
ii  mysql-common                        5.1.49-3                     
MySQL database common files, e.g. /etc/mysql/my.cnf
ii  mysql-server                        5.1.49-3                     
MySQL database server (metapackage depending on the latest version)
ii  mysql-server-5.1                    5.1.49-3                     
MySQL database server binaries and system database setup
ii  mysql-server-core-5.1               5.1.49-3                     
MySQL database server binaries


/etc/apache2/mods-enabled# ls -l
total 0
lrwxrwxrwx 1 root root 28 May 18 18:00 alias.conf -> 
../mods-available/alias.conf
lrwxrwxrwx 1 root root 28 May 18 18:00 alias.load -> 
../mods-available/alias.load
lrwxrwxrwx 1 root root 33 May 18 18:00 auth_basic.load -> 
../mods-available/auth_basic.load
lrwxrwxrwx 1 root root 33 May 18 18:00 authn_file.load -> 
../mods-available/authn_file.load
lrwxrwxrwx 1 root root 36 May 18 18:00 authz_default.load -> 
../mods-available/authz_default.load
lrwxrwxrwx 1 root root 38 May 18 18:00 authz_groupfile.load -> 
../mods-available/authz_groupfile.load
lrwxrwxrwx 1 root root 33 May 18 18:00 authz_host.load -> 
../mods-available/authz_host.load
lrwxrwxrwx 1 root root 33 May 18 18:00 authz_user.load -> 
../mods-available/authz_user.load
lrwxrwxrwx 1 root root 32 May 18 18:00 autoindex.conf -> 
../mods-available/autoindex.conf
lrwxrwxrwx 1 root root 32 May 18 18:00 autoindex.load -> 
../mods-available/autoindex.load
lrwxrwxrwx 1 root root 27 May 18 18:00 cgid.conf -> 
../mods-available/cgid.conf
lrwxrwxrwx 1 root root 27 May 18 18:00 cgid.load -> 
../mods-available/cgid.load
lrwxrwxrwx 1 root root 30 May 18 18:00 deflate.conf -> 
../mods-available/deflate.conf
lrwxrwxrwx 1 root root 30 May 18 18:00 deflate.load -> 
../mods-available/deflate.load
lrwxrwxrwx 1 root root 26 May 18 18:00 dir.conf -> 
../mods-available/dir.conf
lrwxrwxrwx 1 root root 26 May 18 18:00 dir.load -> 
../mods-available/dir.load
lrwxrwxrwx 1 root root 26 May 18 18:00 env.load -> 
../mods-available/env.load
lrwxrwxrwx 1 root root 27 May 18 18:00 mime.conf -> 
../mods-available/mime.conf
lrwxrwxrwx 1 root root 27 May 18 18:00 mime.load -> 
../mods-available/mime.load
lrwxrwxrwx 1 root root 34 May 18 18:00 negotiation.conf -> 
../mods-available/negotiation.conf
lrwxrwxrwx 1 root root 34 May 18 18:00 negotiation.load -> 
../mods-available/negotiation.load
lrwxrwxrwx 1 root root 27 May 18 18:11 perl.load -> 
../mods-available/perl.load
lrwxrwxrwx 1 root root 33 May 18 18:00 reqtimeout.conf -> 
../mods-available/reqtimeout.conf
lrwxrwxrwx 1 root root 33 May 18 18:00 reqtimeout.load -> 
../mods-available/reqtimeout.load
lrwxrwxrwx 1 root root 31 May 18 18:00 setenvif.conf -> 
../mods-available/setenvif.conf
lrwxrwxrwx 1 root root 31 May 18 18:00 setenvif.load -> 
../mods-available/setenvif.load
lrwxrwxrwx 1 root root 29 May 18 18:00 status.conf -> 
../mods-available/status.conf
lrwxrwxrwx 1 root root 29 May 18 18:00 status.load -> 
../mods-available/status.load