Hello, how are you guys?
IN our production environment, we have the oauth_token HUGE (250GB).
I need to delete all expired tokens, but it`s very slow to perform the
deletes (doc CA API Management Oauth Toolkit - 3.6 - page 272).
But it`s very slow the deletes due table token size.
----------------------
delete from oauth_token where rtoken is not null and rexpiration < unix_timestamp();
delete from oauth_token where expiration < unix_timestamp() and rtoken is null;
----------------------
It`s impossible delete expired tokens using those commands.
Please, Do you guys have any suggestion?
Can I simply truncate this table to reduce space size?
And what is impact of truncate this table in a production environment like that?
Thank you very much!