What should I do if Sitegorund prompts me that the database usage limit has been exceeded?

Continue to share wordpress website maintenance tutorial. There is a customer’s website appeared as shown in the picture above is the problem, at first I thought it was a plugin conflict or PHP error, but it is not, in the background of the site to operate a pass are not responding, the problem remains.

Inspection Issues

Background login Siteground before the problem specific problem. As shown in the figure above, the reason is that the customer’s website mysql database use beyond the limit, so Siteground from the server side to do the limit, the only solution is to clean up the database. (Of course, you can also spend money to upgrade the package, but not recommended)

I logged into phpmyadmin to check and found that the postmeta and posts tables are particularly large, adding up to more than 1G indeed. Under normal circumstances the database footprint of an ordinary wordpress site should not be so large.

Problem Analysis

In general, the ordinary wordpress website database is very small, such as my own website, operation for several years, at present only more than 10M only. The reason why the customer’s website database is so big, because the use of elementor and woocommerce, at the same time they also use several other extensions plug-ins, and their website as a whole to do more complex, a variety of elementor elements and modules nested, these operations will make the database bigger.

Another reason is that they turn off caching, and without it, the burden on the database becomes greater.

Addressing The Issue

It’s good to know why. Here are 3 ideas to deal with it shared.

1. use cache plug-ins. wp rocket, litespeed cache, etc. can be, these are cache plug-ins, but they come with the database cleanup function, directly to clean up on it.

2. Use database cleanup plugin. There are many plugins of the same kind, for example, WP-Sweep is very good, you can install it by searching directly in the backend of the wordpress website.

After installation as shown in the picture above, just go straight to clean up the database tables that are taking up a lot of space.

Note: Before cleaning up the database, please always remember to backup the site, if you really can not clean up, or afraid of misuse, you can find professional and technical personnel to deal with.

In phpmyadmin, after the cleanup will change will see changes, but in Siteground background mysql, data refresh is not so much, we can wait for about half an hour, and then go back in you can find that the database occupancy has become smaller, as shown in the figure above.

如何预防这种情况

The culprit of such problems, although generally elementor and woocommerce, but we can not not use these two plug-ins, because they are really very good, some application scenarios also have to use. So do not blame the plug-in problems, from the site itself and their own habits to find the reason. For example, some unnecessary plug-ins plug-ins, can not be installed, do not install, can use the elements and modules that come with the use of self-contained. There is the structure of the site is not too complex, such as a variety of elements of the nested, this is not only to make the database occupancy becomes large, there may be some other unpredictable errors. Of course, the specific how to use or to combine the specific needs of the station and the use of the scene to, experience is also very important.

Finally, it’s a good idea for websites to have their caching turned on. Generally websites with caching turned on will be relieved quite a bit, and these types of problems may be less likely to be encountered.