Support

Admin Tools

#20572 How to reduce db size

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 user77818 on Wednesday, 23 July 2014 08:52 CDT

Tuesday, 22 July 2014 23:17 CDT

user77818
 Hi,

I enabled the 'Calculate diff while scanning' option in PHP file change scanner feature. '...admitools_filecache' db table seems to hold the file contents which substantially increase db size. Now, I've disabled the option and ran the scans but the db table size remains the same. How to reduce the size of the db?

Also, when PHP file change scanner is run through cron job, log is not maintained on the site. How to mark files safe when the log is not maintained and no option to mark them?


Thanks!

Wednesday, 23 July 2014 02:47 CDT

tampe125
Hello,

at the moment there isn't any option to clear the #__admintools_filescache table, we will add it in the next version.
In the meantime, if you want to clear the table contents you have to manually truncate the table.

Regarding your second question, if you don't see any log it means that the scan is not run. Can you please double check the output of the CRON job? Did you see any errors in it?

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Wednesday, 23 July 2014 08:52 CDT

user77818
ok. 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!