{"id":1384741,"date":"2017-11-16T08:50:26","date_gmt":"2017-11-16T16:50:26","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/slow-queries-in-database\/"},"modified":"2017-11-16T08:50:26","modified_gmt":"2017-11-16T16:50:26","slug":"slow-queries-in-database","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/slow-queries-in-database\/","title":{"rendered":"Slow Queries in Database"},"content":{"rendered":"

I was having problems with my website and one of the things siteground has discovered is that Events Calander Pro is causing at least 1,300 cases of slow queries in the past 24 hours and they advised that I reach out to you for help. Here is part of what they sent me.<\/p>\n

also found the following slow queries in the databases hosted under this account:
\nCode:
\n=== TOP 10 of 1330 (total) Slow Queries for the past 24 hours ==========
\n1. Executed 8m 17s ago for 13.357306 sec on Database –> chatha90_chat
\nDate: 2017-11-03 10:54:52 Query_time: 13.357306 Rows_examined: 17593: Rows_sent 17593 Lock_time: 0.000000
\n# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT \/*!40001 SQL_NO_CACHE *\/ * FROM wp_7jqkcqbv9v_options<\/code>;
\n———————————————————————————————————
\n2. Executed 21h 30m 52s ago for 8.086035 sec on Database –> chatha90_chat
\nDate: 2017-11-02 13:32:17 Query_time: 8.086035 Rows_examined: 17297: Rows_sent 1340 Lock_time: 0.004299
\n# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_7jqkcqbv9v_options WHERE autoload = ‘yes’;
\n——————————————————————————————————-
\n3. Executed 21h 30m 46s ago for 6.936295 sec on Database –> chatha90_chat
\nDate: 2017-11-02 13:32:23 Query_time: 6.936295 Rows_examined: 17297: Rows_sent 1340 Lock_time: 0.000262
\n# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_7jqkcqbv9v_options WHERE autoload = ‘yes’;
\n——————————————————————————————————-
\n4. Executed 10h 28m 3s ago for 6.79388 sec on Database –> chatha90_chat
\nDate: 2017-11-03 00:35:06 Query_time: 6.793880 Rows_examined: 17579: Rows_sent 1176 Lock_time: 0.000116
\n# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_7jqkcqbv9v_options WHERE autoload = ‘yes’;
\n——————————————————————————————————-
\n5. Executed 13h 47m 6s ago for 6.543383 sec on Database –> Unknown (NOT FOUND \/ DELETED)
\nDate: 2017-11-02 21:16:03 Query_time: 6.543383 Rows_examined: 17436: Rows_sent 1172 Lock_time: 0.000166
\n# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_7jqkcqbv9v_options WHERE autoload = ‘yes’;
\n——————————————————————————————————-
\n6. Executed 13h 47m 6s ago for 6.54152 sec on Database –> Unknown (NOT FOUND \/ DELETED)
\nDate: 2017-11-02 21:16:03 Query_time: 6.541520 Rows_examined: 17436: Rows_sent 1172 Lock_time: 0.000196
\n# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_7jqkcqbv9v_options WHERE autoload = ‘yes’;
\n——————————————————————————————————-
\n7. Executed 15h 15m 11s ago for 6.155182 sec on Database –> chatha90_chat
\nDate: 2017-11-02 19:47:58 Query_time: 6.155182 Rows_examined: 17352: Rows_sent 1158 Lock_time: 0.023026
\n# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_7jqkcqbv9v_options WHERE autoload = ‘yes’;
\n——————————————————————————————————-
\n8. Executed 14h 2m 52s ago for 5.886644 sec on Database –> chatha90_chat
\nDate: 2017-11-02 21:00:17 Query_time: 5.886644 Rows_examined: 17421: Rows_sent 1171 Lock_time: 0.050135
\n# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_7jqkcqbv9v_options WHERE autoload = ‘yes’;
\n——————————————————————————————————-
\n9. Executed 16h 20m 59s ago for 5.749731 sec on Database –> chatha90_chat
\nDate: 2017-11-02 18:42:10 Query_time: 5.749731 Rows_examined: 17267: Rows_sent 1155 Lock_time: 0.000063
\n# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_7jqkcqbv9v_options WHERE autoload = ‘yes’;
\n——————————————————————————————————-
\n10. Executed 21h 58m 3s ago for 5.746756 sec on Database –> Unknown (NOT FOUND \/ DELETED)
\nDate: 2017-11-02 13:05:06 Query_time: 5.746756 Rows_examined: 17297: Rows_sent 1340 Lock_time: 0.000118
\n# Schema: chatha90_chat Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_7jqkcqbv9v_options WHERE autoload = ‘yes’;
\n——————————————————————————————————-<\/p>\n","protected":false},"template":"","class_list":["post-1384741","topic","type-topic","status-closed","hentry"],"yoast_head":"\nSlow Queries in Database -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/slow-queries-in-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Slow Queries in Database -\" \/>\n<meta property=\"og:description\" content=\"I was having problems with my website and one of the things siteground has discovered is that Events Calander Pro is causing at least 1,300 cases of slow queries in the past 24 hours and they advised that I reach out to you for help. Here is part of what they sent me. also found […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/slow-queries-in-database\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/slow-queries-in-database\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/slow-queries-in-database\/\",\"name\":\"Slow Queries in Database -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2017-11-16T16:50:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/slow-queries-in-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/slow-queries-in-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/slow-queries-in-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/theeventscalendar.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Topics\",\"item\":\"https:\/\/theeventscalendar.com\/support\/topics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Calendar Products\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Events Calendar PRO\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Slow Queries in Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\",\"url\":\"https:\/\/theeventscalendar.com\/support\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Slow Queries in Database -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/slow-queries-in-database\/","og_locale":"en_US","og_type":"article","og_title":"Slow Queries in Database -","og_description":"I was having problems with my website and one of the things siteground has discovered is that Events Calander Pro is causing at least 1,300 cases of slow queries in the past 24 hours and they advised that I reach out to you for help. Here is part of what they sent me. also found […]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/slow-queries-in-database\/","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/slow-queries-in-database\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/slow-queries-in-database\/","name":"Slow Queries in Database -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2017-11-16T16:50:26+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/slow-queries-in-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/slow-queries-in-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/slow-queries-in-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/theeventscalendar.com\/support\/"},{"@type":"ListItem","position":2,"name":"Topics","item":"https:\/\/theeventscalendar.com\/support\/topics\/"},{"@type":"ListItem","position":3,"name":"Calendar Products","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/"},{"@type":"ListItem","position":4,"name":"Events Calendar PRO","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/"},{"@type":"ListItem","position":5,"name":"Slow Queries in Database"}]},{"@type":"WebSite","@id":"https:\/\/theeventscalendar.com\/support\/#website","url":"https:\/\/theeventscalendar.com\/support\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1384741","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1384741\/revisions"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1384741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}