[TYPO3-UG Italy] 100%cpu

Paolo Bragagni paolo.bragagni at gmail.com
Mon Mar 10 13:49:01 CET 2014 

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
>

More information about the TYPO3-UG-Italy mailing list