Best my.cnf configuration

M

memomohannad

Registered
Jan 22, 2014
2
0
1
cPanel Access Level
Root Administrator
Hi

I need the best optimization/configuration for "my.cnf" - MySQL 5.5 - CENTOS 6.5 x86_64 standard

Currently for my.cnf I have the following:
Code: 
#open_files_limit=4006[mysqld]
#innodb_file_per_table=1
#max_connections=150
#interactive_timeout=30
#wait_timeout=30
#query_cache_size=128M
#query_cache_limit = 4M
#tmp_table_size=512M
#max_heap_table_size=512M
#key_buffer=256M
#key_buffer_size=2048M
#long_query_time=5
#join_buffer_size=2M
#thread_cache_size=16k
#low_priority_updates=1
#concurrent_insert=ALWAYS
#table_cache = 1K
#table_definition_cache = 4K
#open_files_limit = 3K
Processor Information

Code: 
 Total processors: 8

Processor #1

    Vendor
        GenuineIntel

    Name
        Intel(R) Xeon(R) CPU X3440 @ 2.53GHz

    Speed
        1200.000 MHz

    Cache
        8192 KB

Processor #2

    Vendor
        GenuineIntel

    Name
        Intel(R) Xeon(R) CPU X3440 @ 2.53GHz

    Speed
        2534.000 MHz

    Cache
        8192 KB

Processor #3

    Vendor
        GenuineIntel

    Name
        Intel(R) Xeon(R) CPU X3440 @ 2.53GHz

    Speed
        2534.000 MHz

    Cache
        8192 KB

Processor #4

    Vendor
        GenuineIntel

    Name
        Intel(R) Xeon(R) CPU X3440 @ 2.53GHz

    Speed
        1200.000 MHz

    Cache
        8192 KB

Processor #5

    Vendor
        GenuineIntel

    Name
        Intel(R) Xeon(R) CPU X3440 @ 2.53GHz

    Speed
        1200.000 MHz

    Cache
        8192 KB

Processor #6

    Vendor
        GenuineIntel

    Name
        Intel(R) Xeon(R) CPU X3440 @ 2.53GHz

    Speed
        1200.000 MHz

    Cache
        8192 KB

Processor #7

    Vendor
        GenuineIntel

    Name
        Intel(R) Xeon(R) CPU X3440 @ 2.53GHz

    Speed
        1200.000 MHz

    Cache
        8192 KB

Processor #8

    Vendor
        GenuineIntel

    Name
        Intel(R) Xeon(R) CPU X3440 @ 2.53GHz

    Speed
        2534.000 MHz

    Cache
        8192 KB
Memory Information

Code: 
Memory: 8032544k/9437184k available (5223k kernel code, 1057676k absent, 346964k reserved, 7119k data, 1264k init)
thank you a lot for your help
Mohannad
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
Samet Chan Best performance my.cnf and EA4 Config Workarounds and Optimization 4
N my.cnf best settings Workarounds and Optimization 3
G Best my.cnf for my servers! Workarounds and Optimization 3
S my.cnf Best configuration Workarounds and Optimization 1
M Best optimization for my.cnf Workarounds and Optimization 5
Similar threads
Best performance my.cnf and EA4 Config
my.cnf best settings
Best my.cnf for my servers!
my.cnf Best configuration
Best optimization for my.cnf
Top Bottom