On 31.05.2016 19:43, Tomek Mrugalski wrote: > >> Could it be useful to make a primary key consisting of >> dhcp_identifier, dhcp4_subnet_id and dhcp6_subnet_id? >> > Almost. The tuple of (identifier-type, identifier, dhcp4_subnet_id) > must be unique. The same is true for v6. Now that you mentioned it, we > should probably have indexes there. > > Actually, having such indexes on host reservations should speed things > up significantly. I know that Marcin is tweaking the MySQL host > reservations code. I'll put an note in ticket #4281. Ignore that. Those indexes are already there. They're created with the hosts table, not with a separate statement. I have missed that, because I was searching for CREATE INDEX...
Tomek
_______________________________________________ Kea-users mailing list [email protected] https://lists.isc.org/mailman/listinfo/kea-users
