viele Servernutzer verwenden ihre eigenen Rootserver.
Bei mir ist dies einer mit folgender Ausstattung:
Code: Select all
# Intel Core 2 Duo 2x 2,6 GHz
# Arbeitsspeicher 4 GB DDR2 RAM
# Traffic 5.000 GB inklusive
# Festplatte SATA 2x 320 GB
# FTP-Backup 100 GB Speicherplatzmeine momentane my.cnf:
Code: Select all
key_buffer = 128M
max_allowed_packet = 16M
thread_stack = 128K
query_cache_limit = 32M
query_cache_size = 128M
query_cache_type = 1
#log = /var/log/mysql.log
#log = /var/log/mysql/mysql.log
#log-slow-queries = /var/log/mysql/mysql-slow.log
#log-bin = /var/log/mysql/mysql-bin.log
max_binlog_size = 104857600
open_files_limit = 24576
table_cache = 8192
thread_cache_size = 16
max_connections = 30
long_query_time = 4
max_heap_table_size = 64M
tmp_table_size = 64M
read_buffer_size = 6M
join_buffer_size = 2048K
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 128MCode: Select all
SLOW QUERIES
The slow query log is NOT enabled.
Current long_query_time = 4 sec.
You have 0 out of 6303 that take longer than 4 sec. to complete
Your long_query_time seems to be fine
BINARY UPDATE LOG
The binary update log is NOT enabled.
You will not be able to do point in time recovery
See http://dev.mysql.com/doc/refman/5.0/en/point-in-time-recovery.html
WORKER THREADS
Current thread_cache_size = 16
Current threads_cached = 1
Current threads_per_sec = 0
Historic threads_per_sec = 0
Your thread_cache_size is fine
MAX CONNECTIONS
Current max_connections = 30
Current threads_connected = 2
Historic max_used_connections = 3
The number of used connections is 10% of the configured maximum.
You are using less than 10% of your configured max_connections.
Lowering max_connections could help to avoid an over-allocation of memory
See "MEMORY USAGE" section to make sure you are not over-allocating
MEMORY USAGE
Max Memory Ever Allocated : 297 M
Configured Max Per-thread Buffers : 311 M
Configured Max Global Buffers : 266 M
Configured Max Memory Limit : 577 M
Physical Memory : 3.94 G
Max memory limit seem to be within acceptable norms
KEY BUFFER
Current MyISAM index space = 317 M
Current key_buffer_size = 128 M
Key cache miss rate is 1 : 17
Key buffer fill ratio = 0 %
Your key_buffer_size seems to be too high.
Perhaps you can use these resources elsewhere
QUERY CACHE
Query cache is enabled
Current query_cache_size = 128 M
Current query_cache_used = 330 K
Current query_cache_limit = 32 M
Current Query cache Memory fill ratio = .25 %
Current query_cache_min_res_unit = 4 K
Your query_cache_size seems to be too high.
Perhaps you can use these resources elsewhere
MySQL won't cache query results that are larger than query_cache_limit in size
SORT OPERATIONS
Current sort_buffer_size = 2 M
Current read_rnd_buffer_size = 256 K
Sort buffer seems to be fine
JOINS
Current join_buffer_size = 2.00 M
You have had 0 queries where a join could not use an index properly
Your joins seem to be using indexes properly
OPEN FILES LIMIT
Current open_files_limit = 24576 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 = 8192 tables
You have a total of 5306 tables
You have 5310 open tables.
The table_cache value seems to be fine
TEMP TABLES
Current max_heap_table_size = 64 M
Current tmp_table_size = 64 M
[color=#FF0000]Of 196 temp tables, 7% were created on disk[/color]
Created disk tmp tables ratio seems fine
TABLE SCANS
Current read_buffer_size = 5 M
Current table scan ratio = 589 : 1
read_buffer_size seems to be fine
TABLE LOCKING
Current Lock Wait ratio = 0 : 6517
Your table locking seems to be finez.B. das rotmarkierte:
habe gelesen, dass das die Performance des Servers runtersetzt - soll ich max_heap_table_size = 64 M und tmp_table_size = 64 M etwa noch höher setzen?Of 196 temp tables, 7% were created on disk
danke für eure Mühen und Hilfe :-D
