Forum


Notice to all users

We are migrating towards a new forum system located at community.teamspeak.com, as such this forum will become read-only on January 29, 2020

Results 1 to 4 of 4
  1. #1
    Join Date
    August 2011
    Location
    United Kingdom
    Posts
    4

    Solved Reduce/Clean Up "ts3server.sqlitedb" Database size? (Very Big)

    Hi,
    My Teamspeak 3 server has been running just under a year now and has been used daily, I currently have 10 servers running, I have deleted and added new servers before too. My user database has about 1600 users in it. I am running this Teamspeak server on a VPS with a limited amount of RAM....

    When I first setup the teamspeak 3 server the "ts3server.sqlitedb" database was very small and Teamspeak didn't use much RAM at all. However now it has grown to around 41MB which I do expect, and RAM usage has also increased a lot to .

    Now clearly I haven't got those "1600" users coming on daily and the majority of these users in the "ts3server.sqlitedb" never come back to my teamspeak again, so how do I clean them up. Now I guess users is only 1 way to clean up the file anything else e.g. channels/settings/backups?

    So my question is how do I clean up/shrink my "ts3server.sqlitedb" database? and most importantly will that bring RAM usage down too?

    See Picture of Usage - See below

    Any help would be appreciated.

    Thank you,
    Ray
    Attached Images Attached Images  

  2. #2
    Join Date
    June 2008
    Posts
    18,513
    You can cleanup your database with the vacuum command from SQLite
    http://www.sqlite.org/lang_vacuum.html

    It rebuilds the whole databse without the unlinked lines.

    http://forum.teamspeak.com/showthrea...ghlight=vacuum
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  3. #3
    Join Date
    August 2011
    Location
    United Kingdom
    Posts
    4
    Thank you for this information, just what I needed!

  4. #4
    Join Date
    January 2014
    Posts
    8

    libts3db_sqlite3.so is 2 gigs in size

    Is there a way to dump old irrelevant data, should it be this big in size?
    Last edited by dante696; September 1st, 2015 at 10:24 AM. Reason: merged / on your own risk!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [On Todo] Truncate large posts instead of "invalid parameter size"
    By PatPeter in forum Bug Reports [EN/DE]
    Replies: 6
    Last Post: November 4th, 2012, 09:28 AM
  2. Replies: 15
    Last Post: June 20th, 2012, 01:51 PM
  3. Replies: 0
    Last Post: August 11th, 2011, 06:21 PM
  4. ts3server.sqlitedb - "log"
    By JackCimberly in forum Linux / FreeBSD
    Replies: 1
    Last Post: February 22nd, 2010, 03:30 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •