MySQL Forums
Forum List  »  Performance

Re: Single host configuration suggest
Posted by: Rick James
Date: November 29, 2015 12:20PM

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.)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Single host configuration suggest
691
November 29, 2015 12:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.