In most situations, reducing load or increasing the availability of resources will improve host performance. Some of the more common steps to take are:
Run the nodes on hosts with better hardware characteristics (more internal memory, higher processor speed, more processors).
Add physical disks and use several data devices, not more than one device on each physical disk.
Add more nodes, on new hosts, and refragment the data to utilize the new nodes.
Change configuration variables to allocate larger memory segments or internal data structures.
In addition, the following resources can be adjusted to improve “HIGH LOAD” problems, as described in the Performance and Tuning Guide:
Table 3–1 HADB Performance Tuning Properties
Resource |
Property |
---|---|
Size of Database Buffer |
hadbm attribute DataBufferPoolSize |
Size of Tuple Log Buffer |
hadbm attribute LogBufferSize |
Size of Node Internal Log Buffer |
hadbm attribute InternalLogBufferSize |
Number of Database Locks |
hadbm attribute NumberOfLocks |