Optimasi XAMPP Outlet (mart_offline)
====================================

Script: OPTIMIZE_XAMPP.ps1
Target : Windows + XAMPP di server outlet (default E:\xampp)

Apa yang diubah
---------------
1. PHP php.ini
   - extension=zip          (wajib untuk Excel .xlsx / ZipArchive)
   - extension=gd
   - zend_extension=opcache + setting produksi
   - realpath_cache_size=4096k, realpath_cache_ttl=120

2. MySQL my.ini (sizing ~8 GB RAM)
   - innodb_buffer_pool_size=1536M  (live bisa jadi ~2G karena rounding InnoDB)
   - max_allowed_packet=64M
   - innodb_log_buffer_size=32M
   - tmp_table_size / max_heap_table_size=64M
   - table_open_cache=400, max_connections=100, thread_cache_size=16
   - innodb_log_file_size TIDAK diubah (aman)

3. Apache
   - mpm_winnt ThreadsPerChild=64
   - KeepAlive On, KeepAliveTimeout 5, HostnameLookups Off

Cara jalankan (di server outlet)
--------------------------------
  powershell -NoProfile -ExecutionPolicy Bypass -File OPTIMIZE_XAMPP.ps1

Dari PC admin (Tailscale + SSH):
  scp deploy/outlet01/OPTIMIZE_XAMPP.ps1 outlet01-ts:E:/xampp/tmp/OPTIMIZE_XAMPP.ps1
  ssh outlet01-ts powershell -NoProfile -ExecutionPolicy Bypass -File E:\xampp\tmp\OPTIMIZE_XAMPP.ps1

Opsi:
  -SkipRestart   hanya tulis config, restart manual di XAMPP Control Panel

Backup
------
Setiap run membuat folder:
  E:\xampp\_backup_optimize_YYYYMMDD_HHMMSS\
Berisi: php.ini, my.ini, httpd-mpm.conf, httpd.conf

Rollback: copy balik file dari folder backup, lalu restart MySQL + Apache.

Verifikasi cepat
----------------
  E:\xampp\php\php.exe -m | findstr /i "zip opcache gd"
  mysql -uroot -e "SHOW VARIABLES LIKE 'innodb_buffer_pool_size';"
  Import Excel di: /mart_offline/mart/backoff/migrasi/

Outlet-01 (2026-07-30)
----------------------
Host SSH : outlet01-ts (100.127.46.37)
Hasil    : zip/ZipArchive/gd/opcache = yes (Apache)
           MySQL max_allowed_packet=64M, buffer pool ~2G (dari 16M)
           Apache ThreadsPerChild=64
Backup   : E:\xampp\_backup_optimize_20260730_224637
