[TYPO3-UG Italy] 100%cpu

Tonix - Antonio Nati tonix at interazioni.it
Mon Mar 10 12:59:46 CET 2014 

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

More information about the TYPO3-UG-Italy mailing list