Delete WordPress Transient

To reduce wordpress wp_options table size, we can run following command to reduce # of records in wp_options which make your site runs faster

DELETE FROM `wp_options` WHERE `option_name` LIKE ('_transient_%');
DELETE FROM `wp_options` WHERE `option_name` LIKE ('_site_transient_%');