shwebdev

Registered
Aug 28, 2012
1
0
1
Brisbane, Queensland, Australia, Australia
cPanel Access Level
Root Administrator
Hi,

Server often runs at 60% using 7% memory. Spikes occasionally into 100's. The server load is about 2.0 but goes up and down constantly alot.

This is my /etc/my.cnf:

[mysqld]
innodb_buffer_pool_size=20M
key_buffer_size = 512M
max_allowed_packet=100M
max_connections=500
max_heap_table_size=24M
open_files_limit=5000
query_cache_size=8M
table_cache = 2200
thread_cache_size=4
tmp_table_size=40M
log-slow-queries=/var/lib/mysql/slow.log

Code:
MYSQL Tuner:

 >>  MySQLTuner 1.1.2 - Major Hayden <[email protected]>
 >>  Bug reports, feature requests, and downloads at [url]http://mysqltuner.com/[/url]
 >>  Run with '--help' for additional options and output filtering

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

-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 3G (Tables: 1307)
[--] Data in InnoDB tables: 2M (Tables: 69)
[!!] Total fragmented tables: 59

-------- Performance Metrics -------------------------------------------------
[--] Up for: 2h 17m 19s (471K q [57.231 qps], 38K conn, TX: 1B, RX: 42M)
[--] Reads / Writes: 99% / 1%
[--] Total buffers: 566.0M global + 2.7M per thread (500 max threads)
[OK] Maximum possible memory usage: 1.9G (34% of installed RAM)
[OK] Slow queries: 0% (1/471K)
[OK] Highest usage of available connections: 3% (17/500)
[OK] Key buffer size / total MyISAM indexes: 512.0M/520.0M
[OK] Key buffer hit rate: 99.9% (64M cached / 47K reads)
[OK] Query cache efficiency: 64.1% (203K cached / 317K selects)
[!!] Query cache prunes per day: 1152803
[OK] Sorts requiring temporary tables: 2% (786 temp sorts / 32K sorts)
[!!] Joins performed without indexes: 247
[OK] Temporary tables created on disk: 1% (397 on disk / 32K total)
[OK] Thread cache hit rate: 96% (1K created / 38K connections)
[OK] Table cache hit rate: 74% (452 open / 609 opened)
[OK] Open file limit used: 15% (764/5K)
[OK] Table locks acquired immediately: 99% (116K immediate / 116K locks)
[OK] InnoDB data size / buffer pool: 2.3M/20.0M
Code:
Server Specs:

Memory: 5563532k/5698560k available (2545k kernel code, 126188k reserved, 1753k data, 196k init)

Total processors: 4

Processor #1

    Vendor
        GenuineIntel

    Name
        Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz

    Speed
        2933.530 MHz

    Cache
        3072 KB

Processor #2

    Vendor
        GenuineIntel

    Name
        Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz

    Speed
        2933.530 MHz

    Cache
        3072 KB

Processor #3

    Vendor
        GenuineIntel

    Name
        Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz

    Speed
        2933.530 MHz

    Cache
        3072 KB

Processor #4

    Vendor
        GenuineIntel

    Name
        Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz

    Speed
        2933.530 MHz

    Cache
        3072 KB