iam
iam copied to clipboard
The content of authorization_code table is never cleaned up
From IAM escape data:
mysql> select count(*) from authorization_code where expiration < NOW();
+----------+
| count(*) |
+----------+
| 2336 |
+----------+
1 row in set (0,01 sec)
mysql> select expiration, count(*) from authorization_code group by expiration ASC limit 10;
+---------------------+----------+
| expiration | count(*) |
+---------------------+----------+
| 2019-08-15 01:52:23 | 1 |
| 2019-08-15 15:55:04 | 1 |
| 2019-08-15 15:55:21 | 1 |
| 2019-08-15 15:56:48 | 1 |
| 2019-08-15 16:00:20 | 1 |
| 2019-08-15 16:01:18 | 1 |
| 2019-08-15 16:03:50 | 1 |
| 2019-08-15 16:06:44 | 1 |
| 2019-08-15 16:17:39 | 1 |
| 2019-08-15 16:18:16 | 1 |
+---------------------+----------+
10 rows in set, 1 warning (0,03 sec)