Hello Steven, On 12 Sep 2014, at 17:36 , Steven Maddox <[email protected]> wrote:
> 2) Don't ask me not to use MySQL - it's what our internal developers > know how to stick data in to... however I appreciate caching this data > to something else might handy to read from that instead. Just one very important thing here - the Recursor has only one Lua instance per thread (threads= setting in recursor.conf), and if this Lua instance is waiting for MySQL to respond, that thread is not handling any other queries. Increasing the thread count to deal with this is unfeasible for any non-trivial traffic amount. Because of this, we recommend caching your data either to a local format that is quick and non-blocking (bdb, lmdb, *maybe* sqlite), or into actual Lua tables that you can index into quickly because you’ve loaded them all into memory. Don’t reject the second option because of memory constraints - your local on-disk database will have to be cached in RAM anyway to get good performance. Kind regards, -- Peter van Dijk Netherlabs Computer Consulting BV - http://www.netherlabs.nl/
signature.asc
Description: Message signed with OpenPGP using GPGMail
_______________________________________________ Pdns-users mailing list [email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users
