mySQL database size large, but tables size less

admin管理员组

文章数量:1122832

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

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

• database
• mysql
• post-thumbnails

Share Improve this question asked Jun 26, 2017 at 20:50 AMAK - BPAMAK - BP 111 bronze badge 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 ♦ Commented May 11, 2022 at 21:31

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 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.

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

本文标签： mySQL database size largebut tables size less