How to Optimize WordPress Database Manually

Your WordPress database stores everything you have on your website. This content includes all pages, posts, blogs, portfolio items, forms, links, comments, and other post types. It will also store settings for your website, theme, and plugins. 

Here are the 11 core tables that are native to WordPress by default along with the kind of information they store.
• wp_commentmeta – Stores meta information for comments.
• wp_comments – Stores comments.
• wp_links – Creates, and stores links menu. 
• wp_options – Stores options set in the admin settings area.
• wp_postmeta – Stores meta information for posts.
• wp_posts – Stores data for posts, pages, and other custom post types.
• wp_terms – Stores a list of tags and categories for all posts and links.
• wp_term_relationships – Stores the relationship between a post and its category and tag, as well as between links and link categories.
• wp_term_taxonomy – Stores a taxonomy label in the wp_terms table. Taxonomy refers to a category, link, or tag.
• wp_usermeta – Stores meta-information about users
• wp_users – Stores a list of users.

Optimizing your database can improve the performance of your website and reduce server loads. By deleting outdated and unnecessary information off your website, you will greatly improve the efficiency of your database, allowing you to serve pages quicker.

It is important to make sure your database is optimized regularly to ensure consistent website performance.
How Your WordPress Database Fills up and Slow Down
Spam Comments: Settings – Discussion and look for the Comment Moderation section. Post Revisions: In order to cap the number of revisions of your WordPress post manually, you can add the following code to your sites wp-config.php file: define( ‘WP_POST_REVISIONS’, 10 ) 
Expired Transients Having too large a wp_options table can slow down your site, so deleting expired transients is a very helpful task.
How to Manually Optimize Your WordPress Database Watch the video until end, and follow the steps.