MySQL Forums
Forum List  »  MySQL Workbench

Mysql workbench Data Export lock table for a long time
Posted by: Pham Canh
Date: November 27, 2023 08:31PM

I utilized the Data Export functionality of MySQL Workbench, with the settings on Dump Structure Only, Export to Self-Contained File, and I did not select the option to Create Dump in Single Transaction. I left the Advanced Options at their default settings, meaning that I did not uncheck the 'skip lock table' option.

The Data Export occurred in about 10 seconds at around 9:15 AM, so the DB should have only been locked during this brief period. However, my database remained locked until 10:30 AM, which caused the PUT requests to be held up, rendering my system unavailable. After 10:30 AM, once the database released the lock, the system started to function normally again.

The issue cannot be reproduced on my staging system.

Options: ReplyQuote

Written By
Mysql workbench Data Export lock table for a long time
November 27, 2023 08:31PM

Sorry, only registered users may post in this forum.

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.