Best performance my.cnf and EA4 Config

Samet Chan · Sep 9, 2017

No need for say managed server. We using self-managed perfectly.
If you are experienced with WHM performances please tell me.

I'm giving you my details EA4 Config and my.cnf,

VPS Server
Hardware: SSD-Boosted (SSHD - Solid-State Hybrid Drive)
Operating System: CentOS 7.3
Control Panel: WHM/cPanel

Server Information

Code:

[0.000000] Memory: 4973584k/32505856k available (6768k kernel code, 1050048k absent, 761368k reserved, 4445k data, 1684k init)

MemTotal:       30716400 kB
MemFree:        27830732 kB
MemAvailable:   28059300 kB
Buffers:             640 kB
Cached:           845220 kB
SwapCached:            0 kB
Active:          1819356 kB
Inactive:         592336 kB
Active(anon):    1621692 kB
Inactive(anon):   268356 kB
Active(file):     197664 kB
Inactive(file):   323980 kB
Unevictable:           0 kB
Mlocked:               0 kB
SwapTotal:             0 kB
SwapFree:              0 kB
Dirty:               396 kB
Writeback:             0 kB
AnonPages:       1565620 kB
Mapped:           200152 kB
Shmem:            324220 kB
Slab:             199212 kB
SReclaimable:      34500 kB
SUnreclaim:       164712 kB
KernelStack:        9840 kB
PageTables:        21316 kB
NFS_Unstable:          0 kB
Bounce:                0 kB
WritebackTmp:          0 kB
CommitLimit:    15358200 kB
Committed_AS:    5854052 kB
VmallocTotal:   34359738367 kB
VmallocUsed:       62444 kB
VmallocChunk:   34359620240 kB
HardwareCorrupted:     0 kB
AnonHugePages:   1224704 kB
HugePages_Total:       0
HugePages_Free:        0
HugePages_Rsvd:        0
HugePages_Surp:        0
Hugepagesize:       2048 kB
DirectMap4k:      189412 kB
DirectMap2M:    10295296 kB
DirectMap1G:    23068672 kB

Code:

processor       : 0
vendor_id       : GenuineIntel
cpu family      : 6
model           : 63
model name      : Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
stepping        : 2
microcode       : 0x1
cpu MHz         : 2399.994
cache size      : 15360 KB
physical id     : 0
siblings        : 6
core id         : 0
cpu cores       : 6
apicid          : 0
initial apicid  : 0
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss ht syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid xsaveopt
bogomips        : 4799.98
clflush size    : 64
cache_alignment : 64
address sizes   : 40 bits physical, 48 bits virtual
power management:

processor       : 1
vendor_id       : GenuineIntel
cpu family      : 6
model           : 63
model name      : Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
stepping        : 2
microcode       : 0x1
cpu MHz         : 2399.994
cache size      : 15360 KB
physical id     : 0
siblings        : 6
core id         : 1
cpu cores       : 6
apicid          : 1
initial apicid  : 1
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss ht syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid xsaveopt
bogomips        : 4799.98
clflush size    : 64
cache_alignment : 64
address sizes   : 40 bits physical, 48 bits virtual
power management:

processor       : 2
vendor_id       : GenuineIntel
cpu family      : 6
model           : 63
model name      : Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
stepping        : 2
microcode       : 0x1
cpu MHz         : 2399.994
cache size      : 15360 KB
physical id     : 0
siblings        : 6
core id         : 2
cpu cores       : 6
apicid          : 2
initial apicid  : 2
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss ht syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid xsaveopt
bogomips        : 4799.98
clflush size    : 64
cache_alignment : 64
address sizes   : 40 bits physical, 48 bits virtual
power management:

processor       : 3
vendor_id       : GenuineIntel
cpu family      : 6
model           : 63
model name      : Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
stepping        : 2
microcode       : 0x1
cpu MHz         : 2399.994
cache size      : 15360 KB
physical id     : 0
siblings        : 6
core id         : 3
cpu cores       : 6
apicid          : 3
initial apicid  : 3
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss ht syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid xsaveopt
bogomips        : 4799.98
clflush size    : 64
cache_alignment : 64
address sizes   : 40 bits physical, 48 bits virtual
power management:

processor       : 4
vendor_id       : GenuineIntel
cpu family      : 6
model           : 63
model name      : Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
stepping        : 2
microcode       : 0x1
cpu MHz         : 2399.994
cache size      : 15360 KB
physical id     : 0
siblings        : 6
core id         : 4
cpu cores       : 6
apicid          : 4
initial apicid  : 4
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss ht syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid xsaveopt
bogomips        : 4799.98
clflush size    : 64
cache_alignment : 64
address sizes   : 40 bits physical, 48 bits virtual
power management:

processor       : 5
vendor_id       : GenuineIntel
cpu family      : 6
model           : 63
model name      : Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
stepping        : 2
microcode       : 0x1
cpu MHz         : 2399.994
cache size      : 15360 KB
physical id     : 0
siblings        : 6
core id         : 5
cpu cores       : 6
apicid          : 5
initial apicid  : 5
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss ht syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid xsaveopt
bogomips        : 4799.98
clflush size    : 64
cache_alignment : 64
address sizes   : 40 bits physical, 48 bits virtual
power management:

-----------------------------

Code:

Apache 2.4
config
config-runtime
devel
mod_bw
mod_bwlimited
mod_cache
mod_cache_disk
mod_cache_socache
mod_cgid
mod_deflate
mod_env
mod_evasive
mod_expires
mod_fcgid
mod_file_cache
mod_headers
mod_heartbeat
mod_http2
mod_mpm_event
mod_proxy
mod_proxy_fcgi
mod_proxy_ftp
mod_proxy_html
mod_proxy_http
mod_proxy_wstunnel
mod_request
mod_security2
mod_security2-mlogc
mod_session
mod_socache_memcache
mod_ssl
mod_suexec
mod_suphp
mod_unique_id
mod_watchdog
tools


PHP 5.6
libc-client
pear
php-bcmath
php-bz2
php-calendar
php-cli
php-common
php-curl
php-dba
php-devel
php-enchant
php-exif
php-fileinfo
php-fpm
php-ftp
php-gd
php-gettext
php-gmp
php-iconv
php-imap
php-intl
php-ldap
php-litespeed
php-mbstring
php-mcrypt
php-memcache
php-memcached
php-mysqlnd
php-odbc
php-opcache
php-pdo
php-pgsql
php-phalcon
php-posix
php-process
php-pspell
php-soap
php-sockets
php-tidy
php-xml
php-xmlrpc
php-zip
runtime


PHP 7.0
libc-client
pear
php-bcmath
php-bz2
php-calendar
php-cli
php-common
php-curl
php-dba
php-dbg
php-devel
php-enchant
php-exif
php-fileinfo
php-fpm
php-ftp
php-gd
php-gettext
php-gmp
php-iconv
php-imap
php-intl
php-ldap
php-litespeed
php-mbstring
php-mcrypt
php-memcache
php-memcached
php-mysqlnd
php-odbc
php-opcache
php-pdo
php-pgsql
php-phalcon
php-posix
php-process
php-pspell
php-soap
php-sockets
php-tidy
php-xml
php-xmlrpc
php-zip
runtime


Others
apr
apr-devel
apr-util
apr-util-devel
apr-util-openssl
cpanel-tools
documentroot
libcurl
libmcrypt
libnghttp2
libtidy
modsec-sdbm-util
nghttp2
openssl
php-cli
php-cli-lsphp
profiles-cpanel
ruby24-libuv
ruby24-runtime

Code:

default-storage-engine=MyISAM
innodb_file_per_table=1
performance-schema=0
max_allowed_packet=268435456
open_files_limit=10000
local-infile=0
open_files_limit = 240000
table_open_cache = 24000
table_definition_cache = 1024
max_connections = 500

Let me know, If you are looking for my details are good or something problem.

cPanelMichael · Sep 12, 2017

Hello,

Performance tuning is unsupported, but here's a thread that you may find helpful for tuning MySQL:

mysqlmymonlite.sh server stats gathering tool for cPanel Server

Thank you.

Samet Chan · Sep 12, 2017

cPanelMichael said:
Hello,

Performance tuning is unsupported, but here's a thread that you may find helpful for tuning MySQL:

mysqlmymonlite.sh server stats gathering tool for cPanel Server

Thank you.

Thanks for the info, I will take look, But this is still on a feature cPanel?

cPanelMichael · Sep 12, 2017

Hello,

There's no MySQL performance tuning script offered with cPanel, however we do have a feature request opened at:

Config Tuner for MySQL/Apache/PHP-FPM Pools

Thank you.

Samet Chan · Sep 12, 2017

I'm glad to that new feature after 5 months ago. I'm waiting for that until pre-release

Thread starter	Similar threads	Forum	Replies	Date
	Best Practice: Automatic Updates vs Manual Updates	Workarounds and Optimization	3	Jun 3, 2019
	Best server side caching on Centos 7/Cloudlinux?	Workarounds and Optimization	4	Nov 13, 2018
M	Settings for best performance & speed	Workarounds and Optimization	8	Feb 10, 2017
D	pool options for best performance	Workarounds and Optimization	6	Nov 21, 2016
G	FCGI best settings for optimal performance	Workarounds and Optimization	8	Apr 25, 2011

Search

Search

Best performance my.cnf and EA4 Config

Samet Chan

Well-Known Member

cPanelMichael

Administrator

Samet Chan

Well-Known Member

cPanelMichael

Administrator

Samet Chan

Well-Known Member