MySQL :: Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock

New Topic

Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock

Posted by: Christine Antoine
Date: July 18, 2019 04:29AM

Olivier,

How can I force the index on a delete ?
I try to find the right syntax but it's not working...
I tried, the "FORCE" or the IGNORE INDEX(PRIMARY) but it fails..

This one is working :
DELETE t1 FROM cid_operation t1 FORCE INDEX (FK_CID_OPERATION_ENV_CASE)
JOIN cid_operation t2 USING (id_env_case)
WHERE (t2.id_env_case = 4448) AND (t2.id BETWEEN 15006449 AND 15007342)

But I'm really not sure of the impacts

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock

1948

Christine Antoine

July 17, 2019 08:30AM

Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock

414

Olivier Dasini

July 18, 2019 02:55AM

Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock

417

Christine Antoine

July 18, 2019 03:11AM

Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock

362

Olivier Dasini

July 18, 2019 03:52AM

Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock

423

Christine Antoine

July 18, 2019 04:01AM

Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock

382

Olivier Dasini

July 18, 2019 04:09AM

Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock

377

Christine Antoine

July 18, 2019 04:20AM

Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock

390

Olivier Dasini

July 18, 2019 04:28AM

Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock

367

Christine Antoine

July 18, 2019 04:29AM

Re: MySQL 5.7 : InnoDB. 2 Deletes query using index but... too many rows locked and cause deadlock

411

james wang

August 19, 2019 02:44AM

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.