since a while I'm working at solving the worst flaws in the OTRS SQL performance. MySQL Booster 1.1.0 is the newest outcome of this, much more complete and much easier to configure than before.
** Beta Warning: Because my test setup is limited and I couldn't test it for long, please consider this a true beta! I will keep up with bug reports, so please feel free to leave a comment when something fishy happens **
How to install
A) Download, unzip and install the opm file
Your system should work the same as before. Maybe the status view will load somewhat faster, all other enhancements need some configuration.
B) Define the quality of your CustomerID and CustomerUserLogin
Check your config.pm for the CustomerUser DB (defined as $Self->{CustomerUser}) after
Code: Select all
# customer uniq id
CustomerKey => 'username',
# customer #
CustomerID => 'id',
Code: Select all
# SearchKeyType used in Ticket.pm ticket searchs
SearchKeyType => {
CustomerID => 'int', # 'int', 'low', 'cas' or 'var' - see UserCustomerID in Map
CustomerUserLogin => 'low', # 'int', 'low', 'cas' or 'var' - see UserLogin in Map
},
C) Define the quality of all fields of your database
This guarantees the best possible performance in all customer searches. BTW: Nothing we do here would harm a normal OTRS performance. As everything except 'int' is treated as 'var' and lowered... now, it can't get any worse
Example:
Code: Select all
[ 'UserCustomerID', 'UserID', 'id', 1, 1, 'int', '', 0, '_blank' ],
[ 'UserLogin', 'Username', 'username', 1, 1, 'cas', '', 0, '_blank' ],
[ 'UserFirstname', 'Vorname', 'firstname', 1, 1, 'var', '', 0, '_blank' ],
[ 'UserLastname', 'Nachname', 'lastname', 1, 1, 'var', '', 0, '_blank' ],
[ 'UserEmail', 'E-Mail', 'email', 1, 1, 'low', '', 0, '_blank' ],
Greets
Dan
* Update: See later version 1.1.3 down the thread