Reduce the size of database / system log
By Artur Vieira
Hello,
I'm developing my website locally and my database is to big and my system log has 3,5 MB.
I searched and found th option to activate the log rotate, wich i had enable to clean it one time per month but the system is getting to slow and the DB to big.
How can I delete entries from the system log and do not mess with the system?
Regards
Beginning Developers
This space is for newcomers, who wish to build a new plugin or to customize an existing one to their liking
- iionly@iionly
iionly - 0 likes
- Artur Vieira@ArturVieira
Artur Vieira - 0 likes
- iionly@iionly
iionly - 0 likes
You must log in to post replies.Check out the No logging plugin: https://community.elgg.org/plugins/1441338/1.8.0/elgg-1819-no-logging. This plugin won't reduce the size of the log table but it will stop new entries getting created.
The logrotate plugin will also only work, if you have the cronjobs of Elgg correctly set up on the server. You can execute a run of logrotate manually (trigger the cronjob) by calling the corresponding "cron url" in your browser, e.g. http://your-site-url/cron/monthly. If you change the log rotate interval to "weekly" (and then call http://your-site-url/cron/weekly) the size of the log table will also get smaller. If you use the No logging plugin the log table should then be empty after the next regular run of logrotate.
Thank you @iionly i used your option to trigger manually and the DB is much better now.
If I use your pluggin the new entries won't be created, but isn't necessary to save there the new entries?
Regards
The No logging plugin only stops the log entries from getting created. These log entries are not necessary for your site to work, i.e. the regular entities, annotations, relationships will still get created without problems.