Why is table-level locking better than row-level locking for large tables?

Viewed 31667

According to the MySQL manual:

For large tables, table locking is often better than row locking,

Why is this? I would presume that row-level locking is better because when you lock on a larger table, you're locking more data.

5 Answers
Related