Reducing Database Size

NexDog · **Reducing Database Size -** 16-03-2008, 07:09 AM

Our eSupport database SQL file is now 1.3gb. Are there any tips to reducing the size? Makes nightly backups kind of long and hard on the server....

craigbrass · 16-03-2008, 11:09 AM

Are you storing attachments in the database? If so, try changing to file storage.

NexDog · 16-03-2008, 11:20 AM

Probably but how do I do that?

Also I remember years ago there was a table that could be cleared out regularly that held something to do with email filter rules or something. Ring any bells?

craigbrass · 16-03-2008, 11:43 AM

Admin CP -> Settings -> Tickets -> "Storage Location For Attachments"

Ryan Lederman · 17-03-2008, 09:10 PM

If you run an Optimize on the tables it will likely shrink the database size quite a bit if it hasn't been run in a while.

supportskins · 17-03-2008, 09:16 PM

Try purging your parserlog table. That should reduce the size considerably.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Attachment Storage - Database or Files Directory	markh	SupportSuite, eSupport and LiveResponse	5	17-07-2007 02:02 PM
Database Stored Attachments	johnham	Wont Implement / Already Implemented	0	04-10-2006 12:11 AM
Import eSupport database into SupportSuite	one9	SupportSuite, eSupport and LiveResponse	0	02-09-2006 04:32 AM
Attachments cleared even if size < Size Limit	lifeunconscious	SupportSuite, eSupport and LiveResponse	4	11-02-2006 03:08 AM
Verifying Database Connection FAILED	MichaelHensley	SupportSuite, eSupport and LiveResponse	0	10-01-2006 06:45 PM

NexDog Offline New Member Posts: 11 Join Date: Nov 2003	Reducing Database Size - 16-03-2008, 07:09 AM Our eSupport database SQL file is now 1.3gb. Are there any tips to reducing the size? Makes nightly backups kind of long and hard on the server....

craigbrass Offline Senior Member Posts: 5,735 Join Date: Jun 2005 Location: Cumbria, UK	16-03-2008, 11:09 AM Are you storing attachments in the database? If so, try changing to file storage. Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

NexDog Offline New Member Posts: 11 Join Date: Nov 2003	16-03-2008, 11:20 AM Probably but how do I do that? Also I remember years ago there was a table that could be cleared out regularly that held something to do with email filter rules or something. Ring any bells?

craigbrass Offline Senior Member Posts: 5,735 Join Date: Jun 2005 Location: Cumbria, UK	16-03-2008, 11:43 AM Admin CP -> Settings -> Tickets -> "Storage Location For Attachments" Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) Icon Headquarters - Its Elixir - Web2Messenger

supportskins Offline Senior Member Posts: 3,850 Join Date: Aug 2006 Location: Mumbai, India	17-03-2008, 09:16 PM Try purging your parserlog table. That should reduce the size considerably. Professional and Affordable Kayako Skins - Specialists in Kayako Skinning & Customization - Professional Paid Support Our Skins and Services - http://www.supportskins.com/store/ SupportSkins.com - http://www.supportskins.com/