User manager and size of DB

RouterOS General
1

Hi, I’d like to know if a new CCR1009 is able to keep the autentication of about 2000 users in pppoe and if yes how much will be large the database?

2

8M / week

3

Why the DB should grow if I hypothetically don’t add users?

4

cause everytime your user login and or logout, the record added for session and log.

P

5

What infos are stored in the sessions?
Can I disable the logging and do it with the firewall and syslog?

6

I made some test and in the log there is no rows after some sessions started and closed, so there is only the problem for old sessions stored. Can I delete them automatically?

7 
/tool user-manager session remove [find where active=no];
/tool user-manager database rebuild;
8

Thanks a lot.
Can the rebuild of DB cause any lag for the users?

9

NO. Why bump?

10

I clicked for error the button.
Sorry

11

Only curiosity…