I read a book High Performance MySQL, she mentions:
performing one query per table uses table locks more efficiently: the queries
will lock the tables invididually and relatively briefly, instead of locking
them all for a longer time.
MyISAM puts a table lock, even when selectingsomething? can someone explain a little?
source
share