Print

[blackmamba]

Hi all:)

I just changed the main mysql engine from MyISAM to InnoDB and I've run into some errors when altered some of the CPG tables from MyISAM to InnoDB.

tables:

ALTER TABLE `cpg143_hit_stats` ENGINE = innodb
#1214 - The used table type doesn't support FULLTEXT indexes

ALTER TABLE `cpg143_pictures` ENGINE = innodb
#1214 - The used table type doesn't support FULLTEXT indexes

ALTER TABLE `cpg_searchmod_last` ENGINE = innodb
#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key

I have the latest XAMPP 1.53a running MySQL 5.0.21 on winXP and the queries were made with phpMyAdmin - 2.8.1
Is it the searchmod fault?

[Nibbler]

You are switching to a table type that does not support some of the features of MyISAM. If you really want to do that then you can drop the keys it complains about.

[blackmamba]

10x Nibbler,

I have dropped the FULLTEXT keys and it now works. I have now all the tables in InnoDB format.

I'm still not sure how it will affect the overall performance since I have noticed an 30% increase in the CPU levels and 200% in the average time for queries.

So it is now twice slower and 30% more CPU expenssive for now.
Next step, i guess: optimising InnoDB