- 🇺🇸United States sunil jolapara 3265 Summitrun Drive, Independence, KY, 41051
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);
# User@Host: mystore[mystore] @ web16.intermesh.net [74.84.132.228]
# Query_time: 3.412435 Lock_time: 0.000076 Rows_sent: 0 Rows_examined: 1
SET timestamp=1349936230;
UPDATE sessions SET uid = 1, cache = 0, hostname = '115.111.169.126', session = 'node_overview_filter|a:0:{}', timestamp = 1349936227 WHERE sid = '4v9bnbjm60bgp8d2uirjdh6lk7';
# User@Host: mystore[mystore] @ web16.intermesh.net [74.84.132.228]
# Query_time: 4.725942 Lock_time: 0.000039 Rows_sent: 0 Rows_examined: 1
use test_sourcing;
SET timestamp=1349937022;
UPDATE sessions SET uid = 1, cache = 0, hostname = '115.111.169.126', session = 'node_overview_filter|a:0:{}', timestamp = 1349937018 WHERE sid = '4bd8infj93e0lcrvd838ei2031';
Closed: duplicate
Code