PHP Stalls before loading page fast

[razorz]

http://www.gamerconx.com/

http://www.gamerconx.com/bp/

Two different sets of code, same issue. It stalls and then loads fast.

Any ideas? PHP 5.3.2 w/ Zend.. tried with and without APC, with and without server side caching.

Solaris 10 SPARC

[mistwang]

Try strace/truss/ktrace the lsphp5 process, it should show what stall PHP.
Sometimes, it is a issue with DNS.

[razorz]

Could you give me some specific commands and what I am looking for? I can truss PID's and it shows either an idle state of lsphp5 or, when I request a page, tons of spam going down. What am I really looking for in the mess of files being opened?

[mistwang]

let truss print out timestamps, and the amount of time each system call. I can do that with strace, not sure about truss.

Then, send a request that show the stall problem. from truss output, you can catch some pauses matching the stall period, log in that period is what you should pay attention. When the timestamp, you can always go over the log output and find out that section. If truss output does not pause, it could be something else.

[razorz]

http://pastebin.ca/1904123

2.5 second pause time. Bloody hell =/

[mistwang]

That looks like a MySQL DB connection, you should investigate why. Maybe try different version of MySQL driver and socket type (TCP/Domain).