Originally published at: Common MySQL Commands for WordPress - Managing WP - All about Managing WordPress
Content Error or Suggest an EditNotice a grammatical error or technical inaccuracy? Let us know; we will give you credit! Draft WarningYou’ve reached a draft 
and unfortunately, it’s a work in progress. Locating Large Database Usage SELECT post_type, COUNT(*) FROM wp_posts GROUP BY post_type;