First of it all, login to your phpmyadmin and choose your WordPress database. Once done, click on the sql button to open the sql command window.
Then, simply paste the following sql command and execute it.
DELETE FROM `wp_options` WHERE `option_name` LIKE ('%\_transient\_%');
Credit: Stack Overflow
Want more super useful SQL queries? Check out this article on Cats Who Code.
The post Downsize your WordPress database by removing transients appeared first on WPRecipes.