0

I searched how can I detect table access history in Aurora. I have a lot of tables in my DB, when I can detect some tables which have not been accessed in a certain period, I would drop them to ease the DB burden.

Is there any way to achieve this? As of Redshift, I can refer SVV_TABLE_INFO, and so on.

If someone has an opinion, please let me know. thanks

buddemat
  • 3,262
  • 10
  • 15
  • 39
Heisenberg
  • 3,657
  • 5
  • 30
  • 51
  • https://stackoverflow.com/questions/5762539/when-was-the-last-time-a-mysql-table-was-accessed/48295317 this thread has some solutions that might fit your use case. – Anss Dec 21 '21 at 06:23

0 Answers0