Hi there,
thanks for your replies...
Did you ever tried to filter these (I think) email that they not become a ticket? Way more efficient.
sure, you are right.
We have reduced those emails that are not relevant for OTRS significantly meanwhile, and developed a bounce mail checker, that filters those messages and also deactivate sending further emails.
But from the time before we still have 3.5M (closed) Tickets. Our current OTRS Installation is very slow. Opening some Queues, Opening tickets, etc. takes several seconds (between 3s up to 20s).
We also have around 5000 open tickets (most of them are "away from office" messages which we want to reduce be generic agent filtering)
Our current installation parameters are
OTRS 5
Ubuntu 16.04 LTS
MariaDB 10.1 (shared with other dbs) using InnoDB Engine
Ticket::SearchIndexModule is StaticDB
Ticket::IndexModule: StaticDB
Ticket::StorageModule is ArticleStorageFS
AdminSupportDataCollector shows a warning for
Query Cache Size (1073741824)
The setting 'query_cache_size' should be used (higher than 10 MB but not more than 512 MB).
We are using staticDB setting
We are planning to upgrade to OTRS6. But due to large amounts of data we assumed to better reduce database size before.
Any help is appreciated.
Regards