How to optimize the WordPress database?

I want to hear how you do an optimization for MySQL WordPress DB.
This is what I do,
1. Change all database tables to InnoDB (there are some hosting companies that make it automated when you install a new WordPress website)
2. Verify all tables and click "optimize" in PHPMyAdmin
3. Use Redis cache for database cache – Under the WordPress Cache Cache plugin
4. If it is an installation complement of the old website to remove all revisions, etc. (then uninstall the add-in; don't love the unused add-ons)

Please share your tips to make the wordpress mysql DB faster.