High Load mysql server

[MyName]

Кирюшкин Владимир Wrote:
-------------------------------------------------------
> Hello,
> 
> > key_buffer_size = 1536M
> 
> owh. i'd suggest you to try this tool:
> http://mysqltuner.pl/mysqltuner.pl
> 
> 
> Cheers,
> 
> Vladimir
> 

Thx for help, i was run that config but still load my CPU is high..
this is after installation :

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

-------- Storage Engine Statistics
-------------------------------------------
[--] Status: -Archive +BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 3M (Tables: 6)
[!!] BDB is enabled but isn't being used
[!!] Total fragmented tables: 4

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

-------- Performance Metrics
-------------------------------------------------
[--] Up for: 4h 9m 43s (5M q [378.161 qps], 1M conn, TX: 15B, RX: 259M)
[--] Reads / Writes: 85% / 15%
[--] Total buffers: 1.6G global + 5.0M per thread (500 max threads)
[!!] Maximum possible memory usage: 4.1G (543% of installed RAM)
[OK] Slow queries: 0% (0/5M)
[OK] Highest usage of available connections: 2% (12/500)
[OK] Key buffer size / total MyISAM indexes: 1.5G/945.0K
[OK] Key buffer hit rate: 99.8% (419K cached / 1K reads)
[OK] Query cache efficiency: 33.9% (667K cached / 1M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 346K sorts)
[OK] Temporary tables created on disk: 0% (23 on disk / 5K total)
[OK] Thread cache hit rate: 99% (12 created / 1M connections)
[OK] Table cache hit rate: 39% (37 open / 94 opened)
[OK] Open file limit used: 0% (59/10K)
[OK] Table locks acquired immediately: 96% (1M immediate / 1M locks)

-------- Recommendations
-----------------------------------------------------
General recommendations:
    Add skip-bdb to MySQL configuration to disable BDB
    Run OPTIMIZE TABLE to defragment tables for better performance
    MySQL started within last 24 hours - recommendations may be
inaccurate
    Reduce your overall MySQL memory footprint for system stability
    Enable the slow query log to troubleshoot bad queries

So, what i`ve must to do again.?

Posted at Nginx Forum: http://forum.nginx.org/read.php?2,217465,217478#msg-217478