[TYPO3-UG Italy] 100%cpu

Simone Mori simone.mori at newtvision.com
Mon Mar 10 14:42:36 CET 2014


Ciao Paolo,

la versione 6.2.5dev può essere aggiornata alla 6.1.7 o sei blindato a
tenere quella per modifiche custom?

La domanda fatta da Antonio è lecita mod_php, cgi o fcgi?

Anche noi abbiamo una configurazione con Ubuntu simile alla tua e con fcgi
e apc attivo problemi non ne abbiamo sulla 6.1.7...

Per quanto tempo rimane attiva la CPU al 100%?
ai provato a vedere anche le chiamate nell'access_log per vedere dove si
pianta?

*----------------------------------------------------------*
*Simone Mori*
*CTO / Web Developer/ Database Specialist*

Easy Web Solution

Telefono: +39 06 5560305 | Mobile: +39 339 4197961
Skype: simonemori83 | Twitter: @simonemori
Facebook: https://www.facebook.com/newtvision
LinkedIn: http://it.linkedin.com/in/simonemori


Il giorno 10 marzo 2014 14:10, Tonix - Antonio Nati
<tonix at interazioni.it>ha scritto:

> Non dico che sia un problema mysql (oltretutto sarebbe al 100% la cpu di
> MySQL), ma di identificare cosa TYPO3 sta usando in maniera intensiva.
>
> Se c'è un loop su una tabella, sicuramente show processes te lo evidenzia.
>
> (per completezza: usi mod_php o php in modalità cgi?)
>
> Tonino
>
>
> Il 10/03/2014 13:49, Paolo Bragagni ha scritto:
>
>  mmm questo non l'ho mai fatto ci provo ma mi sa che non sia un problema di
>> mysql...
>>
>>
>> Il giorno 10 marzo 2014 12:59, Tonix - Antonio Nati
>> <tonix at interazioni.it>ha scritto:
>>
>>  Puoi fare uno show processes su mysql ed 'intuire' su quali tabelle TYPO3
>>> sta ciclando?
>>>
>>> Sempre se di tabelle MySQL si tratta.
>>>
>>> Tonino
>>>
>>>
>>> Il 10/03/2014 12:40, Paolo Bragagni ha scritto:
>>>
>>>   macche, speravo tanto  anch'io..
>>>
>>>> ho troncato tutte le tabelle 'grosse': gli indici, syslog ecc, ma la cpu
>>>> schizza sempre al 100% quando rimuovo la cache
>>>>
>>>>
>>>>
>>>> Il giorno 10 marzo 2014 12:14, Federico Bernardin
>>>> <typo3list at bernardin.it>ha scritto:
>>>>
>>>>   Ciao Paolo, come scrive Mauro può essere la tabella sys_log che ha
>>>>
>>>>> raggiunto dimensioni importanti.
>>>>> Controlla bene le dimensioni delle tabelle di mysql.
>>>>>
>>>>> Ciao
>>>>> Federico
>>>>>
>>>>>
>>>>> Il giorno 10/mar/2014, alle ore 11:55, Paolo Bragagni <
>>>>> paolo.bragagni at gmail.com> ha scritto:
>>>>>
>>>>>   se intendi nc_staticfilecache ma l'ho disattivata qualche tempo fa
>>>>> perche a
>>>>>
>>>>>  volte qualche pagina non andava.
>>>>>> ho visto che disattivandola tutto tornava ok, cosi l'ho tolta.
>>>>>>
>>>>>> sto provando a controllare il mysql ma sembra tutto ok.
>>>>>>
>>>>>> ora provo a replicare il server e disabilitare qualche estensione tipo
>>>>>> l'indicizzazione ecc.. ma mi sa che non ci cavo niente..
>>>>>>
>>>>>>
>>>>>> Il giorno 10 marzo 2014 11:43, Mauro Lorenzutti <
>>>>>> mauro.lorenzutti at webformat.com> ha scritto:
>>>>>>
>>>>>>   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
>>>>>>
>>>>>>  _______________________________________________
>>>>> 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
>>>>
>>>>
>>> --
>>> ------------------------------------------------------------
>>>          Inter at zioni            Interazioni di Antonio Nati
>>>     http://www.interazioni.it      tonix at interazioni.it
>>> ------------------------------------------------------------
>>>
>>> _______________________________________________
>>> 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
>>
>
>
> --
> ------------------------------------------------------------
>         Inter at zioni            Interazioni di Antonio Nati
>    http://www.interazioni.it      tonix at interazioni.it
> ------------------------------------------------------------
>
> _______________________________________________
> TYPO3-UG-Italy mailing list
> TYPO3-UG-Italy at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-ug-italy
>


More information about the TYPO3-UG-Italy mailing list