It might be due to the limitation of Datamemory and the max size of a record
column. The max size of a record colum is 8K while a text column is 16K.
DVP
----
Dathan Vance Pattishall http://www.friendster.com
> -----Original Message-----
> From: Brian L [mailto:tiger1763@stripped]
> Sent: Wednesday, December 01, 2004 8:31 PM
> To: cluster@stripped
> Subject: Encounter problem to insert "text" field data into
> the cluster table
>
> Hi,
>
> I installed the cluster 4.1.7 version and running in the
> following configuration :
> machine a :
> 1 ndb_mgmd
> 1 ndbd
> 1 mysqld
> machine b:
> 1 ndbd
> 1 mysqld
>
> and the config.ini is as follows :
>
> [ndbd default]
> NoOfReplicas= 2
> MaxNoOfOrderedIndexes=1000
> DataMemory=1024M
> IndexMemory=512M
>
> [mysqld default]
> [ndb_mgmd default]
> [tcp default]
>
> [ndbd]
> HostName= a
> DataDir: /var/lib/mysql-cluster/
>
> [ndbd]
> HostName= b
> DataDir: /var/lib/mysql-cluster/
>
> [ndb_mgmd]
> HostName= a
>
> [mysqld]
> [mysqld]
> [mysqld]
>
> It ran pretty soomthly for a normal data. I created 14 tables
> in the database and migrated the existing data from the
> current single node mysql into this cluster.
> And I found out that one of the tables in which the structure
> as follows having problem for me to insert the data on the text field:
>
> CREATE TABLE `enquiry_temp` (
> `E_ID` int(11) unsigned NOT NULL auto_increment,
> `E_SUBJECT` varchar(200) NOT NULL default '',
> `E_FROM_DEPT` int(11) NOT NULL default '0',
> `E_TO_DEPT` int(11) NOT NULL default '0',
> `E_ENTRY_TS` timestamp NOT NULL default CURRENT_TIMESTAMP
> on update CURRENT_TIMESTAMP,
> `E_MESSAGE` text NOT NULL,
> `M_ID` varchar(20) NOT NULL default '',
> `E_READF` tinyint(1) NOT NULL default '0',
> PRIMARY KEY (`ENQ_ID`)
> ) ENGINE=ndbcluster DEFAULT CHARSET=utf8;
>
> INSERT INTO `enquiry_temp`
> (`ENQ_ID`,`E_SUBJECT`,`E_FROM_DEPT`,`E_TO_DEPT`,`E_ENTRY_TS`,`
> E_MESSAGE`,`M_ID`,`ENQ_READF`)
> VALUES
> (254,'Enquiry','CEDD','CSB','2004-09-01 07:51:00', 'Dear
> Sirs,\n\nI\'ve sent you an enquiry yesterday on the
> requirement of reporting of private investment.\n\nPlease
> send your reply to me at the following email
> address:\n\ncfchow1962@stripped\n\nThanks.',
> 'cfchow',1);
>
> The mysql prompt just hang and no responsed at all I found
> out that if I inserted this record into the single node
> mysql, there is no problem. And also if the E_Message field
> is varchar(255), there is no problem to insert into this
> cluster table.
>
> I wonder if there is issues on inserting data into the "text"
> or "mediumtext" datatype in mysql clustering.
> Hope someone can help me.
>
> Regards
>
>
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Read only the mail you want - Yahoo! Mail SpamGuard.
> http://promotions.yahoo.com/new_mail
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:
> http://lists.mysql.com/cluster?unsub=1
>
