Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Latest post by toonetcreation on Friday, 09 September 2022 02:52 CDT
Hi,
regarding this closed ticket https://www.akeeba.com/support/admin-tools/37684-infos-about-admintools-dbrepair-php.html I have a question.
I had a look on this documentation https://www.akeeba.com/documentation/admin-tools-joomla/auto-maintenance.html and this is fine.
But the database optimize/repair tools is not available anymore on J4?
Thanks
L.
This is correct, we no longer include it in Admin Tools for Joomla 4.
This feature was very important around Joomla 1.5 when Joomla was still using the MyISAM storage engine for its tables. On busy sites you might have concurrency issues or crashes which led to the MyISAM data on disk to become corrupt., needing a repair. Moreover, the way it worked would create a lot of holes in the data file when deleting a lot of records, necessitating the optimisation of the table (pretty much like you would defrag a hard drive).
Joomla 4 —in fact, since Joomla 3.4 or thereabouts— uses the InnoDB storage engine for all its tables. Instead of using one data file per table, it uses a shared file across all tables. MySQL's repair statement does nothing on InnoDB tables as per https://dev.mysql.com/doc/refman/5.7/en/repair-table.html. Likewise, optimising the table will have probably no effect unless there is a full text index (of which Joomla uses none in its tables) and even then MySQL can be configured to do this automatically as per https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html.
This means that the repair and optimise feature was doing absolutely nothing for the last several versions of Joomla and had no reason to exist anymore.
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!
that's clear, many thanks for the feedback ;-)
L.
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!