innodb

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.

So supposing you have several sites on D5 that won't get upgraded to D6 (to take advantage of the syslog support) for several months yet due to workload, what are good ways to optimize InnoDB so that Watchdog can write faster, i.e more concurrent INSERT statements, rather than taking down the site if things get fubar'd? Thanks :)

Here is my initial post about performance tuning our site http://www.divx.com/ This is mainly a place for me to brain dump and spark discussion and hopefully open up issues to track and get some of these fixes into Drupal core.

Servers

4 - Web servers with 8GB Memory each, Apache 2.2.x + PHP 5.2.x
2 - Memcache Servers with 8 GB Memory each. 9 bins per server
2 - Database Servers with 16GB each running MySQL 5.0.x

Traffic