I just started at a new job and my first task was to upgrade the companys OTRS-ticketsystem.
The system works fine except some complains about slow search. Over 60sec is not unusually. And kind of the main reason for the upgrade.
System today:
1 virtual server
openSUSE 11.2
2CPU @ 2.8GHz
2GB RAM
mysql-5.1.49
apache2-2.2.13
OTRS 3.0.5 15100 tickets
Code: Select all
Insert Time: 10000 5 s Ok
Update Time: 10000 5 s :-) Looks fine!
Select Time: 10000 4 s :-) Looks fine!
Delete Time: 10000 5 s Ok
Multiplier: * 1 s1 virtual server
openSUSE 12.3
2CPU @ 3.8GHz
3GB RAM
mariadb-5.5.33
apache2-2.2.22
OTRS 3.3.8
Code: Select all
Insert Time: 10000 109 s :-( Should not take more than 5's on an average system.
Update Time: 10000 111 s :-( Should not take more than 9's on an average system.
Select Time: 10000 1 s :-) Looks fine!
Delete Time: 10000 112 s :-( Should not take more than 5's on an average system.
Multiplier: * 1 sthe new server.
As you can see the response time from the new OTRS system is worthless.
I have never worked with databases before, so I don’t know anything about optimizing them.
The otrs.CheckDB.pl doesn’t show any errors.
Apache and mysql(mariaDB) are started, OTRS-service not. I don’t want the new system to fetch mail and snitch them from the old,active system.
This is the my.cnf that was on the old server with som smaller tweaks to handle the upgraded memory and InnoDB.
Code: Select all
[client]
port = 3306
socket = /var/run/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/run/mysql/mysql.sock
datadir = /var/lib/mysql
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 25M
query_cache_size=256M
table_open_cache = 64
sort_buffer_size = 1024K
net_buffer_length = 100K
read_buffer_size = 512K
read_rnd_buffer_size = 1024K
myisam_sort_buffer_size = 16M
server-id = 1
innodb_data_home_dir = /var/lib/mysql
innodb_buffer_pool_size = 2000M
thread_cache_size = 4
query_cache_limit = 100M
log-slow-queries = 1
innodb_file_per_table = 1
[safe_mysqld]
log-error = /var/log/mysql/mysqld.log
socket = /var/run/mysql/mysql.sock
!includedir /etc/mysql
[mysqldump]
socket = /var/run/mysql/mysql.sock
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log = /var/log/mysqld_multi.logBest regards
