Database Optimize & Repair Tools from ACP

General discussion of development ideas and the approaches taken in the 3.x branch of phpBB. The next feature release of phpBB 3 will be 3.3/Proteus.
Forum rules
Please do not post support questions regarding installing, updating, or upgrading phpBB 3.2.x. If you need support for phpBB 3.2.x please visit the 3.2.x Support Forum on phpbb.com.

If you have questions regarding writing extensions please post in Extension Writers Discussion to receive proper guidance from our staff and community.
User avatar
Meis2M
Registered User
Posts: 432
Joined: Fri Apr 23, 2010 10:18 am
Contact:

Database Optimize & Repair Tools from ACP

Post by Meis2M » Fri Jul 20, 2012 3:28 am

Hi
whats is your idea about:
Database Optimize & Repair Tools from ACP

OPTIMIZE will defragment your database and can offer improved database performance.
REPAIR should only be used if you believe your database has crashed or corrupt tables.
CHECK will report on the status of tables.

Image

i found this mod about this:
https://www.phpbb.com/customise/db/mod/d ... pair_tool/

User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 135
Joined: Sun Dec 18, 2005 5:44 pm
Location: Texas
Contact:

Re: Database Optimize & Repair Tools from ACP

Post by Noxwizard » Fri Jul 20, 2012 4:07 am

This has been brought up before: viewtopic.php?f=81&t=41787

User avatar
callumacrae
Former Team Member
Posts: 1046
Joined: Tue Apr 27, 2010 9:37 am
Location: England
Contact:

Re: Database Optimize & Repair Tools from ACP

Post by callumacrae » Fri Jul 20, 2012 7:55 am

This isn't really phpBB's job, surely?
Made by developers, for developers!
My blog

User avatar
psoTFX
Registered User
Posts: 1984
Joined: Tue Jul 03, 2001 8:50 pm
Contact:

Re: Database Optimize & Repair Tools from ACP

Post by psoTFX » Fri Jul 20, 2012 5:24 pm

Well - it was something we considered a long (long long - I feel old) time ago. I don't know what happened to it because I recall us being in favour. The issue may have been cross-server support.

drathbun
Registered User
Posts: 72
Joined: Wed Feb 15, 2006 6:40 pm
Location: Texas
Contact:

Re: Database Optimize & Repair Tools from ACP

Post by drathbun » Sun Jul 22, 2012 6:28 am

You would have to create a different section for each potential database supported by phpBB. And what about databases that don't offer such tools?

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.

I don't even use the backup and restore options in the admin panel. ;)
Sometimes you're the windshield, sometimes you're the bug.

User avatar
bantu
3.0 Release Manager
3.0 Release Manager
Posts: 557
Joined: Thu Sep 07, 2006 11:22 am
Location: Karlsruhe, Germany
Contact:

Re: Database Optimize & Repair Tools from ACP

Post by bantu » Sun Jul 22, 2012 4:08 pm

Maybe we can get something like this included when we switch to a properly-designed DBAL library such as Doctrine. I would certainly not make this a priority.

Senky
Extension Customisations
Extension Customisations
Posts: 314
Joined: Thu Jul 16, 2009 4:41 pm

Re: Database Optimize & Repair Tools from ACP

Post by Senky » Sun Jul 22, 2012 4:31 pm

Well, may be good as an extension, or part of STK, but really not in the core.

User avatar
Vinny
Style Customisations
Style Customisations
Posts: 129
Joined: Thu May 20, 2010 4:01 am
Location: Brazil
Contact:

Re: Database Optimize & Repair Tools from ACP

Post by Vinny » Sun Jul 22, 2012 4:58 pm

Senky wrote:Well, may be good as an extension, or part of STK, but really not in the core.
+1

User avatar
VSE
Extension Customisations
Extension Customisations
Posts: 670
Joined: Mon Mar 08, 2010 9:18 am

Re: Database Optimize & Repair Tools from ACP

Post by VSE » Mon Jul 23, 2012 7:34 am

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.
Has an irascible disposition.

Oleg
Posts: 1150
Joined: Tue Feb 23, 2010 2:38 am
Contact:

Re: Database Optimize & Repair Tools from ACP

Post by Oleg » Mon Jul 23, 2012 8:31 am

I believe this functionality does not need to be in phpbb core (per the ticket).

Post Reply