Tickets Tickets -> Automatic purge based on ticket age

[alexis]

Hi,

Database is growing slowly.
I am getting concerned about cpu and disk usage.
I couldn't find anything on how to purge old tickets automatically.

Does anyone have a suggestion?

[Jamie Edwards]

Hi alexis,

There is no automatic way to perform ticket purging based on age; you will have to do this manually, I am afraid (making use of the mass delete functions from within a ticket listing).

However, I would not worry too much about the size of your database - unless we are talking more than 100s of megabytes. Searching will become a more resource intensive process, but beyond this (in general use of your desk) MySQL's caching techniques will ensure information that is likely to be accessed or is accessed frequently will be cached where other information will not be.

[craigbrass]

On a shared server of decent spec (single core with 1gb RAM or more) will cope fine with 1gb databases. If you are dedicating a box to only the helpdesk I deffo would not worry about it.

Only when you notice slow speeds should you start to consider doing something like this.

[Jamie Edwards]

On a shared server of decent spec (single core with 1gb RAM or more) will cope fine with 1gb databases.

On a shared server he would probably run into problems, particularly when performing searches and especially with a 'big' (oversold) host where resources are tight.

[craigbrass]

Well yea, but on a server with a moderate amount of accounts it should be ok for day to day ticket answering. Ticket searches arn't done that often by the majoirty of users anyway.

[Jamie Edwards]

Originally Posted by craigbrass

Well yea, but on a server with a moderate amount of accounts it should be ok for day to day ticket answering. Ticket searches arn't done that often by the majoirty of users anyway.

I think you'll find the contrary - the search features are one of the most heavily used features of the software (either quick-search, advanced search, ticket filter search) etc.

[craigbrass]

Really? I hardly ever use search unless I need to pull up an old ticket to clarify something. I just answer the open tickets mainly.

[alexis]

Thank you guys, I apreciate.

Actually, the server is far from being overloaded.
But it's shared with two online shops.
And because i don't care about customer inquieries from 6 months ago, I wanted to purge old mail. There's no point in keeping un-necessary stuff. The shops need to be as fast as possible.

I guess I'll have to do it manually from time to time.

But it could be a usefull feature in a next version of Kayako.

[craigbrass]

I totally agree a feature to say "delete all tickets with the following conditions from the database" similar to how the search conditions work.

[sniper]

I also vote for this, why cant we delete tickets from 6 months ago or one year ago. Why do we need to keep it? It keeps growing.

[supportskins]

This indeed is a handy feature although I believe you can add it as an optional feature in the Admin CP which can be activated as well as de-activated.

[tarrinho]

hello,

I would like to delete ticket that are 200 days old, How can I do that?

I believe it's a new feature, right?

Hugs,
Tarrinho

[craigbrass]

Wrong forum *winks*. This is for the windows application rather than the PHP Core. Jamie will move it anyway when he comes back to the forum.

It isn't currently a feature but has been requested for V4. For now, you can do it manually by preforming database queries and removing what is found. Remember to backup first just in case!

[Jamie Edwards]

Thread moved

[kteicher]

Do you mean searching for tickets older than a date and then deleting them? I tried this and only 50 results are returned at a time, is there a faster way?