Gejala umum

• Endpoint lambat saat traffic meningkat

• CPU database naik

• Banyak full table scan

Langkah awal

1. Cek query paling sering dipanggil

2. Tambah index yang relevan

3. Hindari SELECT *

SELECT id, email, created_at
FROM users
WHERE status = 'active'
ORDER BY created_at DESC
LIMIT 50;

EN

(Write English version here)