BIND 10 #2699: DHCP performance: use composite search indexes on the lease4 table to improve performance

[BIND 10 Development]

#2699: DHCP performance: use composite search indexes on the lease4 table to
improve performance
-------------------------------------+-------------------------------------
            Reporter:  marcin        |                        Owner:  tmark
                Type:  defect        |                       Status:
            Priority:  high          |  assigned
           Component:  dhcp4         |                    Milestone:
            Keywords:                |  Sprint-DHCP-20130214
           Sensitive:  0             |                   Resolution:
         Sub-Project:  DHCP          |                 CVSS Scoring:
Estimated Difficulty:  0             |              Defect Severity:
         Total Hours:  0             |  Medium
                                     |  Feature Depending on Ticket:
                                     |          Add Hours to Ticket:  0
                                     |                    Internal?:  0
-------------------------------------+-------------------------------------

Comment (by stephen):

 > BTW, I presume that the variable can be only set when starting the
 mysqld so our effort my by just limited to update the performance guides
 to instruct users that this setting will improve the performance.
 Not sure, but as the configuration setting affects all innodb tables in
 the database - and not just the Kea table - I think it is best left to the
 Database Administrator to change it.

-- 
Ticket URL: <https://bind10.isc.org/ticket/2699#comment:3>
BIND 10 Development <http://bind10.isc.org>
BIND 10 Development