Sudden increase in server load at specific times

[abdobasha2004]

Originally Posted by snakes1100

Can you take a snapshot of "top" running when its under heavy load?

Hit 1 after top starts so we can see all the core's.

now load is 40

the cause of this load is mysql

[mysqld]
query_cache_size=256M
table_cache=80000
max_connections=5000
open_files_limit=5400
log-slow-queries="/var/lib/mysql/slow.log"
innodb_file_per_table=1
thread_cache_size=4
interactive_timeout=60
wait_timeout=60
default-storage-engine=MyISAM
max_heap_table_size = 32M
local-infile=0
max_allowed_packet = 16MB


for my.cnf

and this is what mysql tuner says.

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.32-cll
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 1G (Tables: 333)
[--] Data in InnoDB tables: 224K (Tables: 14)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 16M (Tables: 111)
[!!] Total fragmented tables: 19

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

-------- Performance Metrics -------------------------------------------------
[--] Up for: 20h 0m 46s (32M q [447.256 qps], 2M conn, TX: 1387B, RX: 9B)
[--] Reads / Writes: 63% / 37%
[--] Total buffers: 424.0M global + 2.8M per thread (5000 max threads)
[OK] Maximum possible memory usage: 13.8G (59% of installed RAM)
[OK] Slow queries: 0% (979/32M)
[OK] Highest usage of available connections: 33% (1686/5000)
[OK] Key buffer size / total MyISAM indexes: 8.0M/1.1G
[OK] Key buffer hit rate: 99.0% (1B cached / 9M reads)
[OK] Query cache efficiency: 79.3% (16M cached / 21M selects)
[!!] Query cache prunes per day: 11559
[OK] Sorts requiring temporary tables: 0% (279 temp sorts / 1M sorts)
[OK] Temporary tables created on disk: 1% (3K on disk / 217K total)
[OK] Thread cache hit rate: 93% (182K created / 2M connections)
[OK] Table cache hit rate: 92% (15K open / 16K opened)
[OK] Open file limit used: 9% (15K/165K)
[OK] Table locks acquired immediately: 99% (16M immediate / 16M locks)
[OK] InnoDB data size / buffer pool: 224.0K/128.0M

-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Increasing the query_cache size over 128M may reduce performance
Variables to adjust:
query_cache_size (> 256M) [see warning above]