My site at www.centurionrunning.com over the last couple of days has experienced extreme slowdown. I've been talking to bluehost (I have a bluehost pro account) and they've directed me (
https://www.bluehost.com/cgi/help/000564) to a mysql_slow_queries log which doesn't seem to show what the problem is. Contents below:
# Fri Sep 2 07:12:50 2011
# Query_time: 4.611636 Lock_time: 0.000110 Rows_sent: 0 Rows_examined: 1
use centuri8_centurionmodx;
UPDATE `modx_menus` SET `parent` = 'components',`action` = 1,`description` = 'quip_desc',`icon` = 'images/icons/plugin.gif',`menuindex` = 0,`params` = '',`handler` = '',`permissions` = '' WHERE `text` = 'quip'
# Fri Sep 2 06:51:07 2011
# Query_time: 2.860000 Lock_time: 0.000085 Rows_sent: 0 Rows_examined: 0
use centuri8_centurionmodx;
INSERT INTO `modx_session` (`id`, `access`, `data`) VALUES ('tgkeu930pol91rkq2doal34go7', 1314967865, 'modx.user.0.attributes|a:1:{s:3:\"web\";a:3:{s:16:\"modAccessContext\";a:1:{s:3:\"web\";a:1:{i:0;a:3:{s:9:\"principal\";i:0;s:9:\"authority\";s:1:\"0\";s:6:\"policy\";a:1:{s:4:\"load\";b:1;}}}}s:22:\"modAccessResourceGroup\";a:0:{}s:17:\"modAccessCategory\";a:0:{}}}modx.user.0.resourceGroups|a:1:{s:3:\"web\";a:0:{}}modx.user.contextTokens|a:0:{}')
# Fri Sep 2 05:01:14 2011
# Query_time: 3.926329 Lock_time: 0.000101 Rows_sent: 0 Rows_examined: 0
use centuri8_centurionmodx;
INSERT INTO `modx_session` (`id`, `access`, `data`) VALUES ('3f2hl753jcsp60e5n4a5bju816', 1314961270, 'modx.user.contextTokens|a:0:{}')
These are ~4 second delays, not the 20+ seconds I'm experiencing when loading pages. The manager is quick so I'm assuming it could be some random snippet that I have coded but the site was running fine and I haven't added any snippets since the slowdown. The modx error log shows some errors with getfeed not parsing an rss feed but this is not on every page load.
I know there's not much to go on which is the reason I'm posting this. How can I debug this and find out what the root of the problem is?
MODX Staff
