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.

New Server my.cnf

Discussion in 'Workarounds and Optimization' started by SitexMedia, Jun 8, 2014.

  1. SitexMedia

    SitexMedia Member

    Joined:
    Feb 28, 2013
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Normally the techs at the hosting company sort out the setup up but it is time I learnt to do more myself and understand things better.

    I have a:-

    E3-1230v3 Quad Core with HT (8 logical cores)
    32GB RAM
    2x250GB SSD in RAID1

    CENTOS 6.5 x86_64 standard
    Apache 2.2.27
    PHP 5.4.29

    My current etc/my.cnf is

    [mysqld]
    innodb_file_per_table=1
    open_files_limit=33562

    After running pltuner I see

    General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    MySQL started within last 24 hours - recommendations may be inaccurate
    Enable the slow query log to troubleshoot bad queries
    Adjust your join queries to always utilize indexes
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries without LIMIT clauses
    Set thread_cache_size to 4 as a starting value
    Increase table_open_cache gradually to avoid file descriptor limits
    Read this before increasing table_open_cache over 64: /http://www.mysqlperformanceblog.com/2009/11/16/table_cache-negative-scalability/
    Variables to adjust:
    query_cache_size (>= 8M)
    join_buffer_size (> 128.0K, or always use indexes with joins)
    tmp_table_size (> 16M)
    max_heap_table_size (> 16M)
    thread_cache_size (start at 4)
    table_open_cache (> 400)
    innodb_buffer_pool_size (>= 1G)

    Do I add the above "Variables to adjust" lines but without the brackets? or as it is is above

    Is there any other tools I should run to optimise?

    Many thanks
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. SitexMedia

    SitexMedia Member

    Joined:
    Feb 28, 2013
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thanks I will work with that and see what I can break...
     
Loading...

Share This Page