After having set our website with events-calendar and events-calendar Pro, we published our website online: laguiago.com
\nDays after we received an email from our host provider talking about host abuse on the part of our database website:<\/p>\n
“Your database laguiagogfburgos installed on mysql55-16.bdb
\nis generating a lot of slow queries, slowing down the MySQL
\nserver and impacting other customers.<\/p>\n
A lot of this kind of queries have been found in our logs:
\n# Time: 151001 7:16:22
\nRows_examined: 516811
\nSET timestamp=1443676582;
\nSELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*,
\nMIN(wp_postmeta.meta_value) as EventStartDate,
\ntribe_event_end_date.meta_value as EventEndDate FROM
\nwp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID =
\nwp_postmeta.post_id ) LEFT JOIN wp_postmeta AS mt1 ON (
\nwp_posts.ID = mt1.post_id ) LEFT JOIN wp_postmeta AS mt2
\nON (wp_posts.ID = mt2.post_id AND mt2.meta_key =
\n‘_EventHideFromUpcoming’ ) LEFT JOIN wp_postmeta as
\ntribe_event_end_date ON ( wp_posts.ID =
\ntribe_event_end_date.post_id AND
\ntribe_event_end_date.meta_key = ‘_EventEndDate’ ) WHERE
\n1=1 AND wp_posts.ID NOT IN (400137) AND (
\n wp_postmeta.meta_key = ‘_EventStartDate’
\n AND
\n ( mt1.meta_key = ‘_EventStartDate’ AND
\nCAST(mt1.meta_value AS DATETIME) < ‘2015-10-03 08:00:00’ )
\n AND
\n mt2.post_id IS NULL
\n) AND wp_posts.post_type = ‘tribe_events’ AND
\n(wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID
\nORDER BY EventStartDate DESC LIMIT 0, 1;”<\/p>\n
What could be happening??? When are these processes launched?
\nAny solution? We need it fixed urgently, because our host is threatening us with closing our database…<\/p>\n
Thanks in advance.<\/p>\n","protected":false},"template":"","class_list":["post-1012138","topic","type-topic","status-closed","hentry"],"yoast_head":"\n