How to prevent locking and possible performance issue
Don't use MyISAM; use InnoDB.  (to avoid "table locks")
Build and maintain Summary tables.  (often 10x faster)
Let's see the slow queries; maybe they can be improved.