Support

Admin Tools

#16163 admintools log table bloated

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by nicholas on Thursday, 23 May 2013 08:08 CDT

lcdservices
Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? yes
Have I searched the tickets before posting? yes
Have I read the documentation before posting (which pages?)? yes
Joomla! version: 2.5.11
PHP version: (unknown) 5.3.x
MySQL version: (unknown) 5.1.x
Host: (optional, but it helps us help you)
Admin Tools version: 2.5.5

Description of my issue:
I noticed that admintools was taking a long time to load, and pulling the security exception list took forever. due to some brute force attacks, the exception log table had grown quite large (it's also been operational for quite some time). the delay on the main admintools page was probably due to the new charts that are generated.

I manually pushed records prior to this year to a log_archive table in order to reduce the size of the main log table, and that solved things. but I think it would be worthwhile having a built in archive feature, or some kind of retention rule that can be setup, as that table will grow indefinitely (and steadily) over time.

nicholas
Akeeba Staff
Manager
Hello Brian,

This has already been implemented a few versions ago. Please go to extensions, manage plug-ins, find the system – admin tools plug-in and click on it. Look at the options on the right-hand part of the page. Scroll all the way down. The maximum security exceptions log entries option is the one you are looking for. You can hover your mouse over over the lable to find out more information about how this feature works.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

lcdservices
That's great. Might be worth migrating those options to the component, as it's unlikely people will know to look for them in the plugin config.

Also, having an archive option, not just a record limit, would be useful. And date based controls, not max entries would also be useful. I think most people would want to establish a retention policy such as "archive all records older than 1 yr".

But anyway -- all just feature requests.

nicholas
Akeeba Staff
Manager
The feature is documented. There already is a link to the plugin's configuration page from the component, too.

Database bloat (and subsequent slow down) depends on the number of entries, not their age. That's why the feature is based on # of records.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!