Could somebody tell me how to dynamic extend my ndb data storage file.

[Moon's Father]

Something happend to me when my table's data is much bigger on today's
morning.

mysql> alter table t11 tablespace ts_1 storage disk;
ERROR 1114 (HY000): The table '#sql-3f0d_14cf' is full

Then I have to add a new tablespace data file to make me satisfied.
Anybody can tell me if you have another way to dynamic extend the size of
the tablespace.

Any reply is appreciated.

[Jason Brooke-2]

doesn't the manual mention it's not possible to dynamically size it at
this time? thought I recalled seeing that



Moon's Father wrote:

> Something happend to me when my table's data is much bigger on today's
> morning.
>
> mysql> alter table t11 tablespace ts_1 storage disk;
> ERROR 1114 (HY000): The table '#sql-3f0d_14cf' is full
>
> Then I have to add a new tablespace data file to make me satisfied.
> Anybody can tell me if you have another way to dynamic extend the size of
> the tablespace.
>
> Any reply is appreciated.
>

--
MySQL Cluster Mailing List
For list archives: http://lists.mysql.com/cluster
To unsubscribe:    http://lists.mysql.com/cluster?unsub=lists@...

[Stewart Smith]

On Tue, 2007-12-18 at 12:46 +1000, Jason Brooke wrote:
> doesn't the manual mention it's not possible to dynamically size it at
> this time? thought I recalled seeing that

correct. not currently dynamic. Just need to add more data files to the
tablespace if that's what you run out of.

--
Stewart Smith, Senior Software Engineer (MySQL Cluster)
MySQL AB, www.mysql.com
Office: [phone] Ext: 6616
VoIP: 6616@...
Mobile: [phone]

[Jake Conk]

The only way you can make this dynamic is if you have a script
periodically reading your information schema to see if its almost full
and if it is then add another tablespace to it. I'm not sure I have
the right algorithm for figuring out the amount of space but maybe
someone else here can post it up because I think mine is wrong hehe.

- Jake

On Dec 17, 2007 6:39 PM, Moon's Father <yueliangdao0608@...> wrote:

> Something happend to me when my table's data is much bigger on today's
> morning.
>
> mysql> alter table t11 tablespace ts_1 storage disk;
> ERROR 1114 (HY000): The table '#sql-3f0d_14cf' is full
>
> Then I have to add a new tablespace data file to make me satisfied.
> Anybody can tell me if you have another way to dynamic extend the size of
> the tablespace.
>
> Any reply is appreciated.
>

--
MySQL Cluster Mailing List
For list archives: http://lists.mysql.com/cluster
To unsubscribe:    http://lists.mysql.com/cluster?unsub=lists@...

[Moon's Father]

Thanks for your reply.

On Wed, Jan 23, 2008 at 5:22 AM, Jake Conk <jake.conk@...> wrote:

> The only way you can make this dynamic is if you have a script
> periodically reading your information schema to see if its almost full
> and if it is then add another tablespace to it. I'm not sure I have
> the right algorithm for figuring out the amount of space but maybe
> someone else here can post it up because I think mine is wrong hehe.
>
> - Jake
>
> On Dec 17, 2007 6:39 PM, Moon's Father <yueliangdao0608@...> wrote:
> > Something happend to me when my table's data is much bigger on today's
> > morning.
> >
> > mysql> alter table t11 tablespace ts_1 storage disk;
> > ERROR 1114 (HY000): The table '#sql-3f0d_14cf' is full
> >
> > Then I have to add a new tablespace data file to make me satisfied.
> > Anybody can tell me if you have another way to dynamic extend the size of
> > the tablespace.
> >
> > Any reply is appreciated.
> >
>

--
I'm a mysql DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn

[Jonathan Miller]

But never fear, the team is currently working on making this automatic
in the code and will be released in a future version.

Moon's Father wrote:

> Thanks for your reply.
>
> On Wed, Jan 23, 2008 at 5:22 AM, Jake Conk <jake.conk@...> wrote:
>
>> The only way you can make this dynamic is if you have a script
>> periodically reading your information schema to see if its almost full
>> and if it is then add another tablespace to it. I'm not sure I have
>> the right algorithm for figuring out the amount of space but maybe
>> someone else here can post it up because I think mine is wrong hehe.
>>
>> - Jake
>>
>> On Dec 17, 2007 6:39 PM, Moon's Father <yueliangdao0608@...> wrote:
>>> Something happend to me when my table's data is much bigger on today's
>>> morning.
>>>
>>> mysql> alter table t11 tablespace ts_1 storage disk;
>>> ERROR 1114 (HY000): The table '#sql-3f0d_14cf' is full
>>>
>>> Then I have to add a new tablespace data file to make me satisfied.
>>> Anybody can tell me if you have another way to dynamic extend the size of
>>> the tablespace.
>>>
>>> Any reply is appreciated.
>>>
>
>
>

--
Best wishes,
/Jeb

Jonathan Miller
Cluster Lead QA Developer
Certified Cluster Database Administrator
Sun Microsystems / MySQL
Austin, Texas US
www.mysql.com
www.sun.com

I'm Certified, are you?
http://www.mysql.com/certification/index.html



--
MySQL Cluster Mailing List
For list archives: http://lists.mysql.com/cluster
To unsubscribe:    http://lists.mysql.com/cluster?unsub=lists@...

[Moon's Father]

Exciting news.

On Tue, May 27, 2008 at 7:46 PM, Jonathan Miller <jmiller@...> wrote:

> But never fear, the team is currently working on making this automatic in
> the code and will be released in a future version.
>
>
> Moon's Father wrote:
>
>> Thanks for your reply.
>>
>> On Wed, Jan 23, 2008 at 5:22 AM, Jake Conk <jake.conk@...> wrote:
>>
>>  The only way you can make this dynamic is if you have a script
>>> periodically reading your information schema to see if its almost full
>>> and if it is then add another tablespace to it. I'm not sure I have
>>> the right algorithm for figuring out the amount of space but maybe
>>> someone else here can post it up because I think mine is wrong hehe.
>>>
>>> - Jake
>>>
>>> On Dec 17, 2007 6:39 PM, Moon's Father <yueliangdao0608@...>
>>> wrote:
>>>
>>>> Something happend to me when my table's data is much bigger on today's
>>>> morning.
>>>>
>>>> mysql> alter table t11 tablespace ts_1 storage disk;
>>>> ERROR 1114 (HY000): The table '#sql-3f0d_14cf' is full
>>>>
>>>> Then I have to add a new tablespace data file to make me satisfied.
>>>> Anybody can tell me if you have another way to dynamic extend the size
>>>> of
>>>> the tablespace.
>>>>
>>>> Any reply is appreciated.
>>>>
>>>>
>>
>>
>>
> --
> Best wishes,
> /Jeb
>
> Jonathan Miller
> Cluster Lead QA Developer
> Certified Cluster Database Administrator
> Sun Microsystems / MySQL
> Austin, Texas US
> www.mysql.com
> www.sun.com
>
> I'm Certified, are you?
> http://www.mysql.com/certification/index.html
>

--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn