Is there a utility to analysis my joomla database? Something has gone wrong with it and it taking forever to load or sometimes just fails to load?


Go to phpMyAdmin -> Select your database -> click "Check all" (at the bottom) to select all table -> Choose "Repair table" in "With selected".

You can also perform the steps above and select the "Optimize table" to optimize your database