[TYPO3-UG Italy] 100%cpu

Tonix - Antonio Nati tonix at interazioni.it
Mon Mar 10 14:10:14 CET 2014 

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
------------------------------------------------------------

More information about the TYPO3-UG-Italy mailing list