different size under the two OS

Hello DBAs,

Though this is not exactly a mysql problem, but I think this list may
be helpful for my question.

I have dumped a mysql data file, and scp it to another host.
The current host is ubuntu-8.04, the remote host is ubuntu-9.10.
As you can see below:

The current host:

$ md5sum fcm.0812.sql.gz
ea08ec505c1b1724213538fed7483975 fcm.0812.sql.gz
$ lsb_release -r
Release: 8.04
$ du -k fcm.0812.sql.gz
418080 fcm.0812.sql.gz

The remote host:

$ md5sum fcm.0812.sql.gz
ea08ec505c1b1724213538fed7483975 fcm.0812.sql.gz
$ lsb_release -r
Release: 9.10
$ du -k fcm.0812.sql.gz
417672 fcm.0812.sql.gz


Though the files in two hosts have the same md5sum, but why they have
different size with 'du -k' showed?

Thanks.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: different size under the two OS

--0016363b82ee9cf87c04aa459a67
Content-Type: text/plain; charset=ISO-8859-1

du reports how much space the file takes on the disk. This # depends on the
block size of each file system.

On Aug 11, 2011 9:13 PM, "Feng He" wrote:

Hello DBAs,

Though this is not exactly a mysql problem, but I think this list may
be helpful for my question.

I have dumped a mysql data file, and scp it to another host.
The current host is ubuntu-8.04, the remote host is ubuntu-9.10.
As you can see below:

The current host:

$ md5sum fcm.0812.sql.gz
ea08ec505c1b1724213538fed7483975 fcm.0812.sql.gz
$ lsb_release -r
Release: 8.04
$ du -k fcm.0812.sql.gz
418080 fcm.0812.sql.gz

The remote host:

$ md5sum fcm.0812.sql.gz
ea08ec505c1b1724213538fed7483975 fcm.0812.sql.gz
$ lsb_release -r
Release: 9.10
$ du -k fcm.0812.sql.gz
417672 fcm.0812.sql.gz


Though the files in two hosts have the same md5sum, but why they have
different size with 'du -k' showed?

Thanks.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=johnny@pixelated.net

--0016363b82ee9cf87c04aa459a67--