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;

Yang Baru di bulan Desember 2018

Ada yg baru di bulan Desember 2018

– Promo akhir pekan ( Jumat, Sabtu Minggu ), berupa diskon 40% (one-time) untuk paket VPS Hosting IIX, gunakan promo code: JSM2 pada saat order
– Domain .xyz dengan hanya Rp 50,000 dapat anda dapatkan di https://my.whplus.com/cart.php?a=add&domain=register
 Domain .ID, SCH.ID, WEB.ID dan MY.ID dengan harga kompetitif. selengkapnya di https://my.whplus.com/cart.php?a=add&domain=register

Silakan yang mau order sebelum promo berakhir.

Posted in News. Comments Off on Yang Baru di bulan Desember 2018

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