I'm sure this has been asked before, but I cannot find solid evidence as to whether switching would provide us with any benefits.
We currently run MyIsam tables on 4.1.x and we are continuously processing 24 hours/day and using about 20 tables heavily. The process is generally doing Updates or Inserts depending on whether the row is available for updates, otherwise new rose is inserted and then updates until the next time bucket. It's always a different time bucket though, not always the same row being used. We found that running 3 processing threads seems to be around optimal (10 was too many, 1 was too little) for being able to process the maximum amount. Mysql runs at 100% pretty much constantly.
Now would InnoDB help in this situation? Would it allow us to increase the thread count to push more through in a shorter amount of time (because the tables wouldn't be locking)?
And if so, would it be enough to justify the extra space required for innodb?
Regards,
Travis
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
