By Brian Graham on

My Web site is LessonMapper.com and we have hosting services provided by HostMonster. Our site is designed for NYS teachers to create lesson or unit plans. We have all of the NYS Standards and Performance indicators embedded. The user is given an account (such as Elementary teaching Grades K-4) and then selects the grade and content area. Doing this filters the large database of standards and then the user is able to select the NYS standard related to their grade level and content. The site has been up and running since the fall but we recently received a notice from HostMonster that indicates we are using over 1000 tables in our MySql database.

Your account information:
Total MySQL Database Size: 115.15 MB
Total MySQL Tables: 1365

They are going to shut down the site if we don't reduce the number of tables (below 1000). I could upgrade to a VPS (like GreenGeeks) but am looking for some advice.

⋅ Categories: Drupal 6.x

Comments

nevets’s picture

nevets commented

That is a lot of tables, do you know what purpose most of them serve?

Brian294’s picture

Brian294 commented

I couldn't imagine drupal using more than 150 tables unless you've enabled a 3rd party module that is creating tables automatically. Please post:
1. The table names (your host could give these to you if unknown).
2. The Drupal modules you have enabled.

seanray’s picture

seanray commented

It's crazy that you create over 1000 tables in a Shared hosting, normally they don't support this.

sreyas’s picture

sreyas commented

Only reason i could think of having these much tables are this site have lots of modules which were not uninstalled correctly.

You may have started the development on this same database and then tried many different modules and then choose the best one for you. But for removing the already installed modules you might have just disabled it and removed it from the modules directory. In this case the tables wont be deleted from the database. You should first disable the modules, then uninstall the module and then remove it from the module directory.

Now you may need to track which are the needed tables and then remove the unwanted tables from your database. Its better than just moving to a VPS and then have some problem there.

------------------
Ciril Sreedhar
Sreyas IT Solutions
Server Administration | Web Designing | Web Programming