Slow fulltext search after migration

Moderator: crythias

Post Reply
max123
Znuny newbie
Posts: 5
Joined: 08 Nov 2022, 09:10
Znuny Version: 6.4.3
Real Name: Max Mustermann

Slow fulltext search after migration

Post by max123 »

Hi,

we migrate (copy otrs directory + mysqldump) our Znuny (6.5.3) from Almalinux 9 to Debian 12 and activate the module ModPerl::Util.
to improve the performance of the webinterface.

With the actitation of the module, the webinterface ist much faster,
but the fulltext serarch is 30-40 seconds slower then on the Almalinux System.

Alma: MariaDB 10.5
Debian: MariaDB 10.11


The hardware equipment is identical.

Any idea?

Regards
schulmann
Znuny wizard
Posts: 470
Joined: 20 Nov 2011, 16:08
Znuny Version: 6.5.4
Real Name: Schulmann

Re: Slow fulltext search after migration

Post by schulmann »

Hi,

it's typically the performance of the database (locking some tables in memory in combination with parallel queries).

CD
Znuny6/Debian/ESXi
Post Reply