6 messages in com.mysql.lists.clusterRe: upgraded from 5.0 to 5.1 but data...
FromSent OnAttachments
Paul Maunders11 Sep 2006 06:41 
Anatoly Pidruchny11 Sep 2006 06:53 
Paul Maunders11 Sep 2006 07:20 
Mikael Ronström11 Sep 2006 07:24 
Anatoly Pidruchny11 Sep 2006 08:00 
Paul Maunders11 Sep 2006 08:20 
Subject:Re: upgraded from 5.0 to 5.1 but database size the same
From:Paul Maunders (pa@fubra.com)
Date:09/11/2006 07:20:51 AM
List:com.mysql.lists.cluster

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

By database size I mean the data_length from SHOW TABLE STATUS.

I'm not familiar with the DUMP 1000 command, can you please explain to me what it does?

Here is the output of SHOW TABLE STATUS for one of the tables, as you can see there average row length is 800. This is approximately 3 times the size that each row took up when we were running with MyISAM tables.

*************************** 3. row *************************** Name: user Engine: NDBCLUSTER Version: 10 Row_format: Dynamic Rows: 1421973 Avg_row_length: 800 Data_length: 1294336000 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 1421986 Create_time: NULL Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: number_of_replicas: 2

Regards,

Paul

Anatoly Pidruchny wrote:

Paul,

what do you call the "database size"? Is this the amount of the virtual memory taken up by the ndbd processes? Do you know about the "DUMP 1000" command? Just checking.

Regards, Anatoly. Hi,

I have just upgraded our deployment of MySQL cluster from 5.0 to 5.1 - I did a backup, deleted 5.0, installed 5.1 and then ran ndb_restore to get all the data back.

A lot of the space in the various tables was previously taken up by VARCHARS so I expected the 5.1 version of the database to be significantly smaller, however after restoring the data, it seems that the overall database size has remained the same.

Is this because I restored a backup of a 5.0 database and it somehow maintained the varchar "padding"?

Does anyone know of anyway that I can get MySQL to rebuild the tables so that VARCHARS are stored correctly?

Regards,

ClamAV 0.88.4/1845/Sun Sep 10 20:08:12 2006

- --

Paul Maunders

Operations Director Fubra Limited

web | www.fubra.com email | pa@fubra.com voip | sip://20@asterisk.fubra.it direct | +44 (0)1252 367 202 phone | +44 (0)1252 367 222 fax | +44 (0)1252 367 229

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Fubra Ltd. Finally, the recipient should check this email and any attachments for the presence of viruses. Fubra Ltd accepts no liability for any damage caused by any virus transmitted by this email. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD4DBQFFBXDasYtjtAM5Dp4RAoZwAJ9otoa7sRp4KqwqXdI/ofQUxUVxQwCYkPO+ Fn0rSTFK5XjtlkIl3BNaXg== =3S3V -----END PGP SIGNATURE-----