Best performance my.cnf and EA4 Config
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="30GB RAM">
[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="CPU: 6x"> 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="EA4 Config"> 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="my.cnf"> 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.
[CODE="CPU: 6x"> 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="EA4 Config"> 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="my.cnf"> 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.
-
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. 0 -
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?0 -
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. 0 -
I'm glad to that new feature after 5 months ago. I'm waiting for that until pre-release :) 0
Please sign in to leave a comment.
Comments
4 comments