Salve,
Oggi mi e arrivata una mail dal hosting che uso.
"il suo dominio www.miosito.com crea problemi a livello di servizio mysql,in particolare il problema è causato dall'esecuzione di query continue..."Ed alcuni dati riportati sotto:
# Query_time: 12.544375 Lock_time: 0.000111 Rows_sent: 0 Rows_examined: 87275 Rows_affected: 0 Rows_read: 1
SELECT g.* FROM bla_core_acl_aro_groups AS g INNER JOIN bla_core_acl_groups_aro_map AS gm ON gm.group_id = g.id INNER JOIN bla_core_acl_aro AS ao ON ao.id = gm.aro_id WHERE ao.value='62' ORDER BY g.id;
# Query_time: 14.425694 Lock_time: 0.000094 Rows_sent: 0 Rows_examined: 87272 Rows_affected: 0 Rows_read: 1
SELECT g.* FROM bla_core_acl_aro_groups AS g INNER JOIN bla_core_acl_groups_aro_map AS gm ON gm.group_id = g.id INNER JOIN bla_core_acl_aro AS ao ON ao.id = gm.aro_id WHERE ao.value='62' ORDER BY g.id;
# Query_time: 2.234158 Lock_time: 0.000136 Rows_sent: 0 Rows_examined: 2857 Rows_affected: 0 Rows_read: 2
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug FROM bla_content AS a LEFT JOIN bla_content_frontpage AS f ON f.content_id = a.id INNER JOIN bla_categories AS cc ON cc.id = a.catid INNER JOIN bla_sections AS s ON s.id = a.sectionid WHERE ( a.state = 1 AND s.id > 0 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-11-01 21:03:17' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-11-01 21:03:17' ) AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND (s.id=5 OR s.id=6 OR s.id=7 OR s.id=13) AND s.published = 1 AND cc.published = 1;
Ho il sito online da 1 anno e non ho mai avuto problemi. Non ho niente di strano installato. Uso Joomla 1.6.21 e Jomcosial 1.6.x
Sinceramente non riesco a capire cosa provoca il loop?!
Chiedo gentilmente se qualcuno mi puo aiutare.
Grazie
