Hello.
Very often InnoDB provides a better performance in
environment where a lot of concurrent SELECTs and
UPDATEs. Check if the problem still exists if you change
the engine of you tables from MyISAM to InnoDB.
M.E. Koch wrote:
Hello:
After haveing a look at the `show
Hello:
After haveing a look at the `show processlist`
I realized that querys will be locked if there
is an update or insert statement otherwise
the `STATUS` is as regular copying to temp,
sorting etc. So that not all querys will be
locked automatically. (But when checking there
where lots of