MySQL supports two different database engines: InnoDB and MyISAM.
What is the difference between this two database engines with respect to locking?
What are some of the other differences are there between the database engines?
Why/When would you choose to use the MyISAM engine versus the InnoDB engine?
You can read more about the engines in the MySQL help system but there are many other resources out there.