Database Optimization

Databases
1

Hello Team,
We need to optimize the Postmeta tables. Since it has 2 GB.
We tried to optimize the above tables. But it says like:-

optimise
optimise1273Ă—748 66.6 KB

Please let me know the steps to resolve it.
I have tried with WP optimizer Plugin and other plugins which are related to database optimizer. But still it says the same issue.
Thanks

2

What makes you think they need to be optimized? What is the problem you are having?

1 Like
3

Hello rpkamp,

Actually our hosting providers provide the database size is 1 GB only. But our current database size is 2.5 GB. So we could not able to add any posts and could not add any pages on the database. It says the error like database size is exceeded. Seems some unwanted contents and data are there on the Post meta tables. So postmeta tables size is reached around 2 GB. We need to remove the exact content from the tables.

4

OPTIMIZE wont remove data from tables.

DELETE will.

I… highly doubt that your database being 2.5 GB will magically shrink to 1 GB just by running optimizations. That would imply the database is so fragmented that it is occupying its own space twice (and a half) due to shattering.

That said;
What you see above in the screenshot is not an error to be resolved. These are the normal messages when you run optimize against InnoDB tables. The NOTE tells you that it’s doing a different method (recreate + analyze) than you asked for because the table type does not allow OPTIMIZE (in the background, it’s running ALTER TABLE…FORCE instead, which is how an InnoDB table is defragmented), and then tells you it did that alternate method OK. It has done the defrag on those tables.

5

Hello m_hutley,
Thanks for the update.

Please let us know the exact steps or the solution for this issue.
Thanks

6

The exact steps are to actually read the post above, where i told you it isnt an error.

1 Like
7

Please let us know the solution or the conclusion for this issue.

Thanks

8

Name the issue.

9

Please let us know the solution for the database optimization. We need to reduce the database size.

Please help.

10

You’ve already optimized the database.

If you’ve defragged every table, and you’ve got 2.5 GB still… you’ve got 2.5GB worth of data.

If the database is properly normalized, and optimized, and you cant compact anything… your solution will be to remove data from the database.

That or find a host that will let you have bigger databases.