[Dnsmasq-discuss] Re : Re : Feature request for dhcp-hostfiles to behave like addn-hosts
Vincent Cadet
v_cadet at yahoo.fr
Thu Dec 16 22:46:41 GMT 2010
richardvoigt at gmail.com wrote:
> I haven't used sqlite, but I would imagine it loses many of its
> advantages in the lease script process-model -- dnsmasq spawns a new
> process for every lease.
I've just read SQLite is thread-safe and may be accessed by multiple threads and
processes (though they strongly discourage that: «threads are evil»). They use a
reader/writer lock mechanism. So it looks like it can be done. I have no idea
about the impact upon performance though.
See http://www.sqlite.org/faq.html#q5
Vince
___
> On Thu, Dec 16, 2010 at 1:43 PM, Vincent Cadet <v_cadet at yahoo.fr> wrote:
> > Simon Kelley wrote:
> >
> > ...
> >> > A tangential question, I've increased MAXLEASES to
> >> >
> >> > #define MAXLEASES 16384
> >> >
> >> > in config.h. Is there any danger in having this many leases and
> >> > increasing this even higher if necessary? I'm a few weeks away from
> >> > being able to test this at scale and appreciate any warnings or
> >> > feedback anyone might have now.
> >> >
> >> If you get bitten anywhere, it will be performance writing the lease
> >> file. That gets truncated and re-written for every change. On reasonable
> >> storage it should be fine, but maybe not on a slow flash drive. If it's
> >> a problem that's that prefect excuse to write a script to move the
> >> database to a MySQL backend, right?
> >
> > What about sqlite? IMHO MySQL seems a little bit overkill for that purpose.
> >
> > Vince C.
> >
> >
> >
> >
> >
> > _______________________________________________
> > Dnsmasq-discuss mailing list
> > Dnsmasq-discuss at lists.thekelleys.org.uk
> > http://lists.thekelleys.org.uk/mailman/listinfo/dnsmasq-discuss
> >
>
More information about the Dnsmasq-discuss
mailing list