<\/span><\/h4>\nIn the first stage we run the Easy Apache and selected the following:<\/p>\n
* Apache Version 2.4+<\/p>\n
* PHP Version 5.6+<\/p>\n
* In step 5 \u201cExhaustive Options List\u201d select<\/p>\n
\u2013 Deflate<\/p>\n
\u2013 Expires<\/p>\n
\u2013 MPM Worker<\/p>\n
After Easy Apache finished go to your WHM \u00bb Service Configuration \u00bb Apache Configuration \u00bb \u201cGlobal Configuration\u201d and set the values by the level of resources available on your server.<\/p>\n
Apache Directive (From 2GB memory or less and to 12GB+ memory)\r\n\r\nStartServers 4 8 16 \r\nMinSpareServers 4 8 16 \r\nMaxSpareServers 8 16 32 \r\nServerLimit 128 256 512 \r\nMaxRequestWorkers 150 250 500 \r\nMaxConnectionsPerChild 1000 2500 5000 \r\nKeep-Alive On On On\r\nKeep-Alive Timeout 1 1 1\r\nMax Keep-Alive Requests 30 30 30\r\nTimeout 60 60 60\r\n<\/pre>\nNow go to WHM \u00bb Service Configuration \u00bb Apache Configuration \u00bb Include Editor \u00bb \u201cPre VirtualHost Include\u201d and allow users minimal cache and data compression to allow the server to work less for the same things by pasting the code below into the text field.<\/p>\n
# Cache Control Settings for one hour cache\r\n<FilesMatch \".(ico|pdf|flv|jpg|jpeg|png|gif|js|css|swf)$\">\r\nHeader set Cache-Control \"max-age=3600, public\"\r\n \r\n<FilesMatch \".(xml|txt)$\">\r\nHeader set Cache-Control \"max-age=3600, public, must-revalidate\"\r\n \r\n<FilesMatch \".(html|htm)$\">\r\nHeader set Cache-Control \"max-age=3600, must-revalidate\"\r\n \r\n# Mod Deflate performs data compression\r\n<FilesMatch \".(js|css|html|php|xml|jpg|png|gif)$\">\r\nSetOutputFilter DEFLATE\r\nBrowserMatch ^Mozilla\/4 gzip-only-text\/html\r\nBrowserMatch ^Mozilla\/4.0[678] no-gzip\r\nBrowserMatch bMSIE no-gzip\r\n<\/pre>\nGo to WHM \u00bb Service Configuration \u00bb \u201cPHP Configuration Editor\u201d and set the parameters according to your needs:<\/p>\n
\u2013 memory_limit<\/p>\n
\u2013 max_execution_time<\/p>\n
\u2013 max_input_time<\/p>\n
<\/span>MySQL<\/strong><\/span><\/span><\/h4>\nFor MySQL you need to update the configuration file that usually in \/etc\/my.cnf<\/p>\n
Best config base on 2 core & 4GB memory MySQL 5.6 \\ MariaDB 10:<\/p>\n
[mysqld]\r\n local-infile = 0\r\n max_connections = 250\r\n key_buffer = 64M\r\n myisam_sort_buffer_size = 64M\r\n join_buffer_size = 1M\r\n read_buffer_size = 1M\r\n sort_buffer_size = 2M\r\n max_heap_table_size = 16M\r\n table_cache = 5000\r\n thread_cache_size = 286\r\n interactive_timeout = 25\r\n wait_timeout = 7000\r\n connect_timeout = 15\r\n max_allowed_packet = 16M\r\n max_connect_errors = 10\r\n query_cache_limit = 2M\r\n query_cache_size = 32M\r\n query_cache_type = 1\r\n tmp_table_size = 16M\r\n open_files_limit=25280\r\n\r\n[mysqld_safe]\r\n\r\n[mysqldump]\r\n quick\r\n max_allowed_packet = 16M\r\n[myisamchk]\r\n key_buffer = 64M\r\n sort_buffer = 64M\r\n read_buffer = 16M\r\n write_buffer = 16M\r\n[mysqlhotcopy]\r\n interactive-timeout\r\n \r\n<\/pre>\nBest config base on 8 core & 16GB+ memory (Shared server) MySQL 5.6 or MariaDB 10:<\/p>\n
[mysqld]\r\nlocal-infile=0\r\nmax_connections = 600\r\nmax_user_connections=1000\r\nkey_buffer_size = 512M\r\nmyisam_sort_buffer_size = 64M\r\nread_buffer_size = 1M\r\ntable_open_cache = 5000\r\nthread_cache_size = 384\r\nwait_timeout = 20\r\nconnect_timeout = 10\r\ntmp_table_size = 256M\r\nmax_heap_table_size = 128M\r\nmax_allowed_packet = 64M\r\nnet_buffer_length = 16384\r\nmax_connect_errors = 10\r\nconcurrent_insert = 2\r\nread_rnd_buffer_size = 786432\r\nbulk_insert_buffer_size = 8M\r\nquery_cache_limit = 5M\r\nquery_cache_size = 128M\r\nquery_cache_type = 1\r\nquery_prealloc_size = 262144\r\nquery_alloc_block_size = 65535\r\ntransaction_alloc_block_size = 8192\r\ntransaction_prealloc_size = 4096\r\nmax_write_lock_count = 8\r\nslow_query_log\r\nlog-error\r\nexternal-locking=FALSE\r\nopen_files_limit=50000\r\n\r\n[mysqld_safe]\r\n\r\n[mysqldump]\r\nquick\r\nmax_allowed_packet = 16M\r\n\r\n[isamchk]\r\nkey_buffer = 384M\r\nsort_buffer = 384M\r\nread_buffer = 256M\r\nwrite_buffer = 256M\r\n\r\n[myisamchk]\r\nkey_buffer = 384M\r\nsort_buffer = 384M\r\nread_buffer = 256M\r\nwrite_buffer = 256M\r\n\r\n#### Per connection configuration ####\r\nsort_buffer_size = 1M\r\njoin_buffer_size = 1M\r\nthread_stack = 192K\r\n<\/pre>\n<\/span>Repair & optimize databases then restart MySQL:<\/span><\/span><\/h4>\nmysqlcheck --check --auto-repair --all-databases\r\nmysqlcheck --optimize --all-databases\r\n\/etc\/init.d\/mysql restar\r\n<\/pre>\n<\/span>Security & Limit Resources:<\/span><\/span><\/h4>\nInstall CSF (ConfigServer Security & Firewall) at: http:\/\/configserver.com\/free\/csf\/install.txt
\n1) Go to WHM \u00bb Plugins \u00bb ConfigServer Security & Firewall \u00bb \u201cCheck Server Security\u201d And pass on what appears as required to repair:<\/p>\n
2) Go to WHM \u00bb Plugins \u00bb ConfigServer Security & Firewall \u00bb \u201cFirewall Configuration\u201d and set the parameters according to your needs:<\/p>\n
PT_USERMEM=180<\/p>\n
PT_USERTIME=180<\/p>\n
PT_USERKILL=1<\/p>\n
PT_USERKILL_ALERT=1 (Optional)<\/p>\n
Along with the above, tweak the CSF by checking your server\u2019s security.<\/p>\n
That\u2019s it we are done the optimization of our Mysql and Apache on cPanel\/Whm server.<\/p>\n","protected":false},"excerpt":{"rendered":"
From this post we are going to see how to optimize MySQL & Apache on cPanel\/WHM server. On this optimization process we will go over the Apache core configuration and modules that are part of Apache core. We think that with the correct settings of Apache and MySQL you can […]<\/p>\n","protected":false},"author":1,"featured_media":840,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[1],"tags":[],"class_list":["post-821","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-latest"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/coimbatorewebhosting.com\/blog\/wp-content\/uploads\/2018\/01\/OPTIMIZE.png","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pa2YU7-df","_links":{"self":[{"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/posts\/821","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/comments?post=821"}],"version-history":[{"count":0,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/posts\/821\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/media\/840"}],"wp:attachment":[{"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/media?parent=821"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/categories?post=821"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/coimbatorewebhosting.com\/blog\/wp-json\/wp\/v2\/tags?post=821"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}