[rt-users] Reduce RAM usage of mysql and apache on RT install 1GB Ram vps
Gilbert Rebeiro
gilbert at dido.ca
Wed Aug 24 09:48:39 EDT 2011
Understood, I have upgraded the memory to 2GB.
Let's see how it works.
On 24/08/2011 9:35 AM, Kevin Falcone wrote:
> On Wed, Aug 24, 2011 at 08:42:48AM -0400, Gilbert Rebeiro wrote:
>> 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.
> You could tune mysql down, and tune apache to only have 2 or 3
> children, but the admin time spent doing that is worth way more than
> 1G of RAM these days. If you do tune it down, you'll be trading
> database performance and making RT really slow.
>
> -kevin
>
>> 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
>>
>>
>> --------
>> RT Training Sessions (http://bestpractical.com/services/training.html)
>> * Chicago, IL, USA September 26& 27, 2011
>> * San Francisco, CA, USA October 18& 19, 2011
>> * Washington DC, USA October 31& November 1, 2011
>> * Melbourne VIC, Australia November 28& 29, 2011
>> * Barcelona, Spain November 28& 29, 2011
>>
>>
>> --------
>> RT Training Sessions (http://bestpractical.com/services/training.html)
>> * Chicago, IL, USA --- September 26& 27, 2011
>> * San Francisco, CA, USA --- October 18& 19, 2011
>> * Washington DC, USA --- October 31& November 1, 2011
>> * Melbourne VIC, Australia --- November 28& 29, 2011
>> * Barcelona, Spain --- November 28& 29, 2011
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110824/5772e685/attachment.htm>
More information about the rt-users
mailing list