Slow performance with gethostbyaddr()


#1

Just wondering if anyone else is seeing this problem and if an issue should be created for it on Github.

In our slow log for PHP-FPM, we see numerous entries on a daily (hourly) basis for the following:


[0x00007f816dc2a600] gethostbyaddr() /path/to/piwik/vendor/piwik/network/src/IP.php:108
[0x00007f816dc2a3c8] getHostname() /path/to/piwik/plugins/Provider/Columns/Provider.php:97
[0x00007f816dc2a118] getHost() /path/to/piwik/plugins/Provider/Columns/Provider.php:73
[0x00007f816dc29b38] onNewVisit() /path/to/piwik/core/Tracker/Visit.php:556
[0x00007f816dc296e0] triggerHookOnDimensions() /path/to/piwik/core/Tracker/Visit.php:310
[0x00007f816dc29090] handleNewVisit() /path/to/piwik/core/Tracker/Visit.php:207
[0x00007f816dc27da8] handle() /path/to/piwik/core/Tracker.php:139
[0x00007f816dc27ac8] trackRequest() /path/to/piwik/core/Tracker/Handler.php:49
[0x00007f816dc27900] process() /path/to/piwik/core/Tracker.php:121
[0x00007f816dc275f8] track() /path/to/piwik/core/Tracker.php:98
[0x00007f816dc272f8] main() /path/to/piwik/piwik.php:62

My best guess is either an IP address is unable to be resolved because it has no hostname associated with it, or there is an issue with our DNS server. This only happens for a very small fraction of the traffic we receive so I suspect the IP addresses simply can’t be resolved to a hostname.

These slow requests were originally logged after 5 seconds, but that has been increased to 12 seconds and the issue persists. Ideally, if the IP is unable to be resolved “immediately”, Piwik would move on instead of waiting.

Any input or advice would be appreciated.


(Matthieu Aubry) #2

Hi there

Disable the Provider plugin. This is fixed in 2.15.0 currently in beta and soon release candidate.


(John Praveen) #3

I am currently in Piwik 2.15.0 version and still get those slow log entries for getHostname()

@CanuckNick, Are you getting these slow log entries for version 2.15.0?


(John Praveen) #4

Just realised the suggestion is to disable the Provider plugin https://github.com/piwik/piwik/issues/88264. After disabling the plugin getHostname() is no longer available in slow log entries