I'll do that, thanks. (Sorry for the long response time, I was in
Dublin this past week...).
On Mon, Apr 21, 2008 at 3:16 PM, Wm Mussatto <[EMAIL PROTECTED]> wrote:
>
> On Mon, April 21, 2008 07:28, Waynn Lue wrote:
> > Is there any way to prevent UPDATEs on one database on one mysql
> > instan
On Mon, April 21, 2008 07:28, Waynn Lue wrote:
> Is there any way to prevent UPDATEs on one database on one mysql
> instance from affecting SELECTs on other databases in the same
> instance? I'm noticing a whole bunch of backed up connections on
> other databases when I run massive UPDATEs on one.
Hi Luke,
When mysql is doing a dump, do the updates that happen during the dump
get included in the dump.
I assume you mean 'mysqldump'.
I have a dump that starts at 11pm and goes for 2 hours. If someone
updates data at say 11:45pm, does that update get included in the dump?
When does the
Hi,
I think there is another usable method to backup databases in MySQL.
And that is using a slave server, (that can be running in the same
server),
and when backuping up the databases you do (in the slave):
STOP SLAVE; -- This will stop the replication
-- Now
Hi Luke,
Like most backup systems, there is no window unless you are locking the
table/database. If the record has been read and passed out to mysqldump,
any further updates will not be included until the next backup.
The only way to ensure you get complete referential integrity is to stop
any ap
[resending this with another mail user agent to bypass the spam filter]
Dear Andy,
I have this weird problem with 1 transaction locking out another for
no
apparent reason and in an inconsistent fashion. I'm using mysql
4.0.18
with innodb tables. The table in question has 2 primary keys: CID and
Dear Marko,
It does look like the result of a gap lock, but notice that I used both
primary keys in the where clause of my update query, therefore it should
only match (and update) 1 row. From my understanding (correct me if I'm
wrong, my knowledge of how mysql works is gleaned from the mysql docs
Is there a way to check that data on slave server is the same as data on
master ?
Thanks
From: Paul DuBois <[EMAIL PROTECTED]>
To: "Mike Mapsnac" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject: Re: updates on slave server??
Date: Mon, 26 Jan 2004 21:58:42 -0600
At 0:
The updates on the slave will not syncronize to the master if you have a one
direction master->slave relationship setup. It is possible however to setup
each server as a master and as a slave so that server 1 is the master for
server 2 and server 2 is the master for server 1. Then queries will
pr
At 0:49 + 1/27/04, Mike Mapsnac wrote:
Hello
I found today that some data on slave server
were different than on master server. I dont
know how that can happen. Slave server was
running, "show slave statu"s show no errors
If I make some updates on slave server. Does this updates will be r
Karl,
- Original Message -
From: ""karl "" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Sunday, July 14, 2002 7:41 AM
Subject: Updates
> Hello,
> This is similar to my post earlier...(I'm really racking my brains over
this).
> I'm going to try and rephrase (shorten) my q
11 matches
Mail list logo
