it’s a mix of both, sf_posts are InnoDB, where would I find the my.ini? have I posted anything private so far that you have noticed? I thought I had edited everything out
Mixture? How would the sfxxxx tables not all be the same?
my.ini will vary based on server os.. Usually /etc
There are some config options in the else for memory and things… Might be worth tweaking….
dunno, all are Myisam except for sflinks, sfoptions, sfpostattachments, and sfposts, those are InnoDB, we use wp-engine, we had the issue with the sql query error with the search function when we first started using SP until yellow fixed the issue so it worked with the way wp-engine has the tables set up
I will hunt down the my.ini
Have to wonder if the mixed table types are contributing to this… Seems odd, but perhaps okay…
On your test site, might be worth downloading are plugin (on download page) for converting tables to InnoDB and see if it matters…
our db converter plugin… will let you make all your sp tables be InnDB vice a mixture…
might be red herring, just thought worth a try…
I downloaded the data importer plugin and tried running it, it says
Unable to Import: Your Simple:Press forum already contains data
This importer requires a new and empty Simple:Press installation
@mr-papa , am I looking at the wrong plugin, I was reading yellows blog post about the myisam versus innodb and it says this
At the same time we will also be releasing a small and simple WordPress plugin that will convert all of the Simple:Press MyISAM tables in your database – to use the InnoDB engine if this is something you prefer.
I don’t see a plugin for that under the plugin list
it would be on the main download page… its a wp plugin, not sp… if not there, will have to check with Andy as I thought he had uploaded it… worst case, should be able to link to it here…
Thought I was going crazy for a minute, I don’t see it there, will wait for the link, thanks Mr Papa
yeah, just looked myself and dont see it… so need to check with Andy to see if any reason why it didnt get up… and make sure its ready to share…
