[TYPO3-UG Italy] R: Re: 100%cpu

Ivano Luberti luberti at archicoop.it
Mon Mar 10 13:59:14 CET 2014


sempre nell'ipotesi che sia mysql il problema puoi provare ad attivare
lo slow  query log e vedere se i tuoi 100% coincidono con delle query lente.

Il 10/03/2014 13:42, luca-mastro at libero.it ha scritto:
> Buondì,
>
> Un incremento tale nella cpu, può essere una query che va in loop, non appena 
> viene risolta, il loop si interrompe e le prestazioni ritornano standard.
> Una soluzione interessante potrebbe riguardare il tuning di mysql e, per 
> questo scopo, esistono tool specifici.
>
> ciao,
>
> Luca
>
>> ----Messaggio originale----
>> Da: mauro.lorenzutti at webformat.com
>> Data: 10/03/2014 11.43
>> A: <typo3-ug-italy at lists.typo3.org>
>> Ogg: Re: [TYPO3-UG Italy] 100%cpu
>>
>> Ciao Paolo,
>>
>> hai attiva la cache su file statico? Potrebbe dipendere dal fatto che 
>> deve cancellare troppi file su disco.
>> oppure potrebbe essere il mysql a piantarti la cpu mentre cancella 
>> tabelle che magari hanno raggiunto dimensioni ragguardevoli (in questo 
>> caso potresti valutare di adottare memcache)
>>
>> Ciao,
>> -- 
>>
>> Mauro Lorenzutti
>>
>> CTO / Software Architect
>> mauro.lorenzutti at webformat.com
>> Tel.   +39-0427-926.389
>>
>> WEBFORMAT srl -- www.webformat.com
>> Via Mecenate, 76 - 20138 MILANO
>> Corte Europa, 12 - 33097 SPILIMBERGO (PN)
>>
>> *** TYPO3 Certified Integrator *** - *** Magento Certified Developer ***
>>
>>
>>
>> Il 10/03/2014 11:39, Paolo Bragagni ha scritto:
>>> aggiornamento:
>>> la cpu al 100% mi va quando cancello la cache.
>>>
>>> fra l'altro ho inserito il codice per il quale quando un utente edita una
>>> news, il sistema cancella la cache di certe pagine, ma
>>> ho il problema che ci mette 4 o 5 secondi (e la cpu schizza al 100%).
>>>
>>> credevo fosse un problema facilemtne risolvibile, invece ci sto
>>> impazzendo...
>>>
>>> saluti,
>>> PB
>>>
>>>
>>> Il giorno 07 marzo 2014 17:10, Paolo Bragagni <paolo.bragagni at gmail.com> 
> ha
>>> scritto:
>>>
>>>> C é solo TYPO 3 6.1.5dev con twitter boostrap da fedext
>>>> Ubuntu apache PHP MySQL versioni recenti
>>>> Il 07/mar/2014 14:45 "Attilio Monti NewtVision" <
>>>> attilio.monti at newtvision.com> ha scritto:
>>>>
>>>>> Ciao Paolo,
>>>>> ma su questo server cosa c'è caricato, esclusivamente Typo3 ? E se c'è
>>>>> solo typo3 che estensioni ci sono caricate e se ci sono degli script
>>>> custom.
>>>>> Attilio Monti
>>>>>
>>>>> NewtVision
>>>>> Il giorno 07/mar/2014, alle ore 14:40, Paolo Bragagni <
>>>>> paolo.bragagni at gmail.com> ha scritto:
>>>>>
>>>>>> salve, devo avere dei problemi al server perhe talvolta vedo che
>>>> apache2
>>>>> ha
>>>>>> dei picchi di cpu al 100% anche col server scarico.
>>>>>>
>>>>>> Ho questo tipo di risultato con il benchmark test che non mi sembra
>>>>>> incoraggiante.
>>>>>>
>>>>>>
>>>>>> Qualcuno ha esperienze in merito?
>>>>>>
>>>>>> Grazie,
>>>>>> PB
>>>>>>
>>>>>> ----------------------
>>>>>> Benchmarking localhost (be patient)
>>>>>> Finished 659 requests
>>>>>>
>>>>>>
>>>>>> Server Software:        Apache/2.2.22
>>>>>> Server Hostname:        localhost
>>>>>> Server Port:            80
>>>>>>
>>>>>> Document Path:          /
>>>>>> Document Length:        68152 bytes
>>>>>>
>>>>>> Concurrency Level:      10
>>>>>> Time taken for tests:   30.067 seconds
>>>>>> Complete requests:      659
>>>>>> Failed requests:        0
>>>>>> Write errors:           0
>>>>>> Keep-Alive requests:    0
>>>>>> Total transferred:      45192902 bytes
>>>>>> HTML transferred:       44912168 bytes
>>>>>> Requests per second:    21.92 [#/sec] (mean)
>>>>>> Time per request:       456.247 [ms] (mean)
>>>>>> Time per request:       45.625 [ms] (mean, across all concurrent
>>>>> requests)
>>>>>> Transfer rate:          1467.86 [Kbytes/sec] received
>>>>>>
>>>>>> Connection Times (ms)
>>>>>>               min  mean[+/-sd] median   max
>>>>>> Connect:        0    0   0.2      0       3
>>>>>> Processing:   212  453 100.1    450     869
>>>>>> Waiting:      201  422  95.9    420     825
>>>>>> Total:        212  453 100.1    450     871
>>>>>>
>>>>>> Percentage of the requests served within a certain time (ms)
>>>>>>   50%    450
>>>>>>   66%    486
>>>>>>   75%    508
>>>>>>   80%    531
>>>>>>   90%    583
>>>>>>   95%    631
>>>>>>   98%    683
>>>>>>   99%    745
>>>>>> 100%    871 (longest request)
>>>>>> ----------------------
>>>>>> _______________________________________________
>>>>>> TYPO3-UG-Italy mailing list
>>>>>> TYPO3-UG-Italy at lists.typo3.org
>>>>>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-ug-italy
>>>>> _______________________________________________
>>>>> TYPO3-UG-Italy mailing list
>>>>> TYPO3-UG-Italy at lists.typo3.org
>>>>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-ug-italy
>>>>>
>>>> _______________________________________________
>>>> TYPO3-UG-Italy mailing list
>>>> TYPO3-UG-Italy at lists.typo3.org
>>>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-ug-italy
>>>>
>>> _______________________________________________
>>> TYPO3-UG-Italy mailing list
>>> TYPO3-UG-Italy at lists.typo3.org
>>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-ug-italy
>>
>>
>> _______________________________________________
>> TYPO3-UG-Italy mailing list
>> TYPO3-UG-Italy at lists.typo3.org
>> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-ug-italy
>>
>
> _______________________________________________
> TYPO3-UG-Italy mailing list
> TYPO3-UG-Italy at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-ug-italy

-- 
==================================================
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
web: www.archicoop.it
==================================================



More information about the TYPO3-UG-Italy mailing list