[PHP] how to avoid using temporary?

2011-01-17 Thread I am on the top of the world! Borlange University
heres my sql query: EXPLAIN SELECT t1.szs_guige,SUM(t1.szs_shuliang) FROM szs_ck_ruku_items t1,szs_ck_ruku t2 WHERE t1.szs_rukubianhao = t2.szs_rukubianhao AND t2.szs_date>'2010-10-23' GROUP BY t1.szs_guige ORDER BY null result: id select_type table type possible_keys key key_len ref rows Extra 1

Re: [PHP] PHP Error logging

2011-01-17 Thread Daniel Brown
On Mon, Jan 17, 2011 at 19:33, Jimmy Stewpot wrote: > Hello, > > I currently have a strange issue where we are seeing 'random errors' being > displayed to end users. What I find most interesting is that in the php.ini > file we have the following error settings. > > error_reporting  =  E_ALL & ~

[PHP] PHP Error logging

2011-01-17 Thread Jimmy Stewpot
Hello, I currently have a strange issue where we are seeing 'random errors' being displayed to end users. What I find most interesting is that in the php.ini file we have the following error settings. error_reporting = E_ALL & ~E_NOTICE display_errors = Off display_startup_errors = Off log_er

[PHP] pcntl_signal() get PID

2011-01-17 Thread Алексей Масленников
Hi everyone! My question is:howto getPIDtreadchildto send a signalhandlerinstalled inpcntl_signal()? I apologizeformyEnglish,I'm fromRussia. Thanks.

Re: [PHP] How to get cpu consumption of a php script

2011-01-17 Thread Richard Quadling
On 17 January 2011 10:58, Camilo Sperberg wrote: > Please take into account that lighttpd does have some random high > cpu-consumption problems, it could be that also. Give nginx a try instead. > > Also: microtime by itself isn't enough, sum time() to it because if a script > lasts more than 1 s

Re: [PHP] How to get cpu consumption of a php script

2011-01-17 Thread Tanoor Dieng
Hi thanks, for xdebug, we'll take al look at it. On Mon, Jan 17, 2011 at 11:51 AM, Thijs Lensselink wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 01/17/2011 11:23 AM, Tanoor Dieng wrote: > > Hi everybody, > > I'm a php developper for a high traffic website. Our web servers run

Re: [PHP] How to get cpu consumption of a php script

2011-01-17 Thread Camilo Sperberg
Please take into account that lighttpd does have some random high cpu-consumption problems, it could be that also. Give nginx a try instead. Also: microtime by itself isn't enough, sum time() to it because if a script lasts more than 1 second you can end up with negative total time, microtime

Re: [PHP] How to get cpu consumption of a php script

2011-01-17 Thread Thijs Lensselink
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/17/2011 11:23 AM, Tanoor Dieng wrote: > Hi everybody, > I'm a php developper for a high traffic website. Our web servers run with > lightty? > > We have some issues with the cpu consumption of our servers. > > The problem is that, we don't know

RE: [PHP] How to get cpu consumption of a php script

2011-01-17 Thread Tommy Pham
> -Original Message- > From: a...@ashleysheridan.co.uk [mailto:a...@ashleysheridan.co.uk] > Sent: Monday, January 17, 2011 2:36 AM > To: Tanoor Dieng; php-general@lists.php.net > Subject: Re: [PHP] How to get cpu consumption of a php script > > I can't think of anything except using top or

Re: [PHP] How to get cpu consumption of a php script

2011-01-17 Thread a...@ashleysheridan.co.uk
I can't think of anything except using top or ps. If you can't guarantee what process runs what individual script, are you able to just track them all globally, and check for differences as you start and stop scripts. Perhaps run certain scripts under different users which should give them their

[PHP] How to get cpu consumption of a php script

2011-01-17 Thread Tanoor Dieng
Hi everybody, I'm a php developper for a high traffic website. Our web servers run with lightty? We have some issues with the cpu consumption of our servers. The problem is that, we don't know exactly which script consumes so much cpu. So, we cant to figure out how much cpu does a php script take

Re: [PHP] PHP tutorials

2011-01-17 Thread Geoffrey Van Wyk
I like www.phpexercises.com. On 1/17/11, Paul M Foster wrote: > On Sun, Jan 16, 2011 at 01:26:07PM -0500, tedd wrote: > >> Hi gang: >> >> In the past we talked about PHP tutorials, but I don't remember if >> there was a single clearinghouse/link for them or not -- is there >> one? If not, what do