Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

Re: optimizing ndbd tables

From: Stewart Smith <stewart(at)mysql.com>
Date: Sun Sep 23 2007 - 09:41:08 EDT


On Wed, 2007-09-05 at 16:46 -0400, B. Keith Murphy wrote:
> So, I just searched the archives and it has been some time since this
> question was asked. So I will ask it again...
>
> I understand that you can't defragment (essentially) ndbd tables with
> an OPTIMIZE command. I also understand that currently the only way to
> do this is a "rolling restart" and the tables get optimized as the
> node is brought down/up.
>
> Is this still true?

In 5.0, yes. Post-5.0 (5.1+) currently doesn't and as Jimmy said, we're looking at it.

-- 
Stewart Smith, Senior Software Engineer
MySQL AB, www.mysql.com
Office: +14082136540 Ext: 6616
VoIP: 6616@sip.us.mysql.com
Mobile: +61 4 3 8844 332

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html
Received on Sun Sep 23 09:48:13 2007

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 10:15:14 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library