The below queries taking more time time execute in db i want to know to why these are executing.if these are executing also then taking more time.can we stop to execute these queries due to that my site is always going down on frequent basis.kindly provide anybody solution on priority basis.

Query_time: 30.124537

INSERT INTO cache_category (cid, data, created, expire, headers, serialized) VALUES ('gcmenu_tree_all_dataprimary-links:3777::anonymous user', 'a:1:{s:53:\"cmenu_tree_all_dataprimary-links:3777::anonymous user\";s:37455:\"a:8:{s:17:\"49950 Apparel 274\";a:2:{s:4:\"link\";a:40:{s:14:\"load_functions\";s:26:\"a:1:{i:1;s:9:\"node_load\";}\";s:16:\"to_arg_functions\";s:0:\"\";s:15:\"access_callback\";s:11:\"node_access\";s:16:\"access_arguments\";s:29:\"a:2:{i:0;s:4:\"view\";i:1;i:1;}\";s:13:\"page_callback\";s:14:\"node_page_view\";s:14:\"page_arguments\";s:14:\"a:1:{i:0;i:1;}\";s:5:\"title\";s:7:\"Apparel\";s:14:\"title_callback\";s:15:\"node_page_title\";s:15:\"title_arguments\";s:14:\"a:1:{i:0;i:1;}\";s:4:\"type\";s:1:\"4\";s:11:\"description\";s:0:\"\";s:9:\"menu_name\";s:13:\"primary-links\";s:4:\"mlid\";s:3:\"274\";s:4:\"plid\";s:1:\"0\";s:9:\"link_path\";s:6:\"node/4\";s:11:\"router_path\";s:6:\"node/%\";s:10:\"link_title\";s:7:\"Apparel\";s:7:\"options\";a:0:{}s:6:\"module\";s:13:\"category_menu\";s:6:\"hidden\";s:1:\"0\";s:8:\"external\";s:1:\"0\";s:12:\"has_children\";s:1:\"1\";s:8:\"expanded\";s:1:\"1\";s:6:\"weight\";s:3:\"-50\";s:5:\"depth\";s:1:\"1\";s:10:\"customized\";s:1:\"1\";s:2:\"p1\";s:3:\"274\";s:2:\"p2\";s:1:\"0\";s:2:\"p3\";s:1:\"0\";s:2:\"p4\";s:1:\"0\";s:2:\"p5\";s:1:\"0\";s:2:\"p6\";s:1:\"0\";s:2:\"p7\";s:1:\"0\";s:2:\"p8\";s:1:\"0\";s:2:\"p9\";s:1:\"0\";s:7:\"updated\";s:1:\"0\";s:15:\"in_active_trail\";b:0;s:6:\"access\";b:1;s:4:\"href\";s:6:\"node/4\";s:17:\"localized_options\";a:0:{}}s:5:\"below\";b:0;}s:20:\"49951 Automotive 301\";a:2:{s:4:\"link\";a:40:{s:14:\"load_functions\";s:26:\"a:1:{i:1;s:9:\"node_load\";}\";s:16:\"to_arg_functions\";s:0:\"\";s:15:\"access_callback\";s:11:\"node_access\";s:16:\"access_arguments\";s:29:\"a:2:{i:0;s:4:\"view\";i:1;i:1;}\";s:13:\"page_callback\";s:14:\"node_page_view\";s:14:\"page_arguments\";s:14:\"a:1:{i:0;i:1;}\";s:5:\"title\";s:10:\"Automotive\";s:14:\"title_callback\";s:15:\"node_page_title\";s:15:\"title_arguments\";s:14:\"a:1:{i:0;i:1;}\";s:4:\"type\";s:1:\"4\";s:11:\"description\";s:0:\"\";s:9:\"menu_name\";s:13:\"primary-links\";s:4:\"mlid\";s:3:\"301\";s:4:\"plid\";s:1:\"0\";s:9:\"link_path\";s:7:\"node/19\";s:11:\"router_path\";s:6:\"node/%\";s:10:\"link_title\";s:10:\"Automotive\";s:7:\"options\";a:0:{}s:6:\"module\";s:13:\"category_menu\";s:6:\"hidden\";s:1:\"0\";s:8:\"external\";s:1:\"0\";s:12:\"has_children\";s:1:\"1\";s:8:\"expanded\";s:1:\"1\";s:6:\"weight\";s:3:\"-49\";s:5:\"depth\";s:1:\"1\";s:10:\"customized\";s:1:\"1\";s:2:\"p1\";s:3:\"301\";s:2:\"p2\";s:1:\"0\";s:2:\"p3\";s:1:\"0\";s:2:\"p4\";s:1:\"0\";s:2:\"p5\";s:1:\"0\";s:2:\"p6\";s:1:\"0\";s:2:\"p7\";s:1:\"0\";s:2:\"p8\";s:1:\"0\";s:2:\"p9\";s:1:\"0\";s:7:\"updated\";s:1:\"0\";s:15:\"in_active_trail\";b:0;s:6:\"access\";b:1;s:4:\"href\";s:7:\"node/19\";s:17:\"localized_options\";a:0:{}}s:5:\"below\";b:0;}s:21:\"49952 Engineering 288\";a:2:{s:4:\"link\";a:40:{s:14:\"load_functions\";s:26:\"a:1:{i:1;s:9:\"node_load\";}\";s:16:\"to_arg_functions\";s:0:\"\";s:15:\"access_callback\";s:11:\"node_access\";s:16:\"access_arguments\";s:29:\"a:2:{i:0;s:4:\"view\";i:1;i:1;}\";s:13:\"page_callback\";s:14:\"node_page_view\";s:14:\"page_arguments\";s:14:\"a:1:{i:0;i:1;}\";s:5:\"title\";s:11:\"Engineering\";s:14:\"title_callback\";s:15:\"node_page_title\";s:15:\"title_arguments\";s:14:\"a:1:{i:0;i:1;}\";s:4:\"type\";s:1:\"4\";s:11:\"description\";s:0:\"\";s:9:\"menu_name\";s:13:\"primary-links\";s:4:\"mlid\";s:3:\"288\";s:4:\"plid\";s:1:\"0\";s:9:\"link_path\";s:7:\"node/12\";s:11:\"router_path\";s:6:\"node/%\";s:10:\"link_title\";s:11:\"Engineering\";s:7:\"options\";a:0:{}s:6:\"module\";s:13:\"category_menu\";s:6:\"hidden\";s:1:\"0\";s:8:\"external\";s:1:\"0\";s:12:\"has_children\";s:1:\"1\";s:8:\"expanded\";s:1:\"1\";s:6:\"weight\";s:3:\"-48\";s:5:\"depth\";s:1:\"1\";s:10:\"customized\";s:1:\"1\";s:2:\"p1\";s:3:\"288\";s:2:\"p2\";s:1:\"0\";s:2:\"p3\";s:1:\"0\";s:2:\"p4\";s:1:\"0\";s:2:\"p5\";s:1:\"0\";s:2:\"p6\";s:1:\"0\";s:2:\"p7\";s:1:\"0\";s:2:\"p8\";s:1:\"0\";s:2:\"p9\";s:1:\"0\";s:7:\"updated\";s:1:\"0\";s:15:\"in_active_trail\";b:0;s:6:\"access\";b:1;s:4:\"href\";s:7:\"node/12\";s:17:\"localized_options\";a:0:{}}s:5:\"below\";b:0;}s:17:\"49953 Medical 300\";a:2:{s:4:\"link\";a:40:{s:14:\"load_functions\";s:26:\"a:1:{i:1;s:9:\"node_load\";}\";s:16:\"to_arg_functions\";s:0:\"\";s:15:\"access_callback\";s:11:\"node_access\";s:16:\"access_arguments\";s:29:\"a:2:{i:0;s:4:\"view\";i:1;i:1;}\";s:13:\"page_callback\";s:14:\"node_page_view\";s:14:\"page_arguments\";s:14:\"a:1:{i:0;i:1;}\";s:5:\"title\";s:7:\"Medical\";s:14:\"title_callback\";s:15:\"node_page_title\";s:15:\"title_arguments\";s:14:\"a:1:{i:0;i:1;}\";s:4:\"type\";s:1:\"4\";s:11:\"description\";s:0:\"\";s:9:\"menu_name\";s:13:\"primary-links\";s:4:\"mlid\";s:3:\"300\";s:4:\"plid\";s:1:\"0\";s:9:\"link_path\";s:7:\"node/18\";s:11:\"router_path\";s:6:\"node/%\";s:10:\"link_title\";s:7:\"Medical\";s:7:\"options\";a:0:{}s:6:\"module\";s:13:\"category_menu\";s:6:\"hidden\";s:1:\"0\";s:8:\"external\";s:1:\"0\";s:12:\"has_children\";s:1:\"1\";s:8:\"expanded\";s:1:\"1\";s:6:\"weight\";s:3:\"-47\";s:5:\"depth\";s:1:\"1\";s:10:\"customized\";s:1:\"1\";s:2:\"p1\";s:3:\"300\";s:2:\"p2\";s:1:\"0\";s:2:\"p3\";s:1:\"0\";s:2:\"p4\";s:1:\"0\";s:2:\"p5\";s:1:\"0\";s:2:\"p6\";s:1:\"0\";s:2:\"p7\";s:1:\"0\";s:2:\"p8\";s:1:\"0\";s:2:\"p9\";s:1:\"0\";s:7:\"updated\";s:1:\"0\";s:15:\"in_active_trail\";b:0;s:6:\"access\";b:1;s:4:\"href\";s:7:\"node/18\";s:17:\"localized_options\";a:0:{}}s:5:\"below\";b:0;}s:33:\"49954 Building & Construction 303\";a:2:{s:4:\"link\";a:40:{s:14:\"load_functions\";s:26:\"a:1:{i:1;s:9:\"node_load\";}\";s:16:\"to_arg_functions\";s:0:\"\";s:15:\"access_callback\";s:11:\"node_access\";s:16:\"access_arguments\";s:29:\"a:2:{i:0;s:4:\"view\";i:1;i:1;}\";s:13:\"page_callback\";s:14:\"node_page_view\";s:14:\"page_arguments\";s:14:\"a:1:{i:0;i:1;}\";s:5:\"title\";s:23:\"Building & Construction\";s:14:\"title_callback\";s:15:\"node_page_title\";s:15:\"title_arguments\";s:14:\"a:1:{i:0;i:1;}\";s:4:\"type\";s:1:\"4\";s:11:\"description\";s:0:\"\";s:9:\"menu_name\";s:13:\"primary-links\";s:4:\"mlid\";s:3:\"303\";s:4:\"plid\";s:1:\"0\";s:9:\"link_path\";s:7:\"node/21\";s:11:\"router_path\";s:6:\"node/%\";s:10:\"link_title\";s:23:\"Building & Construction\";s:7:\"options\";a:0:{}s:6:\"

Query_time: 6.132237

INSERT INTO cache_category (cid, data, created, expire, headers, serialized) VALUES ('n3590', 'a:1:{s:25:\"cat_node_get_cats3590:cid\";s:6:\"a:0:{}\";}', 1349934933, 0, '', 1);

Query_time: 10.392684

INSERT INTO cache_category (cid, data, created, expire, headers, serialized) VALUES ('n8331', 'a:1:{s:25:\"cat_node_get_cats8331:cid\";s:6:\"a:0:{}\";}', 1349935101, 0, '', 1);

Query_time: 11.199644
INSERT INTO cache_menu (cid, data, created, expire, headers, serialized) VALUES ('category-menu-trail-links:primary-links:all-cid:6336', 'category-menu-trail-links:primary-links:tree-data:e413fea325d97cafc31d1ce4f0c07910', 1349935101, 0, '', 0);

Comments

Sunil Jolapara’s picture

Status: Active » Closed (duplicate)
Related issues: +#1810984: Category Cache taking more time to excute