Hallo Leute,
wir haben einen V-PowerServer E bei Strato auf dem nur ein einziger OSCommerce-Shop läuft. Leider ist die Seite nach einem Neustart des Server in ca. 1 - 2 Stunden nicht mehr erreichbar. Mit einem Apache2 Neustart läuft es wieder.
Hier die Daten:
CPU GenuineIntel, Intel(R) Pentium(R) 4 CPU 3.06GHz
Version psa v8.2.0_build82070706.15 os_SuSE 10.1
OS Linux 2.6.9-023stab043.1-smp
Apache/2.2.0
PHP Version 5.1.2
mysql 5.0.18
Plesk 8.2.0
Ich habe schon mehrere Einstellungen in der server-tuning.conf ausprobiert, aber kein Erfolg.
Hat einer von euch vielleicht noch eine Idee?
Vielen Dank im Voraus!!
wir haben einen V-PowerServer E bei Strato auf dem nur ein einziger OSCommerce-Shop läuft. Leider ist die Seite nach einem Neustart des Server in ca. 1 - 2 Stunden nicht mehr erreichbar. Mit einem Apache2 Neustart läuft es wieder.
Hier die Daten:
CPU GenuineIntel, Intel(R) Pentium(R) 4 CPU 3.06GHz
Version psa v8.2.0_build82070706.15 os_SuSE 10.1
OS Linux 2.6.9-023stab043.1-smp
Apache/2.2.0
PHP Version 5.1.2
mysql 5.0.18
Plesk 8.2.0
Code:
top - 13:06:37 up 34 min, 2 users, load average: 0.17, 0.06, 0.01
Mem: 2070020k total, 2047132k used, 22888k free, 448096k buffers
Swap: 3068392k total, 7340k used, 3061052k free, 817348k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
21858 wwwrun 17 0 0 0 0 Z 1 0.0 0:00.65 httpd2-prefork <defunct>
1 root 16 0 640 284 248 S 0 0.0 0:00.00 init
15682 root 12 -4 1708 600 420 S 0 0.0 0:00.00 udevd
15893 messageb 15 0 3340 924 728 S 0 0.0 0:00.00 dbus-daemon
15966 root 17 0 3136 1588 1300 S 0 0.1 0:00.01 hald
16247 root 16 0 1512 608 504 S 0 0.0 0:00.03 syslogd
16259 root 17 0 2972 748 572 S 0 0.0 0:00.00 couriertcpd
16261 root 16 0 2876 852 688 S 0 0.0 0:00.00 courierlogger
16270 root 16 0 2972 748 572 S 0 0.0 0:00.00 couriertcpd
16272 root 16 0 2876 852 688 S 0 0.0 0:00.00 courierlogger
16279 root 16 0 2968 744 572 S 0 0.0 0:00.00 couriertcpd
16281 root 16 0 2872 848 688 S 0 0.0 0:00.00 courierlogger
16289 root 16 0 2968 744 572 S 0 0.0 0:00.00 couriertcpd
16291 root 16 0 2876 852 688 S 0 0.0 0:00.00 courierlogger
16299 root 16 0 4792 1268 912 S 0 0.1 0:00.12 sshd
16316 root 16 0 2144 868 708 S 0 0.0 0:00.01 xinetd
16353 named 20 0 36584 2744 1892 S 0 0.1 0:00.01 named
16367 root 16 0 2448 1192 980 S 0 0.1 0:00.01 mysqld_safe
17426 mysql 15 0 121m 16m 4716 S 0 0.8 0:15.26 mysqld
17438 qmails 15 0 1484 396 312 S 0 0.0 0:00.01 qmail-send
17440 qmaill 15 0 1436 460 400 S 0 0.0 0:00.00 splogger
17441 root 21 0 1464 344 260 S 0 0.0 0:00.00 qmail-lspawn
17442 qmailr 16 0 1460 372 288 S 0 0.0 0:00.00 qmail-rspawn
17443 qmailq 15 0 1432 332 272 S 0 0.0 0:00.00 qmail-clean
17511 root 15 0 9384 2720 2096 S 0 0.1 0:00.07 sshd
17539 root 16 0 1728 696 572 S 0 0.0 0:00.00 cron
17549 root 16 0 16716 6304 3804 S 0 0.3 0:00.09 wdcollect
17550 root 16 0 24364 2328 1884 S 0 0.1 0:00.27 monit
17561 root 16 0 4492 2116 1604 S 0 0.1 0:00.05 bash
18253 root 16 0 36236 5312 3256 S 0 0.3 0:00.02 httpsd
18256 psaadm 16 0 40896 18m 12m S 0 0.9 0:01.44 httpsd
18407 psaadm 16 0 41528 22m 15m S 0 1.1 0:02.47 httpsd
19869 root 16 0 9384 2672 2096 S 0 0.1 0:00.06 sshd
19874 root 15 0 4368 2072 1560 S 0 0.1 0:00.04 bash
20234 root 16 0 62748 14m 6484 S 0 0.7 0:00.43 httpd2-prefork
21523 wwwrun 15 0 65056 13m 3596 S 0 0.7 0:01.02 httpd2-prefork
21726 root 15 0 2108 1088 840 R 0 0.1 0:00.23 top
21806 wwwrun 16 0 65116 13m 3416 S 0 0.7 0:01.82 httpd2-prefork
21809 wwwrun 16 0 64828 13m 3568 S 0 0.7 0:00.28 httpd2-prefork
21820 wwwrun 16 0 65084 13m 3564 S 0 0.7 0:00.41 httpd2-prefork
21824 wwwrun 16 0 65076 13m 3560 S 0 0.7 0:00.33 httpd2-prefork
21826 wwwrun 16 0 65208 13m 3416 S 0 0.7 0:01.32 httpd2-prefork
21867 wwwrun 16 0 65100 13m 3416 S 0 0.7 0:00.30 httpd2-prefork
21868 wwwrun 15 0 65084 13m 3376 S 0 0.7 0:00.38 httpd2-prefork
21869 wwwrun 16 0 63100 11m 3228 S 0 0.6 0:00.05 httpd2-prefork
Code:
h1317169:~ # cat /proc/user_beancounters
Version: 2.5
uid resource held maxheld barrier limit failcnt
1317169: kmemsize 4731212 4842781 14271433 15723665 0
lockedpages 0 0 15200 16384 0
privvmpages 83933 84132 256256 288768 0
shmpages 14618 14618 524288 524288 0
dummy 0 0 0 0 0
numproc 61 63 596 596 0
physpages 25542 25742 0 2147483647 0
vmguarpages 0 0 192062 2147483647 0
oomguarpages 25542 25742 216062 2147483647 0
numtcpsock 29 32 2000 2000 0
numflock 9 10 800 928 0
numpty 2 2 256 256 0
numsiginfo 3 6 2048 2048 0
tcpsndbuf 364468 431548 9366512 15204912 0
tcprcvbuf 475136 499900 9366512 15204912 0
othersockbuf 29068 46544 6012928 16252928 0
dgramrcvbuf 0 0 960000 1048576 0
numothersock 26 28 1528 1528 0
dcachesize 0 0 6023656 6072656 0
numfile 2513 2526 13864 13864 0
dummy 0 0 0 0 0
dummy 0 0 0 0 0
dummy 0 0 0 0 0
numiptent 54 54 512 512 0
Code:
h1317169:~ # tuning-primer.sh
-- MYSQL PERFORMANCE TUNING PRIMER --
- By: Matthew Montgomery -
MySQL Version 5.0.18-log i686
/usr/bin/tuning-primer.sh: line 382: bc: command not found
/usr/bin/tuning-primer.sh: line 383: bc: command not found
/usr/bin/tuning-primer.sh: line 384: bc: command not found
/usr/bin/tuning-primer.sh: line 385: bc: command not found
/usr/bin/tuning-primer.sh: line 386: bc: command not found
/usr/bin/tuning-primer.sh: line 387: bc: command not found
Uptime = days hrs min sec
Avg. qps = 54
Total Questions = 118592
Threads Connected = 2
Warning: Server has not been running for at least 48hrs.
It may not be safe to use these recommendations
To find out more information on how each of these
runtime variables effects performance visit:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
SLOW QUERIES
Current long_query_time = 2 sec.
You have 0 out of 118604 that take longer than 2 sec. to complete
The slow query log is enabled.
Your long_query_time seems to be fine
WORKER THREADS
Current thread_cache_size = 10
Current threads_cached = 2
Current threads_per_sec = 0
Historic threads_per_sec = 0
Your thread_cache_size is fine
MAX CONNECTIONS
Current max_connections = 20
Current threads_connected = 2
Historic max_used_connections = 4
The number of used connections is 20% of the configured maximum.
Your max_connections variable seems to be fine.
MEMORY USAGE
/usr/bin/tuning-primer.sh: line 1117: bc: command not found
/usr/bin/tuning-primer.sh: line 1118: bc: command not found
/usr/bin/tuning-primer.sh: line 1142: bc: command not found
/usr/bin/tuning-primer.sh: line 1145: bc: command not found
/usr/bin/tuning-primer.sh: line 1146: bc: command not found
/usr/bin/tuning-primer.sh: line 1148: bc: command not found
/usr/bin/tuning-primer.sh: line 1150: [: -gt: unary operator expected
/usr/bin/tuning-primer.sh: line 344: [: max_memoryHR: integer expression expected
/usr/bin/tuning-primer.sh: line 350: [: max_memoryHR: integer expression expected
/usr/bin/tuning-primer.sh: line 356: [: max_memoryHR: integer expression expected
/usr/bin/tuning-primer.sh: line 363: export: `0=max_memoryHR': not a valid identifier
Max Memory Ever Allocated : bytes
/usr/bin/tuning-primer.sh: line 344: [: per_thread_buffersHR: integer expression expected
/usr/bin/tuning-primer.sh: line 350: [: per_thread_buffersHR: integer expression expected
/usr/bin/tuning-primer.sh: line 356: [: per_thread_buffersHR: integer expression expected
/usr/bin/tuning-primer.sh: line 363: export: `0=per_thread_buffersHR': not a valid identifier
Configured Max Per-thread Buffers : bytes
/usr/bin/tuning-primer.sh: line 344: [: global_buffersHR: integer expression expected
/usr/bin/tuning-primer.sh: line 350: [: global_buffersHR: integer expression expected
/usr/bin/tuning-primer.sh: line 356: [: global_buffersHR: integer expression expected
/usr/bin/tuning-primer.sh: line 363: export: `0=global_buffersHR': not a valid identifier
Configured Max Global Buffers : bytes
/usr/bin/tuning-primer.sh: line 344: [: total_memoryHR: integer expression expected
/usr/bin/tuning-primer.sh: line 350: [: total_memoryHR: integer expression expected
/usr/bin/tuning-primer.sh: line 356: [: total_memoryHR: integer expression expected
/usr/bin/tuning-primer.sh: line 363: export: `0=total_memoryHR': not a valid identifier
Configured Max Memory Limit : bytes
/usr/bin/tuning-primer.sh: line 325: bc: command not found
Total System Memory : G
Max memory limit seem to be within acceptable norms
KEY BUFFER
/usr/bin/tuning-primer.sh: line 325: bc: command not found
/usr/bin/tuning-primer.sh: line 599: bc: command not found
/usr/bin/tuning-primer.sh: line 600: bc: command not found
/usr/bin/tuning-primer.sh: line 325: bc: command not found
Current MyISAM index space = K
/usr/bin/tuning-primer.sh: line 325: bc: command not found
Current key_buffer_size = M
Key cache miss rate is 1 : 5477
Key buffer fill ratio = %
/usr/bin/tuning-primer.sh: line 619: [: -ge: unary operator expected
/usr/bin/tuning-primer.sh: line 623: [: -le: unary operator expected
Your key_buffer_size seems to be fine
QUERY CACHE
/usr/bin/tuning-primer.sh: line 651: bc: command not found
/usr/bin/tuning-primer.sh: line 652: bc: command not found
Query cache is enabled
/usr/bin/tuning-primer.sh: line 325: bc: command not found
Current query_cache_size = M
/usr/bin/tuning-primer.sh: line 325: bc: command not found
Current query_cache_used = M
/usr/bin/tuning-primer.sh: line 325: bc: command not found
Current query_cach_limit = M
Current Query cache fill ratio = %
/usr/bin/tuning-primer.sh: line 661: [: -le: unary operator expected
MySQL won't cache query results that are larger than query_cache_limit in size
SORT OPERATIONS
/usr/bin/tuning-primer.sh: line 325: bc: command not found
Current sort_buffer_size = K
/usr/bin/tuning-primer.sh: line 325: bc: command not found
Current record/read_rnd_buffer_size = M
Sort buffer seems to be fine
JOINS
/usr/bin/tuning-primer.sh: line 325: bc: command not found
Current join_buffer_size = M
You have had 82 queries where a join could not use an index properly
You should enable "log-queries-not-using-indexes"
Then look for non indexed joins in the slow query log.
If you are unable to optimize your queries you may want to increase your
join_buffer_size to accommodate larger joins in one pass.
Note! This script will still suggest raising the join_buffer_size when
ANY joins not using indexes are found.
OPEN FILES LIMIT
Current open_files_limit = 1054 files
The open_files_limit should typically be set to at least 2x-3x
that of table_cache if you have heavy MyISAM usage.
Your open_files_limit value seems to be fine
TABLE CACHE
Current table_cache value = 512 tables
You have a total of 210 tables
You have 217 open tables.
The table_cache value seems to be fine
TEMP TABLES
/usr/bin/tuning-primer.sh: line 325: bc: command not found
Current max_heap_table_size = M
/usr/bin/tuning-primer.sh: line 325: bc: command not found
Current tmp_table_size = M
Of 917 temp tables, 1% were created on disk
Effective in-memory tmp_table_size is limited to max_heap_table_size.
Created disk tmp tables ratio seems fine
TABLE SCANS
/usr/bin/tuning-primer.sh: line 325: bc: command not found
Current read_buffer_size = K
Current table scan ratio = 805 : 1
read_buffer_size seems to be fine
TABLE LOCKING
Current Lock Wait ratio = 0 : 118704
Your table locking seems to be fine
Code:
# prefork MPM
<IfModule prefork.c>
# number of server processes to start
# http://httpd.apache.org/docs/2.2/mod/mpm_common.html#startservers
StartServers 1
# minimum number of server processes which are kept spare
# http://httpd.apache.org/docs/2.2/mod/prefork.html#minspareservers
MinSpareServers 1
# maximum number of server processes which are kept spare
# http://httpd.apache.org/docs/2.2/mod/prefork.html#maxspareservers
MaxSpareServers 3
# highest possible MaxClients setting for the lifetime of the Apache process.
# http://httpd.apache.org/docs/2.2/mod/mpm_common.html#serverlimit
ServerLimit 50
# maximum number of server processes allowed to start
# http://httpd.apache.org/docs/2.2/mod/mpm_common.html#maxclients
MaxClients 10
# maximum number of requests a server process serves
# http://httpd.apache.org/docs/2.2/mod/mpm_common.html#maxrequestsperchild
MaxRequestsPerChild 4000
</IfModule>
#
# KeepAlive: Whether or not to allow persistent connections (more than
# one request per connection). Set to "Off" to deactivate.
#
KeepAlive On
#
# MaxKeepAliveRequests: The maximum number of requests to allow
# during a persistent connection. Set to 0 to allow an unlimited amount.
# We recommend you leave this number high, for maximum performance.
#
MaxKeepAliveRequests 500
#
# KeepAliveTimeout: Number of seconds to wait for the next request from the
# same client on the same connection.
#
KeepAliveTimeout 5Hat einer von euch vielleicht noch eine Idee?
Vielen Dank im Voraus!!
Last edited by a moderator: