In der benchmark bekomme ich folgendes resultat was nicht sehr beeindruckent ist.
kann einer mir da weiter helfen.
lg,
david
[ Benchmark ]
Back
Result: SQL
Key Value Time Comment
Insert Time: 10000 20 s
Should not take more than 5s on an average system. Update Time: 10000 23 s
Should not take more than 9s on an average system. Select Time: 10000 16 s
Should not take more than 6s on an average system. Delete Time: 10000 12 s
Should not take more than 5s on an average system. Multiplier: * 1
Aufbau der umgebung:
otrs auf einem 1cpu server mit 1024 mb ram mit opensuse 11.2
mysql auf einem 2cpu server mit 1024 mb ram mit ubuntu
my.cnf
#bind-address = 192.168.160.139
#
# * Fine Tuning
#
key_buffer = 128M
max_allowed_packet = 16M
thread_stack = 256K
thread_cache_size = 32
#max_connections = 100
table_cache = 128
##thread_concurrency = 4
#
# * Query Cache Configuration
#
query_cache_type = 1
query_cache_limit = 8M
query_cache_size = 256M
#
innodb_file_per_table
innodb_buffer_pool_size = 768M
innodb_log_buffer_size = 64M
support assesment
Database
Check Comment State
Check "max_allowed_packet" setting. Your configuration setting is 15 MB. OK
Check "query_cache_size" setting. 256 MB OK
Check existing framework tables. 69 tables checked. OK
Check database utf8 support. Your database version supports utf8. OK
Check if the client uses utf8 for the connection. Your client connection is utf8. OK
Check if the database uses utf8 as charset. Your database character setting is utf8. OK
Check the utf8 table charset collation. Your charset collation is set to utf8_general_ci. OK
Check database version. MySQL 5.0.51a-3ubuntu5.4 OK
OS
Check Comment State
A CPU load check. We try to find out if the system load in the last 15 minutes > 1. The Host System has a load: 0.02 in the last 1 minute 0.09 in the last 5 minutes 0.06 in the last 15 minutes OK
Check disk usage. Disk usage (/dev/sda2[23%],/dev/sda3[2%]). OK
A Memory Check. We try to find out if SwapFree : SwapTotal < 60 % or if more than 200 MB Swap is used. The Host System has: 1006 MB Memory total 558 MB Memory free 1513 MB Swap total 1513 MB Swap free OK
Shows the used distribution. "Welcome to openSUSE 11.2 "Emerald" - Kernel " is used. OK
Shows the used Kernel version. "Linux SVRTICKET00PROD 2.6.31.5-0.1-default #1 SMP 2009-10-26 15:49:03 +0100 i686 i686 i386 GNU/Linux" is used. OK
Check Perl Version. Perl 5.10.0 (linux) is used. OK
OTRS
Check Comment State
Check open tickets in your system. You have 6 open tickets in your system. OK
Check Ticket::IndexModule setting. You are using "Kernel::System::Ticket::IndexAccelerator::RuntimeDB", that's fine for 15 tickets in your system. OK
Check orphaned StaticDB records. No orphaned records found. OK
Check Ticket::SearchIndexModule setting. You are using "Kernel::System::Ticket::ArticleSearchIndex::RuntimeDB", that's fine for 51 articles in your system. OK
Check if the configured FQDN is valid. FQDN 'svrticket00prod.moventum.lu' looks good. OK
Check if the configured SystemID contains only digits. Your SystemID setting is 10. OK
Check if file system is writable. The file system is writable. OK
Check deployment of all packages. All packages are correctly installed. OK
Search for invalid user with locked tickets. There are no invalid users with locked tickets. OK
Check if Ticket::Frontend::ResponseFormat contains no $Data{""}. No $Data{""} found. OK
Check if root@localhost account has the default password. There is no active root@localhost with default password. OK
Check default SOAP credentials. You have not enabled SOAP or have set your own password. OK
Webserver
Check Comment State
Display web server version. You are running Apache/2.2.13 (Linux/SUSE). OK
Check for CGI Accelerator. mod_perl/2.0.4 OK
Check if the system uses Apache::DBI. Apache::DBI OK
Check if the system uses Apache::Reload/Apache2::Reload. Apache2::Reload OK
