OVH Community, your new community space.

Cerco aiuto per lentezza sito


Piter
25.02.2013, 21.34
Citazione Originariamente Scritto da torpado
Il database utilizzato da questo dominio su SQLprivato, prova ad ottimizzare il tuning della configurazione MySQL modificando il file my.cnf

Questa guida ti spiega come procedere :
http://guida.ovh.it/FtpSqlPrivato
Raccomandazioni

Run OPTIMIZE TABLE to defragment tables for better performance
Enable the slow query log to troubleshoot bad queries
Adjust your join queries to always utilize indexes
Increase tmp_table_size (>10M) and max_heap_table_size (>32M)
Increase table_cache gradually to avoid file descriptor limits

my.cnf

join_buffer_size = 4M
tmp_table_size = 20M
max_heap_table_size = 64M
table_open_cache = 1200

General Statistics
validate mysql version
Currently running supported MySQL version 5.1.31
check global stats
Up for: 1d 22h 33m 2s (211K q [1.260 qps], 5K conn, TX: 3B, RX: 52M)
Reads / Writes: 78% / 22%
Storage engine Statistics
check engine
InnoDB enabled
MyISAM enabled
All is fine
check fragmented tables
Total fragmented tables: 102
Security
check databases security
All database users have passwords assigned
Performance Metrics
check memory usage
Total Max buffers: 52.0M global + 3.9M per thread (75 max threads)
Maximum possible memory usage: 342.6M (133% of installed RAM)
Maximum memory used: 83.0M (32% of installed RAM)
check slow queries
Slow queries: 0% (1/211K)
check connections
Highest connection usage: 10% (8/75)
check key buffer
Key buffer size / total MyISAM indexes: 10.0M/40.0M
Key buffer hit rate: 99.9% (1M cached / 2K reads)
All is fine
check query cache
Query cache efficiency: 69.2% (117K cached / 170K selects)
Query cache prunes per day: 2285
All is fine
check sorting
Sorts requiring temporary tables: 0% (0. temp sorts / 12K sorts)
check joins
Joins performed without indexes: 7498
check temporary tables
Temporary tables created on disk: 26% (7K on disk / 29K total)
check thread cache
Thread cache hit rate: 99% (15 created / 5K connections)
check table cache
Table cache hit rate: 6% (600 open / 9K opened)
check open file
Open file limit used: 74% (957/1K)
check table lock
Table locks acquired immediately: 99%
(107K immediate / 107K locks)
check performance option
All is fine

Come posso ottimizzare? Potresti aiutarmi?

torpado
22.02.2013, 09.37
Citazione Originariamente Scritto da Piter
Questi gli errori nel log
...
Il database utilizzato da questo dominio su SQLprivato, prova ad ottimizzare il tuning della configurazione MySQL modificando il file my.cnf

Questa guida ti spiega come procedere :
http://guida.ovh.it/FtpSqlPrivato

Piter
21.02.2013, 16.19
Citazione Originariamente Scritto da torpado
Verifica prima di tutto che non vi siano problemi/errori riportati nei logs :

https://logs.ovh.net/pugliablu.com/
Questi gli errori nel log

[Wed Feb 20 00:31:36 2013] [error] [client 79.2.75.248] [host www.pugliablu.com] Premature end of script headers: index.php, referer: http://www.pugliablu.com/inserisci-g...da-puglia.html
[Wed Feb 20 01:14:30 2013] [error] [client 79.2.75.248] [host www.pugliablu.com] Premature end of script headers: index.php, referer: http://www.pugliablu.com/paesi-puglia.html
[Wed Feb 20 12:27:24 2013] [error] [client 79.2.75.248] [host www.pugliablu.com] Premature end of script headers: index.php, referer: http://www.pugliablu.com/concerti-mu...nica-bari.html
[Wed Feb 20 18:11:54 2013] [error] [client 82.89.142.180] [host www.pugliablu.com] (104)Connection reset by peer: Error reading request entity data, referer: http://www.pugliablu.com/area-riserv...tmpl=component
[Wed Feb 20 18:56:36 2013] [error] [client 95.237.8.223] [host www.pugliablu.com] (104)Connection reset by peer: Error reading request entity data, referer: http://www.pugliablu.com/inserisci-azienda.html
[Wed Feb 20 19:01:36 2013] [error] [client 79.2.75.248] [host www.pugliablu.com] Premature end of script headers: index.php, referer: http://www.pugliablu.com/community.html
[Wed Feb 20 21:53:19 2013] [error] [client 94.23.64.19] [host www.pugliablu.com] Premature end of script headers: index.php, referer: http://www.pugliablu.com/
[Wed Feb 20 21:56:46 2013] [error] [client 94.23.64.19] [host www.pugliablu.com] Premature end of script headers: index.php, referer: http://www.pugliablu.com/
[Wed Feb 20 21:58:24 2013] [error] [client 94.23.64.19] [host www.pugliablu.com] Premature end of script headers: index.php, referer: http://www.pugliablu.com/

torpado
21.02.2013, 15.11
Citazione Originariamente Scritto da Piter
Qualcuno pu aiutarmi a capire da cosa dipenda la lentezza del mio sito?

il sito in questione www.pugliablu.com

Grazie in anticipo
Verifica prima di tutto che non vi siano problemi/errori riportati nei logs :

https://logs.ovh.net/pugliablu.com/

Piter
21.02.2013, 14.55
Qualcuno pu aiutarmi a capire da cosa dipenda la lentezza del mio sito?

il sito in questione www.pugliablu.com

Grazie in anticipo