Am 13.08.2018 um 12:22 schrieb Ling, Andy:
>> "The advantage of FLUSH TABLES table_name FOR EXPORT is that the table
>> is read locked until UNLOCK TABLES is executed" is not really true
>> because that's only valid for the running connection
>
> Surely not. If you've locked a table for read only nothing should be able to
> write to it from any connection otherwise what's the point of a
> multi-threaded server? Tests suggest otherwise.
surely YES
https://blogs.vmware.com/vsphere/2014/12/mysql-backup-with-vdp.html
"Another item to be aware of with this statement is that the read lock
is released as soon as the session that made the call ends. When the
pre-freeze-script finishes, the session is closed" - try it out
and how do you make a script that locks the table and continues without
closing the session to mysqld?
--
"I forgot to use reply all. Most lists, just reply works" - FOR THE SAKE
OF GOD reply just to the list, no reply all, no reply to from-address -
that's why proper mail clients have a reply-list button in case headers
in the mail exists which is true here and with your idiotic reply-all
you broke my reply-list button and that breaks threading now
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
