MyISAM

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
deja711's picture

Performance issues with INNODB vs 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.

Read more
ghayoumi's picture

Vertical Partitioning for nodes table

We have a website and we want to migrate to drupal. I have never build a website with drupal before. we might have 200,000-300,000 new pages in {nodes}.body each month. for the current website we had to denormalize database and call a second query to select the longText field and we had a significant performance gain. Can we somehow denormalize the nodes table and separate the body field. what do u think ?
you can also check this address to see an example of vertical partitioning performance gain.

Read more
Subscribe with RSS Syndicate content

MySQL

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: