mysql locking and backups

Randall Hofland rhofland at fastdial.net
Thu May 4 17:26:12 EDT 2000


Since I have an avid interest in at least the MySQL, I vote YES! but again
question whether we can do more than just compare the 2 items suggested.
Might it not be worth some time to do a slightly broader comparison by
including the 3 or 4 major proprietary SQL servers as benchmarks so people
have a better idea why you might be willing to pay the BIG BUCKS for Oracle,
DB2, MS-SQL or such?

Niall Kavanagh wrote:

> Just to clarify the back scenario. If using mysqldump doesn't suit your
> needs, you lock the tables and then perform the file backup. Once the lock
> has been released the inserts will take effect.
>
> Again, you can work around it if you feel mysql is meeting you needs by
> using temporary tables while the lock is in place. A kludge, but it works.
>
> Chances are pretty good if you're using mysql in a production enviornment
> you value read access over write anyway. If that's not the case, us
> postgreSQL.
>
> Perhaps we should have a mysql/postgreSQL demostration sometime?
>
> --
> Niall Kavanagh, niall at kst.com
> News, articles, and resources for web professionals and developers:
> http://www.kst.com
>
> -
> Subcription/unsubscription/info requests: send e-mail with
> "subscribe", "unsubscribe", or "info" on the first line of the
> message body to discuss-request at blu.org (Subject line is ignored).

-
Subcription/unsubscription/info requests: send e-mail with
"subscribe", "unsubscribe", or "info" on the first line of the
message body to discuss-request at blu.org (Subject line is ignored).



More information about the Discuss mailing list