MySQL Forums
Forum List  »  PHP

Re: Mysql 5.7.20 Innodb Delete query very slow randomly on CentOS 7.x
Posted by: Peter Brawley
Date: December 19, 2017 05:20PM

> Its not multiple-query

OK, it's not that.

On your account it occurs only when this delete query is one of several queries executed in succession from a PDO connection. Have you shown the slowness is specific to this table? Have you tried the same query sequence in the mysql client program, or with another client eg PHP/mysqli or Python?

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.