Large Post Meta Table in WordPress?

Most hosting companies offer WordPress installation using cPanel setup. It uses the MySQL database in the backend and phpMyAdmin to modify Belize B2B List the database content. You will also have tools in cPanel for managing user privileges and backing up your database. As far as we’ve checked, it’s the same setup with popular hosting companies like SiteGround, Bluehost, and HostGator, unless you’re using a dedicated custom option. You may notice that the database size will grow faster with the content you publish. In particular, few tables in MySQL database will grow much faster than other tables. What is post metadata? Before we embark on the cleaning process, it is necessary to understand the metadata. It is a type of information data used for different purposes. WordPress stores post related content in two tables wp_posts and wp_postmeta.

Post Meta Table

Any additional meta boxes you see in the post editor will add data into the post’s meta table. Here are some of the most well-known examples: SEO plugins like Yoast SEO meta boxes. Yoast SEO Plugin Metadata Yoast SEO Plugin Metadata Review plugins like WP Review. Review plugin metadata Review plugin metadata Commercial themes add meta boxes for layout settings and other features Theme Metadata Theme Metadata Custom fields created by plugins and themes. Custom fields in posts Custom fields in posts Although you can disable these meta boxes in the Gutenberg editor, each meta box will still create entries in the main table.

Review Plugins

Belize B2B List
Belize B2B List

Check wp_postmeta table size By default, MySQL tables will have the wp_ prefix . For example, the post content table will be like wp_posts and the post meta will be like wp postmeta. However, if you changed the prefix during installation, you will see a different prefix on your database. Log in to your cPanel hosting account. Click on the phpMyAdmin app. Select your database and sort the database with the “Size” column. You can find the biggest table on top. Checking table size in WordPress database Checking table size in WordPress database As you can see in the screenshot above, the post table is 26.6 MB, while the meta post table is 109.8 MB in size. clear warning that something is affecting the size of the post meta table and you need to work on cleaning it up.

Leave a comment

Your email address will not be published.