1 waltercruz Mar 03, 2005 16:03
3 waltercruz Mar 03, 2005 19:25
from the MYSQL website;
http://www.innodb.com/howtouse.php :
# InnoDB tables are transactional: they provide rollback and commit capabilities.
# InnoDB is the only table type in MySQL which supports foreign key constraints.
# InnoDB tables are fast, even faster than MyISAM tables in many simple benchmarks. See the benchmark page.
# InnoDB tables have row level locking: they allow higher concurrency than MyISAM tables which use table level locking, or BDB tables, which use page level locking. High concurrency is reflected in high multiuser performance.
My question is: will b2evo in the future use some os the caracteristics of InnoDb ? (CONSTRAINTS) ? innodb is really fast than myisam tables? (well.. I don?t trust 100% in the innodb tests)
It?s just this! :-/
4 tor Mar 08, 2005 20:48
It's "supported" today - just change your index using phpmyadmin or similar tools. I saw little or no advantages speedwise.
Tor
5 fplanque Mar 09, 2005 13:12
MyISAM tables are a low end toy. The only reason we support MyISAM is because many low cost hosts do not support InnoDB.
InnoDB is what makes MySQL something serious you can consider for professional usage. InnoDB allows for constraints, transactions and guarantees data integrity. Not using InnoDB for large size multiuser blogs/applications would be a joke.
All current developments are done with InnoDB in mind, but we'll still support the low end MyISAM.
I don't know anything about InnoDB, but if there were advantages/disadvantages to using it, don't you think those would be global and not application specific?