Cada línea es una query para limpiar la tabla sessions https://wordpress.org/support/topic/rows-added-to-wp_options-table-with-every-page-view/
DELETE FROM PREFIJODETUTABLA_options WHERE option_name LIKE ('_transient_%');
DELETE FROM PREFIJODETUTABLA_options WHERE option_name LIKE ('_wp_session_%');