Re: Deadlock BLOB INSERT MySQL 8.0x InnoDB Cluster
Hi Volker,
Thank you for using MySQL InnoDB Cluster.
I just tied with exact the same files as you and I didn't experienced any issue:
MySQL 127.0.0.1:33060+ ssl sbtest SQL > INSERT INTO `onlineorder_attachments` (`AttachmentGUID`,`Filename`,`File`) VALUES ('00a2b54f-b0cf-4f3a-9bed-02dba853b506', 'M-02-012.jpg', LOAD_FILE('/var/lib/mysql-files/M-02-012.jpg'));
Query OK, 1 row affected (8.9896 sec)
I've the same values as the one you published.
Just for the test could you replace the PK with an auto_increment ?
Regards,
Subject
Views
Written By
Posted
1558
October 28, 2019 04:19AM
Re: Deadlock BLOB INSERT MySQL 8.0x InnoDB Cluster
1017
October 28, 2019 04:12PM
874
February 20, 2020 02:29PM
719
January 25, 2021 03:29AM
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.