The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Best my.cnf configuration

Discussion in 'Workarounds and Optimization' started by memomohannad, Jan 22, 2014.

  1. memomohannad

    memomohannad Registered

    Joined:
    Jan 22, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    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
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. memomohannad

    memomohannad Registered

    Joined:
    Jan 22, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Re: i need a help please

    Thank you.
     
Loading...

Share This Page