How to Optimize MySQL Tables ? 1. Login on server 2. Type next linux command in your mysql folder with MYI files : myisamchk --quick --check-only-changed --sort-index --analyze *.MYI folder ex: /var/lib/mysql/yourdatabase/