Ciao a tutti,
stamani il fornitore di hosting a messo offline il mio sito a causa di un eccesso di traffico sul server database.
Mi ha inviato anche un esempio di query che crea problemi, dicendomi che se risolvo il probblema possono riattivare il servizio, altrimenti devo optare per un server dedicato.
A qualcuno di voi è successo qualcosa del genere ed ha trovato la soluzione?
Ho migrato il sito da joomla! 1.5 ad 1.7 da un paio di mesi. La 1.7 si è mostrata fin da subito meno reattiva della 1.5, in particolare quando gira in locale.
Di seguito un esempio di query "incriminata":
# Time: 110907 11:33:20
# User@Host: xxx[xxx] @ localhost []
# Query_time: 14.762479 Lock_time: 0.647521 Rows_sent: 5 Rows_examined: 73412
SET timestamp=1315388000;
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM j16_content AS a
LEFT JOIN j16_content_frontpage AS fp ON fp.content_id = a.id
LEFT JOIN j16_categories AS c ON c.id = a.catid
LEFT JOIN j16_users AS ua ON ua.id = a.created_by
LEFT JOIN j16_users AS uam ON uam.id = a.modified_by
LEFT JOIN j16_contact_details AS contact on contact.user_id = a.created_by
LEFT JOIN j16_categories as parent ON parent.id = c.parent_id
LEFT JOIN j16_content_rating AS v ON a.id = v.content_id
LEFT OUTER JOIN (SELECT cat.id as id FROM j16_categories AS cat JOIN j16_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id
WHERE a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2011-09-07 09:33:05') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2011-09-07 09:33:05')
ORDER BY a.created DESC LIMIT 0, 5;
