Here some Some useful mySql Query for WordPress database you shold know while working on WordPress database project. Optimize the Database As you work on your blog, your database transactions pile up overheads which can be a performance hog. To clear such overheads and optimize your database, use this query: OPTIMIZE TABLE ‘wp_posts’;