Using MySQL log table to get current profile values, is this normal?

Question

MySQL

profile_id type new_value date_time
Let's say that to log changes in the value of any profile property, a table with columns is created: date_time column for profile?

Answer 1

no.
with any decent number of users and profile variability, the system will start to slow down on these queries, and you will come to the idea of ​​caching this data in a table :)

Answer 2

Read about event sourcing .