I made a drupal site and my client decide to go with shared hosting ( 1nor1 ). They gave unlimited MySQL databases. The maximum of the database it's 1GB. I reached it, and the only thing I can make it's clean the cache and accesslog tables ( 100-200MB ), but after 3-4 days when accesslog and cache tables get those 100-200MB the page crashes once more time.
I just found this: https://stackoverflow.com/questions/1897260/how-to-deal-with-the-200mb-limit-of-godaddy-database but the answer it's change hosting provider what I can't do.
What can I do? Thanks.
Try to use http://support.godaddy.com/ chat or phone call to find out, is there an option to buy extra resources for your project.
Run cron regularly to clear cache tables. Re factor your project's code... Use separate database for some part of your data... Check this strategy: drupal.org/node/18429
Take a look at this question. I hope this will help you to solve your problem.
A few things can be factors in your database size increasing rapidly.
You could also have a large volume of comments or/registered users. Try checking those two area's for spam as well and disable both.