Vesta Control Panel - Forum

Turns out httpd hanged because it was trying to connect to MySQL through ipv6 even if my script stated to use ipv4. I disabled ipv6 on the server and the issue had dissipated.

Running strace shows that httpd hangs a lot for a second, but multiple times: 7013 1.001157 wait4(-1, 0x7fffed2d7b6c, WNOHANG|WSTOPPED, NULL) = 0 7013 0.000063 select(0, NULL, NULL, NULL, {1, 0}) = 0 (Timeout) 7013 0.111947 wait4(-1, 0x7fffed2d7b6c, WNOHANG|WSTOPPED, NULL) = 0 7013 0.000059 select(0...

I'm thinking that maybe httpd or php stalls the response because of buffer being larger. I'm not sure, I'm really out of ideas of how to fix this or on to what to look into next.

It is. But the browser receives the response in one minute.

Is it just this request that is slow? Or is everything slow? Can you provide the link so we can look it's not a local problem. (maybe in PM) That and a few other pages that are more query intensive, although I added timers in the code and the results are in microseconds: 0.0028798580169678 0.003633...

http://screenshot.vodoosolutions.com/2015-05-25_1321.png The server has 12GB Ram, MySQL uses InnoDb and has 6GB of ram dedicated. PHP 5.4.41, 5.5.43-log MySQL Community Server (GPL) by Remi Apache/2.2.15 (Unix) nginx/1.8.0 Running the same queries in phpmyadmin run in a matter of ms, while the app (...

Here is the HAR on the slow call { "startedDateTime": "2015-05-22T15:24:59.593Z", "time": 60663.44500007108, "request": { "method": "GET", "url": "http://gameiki.com/search/suggestions/index/keywords/test?is_global=1", "httpVersion": "HTTP/1.1", "headers": [ { "name": "Pragma", "value": "no-cache" }...

I'm at wits end.

It's not MySQL, Nginx, firewall,php ... what could cause this http://screenshot.vodoosolutions.com/20 ... 2_1826.png With no errors in any log.

Downgraded php from 5.6.9 to PHP 5.4.41, same behaviour.

I stopped nginx and made httpd work on port 80. Seems to have the same issue, so the problem might reside in httpd itself or php which works as a module.