On 2014-09-17 15:20, Hugh Williams wrote: > Hi Bart, > > This is indeed strange behaviour and would appear to be network related > as you indicate the spikes about every 100 query executions only occur > when the script is run on the machine hosting Virtuoso and the > "physical" IP address it used for connecting but not if localhost is use > or it is run from a remote client. It might also be useful to see if > this behaviour is seen if the Virtuoso Server was setup on another > physical machine ?
Hughes, I probably didn't explain myself well enough... To summarize, here's what I observed: Sending curl requests from my wireless laptop to the Virtuoso server resulted in the following spiky graph: https://dl.dropboxusercontent.com/u/32340538/repeattest_with_union_speedwing_wireless.png Sending curl request to localhost on the Virtuoso server itself resulted in no spikes: https://dl.dropboxusercontent.com/u/32340538/repeattest_with_union_localhost.png Sending curl requests from another (wired) machine to the Virtuoso server also didn't show any spikes: https://dl.dropboxusercontent.com/u/32340538/repeattest_with_union_sandy-quad.png So the only situation where I got the spiky behavior was with my laptop on the wireless network. I just tried the same experiment with my laptop connected with a cable to the network and this is the result: https://dl.dropboxusercontent.com/u/32340538/repeattest_with_union_speedwing_wired.png As you can see, quasi no spiky behaviour. My conclusion is that the spikes are *not* caused by Virtuoso, but that they are somehow network-related and that it had to do with the fact that I was on the wireless network. Probably the Network Manager periodically disconnecting, see e.g. http://askubuntu.com/questions/128024/wireless-connection-is-lost-periodically-and-without-apparent-reason-and-is-quic https://bugzilla.redhat.com/show_bug.cgi?id=490493 As this is getting more and more off-topic for the Virtuoso list, I'm closing the discussion here :-) Kind regards, Bart ------------------------------------------------------------------------------ Want excitement? Manually upgrade your production database. When you want reliability, choose Perforce Perforce version control. Predictably reliable. http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users