### Node-1 and Node-2 ###
mkdir -p /u01/oomlab /u01/csv
### Upload scripts to /u01/oomlab
chmod 700 /u01/oomlab/*.sh

### Node-1 ###
# Create the lab schema
cd /u01/oomlab
mysql -e "drop database if exists oomlab"
mysql < 01_schema.sql
mysql -e "show tables from oomlab"


[root@gcisdb1 oomlab]# ./oomctl.sh
╔══════════════════════════════════════════════════════════════════════╗
║              OOM ROOT-CAUSE ISOLATION MENU                           ║
╠══════════════════════════════════════════════════════════════════════╣
║  Memory cap is EXTERNAL. Set before running:                         ║
║    systemctl set-property mariadb.service MemoryMax=2048M            ║
║    systemctl set-property mariadb.service MemoryHigh=infinity        ║
║  Swap must be off: run ./disable_swap_permanently.sh once            ║
╠══════════════════════════════════════════════════════════════════════╣
║  Diagnostics                                                         ║
║    D1) Pre-flight                                                    ║
║    D2) Show matrix.csv                                               ║
║    D3) Show memory now                                               ║
║                                                                      ║
║  T0 Baseline sizing (3)      1) T0.1  2) T0.2  3) T0.3               ║
║  T1 Vector isolation (7)     4) T1.1  5) T1.2  6) T1.3  7) T1.4      ║
║                              8) T1.5  9) T1.6 10) T1.7               ║
║                                                                      ║
║  Utilities                                                           ║
║   90) Emergency abort                                                ║
║   91) Collect evidence manually                                      ║
║   92) Recovery / cleanup (DB drop + CSV wipe — leaves cap/swap)      ║
║   93) Reset database                                                 ║
║    0) Exit                                                           ║
╚══════════════════════════════════════════════════════════════════════╝
Select test: