At this point, you should be able to configure and track database usage for both backend and frontend user requests. In this section, we will be looking at the usage of database in the most common WordPress features, and understand the need for storing the specified data.
Being the most frequently used feature in WordPress sites, you need thorough understanding of the database usage. First, you need to go to Posts
| Add New
section and clear the existing query logs. Then, you can add the data and publish a post to track the database usage. The Post creation
screen offers wide range of features and hence database usage may vary based on the amount of options you use. Let's track the queries by using the most common options in post creation:
INSERT INTO `wp_posts` (`post_author`, `post_date`...........) VALUES (1, '2018-07-13 08:43:22'.....) UPDATE `wp_posts` SET `post_author` = 1, `post_date` = '2018-07-13 08:43:30' ..... WHERE...