[MUD-Dev] Re: The total DBMS approach

[Hanz]

From: Derek Licciardi

> The serialized writes are due to page locking instead of row
> locking.  It theoretically can do multiple writes and reads as
> long as you're not trying to do it from the same database page.
> Since this is a very specific DB topic, I'd be glad to field your
> questions offline and provide suggestions on how to work within
> this limitation as page level locking is not specific to MySQL and
> probably not of great interest to this list. (It used to be
> standard in MS SQL Server 6.5 and earlier versions of Sybase SQL
> Server) All this said, I don't think you'll have a problem with
> MySQL given the user loads you are discussing.  MySQLs limitations
> only become visible with scale from my understanding of the
> DBMS.(cursory at best)

As of version 4.0, MySQL can use row-level locking, if you use the
InnoDB handler.  It also has support for transactions, meaning the
only major functionality missing is stored procedures and nested
select statements.

Rob


_______________________________________________
MUD-Dev mailing list
MUD-Dev at kanga.nu
https://www.kanga.nu/lists/listinfo/mud-dev