search

kellerkinderDE / shopware6-database-dump

Dump a Shopware 6 database for your local environments (and filter GDPR data)
MIT License
38 stars 11 forks source link

Whats about --single-transaction? #8

Closed sumedia-webdesign closed 10 months ago

kleinmann commented 10 months ago

Hi @sumedia-webdesign, I'm not sure I understand your question 🙂 Can you add some context?

sumedia-webdesign commented 10 months ago

Hi, sure.

I recently noticed that the database in MySQL seems to lock tables without --single-transaction. This disrupted the operation of the website. Maxcluster told me this. I still don't know why that is the case. Because I think the data synchronicity is gone anyway as soon as the file is saved. But no idea. That's why I ask.

Without --single-transaction it disrupts the operation of live databases.

kleinmann commented 10 months ago

Hi @sumedia-webdesign, since we're already using --single-transaction in this script, I'm still not sure what you're getting at 🙂 --single-transaction should correctly skip table locks as per the MySQL documentation.

sumedia-webdesign commented 10 months ago

Oh, then i must be redirected to an older code by google. But History say no. Maybe, i didn't see that.

kleinmann commented 10 months ago

No worries 🙂 I'll close the issue, then.