On Sat, Mar 21, 2009 at 1:16 PM, Daniel Carrera daniel.carrera@theingots.org wrote:
Kieran Lal wrote:
Tell us more about your site. Number of nodes, users, traffic. What kind of hosting environment, etc?
InnoDB is safer, but consumes more resources.
Hmm... let's see... 7,152 nodes, 4,300 users, and if I read the monthly log correctly, it seems like it averages 15,300 hits/day with a peak of 18,000 hits/day on wednesdays. But I think that might include all the files that go into making a web page (CSS, logo, etc).
We have a shared hosting environment, of the type that doesn't over-sell disk space, so it is somewhat intermediate between a typical shared hosting and a dedicated host.
The servers run RHEL, PHP 5.2.8 and MySQL 5.1.30.
Uhm... I can't think of anything else I can say about the site. Does any of this help answer my question?
MySQL ISAM engine is lightweight, and not transactional, but has been know to corrupt, although I think it's much more stable in MySQL 5.1. For high performance, and transaction integrity many people move their database engine to InnoDB.
InnoDB uses ~5x the disk space and ~3x more memory. It can be faster, and more reliable. But the down side is that if big tables like node, watchdog are InnoDB you can run into problems. Based on your site size, I don't forsee moving your entire site to InnoDB to be a problem.
Here's a Drupal performance tuning checklist: http://tag1consulting.com/files/checklist.pdf
If you see a slowdown, let me know and I'll help you out.
Cheers, Kieran
Daniel.
[ Drupal support list | http://lists.drupal.org/ ]