BIGINT ; the allowed range of the offset value is the same as the signed version of that type (this allows the offset to be negative if desired). 

The new option can be used multiple times in the same invocation of ndb_restore , so that you can remap to new values multiple columns of the same table, different tables, or both. The offset value does not have to be the same for all instances of the option. 

In addition, two new options are provided for ndb_desc , also beginning in NDB 8.0.21: 

• --auto-inc  (short form -a ): Includes the the next auto-increment value in the output, if the table has an AUTO_INCREMENT  column. 

• --context  (short form -x ): Provides extra information about the table, including the schema, database name, table name, and internal ID. 

For more information and examples, see the description of the --remap-column  option. 

• Send thread improvements.  As of NDB 8.0.20, each send thread now handles sends to a subset of transporters, and each block thread now assists only one send thread, resulting in more send threads, and thus better performance and data node scalability. 

• Adaptive spin control using SpinMethod.  A simple interface for setting up adaptive CPU spin on platforms supporting it, using the SpinMethod  data node parameter. This parameter (added in NDB 8.0.20, functional beginning with NDB 8.0.24) has four settings, one each for static spinning, cost-based adaptive spinning, latency-optimized adaptive spinning, and adaptive spinning optimized for database machines on which each thread has its own CPU. Each of these settings causes the data node to use a set of predetermined values for one or more spin parameters which enable adaptive spinning, set spin timing, and set spin overhead, as appropriate to a given scenario, thus obviating the need to set these directly for common use cases. 

For fine-tuning spin behavior, it is also possible to set these and additional spin parameters directly, using the existing SchedulerSpinTimer  data node configuration parameter as well as the following DUMP  commands in the ndb_mgm  client: 

• DUMP 104000 (SetSchedulerSpinTimerAll) : Sets spin time for all threads 

• DUMP 104001 (SetSchedulerSpinTimerThread) : Sets spin time for a specified thread 

• DUMP 104002 (SetAllowedSpinOverhead) : Sets spin overhead as the number of units of CPU time allowed to gain 1 unit of latency 

• DUMP 104003 (SetSpintimePerCall) : Sets the time for a call to spin 

• DUMP 104004 (EnableAdaptiveSpinning) : Enables or disables adpative spinning 

NDB 8.0.20 also adds a new TCP configuration parameter TcpSpinTime  which sets the time to spin for a given TCP connection. 

The ndb_top  tool is also enhanced to provide spin time information per thread. 

For additional information, see the description of the SpinMethod  parameter, the listed DUMP commands, and Section 23.4.29, “ndb_top — View CPU usage information for NDB threads” . 

