For your site to perform smoothly all the time, it will require regular maintenance. Plenty of people use phpMyAdmin to manage their database. Plugins such as Ultimate DB Manager are also worth a look. It is a handy plugin that saves you time cleaning up your database and backing it up. It lets you schedule these tasks to save time.
This plugin can delete trash posts, pending comments, spam comments, trackbacks, and orphaned post/comment meta data and relationships. Scheduled daily tasks can be set to happen hourly, daily, weekly, or monthly. You can also use this plugin to repair corrupted database tables and easily download backups.