BIND 10 #2703: DHCPv6 performance: use composite search indexes on the lease6 table to improve performance

[BIND 10 Development]

#2703: DHCPv6 performance: use composite search indexes on the lease6 table to
improve performance
-------------------------------------+-------------------------------------
                   Reporter:         |                 Owner:
  marcin                             |                Status:  new
                       Type:         |             Milestone:  Sprint-
  defect                             |  DHCP-20130214
                   Priority:         |              Keywords:
  medium                             |             Sensitive:  0
                  Component:  dhcp6  |           Sub-Project:  DHCP
               CVSS Scoring:         |  Estimated Difficulty:  0
            Defect Severity:  High   |           Total Hours:  0
Feature Depending on Ticket:         |
        Add Hours to Ticket:  0      |
                  Internal?:  0      |
-------------------------------------+-------------------------------------
 In the course of #2701 it has been found that the performance of the
 DHCPv6 server using MySQL lease database backend is limited to ~250
 leases/sec because it performs full table scans to search the existing
 lease when the new lease is being acquired. When applying the composite
 search index on the lease6 table which includes: iaid, subnetid, duid
 performance raises up to ~900 leases/sec which is the maximum throughput
 that can be currently obtained with the Memfile backend.

-- 
Ticket URL: <http://bind10.isc.org/ticket/2703>
BIND 10 Development <http://bind10.isc.org>
BIND 10 Development