Received: by 10.100.81.11 with SMTP id e11mr1147161anb.43.1314383331854;
        Fri, 26 Aug 2011 11:28:51 -0700 (PDT)
X-BeenThere: maatkit-discuss@googlegroups.com
Received: by 10.90.116.9 with SMTP id o9ls8564947agc.3.gmail; Fri, 26 Aug 2011
 11:28:50 -0700 (PDT)
Received: by 10.236.187.1 with SMTP id x1mr6345733yhm.8.1314383330095;
        Fri, 26 Aug 2011 11:28:50 -0700 (PDT)
Received: by 10.236.187.1 with SMTP id x1mr6345732yhm.8.1314383330085;
        Fri, 26 Aug 2011 11:28:50 -0700 (PDT)
Return-Path: <baron.schwa...@gmail.com>
Received: from mail-yi0-f41.google.com (mail-yi0-f41.google.com [209.85.218.41])
        by gmr-mx.google.com with ESMTPS id p20si1365443yhe.5.2011.08.26.11.28.49
        (version=TLSv1/SSLv3 cipher=OTHER);
        Fri, 26 Aug 2011 11:28:49 -0700 (PDT)
Received-SPF: pass (google.com: domain of baron.schwa...@gmail.com designates 209.85.218.41 as permitted sender) client-ip=209.85.218.41;
Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of baron.schwa...@gmail.com designates 209.85.218.41 as permitted sender) smtp.mail=baron.schwa...@gmail.com; dkim=pass (test mode) header...@gmail.com
Received: by mail-yi0-f41.google.com with SMTP id 2so1938901yib.0
        for <maatkit-discuss@googlegroups.com>; Fri, 26 Aug 2011 11:28:49 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=mime-version:sender:in-reply-to:references:date
         :x-google-sender-auth:message-id:subject:from:to:content-type
         :content-transfer-encoding;
        bh=gC4KFpgz9BLPW/kMERAVx6a2H88+dun92tiSpb7XWDg=;
        b=fVe6mcGuY8cae8S1h+CXc8TOaz2cYX51q0C2wXGwpYstT4igAxTZLk0tvVnXrOiX2a
         7xMOWGvWIBY0uV9dgmAGUvt8NCfYGdjcEdsD6bMbj53/jfSW2266W15i3OcngnOwZnfL
         tGTXmgweZzxdfTu0ZYI5H0W/ZIxD9a4ckiRWM=
MIME-Version: 1.0
Received: by 10.42.144.193 with SMTP id c1mr1284414icv.516.1314383328904; Fri,
 26 Aug 2011 11:28:48 -0700 (PDT)
Sender: baron.schwa...@gmail.com
Received: by 10.42.140.201 with HTTP; Fri, 26 Aug 2011 11:28:48 -0700 (PDT)
In-Reply-To: <CAGDOe_JzZf9svrPD0Bca9j87-8EXwa3nZsR1toYtNMWsSLN...@mail.gmail.com>
References: <CAGDOe_JzZf9svrPD0Bca9j87-8EXwa3nZsR1toYtNMWsSLN...@mail.gmail.com>
Date: Fri, 26 Aug 2011 14:28:48 -0400
Message-ID: <CADPxqFb2eWqFudeCPjp+ZDhLSrOPpQBFw_oNwwTJwq3v0bJ...@mail.gmail.com>
Subject: Re: [maatkit-discuss] Crc issue
From: Baron Schwartz <ba...@xaprb.com>
To: maatkit-discuss@googlegroups.com
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

SKB,

It's because there is some data difference in the tables.

- Baron

On Fri, Aug 26, 2011 at 10:58 AM, Santhi kishore Balusu
<kishorechowd...@gmail.com> wrote:
> Hello Everybody.
> I am trying to compare master & slave using mk-table-checksum.
> When i use=A0--no-crc --count i have no issues but when i remove them i s=
ee
> there is some difference in the tables.
> Slave server is setup using the dump created from mysqldump & nobody is
> writing to the slave & it is in read_only mode.
> Master version is 5.1 & slave version is 5.5.
> Why am i getting a difference when i do a crc check.
> Thanks & regards
> SKB



--=20
Baron Schwartz
Percona Inc <http://www.percona.com/>
Consulting, Training, Support & Services for MySQL