Deleting entries in the mysql database table serveractivity_logs
It would be required to reduce the size of the Ezeelogin mysql database table serveractivity_logs as it would cause the Ezeelogin software upgrade to slow down significantly ( 2-4 hours ) because of the huge size of the database table. The table can be truncated based on the ssh gateway users ’login time’ so that the upgrade operations completes quickly.
This data from the serveractivity_logs would be displayed in the GUI under Users->Server Activity->Server Activity Logs as shown.
Before truncating the serveractivity_logs you can export the logs from GUI for audit purposes under Users>Server Activity>Export
Generate a mysql dump of the Ezeelogin database or a table dump before you perform the operation in case you need to revert due to any unforeseen reasons.
The serveractivity _logs mysql table structure would looks as follows.
[[email protected]~gate]# MariaDB [ezlogin_wggmp]> desc thwm_serveractivity_logs;
Alternatively, the mysql command to delete the entries based on the user Login Time would be
MariaDB [ezlogin_wggmp]> delete from thwm_serveractivity_logs where login_time < ’2020-01-01’;
Query OK, 235 rows affected (0.009 sec)