table locking

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
kryles
Forum Contributor
Posts: 114
Joined: Fri Feb 01, 2008 7:52 am

table locking

Post by kryles »

I expect this to be a rather large answer, but maybe someone can point me in the right direction (instead of blindly googling).

Eventually I want to go from Access2000 -> VB/MySql

In access there are table locks, so I'd like to know how MySql locks tables, and in what scenarios it does so.

My problem would be that a few people would be querying off the same tables, maybe even the same records so I'd like to know how to handle this before we migrate.

Any link to a good read, or any little tid bits people could offer would be much appreciated.

Thanks
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Re: table locking

Post by pickle »

MyISAM (the MySQL default) has row level locking, which means no two queries can write to the same row at the same time. If you want table-wide locking, use InnoDB.

The MySQL website docs are helpful - do a search there for table locking.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
Post Reply