Today reading about MySQL Table Locking Issues. Of particular interest were the HIGH_PRIORITY and SQL_BUFFER_RESULT SELECT Statement options.