Benim büyük bir sosyal platform sitem var fakat 10 kişi girişinde çok fazla database sorgusu yapıyor. Yardım edebilir misiniz?
Mysqltuner testi:

./mysqltuner.pl >> MySQLTuner 1.4.0 - Major Hayden >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering [OK] Currently running supported MySQL version 5.5.42-cll [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM [--] Data in MyISAM tables: 63M (Tables: 452) [--] Data in InnoDB tables: 550M (Tables: 470) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) [!!] Total fragmented tables: 476 -------- Security Recommendations ------------------------------------------- [OK] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [--] Up for: 1d 19h 37m 2s (41M q [262.326 qps], 1M conn, TX: 66B, RX: 14B) [--] Reads / Writes: 84% / 16% [--] Total buffers: 597.0M global + 86.6M per thread (500 max threads) [!!] Maximum possible memory usage: 42.9G (750% of installed RAM) [OK] Slow queries: 0% (2K/41M) [OK] Highest usage of available connections: 48% (240/500) [OK] Key buffer size / total MyISAM indexes: 256.0M/14.1M
[OK] Key buffer hit rate: 99.4% (1M cached / 10K reads) [OK] Query cache efficiency: 56.7% (18M cached / 33M selects)
[!!] Query cache prunes per day: 30611
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 8M sorts)
[!!] Joins performed without indexes: 460935
[OK] Temporary tables created on disk: 0% (19K on disk / 8M total)
[OK] Thread cache hit rate: 99% (240 created / 1M connections)
[OK] Table cache hit rate: 51% (2K open / 3K opened)
[OK] Open file limit used: 3% (968/30K)
[OK] Table locks acquired immediately: 99% (53M immediate / 53M locks)
[!!] InnoDB buffer pool / data size: 5.0M/550.1M
[OK] InnoDB log waits: 0
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
Reduce your overall MySQL memory footprint for system stability
Adjust your join queries to always utilize indexes
Variables to adjust:
*** MySQL's maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***
query_cache_size (> 64M)
join_buffer_size (> 64.0M, or always use indexes with joins)
innodb_buffer_pool_size (>= 550M)

Sunucu 4 çekirdek 2.80 ghz ve 6 GB RAM var.
Birde litespeed kullanıyorum
Sizin önereceğiniz my.cnf optimizasyonu var mıdır?