[Kea-users] Hosts table

[Tomek Mrugalski]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20160531/fe6b1a72/attachment.htm>