On 3 February 2012 18:48, Karlos Jelez <otrsfan@gmail.com> wrote:

Hi Steve
Thanks for your comments
OTRS has a Generic Agent where you can do some tasks.
I create a task to collect tickets until Nov-30-2011, pass the tickets to Junk queue and then delete from Junk.
All was fine.

The trouble is with the first queue, wich receive 100 new messages daily. The second queue onlu receive 5 messages daily.
If it is a database performance issue I think both queues must works slow, not only one.

In fact, OTRS works fine, except for fetch mails to one of the queues.

Currently
OTRS v 2.3.4
2 queues, fetching by POP
6,000 tickets (December to February)
100 tickets as open/pending
5900 tickets closed
100 new tickets daily, most of theme close same day
MySql Db was optimize and index rebuilt

I did set up PostMasterReconnectMessage to 50.
I did set up storage to ArticleStorageFS
I did change exchange server for qmail for both queue-accounts.

2012/2/3 Steven Carr <sjcarr@gmail.com>

How exactly did you purge the 45k tickets? and when did you purge them? recently hours/days?

It sounds to me like OTRS still has something in it's database for the 45k tickets you purged and so is searching through that data for a match whenever a new ticket comes into that queue. If you have only just recently deleted them then there are a few cron jobs you may want to kick off manually which rebuilds indexes etc.

Steve

On 3 February 2012 16:24, Ugo Bellavance <ugob@lubik.ca> wrote:

On 2012-02-03 09:02, Karlos Jelez wrote:

Thanks Ugo
The HW is ok; it is a FreeBSD hosted in a datacenter.
OTRS receive 100 new tickets daily; working hours.
90% of tickets are closed same day..

What is the load average on the machine? What is the average wait and service times on the disk when the "slowness" occurs?

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs