converting to innodb

Hi @andreinoell, thank you for your question about converting tables to InnoDB through Vevida Optimizer.

The plugin leaves non-WordPress database tables untouched.

so It converts all wordpress database on the server? and not only the database where the plugin is isntalled?

Hi @andreinoel.l,

No. The plugin converts only those tables in your websites database that have a prefix that matches your WordPress install (usually wp_). It does not touch any other tables nor does it change anything to other databases on the same server. Of course it doesn’t, because usually your WordPress website database user credentials are not valid for other databases (at least they shouldn’t be).

However, if you are interested in converting other tables or full databases to Innodb, it is quite easy to adapt the query from the source code to accomplish this.

thank you for replying I tried to convert to innoDB but my wp_postmeta is now 1Million+ rows before it was 100K+ is that okay?

I’m sorry to hear the convert to InnoDB didn’t work as expected for you. Converting the database tables shouldn’t increase the number of rows.

I haven’t been able reproduce that behavior. Your MySQL server log files should provide some more information and details about this. Ask your hosting provider if you’re not self hosting the database, and if the sudden increase in rows is due to our plugin we’re more than happy to receive those logs.