Mysql workbench Data Export lock table for a long time

[Pham Canh]

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.