Christopher E. Brown wrote:
On Sat, 3 Nov 2007, bob b wrote:
So, a slave is down for 8hrs. It comes online and pulls the binlog in
120 seconds. The "seconds behind master" does not reflect 8hrs, but how
many seconds (at current processing rate) before the slave finishes the
relay logs.
Th
On Sat, 3 Nov 2007, bob b wrote:
Good to hear that you found the problem.
The only remaining puzzle is why the replica reported that it was up to date
when it was several binlogs behind.
Possibly the replica was always caught up with the last entry from the very
slow link.
Perhaps you shoul
On 04.11.2007 21:10 CE(S)T, Martijn Tonies wrote:
>> Now I have added this foreign key constraint:
>>
>> ALTER TABLE "user" ADD FOREIGN KEY ("AdditionalKeylist") REFERENCES
>> "keylist" ("KeylistId") ON DELETE SET NULL;
>
> This cannot work. The column in KEYLIST to which you are
> pointing should
Grant Peel wrote:
Hi all,
This is my first post to this list so bear with me if I ramble on a
bit. I have been reading as much as I can on this subject and am yet to
feel confident about an answer so I thought I would throw it at this
list and see what comes back.
One thing I should m
Hi Yves,
> I have a problem with my foreign keys. I have the following two tables:
>
> CREATE TABLE "keylist" (
> "KeylistId" INTEGER NOT NULL,
> "UserId" INTEGER NOT NULL,
> PRIMARY KEY (KeylistId, UserId));
>
> CREATE TABLE "user" (
> "UserId" INTEGER NOT NULL PRIMARY KEY,
>
This one time, at band camp, "Grant Peel" <[EMAIL PROTECTED]> wrote:
> What priveleges should I grant users at setup time?
Perhaps look at the GRANT option
GRANT SELECT, UPDATE, DELETE TO [EMAIL PROTECTED] IDENTIFIELD BY 'password';
you can use GRANT * or any combination of privileges you like.
Hi all,
This is my first post to this list so bear with me if I ramble on a bit.
I have been reading as much as I can on this subject and am yet to feel
confident about an answer so I thought I would throw it at this list and see
what comes back.
One thing I should mention up front is
