I have my site hosted with NetworkSolution, and they have a sql database size limit of 300MB. IF the size exceeds this limit we cannot access the wordpress admin dashboard. So currently its showing 441MB, and its overlimit. And they are force me to upgrade the database size to 1GB for 120$/yearly.

But previously I had all tables size totaling to 45MB, but the database size was 321MB, and I had to request them to grant me access, so they use to resync/optimise the database, so it gets the actual size around 60MB.

But now they claim that my site has increased the database size to 441MB.

How can I check what table is taking the max storage? or whats causing the database size to increase?



It could be because bigger than needed because Wordpress keeps in it some old stuff like post revisions, autodrafts, orphaned or duplicated meta... this could be easily cleaned using WP-Sweep plugin as long as you can run it on your site. I'm not sure how is your situation right now, are you able to use wp-admin or not. Anyway:

  1. As a first step I'd recommend backing up your database using PHPmyAdmin or much smaller alternative - PHPminiAdmin. With any of those tools you can also see the size of the tables, so you can check if the hosting company doesn't lie to you. Notice that besides the table size, for each table there's and index which depending on the table structure can take a reasonable space too.

  2. a) If you have access to the wp-admin - install the plugin and do some cleaning - the options are quite self-explanatory.

  3. b) If you don't have wp-admin access and you don't want to pay for an upgrade I think you should download the database and the files and setup your site somewhere else just for the sake of running the plugin and cleaning the database. Many hosting companies offer a free trial period. Alternatively you can set up the site on you local machine using XAMP server setup for instance and do the same. Having cleaned up the DB you can upload it back to the server.

From my experience sometimes the Wordpress database can take many times more space than really needed, because of the trash collected with the years of working, so you could win this situation not paying for the upgrade.

| improve this answer | |
  • I dont have access to the wordpress admin dashboard, nor able to connect to the phpmyadmin page for the database admin. – AMAK - BP Jun 27 '17 at 13:44
  • I tried the ssh connection and got the result is 40.80 MB. How can I know the rest 400MB size are stored where? – AMAK - BP Jun 27 '17 at 13:59
  • What can I ask the hosting provider to check related the the DB size, any cron jobs not working, or anything to fix for this issue. – AMAK - BP Jun 27 '17 at 14:06
  • Having ssh access you could try to upload PHPmyAdmin or PHPminiAdmin to the server - if you are working under Windows - you could use WinSCP utility. – Picard Jun 27 '17 at 16:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.