>  >Can you try telne to policyd or use nc or nc6 and pump queries to it ...
>>as there are no errors in policyd it should be processing the queries
>>fine, lets just confirm that.
>
>Is there a reference to the query format ? In other words, what do I
>need to feed it ?

Good hint there.

I ripped a query from the packet capture.

With a simple loop sending the same query to the backend via nc, I 
can do a little over 16 queries/second from my laptop. This rises to 
a little over 18/s when run from the backend and sending the queries 
to localhost.

While doing this for 1000 queries, top shows the machine is spending 
a fair amount of time on WIO, and there is always a fairly 
significant amount of memory still unused.

So I'm starting to think MySQL needs a bit of tuning for memory usage.

My reading of the docs so far suggests that key_buffer_size 
(currently on the default of 16M) and table_cache (currently default 
of 64) are ones to start with.

-- 
Simon Hobson

Visit http://www.magpiesnestpublishing.co.uk/ for books by acclaimed
author Gladys Hobson. Novels - poetry - short stories - ideal as
Christmas stocking fillers. Some available as e-books.
_______________________________________________
Users mailing list
[email protected]
http://lists.policyd.org/mailman/listinfo/users

Reply via email to