Huge Hosting Problem! Please help!!

I'm a total newbie in these things and have no idea what to do

I have consulted my friends who are more aware of these kinds of problems than me but still i could not understand.

If i do not resolve this issue by the 7th, godaddy will shut down my hosting account.. Really need you guys to help me!

I know the problem is over utilization but i don't know what to do, they said either to upgrade to a dedicated server which i do not have the funds to or address and resolve this problem..

This was the message they sent me..

Dear Sir/Madam,

Thank you for contacting Hosting Support regarding the network violation for over-utilization of the smartbananas MySQL database on your smartbananas.com hosting account.

Upgrading to a different plan within the shared hosting environment would not be a solution to this issue. By definition, shared hosting shares resources with other plans and therefore the over-utilization of those resources by any one account is not acceptable. If you have server administration experience, you may wish to consider moving to a dedicated server plan, as you would then no longer be in a shared environment. Otherwise, you may wish to consider moving to a Managed Hosting plan, which features the benefits of a dedicated server without the requirements of managing it yourself.

However, should you wish to remain in the shared environment, you would need to address the following query:

SELECT DISTINCT u.ID, u.display_name FROM wp_users u , wp_usermeta um where u.ID = um.user_id ORDER BY rand() limit 5

EXPLAIN:
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE u ALL PRIMARY 156578 Using temporary; Using filesort
1 SIMPLE um ref user_id user_id 8 smartbananas.u.ID 15 Using index; Distinct

This query examines 2,348,670 rows, which is unacceptable in the shared environment.

Upon further review, we are seeing that the size of this database is approximately 2,300 MB, with approximately 1,300 MB being consumed by the 'wp_posts' table within it. Currently the size limitation for databases in our shared hosting environments is 2,000 MB.

We would therefore strongly recommend you review your database content, using the read-only user 'smartbananas2' through the phpMyAdmin interface, to determine whether this is valid content or the result of unchecked spamming of your WordPress application.

To Manage Your Databases Using phpMyAdmin

Log in to your Account Manager.

From the Products section, click Hosting.

Next to the hosting account you want to use, click Launch.

In the Databases section of the Hosting Control Center, click MySQL.

Click Manage via phpMyAdmin for the database you want to manage with phpMyAdmin.

Enter your user name and password. The user name is the same as the database name.
TIP: If you don't know your password, see Resetting Your MySQL Database Password for information about changing it.

Click Go.


For more information about working with phpMyAdmin once you're logged in, visit phpmyadmin.net.

If you find the contents to be due to spamming, you would need to clear that out either through phpMyAdmin or the WordPress dashboard, once you have responded with the required statements listed below so that we can re-enable access to this database.

If you find that the contents are legitimate, you would need to either remove any non-essential content in order to comply with the 2,000 MB limit or move to a more suitable hosting plan, as referenced above.

Please keep in mind that we are unable to support custom scripting or the inner workings of third-party products. Therefore, as the owner of this hosting plan, is is incumbent on your to verify that there are no other underlying factors that may be contributing to this issue.

*** IMPORTANT ***

Due to the serious nature of this situation, this hosting account is scheduled to be suspended if you do not take timely action. This suspension will take place SATURDAY JANUARY 7, 2012 if either you fail to reply to this message with the required statements below OR fail to correct the issues with this database after committing to do so.

****************

After you have examined this issue, your services can be reactivated by responding to this notice with the following:

1. A statement that you have reviewed and agree to abide by the terms of the "Web Hosting and Virtual Dedicated Hosting Service Agreement," and
2. A detailed description of the steps you have taken, or intend to take, to resolve and/or correct this issue, and
3. A statement that you agree to configure your site in such a way as to ensure that there is not a re-occurrence of this issue at any point in the future.

After we receive your reply with these statements we will contact Go Daddy's database administrators, provide them with your solution, and request that they re-investigate the issue. If they approve your proposed solution, we will reactivate your service. (We reserve the right to suspend your services again should its reactivation result in a repeat occurrence of the problem.)

We appreciate your cooperation and your understanding in this matter. If you have any questions, you may contact us by replying to this email or by calling 480-505-8871.

Regards,

Scott S.
Advanced Hosting Support

I would really appreciate it and be very thankful to you if you could tell what should i do, or whether i can choose any other plan that is in the under $30 range per month.. but they said you can only choose a dedicated server ..