what to do when your WordPress database is too large?

Well I have asked this question in WP Forums, StackOverflow, and GoDaddy community as well, but nothing worked out. Hoping something is in here.

I used 2 separated subdomains for my blog and site (2separate SQL database). But not I cudn’t maintain separately so trying to merge them into a single WP driven site. If I do that, I will end up with limitation of max 1GB SQL DB set by GoDaddy (and I can’t purchase dedicated solutions for this).

There is a way out to split a single DB into 2, or use more than 1 DB for WP. So, asking for you genius guys to help me out.

Not 100% sure how your DB could get that big. Have you gone through and cleaned out post revisions, old rows in the wp_options table from old plugins, etc?