مشکل با mysqltuner.pl برای کانفیگ my.cnf

[Web Host Persia]

به طور معمول بزارید sql شما یه 24 ساعتی ران باشه و اصلا ریستارت نکنید ..
بعد از 24 ساعت نتیجه رو بررسی کنید ...

[OmidX]

General recommendations:    Run OPTIMIZE TABLE to defragment tables for better performance
    Enable the slow query log to troubleshoot bad queries
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries without LIMIT clauses
    Set thread_cache_size to 4 as a starting value
    Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
    query_cache_size (>= 8M)
    tmp_table_size (> 16M)
    max_heap_table_size (> 16M)
    thread_cache_size (start at 4)
    table_cache (> 400)

اساتید ، راهنمایی کنید لطفا

[zartosht]

General recommendations:    Run OPTIMIZE TABLE to defragment tables for better performance
    Enable the slow query log to troubleshoot bad queries
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries without LIMIT clauses
    Set thread_cache_size to 4 as a starting value
    Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
    query_cache_size (>= 8M)
    tmp_table_size (> 16M)
    max_heap_table_size (> 16M)
    thread_cache_size (start at 4)
    table_cache (> 400)

اساتید ، راهنمایی کنید لطفا

خوب مشکل شما الان چیه ؟در چه مورد راهنمایی نیاز دارید ؟

[InterServer.ir]

General recommendations:    Run OPTIMIZE TABLE to defragment tables for better performance
    Enable the slow query log to troubleshoot bad queries
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries without LIMIT clauses
    Set thread_cache_size to 4 as a starting value
    Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
    query_cache_size (>= 8M)
    tmp_table_size (> 16M)
    max_heap_table_size (> 16M)
    thread_cache_size (start at 4)
    table_cache (> 400)

اساتید ، راهنمایی کنید لطفا

سلام

query_cache_size=8M
tmp_table_size=16M
max_heap_table_size=16M
thread_cache_size=128
table_cache=512