Guide: Increasing Subsonic Memory Limit

[alphawave7]

LOL! Thanks Kirk!

[mbro]

Ok, I'm still seeing an issue. Subsonic 5.0, Ubuntu and Java 1.7, 2GB of RAM. My configuration is as such:

root@bonusroom:/etc/default# cat subsonic
#
# This is the configuration file for the Subsonic service
# (/etc/init.d/subsonic)
#
# To change the startup parameters of Subsonic, modify
# the SUBSONIC_ARGS variable below.
#
# Type "subsonic --help" on the command line to read an
# explanation of the different options.
#
# For example, to specify that Subsonic should use port 80 (for http)
# and 443 (for https), and use a Java memory heap size of 200 MB, use
# the following:
#
# SUBSONIC_ARGS="--port=80 --https-port=443 --max-memory=200"

SUBSONIC_ARGS="--max-memory=700"
#was 150

# The user which should run the Subsonic process. Default "root".
# Note that non-root users are by default not allowed to use ports
# below 1024. Also make sure to grant the user write permissions in
# the music directories, otherwise changing album art and tags will fail.

SUBSONIC_USER=root
root@bonusroom:/etc/default#


root@bonusroom:/usr/share/subsonic# cat subsonic.sh
#!/bin/sh

###################################################################################
# Shell script for starting Subsonic. See http://subsonic.org.
#
# Author: Sindre Mehus
###################################################################################

SUBSONIC_HOME=/var/subsonic
SUBSONIC_HOST=0.0.0.0
SUBSONIC_PORT=4040
SUBSONIC_HTTPS_PORT=0
SUBSONIC_CONTEXT_PATH=/
SUBSONIC_MAX_MEMORY=500
#SUBSONIC_MAX_MEMORY=150
SUBSONIC_PIDFILE=
...

When I'm using the web interface and click on Settings -> clean-up database, I receive the following:

Exception org.springframework.dao.TransientDataAccessResourceException
Message PreparedStatementCallback; SQL [select max(id) from album where not present]; out of memory; nested exception is java.sql.SQLException: out of memory
Java version Oracle Corporation 1.7.0_51
Operating system Linux 3.2.0-4-686-pae
Server jetty-6.1.x
Memory Used 40 of 189 MB

Doesn't seem like its out of memory. Despite my settings above, it only shows 189MB of memory being allocated. How come? Do I need to adjust another file?


*** Edit ***

I think my issue was sorted out by deleting the /var/subsonic/db and /var/subsonic/jetty directories contents and rebuilding the database. I don't entirely understand what was going on in the DB, but deleting the DB and running the media scan again succeeded....

[lovebags]

I've been running our installation at 2GB of memory for the last year and has handled well with over 1000 users and 500,000 hits. Prior to that the system would lock up under heavy load.

[Sherwino]

I've been running our installation at 2GB of memory for the last year and has handled well with over 1000 users and 500,000 hits. Prior to that the system would lock up under heavy load.

Whoa, can you tell me a little bit more about your setup?

It could be via PM don't want to derail the guide.
Just curious what you have to do to prepare for such traffic.
Recently got a VPS, figuring out how to allocate the right resources.

[chasmo]

A note on this - I've found that even with a very large collection, setting the memory limit too high actually slows down the interface. I was using 512, and when I dropped to 256, everything improved greatly. I have no idea why that would be - I have plenty of RAM available.

I should add that I don't have a high user load, usually only me or my wife at work or on the road via AVSub.

[herri]

Very helpful tutorial! I will definitely try it. Right - sometimes Subsonic freezes and I think that increasing the memory limit will help to solve this problem.

[lovebags]

Sorry for the delay in response, only just saw the question - here's a link to our setup - https://le.unimelb.edu.au/news/setting- ... ng-server/

I've been running our installation at 2GB of memory for the last year and has handled well with over 1000 users and 500,000 hits. Prior to that the system would lock up under heavy load.

Whoa, can you tell me a little bit more about your setup?

It could be via PM don't want to derail the guide.
Just curious what you have to do to prepare for such traffic.
Recently got a VPS, figuring out how to allocate the right resources.