Title: WordPress database problem
Last modified: August 30, 2016

---

# WordPress database problem

 *  [techill](https://wordpress.org/support/users/techill/)
 * (@techill)
 * [10 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-problem-5/)
 * Hello,
 * Every time I download a full backup, I always check my wordpress DB file to see
   if everything is ok. In this DB, the most important tables are wp_postmeta and
   wp_posts (under these two segments):
 * — Dumping data for table `wp_postmeta`
    — Dumping data for table `wp_posts`
 * I always check these two segments in DB. The posts on my blog are stored by timeline
   in DB. Literally, the newest post I made on my blog will be added to the end 
   of these two tables. So, it’s easy for me to see everything is fine.
 * But after Oct 10th, things changed. The postmeta of new posts I created after
   Oct 10th were still added to the end of the table “wp_postmeta”. But the content
   of new posts I created after Oct 10th were not added to the end of the table “
   wp_posts”. They are still in “wp_posts” table, but somewhere close to the end
   of table. It looks like they are inserted to the table randomly.
 * Since I have over 2000 posts on my blog, I am worried that new post random being
   inserted to the wp_posts table will affect the performance of surfing my site.
   I make new posts on a daily basis. All the new posts made after oct 10th will
   be stored in a random sequence in wp_posts. That’s not good although the access
   to all my posts still looks ok.
 * I tried optimize and repair function in phpmyadim. I optimized all tables and
   tried repair on wp_posts. The execution is ok and no errors. But nothing changed.
   The posts after Oct 10th are still not stored by the timeline in wp_posts table.
 * Things I’ve done right before Oct 10th:
    1) I deleted revisions by SQL: DELETE
   FROM wp_posts WHERE post_type=’revision’; I’ve done this a few times before, 
   without any problem.
 * 2) I added a feature of “Add Open Graph meta data” in Yoast SEO plugins.
 * I don’t know if they are the reasons for this DB issue. Please help and tell 
   me how to make posts stored by timeline in wp_posts.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [AllHeart Web](https://wordpress.org/support/users/amitsingh1984/)
 * (@amitsingh1984)
 * [10 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-problem-5/#post-6664006)
 * you using wp chache ?
 *  Thread Starter [techill](https://wordpress.org/support/users/techill/)
 * (@techill)
 * [10 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-problem-5/#post-6664073)
 * I don’t use cache plugins. I set up cache in .htaccess file.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘WordPress database problem’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [techill](https://wordpress.org/support/users/techill/)
 * Last activity: [10 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-problem-5/#post-6664073)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics