272 reputation
38
bio website scribu.net
location Romania
age 25
visits member for 5 years, 1 month
seen Dec 23 '13 at 13:50

Web Developer


Sep
4
comment Why do some hosts provide consoles instead of true ssh logins?
@WesleyDavid Thanks for the link, but my question is narrower. Updated title.
Sep
2
comment PHP slow to talk to MySQL on same host
Default firewall rules; MySQL has skip-networking so I presume a socket is used.
Sep
1
comment PHP slow to talk to MySQL on same host
chat: chat.stackexchange.com/rooms/1262/…
Sep
1
comment PHP slow to talk to MySQL on same host
No, I'm not using any opcode caching; need to figure this out first. I did a strace and php-fpm seems to be making tens of thousands of gettimeofday() calls for a single request.
Sep
1
comment PHP slow to talk to MySQL on same host
Yeah, but that's used in every WordPress installation (including on the other VPS, which works fine). Thanks for looking though.
Sep
1
comment PHP slow to talk to MySQL on same host
Sure: lomo.scribu.net/cachegrind.out.3974 (it's 12mb).
Sep
1
comment PHP slow to talk to MySQL on same host
Ok, did a profiling, looked at it through KCacheGrind; didn't learn anything. :|
Sep
1
comment PHP slow to talk to MySQL on same host
@Dana the Sane: Like I said, the actual query time is small: 0.77 seconds in total.
Sep
1
comment PHP slow to talk to MySQL on same host
I tried switching to apache and the problem persists, only now it's the apache process hogging the CPU. The funny thing is that I run the same app on a similar VPS with no delay. So yeah, I guess profiling is the last hope.
Sep
1
comment PHP slow to talk to MySQL on same host
Thanks for the suggestion, but it is MySQL related, since it only happens when MySQL is involved; maybe it has something to do with the PHP MySQL driver.
Sep
1
comment PHP slow to talk to MySQL on same host
@Shane Madden: Hm... it's actually php-fpm that's spiking. But when I enable the caching, it doesn't anymore.
Sep
1
comment PHP slow to talk to MySQL on same host
@Shane Madden: Nope; if I log into ssh and then run the mysql command, it's fast.
Jun
13
comment Why is PHP script downloaded instead of executed
No, at least I don't think I am. I was actually working on a WordPress plugin and one minute it was working and after modifying something trivial, I got the download dialog.
Jun
13
comment Why is PHP script downloaded instead of executed
It's not a script execution timeout in my case.