Hot answers tagged mysql
WordPress absolutely does need "DELETE", otherwise it has no way to delete posts or tags or options rows or anything else. The "DROP" command is sometimes used during upgrades, although it's been a long time. The last time I think it was used was during the WordPress 2.3 update, which removed the assorted categories tables in favor of the new taxonomy ...
If you remove revisions, your blog is going to be identical for the user. Only in the backend, you won't have access anymore to your post history. You can also use plugins like https://wordpress.org/plugins/wp-optimize/ to do that. Ref: http://codex.wordpress.org/Post_Types#Revision
Only top voted, non community-wiki answers of a minimum length are eligible