I thought I would post some more links about the InnoDB storage engine if anyone wants to read more.
Chances are if you are a small server then the delays caused by table locks are small and tolerable and you may not even notice. However, multi-user servers have probably noticed some performance degradation consistent with the situation I described in my post at the PEQ forum. If you have been scratching your head trying to figure it out, then I recommend you examine the InnoDB storage engine and decide if it may be right for you.
You do not need MySQL 5.0 to use the InnoDB engine, however MySQL 5.0 did enhance the engine so that it requires less resources from your system than MySQL 3, 4, or 4.1 does.
Enjoy the reads and please post your results and experiences.
http://www.databasejournal.com/featu...le.php/2248101
http://dev.mysql.com/tech-resources/...ne/part_3.html
http://www.innodb.com/howtouse.php
http://opensource.apress.com/article...er-than-innodb
http://www.mysqlperformanceblog.com/...hmarks-part-1/
http://www.innodb.com/bench.php
http://dev.mysql.com/doc/refman/5.0/en/innodb.html
http://dev.mysql.com/doc/refman/4.1/en/innodb.html
NOTE: You can easily find out if your MySQL server instance has your InnoDB storage engine enabled or not. Run the following query:
Code:
show variables like 'have_innodb';
If this query returns a value of "YES" then InnoDB is enabled. If it returns "NO" then you need to enable it by editing your "/etc/my.cnf" file under linux or "my.ini" file under windows and then restart your MySQL server. Please refer to the links I posted above on how to enable InnoDB.