Kieran Lal wrote:
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.
Yeah. What prompted my initial post is that today I had to repair the accesslog table. That got me thinking "maybe I should try InnoDB".
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.
Thanks. That's very informative. I didn't realize that the space difference was so big. I'm not worried about the disk space. I just hope that the memory doesn't become a problem. I'll write to my web host to ask how my site is doing memory-wise.
Here's a Drupal performance tuning checklist: http://tag1consulting.com/files/checklist.pdf
Ah, that'll be useful. Thanks.
If you see a slowdown, let me know and I'll help you out.
Thanks.
Daniel.