RE: Maximum row size - Serhat Gungor - com.mysql.lists.cluster

9 messages in com.mysql.lists.clusterRE: Maximum row size

From	Sent On	Attachments
Serhat Gungor	28 Jun 2005 05:37
Mikael Ronström	28 Jun 2005 06:17
Serhat Gungor	28 Jun 2005 07:35
pek...@mysql.com	28 Jun 2005 09:18
Jonathan Miller	28 Jun 2005 10:16
Hota, Chris G	28 Jun 2005 11:42
Hota, Chris G	28 Jun 2005 11:43
Walter Bertot	08 Jul 2005 12:56
Stewart Smith	11 Jul 2005 00:28

Subject:	RE: Maximum row size
From:	Serhat Gungor (gung...@itu.edu.tr)
Date:	06/28/2005 07:35:51 AM
List:	com.mysql.lists.cluster

When I change some columns to TEXT i get the following error.

#1005 - Can't create table './horde/#sql-429a_80.frm' (errno: 743)

It seems that it didn't work. Isn't there any way to use such tables with a large number of rows in mysql cluster?

Serhat

-----Original Message----- From: Mikael Ronström [mailto:mik...@mysql.com] Sent: 28 Haziran 2005 Salı 16:18 To: Serhat Gungor Cc: clus...@lists.mysql.com Subject: Re: Maximum row size

Hi,

2005-06-28 kl. 14.37 skrev Serhat Gungor:

Hi,

I am trying to change the type of my MyISAM tables to NDBCLUSTER table but i get the following error.

#1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8052. You have to change some columns to TEXT or BLOBs

I don't want to change my columns to TEXT or BLOB, Is there any way to increase maximum row size?

No, only waiting for future releases, 5.1 will increase it most likely to some extent.

Rgrds Mikael

Thanks

Serhat

Mikael Ronstrom, Senior Software Architect MySQL AB, www.mysql.com

Jumpstart your cluster: http://www.mysql.com/consulting/packaged/cluster.html