high load average in strong server !

J

Jeff_Anderson

New Member
#1
#1
hi guys
my load average time in my server is 40s.please somebody help me

my server detail :
LiteSpeed 4CPU License
Ram : 72 Gig
CPU : 24 Core
Hard drive : 128 SSD
i don't think i have problem in my hardware cause its strong,maybe it's from bad config in litespeed

my.cnf file

-----------------------------------------

[mysqld]
query-cache-type = 1
thread_cache = 10
query_cache_size = 200M
thread_concurrency = 10
max_connections = 2024
max_user_connections = 2024
innodb_buffer_pool_size=5G
max_heap_table_size=500M
tmp_table_size=500M

-----------------------------------------------
and here is mysqltuner result


[OK] Currently running supported MySQL version 5.5.31
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM
[--] Data in MyISAM tables: 23M (Tables: 116)
[--] Data in InnoDB tables: 4G (Tables: 165)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[!!] Total fragmented tables: 169

-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 22m 37s (395K q [291.195 qps], 26K conn, TX: 273M, RX: 27M)
[--] Reads / Writes: 65% / 35%
[--] Total buffers: 5.7G global + 2.8M per thread (2024 max threads)
[OK] Maximum possible memory usage: 11.1G (15% of installed RAM)
[OK] Slow queries: 0% (0/395K)
[OK] Highest usage of available connections: 4% (98/2024)
[OK] Key buffer size / total MyISAM indexes: 8.0M/2.5M
[OK] Key buffer hit rate: 99.9% (1M cached / 982 reads)
[OK] Query cache efficiency: 33.5% (52K cached / 157K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 59K sorts)
[!!] Joins performed without indexes: 87
[!!] Temporary tables created on disk: 40% (21K on disk / 54K total)
[OK] Thread cache hit rate: 93% (1K created / 26K connections)
[OK] Table cache hit rate: 97% (261 open / 268 opened)
[OK] Open file limit used: 1% (171/10K)
[OK] Table locks acquired immediately: 98% (158K immediate / 161K locks)
[OK] InnoDB buffer pool / data size: 5.0G/4.4G
[OK] InnoDB log waits: 0
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Enable the slow query log to troubleshoot bad queries
Adjust your join queries to always utilize indexes
Temporary table size is already large - reduce result set size
Reduce your SELECT DISTINCT queries without LIMIT clauses
Variables to adjust:
join_buffer_size (> 128.0K, or always use indexes with joins)

----------------------------------------

free -m command result in SSH

total used free shared buffers cached
72496 3541 68954 0 178 1410
-/+ buffers/cache: 1952 70544
Swap: 4095 0 4095

------------------------------------------

here is my litespeed settings

http://i.imgur.com/ZFXOJmg.jpg
http://i.imgur.com/moGWjL8.jpg
http://i.imgur.com/YKM0uKN.jpg

my load average is +40 and i cache somefiles
i have 2 important file and all traffics are in this files ( i can't use cache this files )
traffic in this files are +50 request per sec

i hope someone help me

thanks in advance
 
M

mistwang

LiteSpeed Staff
#4
#4
your load is coming from mysqld, so you need to optimize your table index and SQL query.
Turn on slow query cache, check "msyqladmin processlist", extended status etc to find out where is the bottle neck.
Usually, a missing table index on a large table could cause big trouble.
 
You must log in or register to reply here.
Top