Re: Single host configuration suggest

[Rick James]

Let's see the the queries that are "too slow". Also provide SHOW CREATE TABLE and EXPLAIN.

OK, it could be non-trivial to switch to InnoDB and change the code to handle deadlocks. But that is the ultimate solution.

If you have anything that can be "batched", do so. For example, if you are doing the same thing to two rows in the same table do them in a single statement, not two statements. Examples:

INSERT ... VALUES (...), (...)
UPDATE ... WHERE id ID (3,5)
SELECT ... WHERE id ID (3,5)
DELETE ... WHERE id ID (3,5)

These will lead to a single MySQL lock instead of two. And having a single round trip to the server helps. And InnoDB would benefit, too. (Especially if you sort the values in IN.)