[RC] Automated MySQL Table Optimization

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Suggested Hosts
Skinny Vinny
Registered User
Posts: 230
Joined: Tue Dec 01, 2009 7:10 pm

Re: [RC] Automated MySQL Table Optimization

Post by Skinny Vinny »

As this sends all tables in one query, even if the php script itself were to timeout the mysql process should continue to run. If anyone wishes to test and finds otherwise, please do share :)

User avatar
VSE
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 5065
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Contact:

Re: [RC] Automated MySQL Table Optimization

Post by VSE »

I'm finding it hard to test out with any results...

But, I guess if the php script were to timeout and the MySQL process completes, then at the very least all that would happen is the time of the last run optimize would not be added to the config.

You could use the set_time_limit() function though to temporarily override any timeout limits
🧩 My Extensions 🧩 ✨ YES...they ALL work with phpBB 3.3!! ✨
Please do not PM me for support.

mut2nt
Registered User
Posts: 47
Joined: Sun Feb 21, 2010 8:22 pm
Location: HELL
Name: none mut2nt
Contact:

Re: [RC] Automated MySQL Table Optimization

Post by mut2nt »

what about my error? :-S

User avatar
Neuropass
Registered User
Posts: 1158
Joined: Fri Apr 17, 2009 2:02 pm
Location: SciTE4AutoIt3

Re: [RC] Automated MySQL Table Optimization

Post by Neuropass »

hi there, i wanted to know if there are any known bugs and if i can test on phpbb 3.07pl live forum?

thanks in advance.. ;)

Aber28
Registered User
Posts: 1
Joined: Wed Aug 11, 2010 8:30 am

Re: [RC] Automated MySQL Table Optimization

Post by Aber28 »

Hi all,

I am new at MySQL and just wanted to ask something :)

If I install this mod and use it, can something go wrong on the forum (phpbb3)? I will be using it on a live forum (not a demo/dummy one).

Thanks and have a nice day! :D

Regards,

User avatar
Neuropass
Registered User
Posts: 1158
Joined: Fri Apr 17, 2009 2:02 pm
Location: SciTE4AutoIt3

Re: [RC] Automated MySQL Table Optimization

Post by Neuropass »

Neuropass wrote:hi there, i wanted to know if there are any known bugs and if i can test on phpbb 3.07pl live forum?

thanks in advance.. ;)

bump

theendfear
Registered User
Posts: 22
Joined: Sun Apr 25, 2010 2:51 am

Re: [RC] Automated MySQL Table Optimization

Post by theendfear »

thank you!!

skarbanan
Registered User
Posts: 158
Joined: Mon Dec 01, 2008 9:11 am
Contact:

Re: [RC] Automated MySQL Table Optimization

Post by skarbanan »

anyone tried this on 3.0.7 pl1 ?

cheers

Locked

Return to “[3.0.x] MODs in Development”