BIND 10 trac2699, updated. 20ad24c67485244b8e41823dca650ac5607eb778 Added composite search indexes to lease4 and lease6 tables to boost performance. Note: This change fulfills both 2699 (lease4) and 2703 (lease6).

[BIND 10 source code commits]

The branch, trac2699 has been updated
       via  20ad24c67485244b8e41823dca650ac5607eb778 (commit)
      from  3f272be09aadc78d27333ddeba66ba7e9de25f1f (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 20ad24c67485244b8e41823dca650ac5607eb778
Author: Thomas Markwalder <tmark at isc.org>
Date:   Mon Feb 11 15:39:59 2013 -0500

    Added composite search indexes to lease4 and lease6 tables to boost performance.
    Note: This change fulfills both 2699 (lease4) and 2703 (lease6).

-----------------------------------------------------------------------

Summary of changes:
 src/lib/dhcpsrv/dhcpdb_create.mysql |   12 ++++++++++++
 1 file changed, 12 insertions(+)

-----------------------------------------------------------------------
diff --git a/src/lib/dhcpsrv/dhcpdb_create.mysql b/src/lib/dhcpsrv/dhcpdb_create.mysql
index 695091d..b7b7635 100644
--- a/src/lib/dhcpsrv/dhcpdb_create.mysql
+++ b/src/lib/dhcpsrv/dhcpdb_create.mysql
@@ -39,6 +39,14 @@ CREATE TABLE lease4 (
     subnet_id INT UNSIGNED                      # Subnet identification
     ) ENGINE = INNODB;
 
+
+# Create search indexes for lease4 table 
+# index by hwaddr and subnet_id
+CREATE INDEX lease4_by_hwaddr_subnet_id ON lease4 (hwaddr, subnet_id);
+
+# index by client_id and subnet_id
+CREATE INDEX lease4_by_client_id_subnet_id ON lease4 (client_id, subnet_id);
+
 # Holds the IPv6 leases.
 # N.B. The use of a VARCHAR for the address is temporary for development:
 # it will eventually be replaced by BINARY(16).
@@ -55,6 +63,10 @@ CREATE TABLE lease6 (
     prefix_len TINYINT UNSIGNED                 # For IA_PD only
     ) ENGINE = INNODB;
 
+# Create search indexes for lease4 table 
+# index by iaid, subnet_id, and duid 
+CREATE INDEX lease6_by_iaid_subnet_id_duid ON lease6 (iaid, subnet_id, duid);
+
 # ... and a definition of lease6 types.  This table is a convenience for
 # users of the database - if they want to view the lease table and use the
 # type names, they can join this table with the lease6 table