Database Optimize & Repair Tool

InnoDB. Definitely work? - Database Optimize & Repair Tool

InnoDB. Definitely work?

by Volksdevil » Thu Dec 11, 2014 2:53 am

Hi mate,

Just a quick one...My boards tables are all InnoDB and whenever I've tried any of the Optimize etc via phpMyadmin, I get a response along the lines of 'This action can not be performed on this table type'

Something like that anyway...Will this extension allow me to actually perform the tasks?
My phpBB Extensions
Finally found great Website Hosting from Image KUALO!
Do NOT use 123-reg.co.uk - Incapable of running phpBB!
:ugeek: TekNeil - Streamer on Mixer | My Volkswagen Corrado G60
User avatar
Volksdevil
Registered User
Posts: 2414
Joined: Sun Oct 03, 2010 2:03 pm
Location: Lancashire, UK
Name: Neil
Contact:

Re: InnoDB. Definitely work?

by VSE » Thu Dec 11, 2014 3:22 am

It's fine. With innodb you can optimize, though it does something else called analyze & recreate. You can't repair innodb though, choosing optimize (analyze & recreate) will repair it anyways.
🧩 My Extensions 🧩 ✨ YES...they ALL work with phpBB 3.3!! ✨
Please do not PM me for support.
User avatar
VSE
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 5151
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Contact:

Re: InnoDB. Definitely work?

by Volksdevil » Thu Dec 11, 2014 3:29 am

Good stuff, cheers Matt. I'm not sure how I ended up with innoDB but I guess that's another topic...
My phpBB Extensions
Finally found great Website Hosting from Image KUALO!
Do NOT use 123-reg.co.uk - Incapable of running phpBB!
:ugeek: TekNeil - Streamer on Mixer | My Volkswagen Corrado G60
User avatar
Volksdevil
Registered User
Posts: 2414
Joined: Sun Oct 03, 2010 2:03 pm
Location: Lancashire, UK
Name: Neil
Contact:

Re: InnoDB. Definitely work?

by VSE » Thu Dec 11, 2014 3:31 am

InnoDB has been growing as the new standard/default. It's considered better than MyISAM.
🧩 My Extensions 🧩 ✨ YES...they ALL work with phpBB 3.3!! ✨
Please do not PM me for support.
User avatar
VSE
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 5151
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Contact:

Re: InnoDB. Definitely work?

by Volksdevil » Thu Dec 11, 2014 3:34 am

Ah, good to know then. In fact when I say all my tables are innoDB, there's just the one that isn't for some reason, the topics table, that's MyISAM. Anyway, all seems well. I'll give the extension a shot.

Cheers again.
My phpBB Extensions
Finally found great Website Hosting from Image KUALO!
Do NOT use 123-reg.co.uk - Incapable of running phpBB!
:ugeek: TekNeil - Streamer on Mixer | My Volkswagen Corrado G60
User avatar
Volksdevil
Registered User
Posts: 2414
Joined: Sun Oct 03, 2010 2:03 pm
Location: Lancashire, UK
Name: Neil
Contact:

Re: InnoDB. Definitely work?

by VSE » Thu Dec 11, 2014 3:41 am

Volksdevil wrote:Ah, good to know then. In fact when I say all my tables are innoDB, there's just the one that isn't for some reason, the topics table, that's MyISAM. Anyway, all seems well. I'll give the extension a shot.

Cheers again.

Don't mess with that one! That means you probably installed Precise Similar Topics, which requires that table to be MyISAM ;)
🧩 My Extensions 🧩 ✨ YES...they ALL work with phpBB 3.3!! ✨
Please do not PM me for support.
User avatar
VSE
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 5151
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Contact:

Re: InnoDB. Definitely work?

by Volksdevil » Thu Dec 11, 2014 3:45 am

Yep! That rings a bell actually. I did indeed have that as a MOD. No longer have it though, neither as a MOD nor Extension...
My phpBB Extensions
Finally found great Website Hosting from Image KUALO!
Do NOT use 123-reg.co.uk - Incapable of running phpBB!
:ugeek: TekNeil - Streamer on Mixer | My Volkswagen Corrado G60
User avatar
Volksdevil
Registered User
Posts: 2414
Joined: Sun Oct 03, 2010 2:03 pm
Location: Lancashire, UK
Name: Neil
Contact:

Re: InnoDB. Definitely work?

by Volksdevil » Thu Dec 11, 2014 10:48 am

Nice extension, just tried it.

For 'Optimize' I get:
note: Table does not support optimize, doing recreate + analyze instead
My phpBB Extensions
Finally found great Website Hosting from Image KUALO!
Do NOT use 123-reg.co.uk - Incapable of running phpBB!
:ugeek: TekNeil - Streamer on Mixer | My Volkswagen Corrado G60
User avatar
Volksdevil
Registered User
Posts: 2414
Joined: Sun Oct 03, 2010 2:03 pm
Location: Lancashire, UK
Name: Neil
Contact: