- Currently, all log information is in the
loggingtable and as of now it has around~2,13,92,493records - Total size of data is
~36 GB(retrieved frominformation_schematable) - A record can have a size between 1KB to 10KB based on the amount of data stored.
- With the current indexes in the table, logs for a single user can be fetched pretty quickly and uses
constref
mysql> EXPLAIN SELECT * FROM `logging` WHERE `member_id` = 45373 ORDER BY `id` DESC LIMIT 100 OFFSET 0;
+----+-------------+---------+------------+------+---------------------------+---------------------------+---------+-------+------+----------+-------------+