Senky wrote:Well, may be good as an extension, or part of STK, but really not in the core.
It is/will be an extension... That is
my MOD pictured above. And when 3.1 arrives, I hope to make the 3.1 version of it.
drathbun wrote:To be honest, I am not in favor of this. In my opinion, database administration should never be done using tools that are embedded within an application because they might be out of date or just flat out wrong. Who would you trust to write DBA utilities? phpBB, or MySQL? Nothing against the developers here, it's just not expected to be their area of expertise.
FWIW, the commands used to Optimize, Check and Repair are SQL commands. In other words, those tasks are performed by native MySQL functions and not by PHP. So there is no reason to not trust what it is doing.
IMO, this should not be part of the core either. As mentioned, this only applies to MySQL databases, and on top of that their are additional quirks such as InnoDB not supporting some of these functions. That's why this is best as a MOD/extension where users who know they might benefit from such a tool could choose to install it.
The whole point of this MOD is simply to eliminate the task of going to phpMyAdmin to perform occasional DB optimization tasks, and give users the option to do so from within phpBB's ACP where they may feel more at home.