Konversi tabel InnoDB ke MyISAM

Untuk menjaga performansi server terutama agar mysql tidak overload, salah satunya adalah dengan menggunakan default MyISAM tabel dengan menambahkan field skip-innodb pada /etc/my.cnf
Bila sudah ada tabel yang terlanjur menggunakan format innoDB dapat dikonversi ke MyISAM dengan cara:

ALTER TABLE table_name ENGINE = MyISAM;

Edit Default PHP-FPM Settings

If you have many cPanel accounts, you may prefer to change the default settings for newly created cPanel accounts.

  1. As root, SSH into your server or launch WHM terminal.
  2. Create a system_pool_defaults.yaml file in the /var/cpanel/ApachePHPFPM directory. To do this using nano, type the following:

    nano /var/cpanel/ApachePHPFPM/system_pool_defaults.yaml

    Add the following to the new file:

    pm_max_children: 500
    pm_max_requests: 2000
    pm_min_spare_servers: 1
    pm_max_spare_servers: 25
    pm_process_idle_timeout: 150

    pm_max_children: Max number of child processes
    pm_max_requests: Number of requests a child process executes before respawning.
    pm_min_spare_servers: Minimum idle server processes
    pm_max_spare_servers: Maximum idle server processes
    pm_process_idle_timeout: Time until an idle process is killed in s(econds), m(inutes), m(inutes), h(ours), or d(ays).

  3. Save and exit the file. Using nano, press Control and x for the save prompt before exiting. Press y, then Enter ? to save the file.
  4. Rebuild PHP-FPM using the following command:

    /usr/local/cpanel/scripts/php_fpm_config --rebuild

  5. Restart PHP-FPM using the following command:

    /scripts/restartsrv_apache_php_fpm

CSF wp-login attempts block

In order to block IP’s that flood wp-login.php attempts by using CSF regex.custom.pm
if (($globlogs{CUSTOM2_LOG}{$lgfile}) and ($line =~ /(\S+).*] "\w*(?:GET) \/wp-login\.php.*" /)) {
return ("Failed WordPress GET",$1,"WPLOGINGET","3","80,443,21,25,22,23","1");
}
if (($globlogs{CUSTOM2_LOG}{$lgfile}) and ($line =~ /(\S+).*] "\w*(?:POST) \/wp-login\.php.*" /)) {
return ("Failed WordPress POST",$1,"WPLOGINPOST","3","80,443,21,25,22,23","1");
}