Hi guys.  I’m back with an update and a quick question.

Per your suggestion, we had our hosting guys make the move from myISAM to InnoDB for our db tables today.  Some of our tables were using myISAM and some were using InnoDB.  Hosting guys said the mySQL default is InnoDB, but some plugins change their tables to myISAM!?

They converted all myISAM tables to InnoDB except for two.

wp_sfposts
wp_sftopics

Because of this error: “ERROR 1214 (HY000) at line 1: The used table type doesn’t support FULLTEXT indexes ERROR 1214 (HY000) at line 1: The used table type doesn’t support FULLTEXT indexes”

Does that sound right to you guys?  Do you know if those tables should be able to use InnoDB?

Thanks again for all the help.

Pete

Tell your guys to remove those 2 indices and resubmit the tables to innoDB. This is what out InnoDB conversion plugin does. And that will be fine as long as your SP is an up to date version, say, newer than a year ago which is about when we made the necessary changes to abandon those indices.

Yellow Swordfish said
This is what out InnoDB conversion plugin does

What and where is this InnoDB conversion plugin you speak of?

I have considered converting our db tables from MyISAM to innoDB for quite some time, but have been daunted by the task after reading up on it.

I see no such download in the SP Plugins.

Oddly – we wrote the small plugin to help a user – decided to offer it and then promptly forgot about it! This was about a year back. It IS going to make an appearance in a few weeks when we rework the website here.

Not swapping the database engine is really not hard. It can be done manually in phpMyAdmin at table level. It was just the two tables referred to that had indexing unsupported by innoDB. I have attached a copy of the plugin you can try. Running it multiple times has no ill-effect although it should just do the job on the first pass. It is a WP plugin and adds an item to the forum menu. When done it should just be deactivated and removed. The plugin is a bit utilitarian by the way – nothing fancy!

Make a backup first? Always 🙂

Yellow Swordfish said
Not swapping the database engine is really not hard….I have attached a copy of the plugin…

Thanks! I’ll start a new topic if I have questions…

we will be here… 😉

Wanted to chime back in on this thread for a moment in case anyone else is dealing with slow load time in the forum. 

The thing that finally did the trick for us was disabling our security plugin (iThemes) and getting a firewall from sucuri.net ($10/month). We tried most of the major security plugins and they all slowed down our load time and gave us errors on occasion.  For sites that have a lot of plugins, it’s worth looking at their firewall.

The forum has been zooming ever since…

Thanks for the contribution, some security plugins can definitely do a number on load times..

Yellow Swordfish said
Oddly – we wrote the small plugin to help a user – decided to offer it and then promptly forgot about it! This was about a year back. It IS going to make an appearance in a few weeks when we rework the website here.
Not swapping the database engine is really not hard. It can be done manually in phpMyAdmin at table level. It was just the two tables referred to that had indexing unsupported by innoDB. I have attached a copy of the plugin you can try. Running it multiple times has no ill-effect although it should just do the job on the first pass. It is a WP plugin and adds an item to the forum menu. When done it should just be deactivated and removed. The plugin is a bit utilitarian by the way – nothing fancy!

Make a backup first? Always 🙂

How does this plugin work?  Does it make the table change for you?

Firstly it is a WordPress (NOT Simple:Press) plugin and when activated will add a new item at the bottom of the SP Forum admin menu.

If you have the latest version it will ask you whether you want the whole site or just the SP tables converting and then – when you press the ‘go’ button it will do the conversion for you, It only takes a few seconds,

There may be some conditions where the action id disallowed bit we have not encountered one yet. Also – if any of the tables from plugins have anything defined that is innoDB incompatible then it will leave that table alone.

make a safety backup and give it a try!

Yellow Swordfish said
Firstly it is a WordPress (NOT Simple:Press) plugin and when activated will add a new item at the bottom of the SP Forum admin menu.

If you have the latest version it will ask you whether you want the whole site or just the SP tables converting and then – when you press the ‘go’ button it will do the conversion for you, It only takes a few seconds,

There may be some conditions where the action id disallowed bit we have not encountered one yet. Also – if any of the tables from plugins have anything defined that is innoDB incompatible then it will leave that table alone.

make a safety backup and give it a try!

Yea, I installed it in WP but haven’t activated it yet.  Wanted to know how it functions first.  

just a db conversion…  potential throughput benefits…