ransactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
- Original Message -
From: "Nils Valentin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "P Srinivasulu" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; &
> > The advantage of other methods is that you avoid all sorts of nasty
> > locking on various parts of your database. The advantage of
> the Hot Copy
> > product that Innobase Oy sell is that it doesn't place any
> locks on your
> > InnoDB table space when it runs.
>
> Wouldn't that break the A
2003年 8月 28日 木曜日 01:43、Nils Valentin さんは書きました:
> Hi Chris,
>
> 2003年 8月 28日 木曜日 00:54、Chris Nolan さんは書きました:
> > A very good question! One which I will attempt to provide a half-decent
> > answer for.
> >
> > Trying to execute a transaction that involves grabbing massive amounts of
> > data from var
Hi Chris,
2003年 8月 28日 木曜日 00:54、Chris Nolan さんは書きました:
> A very good question! One which I will attempt to provide a half-decent
> answer for.
>
> Trying to execute a transaction that involves grabbing massive amounts of
> data from various tables while still allowing updates to be committed can
>
Hi Chris,
2003年 8月 28日 木曜日 00:54、Chris Nolan さんは書きました:
> A very good question! One which I will attempt to provide a half-decent
> answer for.
>
> Trying to execute a transaction that involves grabbing massive amounts of
> data from various tables while still allowing updates to be committed can
Hi All,
my $0.0.2... anybody correct me please if you know it better...;-)
2003年 8月 27日 水曜日 23:22、P Srinivasulu さんは書きました:
> If the backup solutions are there already, why is that a future
> requirement for Mysql?
>
> Thanks,
> Srinivasulu.
>
> >>> Chris Nolan <[EMAIL PROTECTED]> 8/27/2003 6:41:2
A very good question! One which I will attempt to provide a half-decent
answer for.
Trying to execute a transaction that involves grabbing massive amounts of
data from various tables while still allowing updates to be committed can
be tricky. At best, this means performance problems. Please don't
If the backup solutions are there already, why is that a future
requirement for Mysql?
Thanks,
Srinivasulu.
>>> Chris Nolan <[EMAIL PROTECTED]> 8/27/2003 6:41:27 PM >>>
Hi!
You can currently do this with InnoDB with mysqldump (look at the
--single-transaction switch). I use it for backing up
Hi!
You can currently do this with InnoDB with mysqldump (look at the
--single-transaction switch). I use it for backing up a 12 GB mail
database without problems.
Regards,
Chris
P.S. Keep up the great work over there at Novell! Tell us where to send
the expensive bottles of alcohol for when
