When MySQL updates a table, it performs what is called a "lock" - it ensures that no other program can read or write from the table while it updates. As soon as MySQL has finished writing, it allows access again. So, it is best not to try to perform complicated SELECT statements (reads) on tables which are updated regularly, because your SELECT statement will stall.
Copyright 2012 Future Publishing Limited (company
registered number 2008885), a company registered
in England and Wales whose registered office is at