How to remove transients from WordPress database + jetpack_nonce

I have a lot of transients, such as:

_transient_jpp_li

_transient_timeout_jpp_li

etc.

These need to be removed physically from time to time:

Run the following query:

DELETE FROM `wp_xxxx_options` WHERE `option_name` LIKE (‘%\_transient\_%’)

Then optimise those tables that have overhead.

I reduced my database size by around 8MB in this manner

ALSO CONSIDER THIS.

jetpack_nonce

This is a big issue. However, I don’t yet know what to do about it.