Re[2]: Diffrences in table types - Jacques Jocelyn - com.mysql.lists.mysql

8 messages in com.mysql.lists.mysqlRe[2]: Diffrences in table types

From	Sent On	Attachments
GH	09 Oct 2004 17:28
John McCaskey	09 Oct 2004 19:15
GH	09 Oct 2004 22:53
John McCaskey	09 Oct 2004 23:38
Jacques Jocelyn	10 Oct 2004 01:51
John McCaskey	11 Oct 2004 09:22
Benjamin Arai	11 Oct 2004 09:48
John McCaskey	11 Oct 2004 09:59

Subject:	Re[2]: Diffrences in table types
From:	Jacques Jocelyn (ml-m...@salaireonline.com)
Date:	10/10/2004 01:51:01 AM
List:	com.mysql.lists.mysql

Hello John,

Interesting post, quite useful, Question about performance with InnoDB ? say you have a hosting server with 256 Mb of ram, would you know if that will make a difference if the major database is converted from MyIsam to InnoDb ?

Although, InnoDB is not a requirement, just luxury, but I would love to enjoy foreign keys and transactions

Please advise, Thanks

Sunday, October 10, 2004, 8:39:15 AM, you wrote:

JM> I meant 'No transaction support', which is you can't use JM> begin work; ... ; commit; etc to perform transactions, each query JM> takes effect immeiately and is visible to all other JM> threads/clients immediately. ...

JM> Concurrency refers to multiple seperate connections (threads) JM> trying to read/write to/from the same table at the same time. JM> Imagine you have 100 different connections to the database all JM> trying to write to the same table. With MyISAM each one will lock JM> the entire table, and only one will execute at a time, making it JM> very slow. In InnoDB each one will only lock the rows it is JM> modifying and they can all execute at once (if they are not JM> modifying the same rows), and it will be very fast.