Support

Admin Tools

#22997 internal server error when optimising database

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 Tuesday, 21 July 2015 02:29 CDT

amiella
 Hi. I have 30-40 sites on this server. Most of them are small sites with little traffic. Some of them are large. I am using Admin Tools Pro.
When I perform Repair & Optimise Tables, the smaller sites do it fine and for all the larger sites I get an error (see attached file).
I tried setting the max_execution_time to 240 seconds for one of them, and I still have the same problem.
I talked to my server provider's support and they say that the problem is in the Admin Tools - It is a "Negative side security application" (I translated there answer from Hebrew - I hope you understand what they mean...).
Thanks,
Ami

nicholas
Akeeba Staff
Manager
The Repair & Optimise feature merely issues the MySQL commands REPAIR TABLE and OPTIMIZE TABLE, see https://dev.mysql.com/doc/refman/5.1/en/repair-table.html and https://dev.mysql.com/doc/refman/5.1/en/optimize-table.html As you can read in the official MySQL documentation, written and maintained by Oracle, these are security neutral commands. In fact you should not even need to run them if your host didn't have a severely overloaded and misconfigured database server. MySQL tables don't crash on their own volition, they crash because the server is so stressed that threads are crashing in the middle of a write operation.

In the end of the day try issuing these commands from phpMyAdmin. Select the tables you want and from the "With selected" dropdown at the bottom of the page first select "Repair" and then "Optimize".

I still do not understand how issuing two very standard, security neutral MySQL commands which are also used by phpMyAdmin (that they already have installed on their server!) makes Admin Tools a malicious piece of software. They have no idea what they are talking about. I strongly recommend no longer using Interspace because they've pretty much proved to you that they don't understand how their own servers work!!!

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!