How to optimize database through phpMyadmin JE Gan Modified on: Thu, 12 Sep, 2019 at 12:06 PM 1. Login to phpMyadmin.2. Select database. - Check all tables.- Select "Optimize table". - Press "Go".3. Done.