tag:blogger.com,1999:blog-14455177.post114010261032521423..comments2024-03-07T18:57:25.977+01:00Comments on Mikael Ronstrom: How to define a table that uses disk data in MySQL ClusterMikael Ronstromhttp://www.blogger.com/profile/07134215866292829917noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-14455177.post-7579115260153847282017-01-12T07:41:58.786+01:002017-01-12T07:41:58.786+01:00I am running 5.6.31-ndb-7.4.12-cluster-gpl-log.
B...I am running 5.6.31-ndb-7.4.12-cluster-gpl-log.<br /><br />But even after converting table to disk I am receiving table full error.<br /><br />I don't know how to check and fix this issue.<br />Ali Razahttps://www.blogger.com/profile/03940005135062311348noreply@blogger.comtag:blogger.com,1999:blog-14455177.post-20571226614081414922017-01-12T07:38:20.285+01:002017-01-12T07:38:20.285+01:00thanks Mikael for the positive response.
Can you ...thanks Mikael for the positive response.<br /><br />Can you plz share complete process to convert/create on disk table and verify it.Ali Razahttps://www.blogger.com/profile/03940005135062311348noreply@blogger.comtag:blogger.com,1999:blog-14455177.post-87634343115016317732016-11-14T10:21:14.334+01:002016-11-14T10:21:14.334+01:00/*!50100 ... */
This means that the section will b.../*!50100 ... */<br />This means that the section will be used if MySQL version is above<br />5.1.0. So if you try to restore this table in 5.0 or older version the<br />tablespace part will not be used since the 5.0 version of MySQL Cluster<br />didn't support table on disk.<br /><br />So for all practical matters nowadays it simply means that the<br />TABLESPACE ts_1 DISK is there since I assume you are not running<br />on such old versions as 5.0.Mikael Ronstromhttps://www.blogger.com/profile/07134215866292829917noreply@blogger.comtag:blogger.com,1999:blog-14455177.post-20344473998598073152016-11-14T08:47:50.906+01:002016-11-14T08:47:50.906+01:00I created table with following command on ndb
CRE...I created table with following command on ndb<br /> CREATE TABLE table_1 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, a VARCHAR(50) NOT NULL, b DATE NOT NULL ) TABLESPACE ts_1 STORAGE DISK ENGINE NDBCLUSTER;<br />Query OK, 0 rows affected (3.90 sec)<br /><br />new if I check the table create command it show as follows<br /><br />CREATE TABLE `table_1` (<br /> `id` int(10) unsigned NOT NULL AUTO_INCREMENT,<br /> `a` varchar(50) NOT NULL,<br /> `b` date NOT NULL,<br /> PRIMARY KEY (`id`)<br />) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 <br /><br />kindly let me know what does "/*!50100 TABLESPACE ts_1 STORAGE DISK */" means.<br />and how I can check wich table is stored on the disk.<br /><br />Best Regards,<br />Ali Raza<br />Ali Razahttps://www.blogger.com/profile/03940005135062311348noreply@blogger.comtag:blogger.com,1999:blog-14455177.post-1141501130667293422006-03-04T20:38:00.000+01:002006-03-04T20:38:00.000+01:00Looks like there is some bug around this withTEXT ...Looks like there is some bug around this with<BR/>TEXT columns.Mikael Ronstromhttps://www.blogger.com/profile/07134215866292829917noreply@blogger.comtag:blogger.com,1999:blog-14455177.post-1141469818581077872006-03-04T11:56:00.000+01:002006-03-04T11:56:00.000+01:00Hi Mikael,I just tried out this new feature but i ...Hi Mikael,<BR/><BR/>I just tried out this new feature but i am wondering why some columns are still stored in memory (even tough they are not part of the index)<BR/><BR/>I asked my question here: http://www.mysqltalk.org/question-about-tablespace-fields-on-disk-with-517-vt190493.html<BR/><BR/>Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14455177.post-1140442252254869262006-02-20T14:30:00.000+01:002006-02-20T14:30:00.000+01:00From version 5.1.6.Rgrds MikaelFrom version 5.1.6.<BR/><BR/>Rgrds MikaelMikael Ronstromhttps://www.blogger.com/profile/07134215866292829917noreply@blogger.comtag:blogger.com,1999:blog-14455177.post-1140431070188027112006-02-20T11:24:00.000+01:002006-02-20T11:24:00.000+01:00From which version on is this supposed to work ?From which version on is this supposed to work ?Anonymousnoreply@blogger.com