MySQL Forums
Forum List  »  InnoDB

Re: Mysql hangs once in 2 days with mysterious deadlock?
Posted by: Rick James
Date: October 05, 2014 04:52PM

> Have lots of partitions in big tables.

How many partitions on how many tables?

SHOW VARIABLES LIKE 'innodb_file_per_table';
SHOW VARIABLES LIKE '%open%';

> I do not use transactions - only single line queries (select or update or insert).

If you are using InnoDB, you are using transactions, albeit implicit ones.

SHOW VARIABLES LIKE 'autocommit';

SELECTs and UPDATEs can take a long time -- other connections can collide with them.

Options: ReplyQuote




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.