myisam

Not sure where is the most appropriate post for this, let me know if anybody has suggestion.

I am having performance issues with INNODB. My major issue is that with INNODB I am getting approximately 20 times slower performance than with MyISAM. For the purpose of testing I have used Drupal 7 with devel module installed. Further more I used 2 bare bone servers with default installations so I can do parallel comparisons.

Not sure where is the most appropriate post for this, let me know if anybody has suggestion.

I am having performance issues with INNODB. My major issue is that with INNODB I am getting approximately 20 times slower performance than with MyISAM. For the purpose of testing I have used Drupal 7 with devel module installed. Further more I used 2 bare bone servers with default installations so I can do parallel comparisons.

We were considering conversion of Tables to Innodb. I have read at many places about the side effects and positive things about Converting to Innodb.

Can we have a list of tables here, which we can convert to Innodb and those which should be kept to MyIsam.

The site is am working on, is having high load and high number of pages are delivered.

On an average, 300 nodes are added everyday. (Not much of Commenting activity)

The pages are served via Boost Module to Anonymous users.

The logged in user activity is also low.