Our AgentTicketQueue is really slow for all queues with more then 1 ticket. When I fetch the page for queues with no tickets or just 1 ticket then it's fast. So the page time is linear with the number of tickets in the page. All other pages are acceptable from speed.
It looks like it's querying something for each ticket. When I do a query log I do see that I get SELECT queries for each customer in that view. Will this mean that I have 31 queries for a AgentTicketQueue with 30 tickets?
OTRS version: CE Free 6 patch level 8
LDAP disabled, just a local user and agent database
163 000 tickets in the database, but only 200 active (open), most tickets are archived.
Kernel::System::Ticket::IndexAccelerator::StaticDB
Kernel::System::Ticket::ArticleSearchIndex::RuntimeDB (most tickets are archived)
Kernel::System::Ticket::ArticleStorageDB (there are no attachments)
My.cnf of MariaDB:
Code: Select all
[mysqld]
open_files_limit = 8192
max_connections = 2000
tmp_table_size = 1024M
max_heap_table_size = 1024M
table_cache = 512
slow_query_log
slow_query_log_file = /var/log/mysql/slow.log
long_query_time = 1
log_queries_not_using_indexes
query_cache_type = 1
query_cache_limit = 256K
query_cache_size = 512M
Code: Select all
Alias /otrs-web/ "/opt/otrs/var/httpd/htdocs/"
ScriptAlias / "/opt/otrs/bin/cgi-bin/"
<IfModule mod_perl.c>
Perlrequire /opt/otrs/scripts/apache2-perl-startup.pl (added MySQL preloading to this)
PerlModule Apache2::Reload
PerlInitHandler Apache2::Reload
<Location /*.pl>
ErrorDocument 403 /otrs/index.pl
SetHandler perl-script
PerlResponseHandler ModPerl::Registry
Options +ExecCGI
PerlOptions +ParseHeaders
PerlOptions +SetupEnv
<IfModule mod_version.c>
<IfVersion < 2.4>
Order allow,deny
Allow from all
</IfVersion>
<IfVersion >= 2.4>
Require all granted
</IfVersion>
</IfModule>
<IfModule !mod_version.c>
Order allow,deny
Allow from all
</IfModule>
</Location>
# mod_perl2 options for GenericInterface
<Location /nph-genericinterface.pl>
PerlOptions -ParseHeaders
</Location>
</IfModule>