List:General Discussion« Previous MessageNext Message »
From:Baron Schwartz Date:July 4 2009 9:08pm
Subject:Re: Anyone using LVM for backing up?
View as plain text  
Hi Tim,

On Mon, Jun 22, 2009 at 4:41 PM, Little,
Timothy<tlittle@stripped> wrote:
> We have a 20 gig db (that includes the MYIs and MYDs and FRMs).
>
> We are wondering how long LVM snapshots take.. in that how long might
> the DB be read-locked?  Do we have to read-lock it and flush tables?
>
> Are we talking half a second, ten-seconds, 20 minutes?

It depends.  Long-running queries will block FLUSH TABLES WITH READ
LOCK, if you're using it, which will in turn block other queries.  So
FLUSH TABLES WITH READ LOCK itself can take a long time.  If you're
using only InnoDB tables you don't need to do that, you can just take
the snapshot and go.  Upon recovery on the other server you can find
the binlog position in InnoDB's messages to the error log.

There are a lot of subtleties to all of this, so maybe you can give a
few more details about your setup.
Thread
how to efficiently query for the next in MySQL Community Edition 5.1.34?Mike Spreitzer20 Jun
  • Re: how to efficiently query for the next in MySQL Community Edition5.1.34?Peter Brawley20 Jun
    • Re: how to efficiently query for the next in MySQL Community Edition 5.1.34?Johnny Withers20 Jun
    • Re: how to efficiently query for the next in MySQL Community Edition 5.1.34?Mike Spreitzer20 Jun
      • Re: how to efficiently query for the next in MySQL Community Edition5.1.34?Peter Brawley20 Jun
        • Re: how to efficiently query for the next in MySQL Community Edition 5.1.34?Mike Spreitzer20 Jun
          • Re: how to efficiently query for the next in MySQL Community Edition5.1.34?Peter Brawley20 Jun
            • Re: how to efficiently query for the next in MySQL Community Edition 5.1.34?Mike Spreitzer21 Jun
              • Re: how to efficiently query for the next in MySQL Community Edition5.1.34?Peter Brawley21 Jun
                • Re: how to efficiently query for the next in MySQL Community Edition 5.1.34?Mike Spreitzer21 Jun
        • Anyone using LVM for backing up?Timothy Little22 Jun
          • Re: Anyone using LVM for backing up?Thomas A. McGonagle22 Jun
          • Re: Anyone using LVM for backing up?Jim Lyons23 Jun
          • Re: Anyone using LVM for backing up?David Sparks23 Jun
          • Re: Anyone using LVM for backing up?Baron Schwartz4 Jul