Entry

What is page level locking?

May 13th, 2000 02:14
Nathan Wallace, Tim Smith

You can think of a page as a chunk of records; how many records depends
on record size and how the underlying table handler works.  With the
table handler MySQL uses, typically a page is the same size as a
filesystem block.

Instead of locking the entire table, or locking just one record,
page-level locking means that one page is locked.  If another thread
wants to access a record that is in a locked page, it will have to
wait.  But two threads can be accessing records at the same time in the
same table, as long as the records are stored in different pages.