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.

Optimization help

Discussion in 'Workarounds and Optimization' started by Diego Vieira, Dec 15, 2014.

  1. Diego Vieira

    Diego Vieira Registered

    Joined:
    Dec 15, 2014
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Vila Velha, Brazil
    cPanel Access Level:
    Root Administrator
    We're running two stores, a forum and a blog.
    Thanks in advance.

    Code:
    root@server2 [~]# cat /etc/my.cnf 
    [mysqld]
    innodb_file_per_table=1
    max_allowed_packet=268435456
    open_files_limit=10000
    max_connections=151
    wait_timeout=27000
    interactive_timeout=27000
    query_cache_size=8M
    join_buffer_size=128K
    tmp_table_size=17M
    max_heap_table_size=17M
    thread_cache_size=4
    table_open_cache=410
    Code:
    root@server2 [~]# cat /proc/cpuinfo
    processor	: 0
    vendor_id	: GenuineIntel
    cpu family	: 6
    model		: 26
    model name	: Intel(R) Core(TM) i7 CPU         920  @ 2.67GHz
    stepping	: 5
    cpu MHz		: 1600.000
    cache size	: 8192 KB
    physical id	: 0
    siblings	: 8
    core id		: 0
    cpu cores	: 4
    apicid		: 0
    initial apicid	: 0
    fpu		: yes
    fpu_exception	: yes
    cpuid level	: 11
    wp		: yes
    flags		: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni dtes64 monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm ida dts tpr_shadow vnmi flexpriority ept vpid
    bogomips	: 5347.07
    clflush size	: 64
    cache_alignment	: 64
    address sizes	: 36 bits physical, 48 bits virtual
    power management:
    
    processor	: 1
    vendor_id	: GenuineIntel
    cpu family	: 6
    model		: 26
    model name	: Intel(R) Core(TM) i7 CPU         920  @ 2.67GHz
    stepping	: 5
    cpu MHz		: 1600.000
    cache size	: 8192 KB
    physical id	: 0
    siblings	: 8
    core id		: 1
    cpu cores	: 4
    apicid		: 2
    initial apicid	: 2
    fpu		: yes
    fpu_exception	: yes
    cpuid level	: 11
    wp		: yes
    flags		: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni dtes64 monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm ida dts tpr_shadow vnmi flexpriority ept vpid
    bogomips	: 5347.07
    clflush size	: 64
    cache_alignment	: 64
    address sizes	: 36 bits physical, 48 bits virtual
    power management:
    
    processor	: 2
    vendor_id	: GenuineIntel
    cpu family	: 6
    model		: 26
    model name	: Intel(R) Core(TM) i7 CPU         920  @ 2.67GHz
    stepping	: 5
    cpu MHz		: 1600.000
    cache size	: 8192 KB
    physical id	: 0
    siblings	: 8
    core id		: 2
    cpu cores	: 4
    apicid		: 4
    initial apicid	: 4
    fpu		: yes
    fpu_exception	: yes
    cpuid level	: 11
    wp		: yes
    flags		: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni dtes64 monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm ida dts tpr_shadow vnmi flexpriority ept vpid
    bogomips	: 5347.07
    clflush size	: 64
    cache_alignment	: 64
    address sizes	: 36 bits physical, 48 bits virtual
    power management:
    
    processor	: 3
    vendor_id	: GenuineIntel
    cpu family	: 6
    model		: 26
    model name	: Intel(R) Core(TM) i7 CPU         920  @ 2.67GHz
    stepping	: 5
    cpu MHz		: 1600.000
    cache size	: 8192 KB
    physical id	: 0
    siblings	: 8
    core id		: 3
    cpu cores	: 4
    apicid		: 6
    initial apicid	: 6
    fpu		: yes
    fpu_exception	: yes
    cpuid level	: 11
    wp		: yes
    flags		: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni dtes64 monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm ida dts tpr_shadow vnmi flexpriority ept vpid
    bogomips	: 5347.07
    clflush size	: 64
    cache_alignment	: 64
    address sizes	: 36 bits physical, 48 bits virtual
    power management:
    
    processor	: 4
    vendor_id	: GenuineIntel
    cpu family	: 6
    model		: 26
    model name	: Intel(R) Core(TM) i7 CPU         920  @ 2.67GHz
    stepping	: 5
    cpu MHz		: 1600.000
    cache size	: 8192 KB
    physical id	: 0
    siblings	: 8
    core id		: 0
    cpu cores	: 4
    apicid		: 1
    initial apicid	: 1
    fpu		: yes
    fpu_exception	: yes
    cpuid level	: 11
    wp		: yes
    flags		: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni dtes64 monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm ida dts tpr_shadow vnmi flexpriority ept vpid
    bogomips	: 5347.07
    clflush size	: 64
    cache_alignment	: 64
    address sizes	: 36 bits physical, 48 bits virtual
    power management:
    
    processor	: 5
    vendor_id	: GenuineIntel
    cpu family	: 6
    model		: 26
    model name	: Intel(R) Core(TM) i7 CPU         920  @ 2.67GHz
    stepping	: 5
    cpu MHz		: 1600.000
    cache size	: 8192 KB
    physical id	: 0
    siblings	: 8
    core id		: 1
    cpu cores	: 4
    apicid		: 3
    initial apicid	: 3
    fpu		: yes
    fpu_exception	: yes
    cpuid level	: 11
    wp		: yes
    flags		: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni dtes64 monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm ida dts tpr_shadow vnmi flexpriority ept vpid
    bogomips	: 5347.07
    clflush size	: 64
    cache_alignment	: 64
    address sizes	: 36 bits physical, 48 bits virtual
    power management:
    
    processor	: 6
    vendor_id	: GenuineIntel
    cpu family	: 6
    model		: 26
    model name	: Intel(R) Core(TM) i7 CPU         920  @ 2.67GHz
    stepping	: 5
    cpu MHz		: 1600.000
    cache size	: 8192 KB
    physical id	: 0
    siblings	: 8
    core id		: 2
    cpu cores	: 4
    apicid		: 5
    initial apicid	: 5
    fpu		: yes
    fpu_exception	: yes
    cpuid level	: 11
    wp		: yes
    flags		: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni dtes64 monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm ida dts tpr_shadow vnmi flexpriority ept vpid
    bogomips	: 5347.07
    clflush size	: 64
    cache_alignment	: 64
    address sizes	: 36 bits physical, 48 bits virtual
    power management:
    
    processor	: 7
    vendor_id	: GenuineIntel
    cpu family	: 6
    model		: 26
    model name	: Intel(R) Core(TM) i7 CPU         920  @ 2.67GHz
    stepping	: 5
    cpu MHz		: 2668.000
    cache size	: 8192 KB
    physical id	: 0
    siblings	: 8
    core id		: 3
    cpu cores	: 4
    apicid		: 7
    initial apicid	: 7
    fpu		: yes
    fpu_exception	: yes
    cpuid level	: 11
    wp		: yes
    flags		: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni dtes64 monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr pdcm sse4_1 sse4_2 popcnt lahf_lm ida dts tpr_shadow vnmi flexpriority ept vpid
    bogomips	: 5347.07
    clflush size	: 64
    cache_alignment	: 64
    address sizes	: 36 bits physical, 48 bits virtual
    power management:
    Code:
    root@server2 [~]# cat /proc/meminfo
    MemTotal:       49553228 kB
    MemFree:          736452 kB
    Buffers:         3875808 kB
    Cached:         33882540 kB
    SwapCached:        24172 kB
    Active:         16265184 kB
    Inactive:       22024192 kB
    Active(anon):     147700 kB
    Inactive(anon):   380220 kB
    Active(file):   16117484 kB
    Inactive(file): 21643972 kB
    Unevictable:           0 kB
    Mlocked:               0 kB
    SwapTotal:      25165692 kB
    SwapFree:       25042248 kB
    Dirty:              1128 kB
    Writeback:             0 kB
    AnonPages:        503752 kB
    Mapped:            29452 kB
    Shmem:               124 kB
    Slab:           10174300 kB
    SReclaimable:    9875416 kB
    SUnreclaim:       298884 kB
    KernelStack:        2080 kB
    PageTables:        10152 kB
    NFS_Unstable:          0 kB
    Bounce:                0 kB
    WritebackTmp:          0 kB
    CommitLimit:    49942304 kB
    Committed_AS:     821044 kB
    VmallocTotal:   34359738367 kB
    VmallocUsed:      382800 kB
    VmallocChunk:   34359345188 kB
    HardwareCorrupted:     0 kB
    AnonHugePages:    323584 kB
    HugePages_Total:       0
    HugePages_Free:        0
    HugePages_Rsvd:        0
    HugePages_Surp:        0
    Hugepagesize:       2048 kB
    DirectMap4k:        7680 kB
    DirectMap2M:    50315264 kB
    Code:
    root@server2 [~]# ./mysqltuner.pl 
    
     >>  MySQLTuner 1.4.0 - Major Hayden <major@mhtx.net>
     >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
     >>  Run with '--help' for additional options and output filtering
    [OK] Currently running supported MySQL version 5.5.40-cll
    [OK] Operating on 64-bit architecture
    
    -------- Storage Engine Statistics -------------------------------------------
    [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM 
    [--] Data in MyISAM tables: 3G (Tables: 983)
    [--] Data in InnoDB tables: 1M (Tables: 114)
    [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
    [--] Data in MEMORY tables: 372K (Tables: 633)
    [!!] Total fragmented tables: 26
    
    -------- Security Recommendations  -------------------------------------------
    [OK] All database users have passwords assigned
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 4d 21h 44m 46s (153M q [362.579 qps], 995K conn, TX: 484B, RX: 27B)
    [--] Reads / Writes: 93% / 7%
    [--] Total buffers: 177.0M global + 2.8M per thread (151 max threads)
    [OK] Maximum possible memory usage: 592.2M (1% of installed RAM)
    [OK] Slow queries: 0% (6/153M)
    [OK] Highest usage of available connections: 35% (53/151)
    [OK] Key buffer size / total MyISAM indexes: 8.0M/528.8M
    [OK] Key buffer hit rate: 99.3% (7B cached / 56M reads)
    [OK] Query cache efficiency: 44.1% (63M cached / 144M selects)
    [!!] Query cache prunes per day: 11650517
    [OK] Sorts requiring temporary tables: 0% (36K temp sorts / 9M sorts)
    [!!] Joins performed without indexes: 143919
    [!!] Temporary tables created on disk: 48% (2M on disk / 4M total)
    [OK] Thread cache hit rate: 97% (27K created / 995K connections)
    [!!] Table cache hit rate: 0% (410 open / 113K opened)
    [OK] Open file limit used: 5% (546/10K)
    [OK] Table locks acquired immediately: 99% (101M immediate / 101M locks)
    [OK] InnoDB buffer pool / data size: 128.0M/1.8M
    [OK] InnoDB log waits: 0
    -------- Recommendations -----------------------------------------------------
    General recommendations:
        Run OPTIMIZE TABLE to defragment tables for better performance
        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
        Increase table_open_cache gradually to avoid file descriptor limits
        Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
    Variables to adjust:
        query_cache_size (> 8M)
        join_buffer_size (> 128.0K, or always use indexes with joins)
        tmp_table_size (> 17M)
        max_heap_table_size (> 17M)
        table_open_cache (> 410)
    
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Are you experiencing noticeable slowness or are you simply wanting to get user-feedback on the best possible configuration?

    Thank you.
     
Loading...

Share This Page