0

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?

thanks

1
  • 1
    This probably won't benefit a huge amount from WordPress expertise, perhaps you need dba.stackexchange.com but most likely you need a new host, cheap shared hosts can have larger databases than that with no database specific upper limit, and the cheapest VPS options on most hosts can handle much more than that for less than $10 per month sometimes $5 even
    – Tom J Nowell
    May 11, 2022 at 21:31

2 Answers 2

0

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.

4
  • 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, 2017 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, 2017 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, 2017 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, 2017 at 16:49
0

export( download) your db and import it in local mysql ( or with XAMP ) then you can analyse it

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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