List:Cluster« Previous MessageNext Message »
From:shrey.chen Date:April 19 2013 2:20am
Subject:is there anyway to auto_extend a datafile?
View as plain text  
hi,

     i am a newbie of mysql cluster.
     i set up a cluter from "mysql-cluster-gpl-7.2.10-debian6.0-x86_64.deb"

     here is the problem when i tested the 'disk data table'.
     i dump a database named 'news' from my standard sqlserver,it only contained one table named 'news_cr_news' and its size is 2.4G
         -rw-rw---- 1 mysql mysql 2.4G 2011-02-26 news_cr_news.MYD.
     so i create a tablespace that contained two datafiles,one's size is 1G,the other 2G, and i thought that was enough.
     when i loaded data into the cluster, i got an error as follow:
ERROR 1114 (HY000): The table 'news_cr_news' is full
mysql> show warnings;
+---------+------+--------------------------------------------------------+
| Level   | Code | Message                                                |
+---------+------+--------------------------------------------------------+
| Warning | 1296 | Got error 1601 'Out extents, tablespace full' from NDB |
| Error   | 1114 | The table 'news_cr_news' is full                       |
+---------+------+--------------------------------------------------------+
2 rows in set (0.00 sec)

and the informations of files are:

mysql> select FILE_NAME,INITIAL_SIZE,TABLESPACE_NAME,FREE_EXTENTS,TOTAL_EXTENTS,MAXIMUM_SIZE from FILES;
+---------------------+--------------+-----------------+--------------+---------------+--------------+
| FILE_NAME           | INITIAL_SIZE | TABLESPACE_NAME | FREE_EXTENTS | TOTAL_EXTENTS | MAXIMUM_SIZE |
+---------------------+--------------+-----------------+--------------+---------------+--------------+
| diskdata/news_2.dat |   2147483648 | news_ts         |            0 |          2048 |   2147483648 |
| diskdata/news_2.dat |   2147483648 | news_ts         |            0 |          2048 |   2147483648 |
| diskdata/news_1.dat |   1073741824 | news_ts         |            0 |          1024 |   1073741824 |
| diskdata/news_1.dat |   1073741824 | news_ts         |            0 |          1024 |   1073741824 |
| NULL                |         NULL | news_ts         |         NULL |          NULL |         NULL |
| undologs/news_1.log |    134217728 | NULL            |         NULL |      33554432 |    134217728 |
| undologs/news_1.log |    134217728 | NULL            |         NULL |      33554432 |    134217728 |
| NULL                |         NULL | NULL            |     33505296 |          NULL |         NULL |
+---------------------+--------------+-----------------+--------------+---------------+--------------+
8 rows in set (0.01 sec)

here i found a column named 'AUTOEXTEND_SIZE',
so, Is there a way to auto_extend a datafile from the initial size ?
Thread
is there anyway to auto_extend a datafile?shrey.chen19 Apr
  • Re: is there anyway to auto_extend a datafile?Stewart Smith19 Apr