How can I fix/repair and optimize database myself?
You can optimize / repair your database via phpMyAdmin: First log into cPanel and open up the MySQL Databases manager icon. At the bottom of this screen you will find a link for phpMyAdmin. Clicking on this link will open up a new browser window with the home screen for phpMyAdmin. On this screen, click Databases. This will list all the databases you have setup. Click on the database you want to work on. The database screen will list the tables for the given database. Click the Check All link on the bottom left. Then from the pulldown menu choose Optimize /Repair Table.