Hello to all,
Sorry if this is a long post! Spent days searching on forums and handbooks, both with drupal's search feature and using google.
I've been having very bad nightmares recently with my site and after several 16 hour workdays, a migration from a shared hosting environment to a dedicated server and upgrading of all software packages on the server side to their latest versions. The only thing that has not the latest release installed is mysql.
We're using drupal 4.6.6 with mysql 4.1 and php 4.4.2 on a site with approx 300 taxonomy terms, 5 vocabularies and about 2000 nodes so far. It might be one of the modules I was using, since the site was originally implemented using 4.6.3 and then upgraded to the next versions.
What seems to be lagging is the mysql server. The site is hosted on a dedicated server, along with some other drupal sites which use minimal resources (seperate installations). The server runs on Redhat enterprise 3 and is manageable via a plesk control panel. I haven't got enough experience to ssh into the server and alter the mysql configuration, but my hosting's support is helpful and can make any alterations required.
The homepage has proven to be one of the heaviest pages. It runs one query and prints the 30 latest results it finds from the node table. Also all categories and nodes have an automatic path created for them through pathauto. There was an isssue about the pathauto module slowing the server and I installed a patched version which was supposed to fix that in 4.6.6.
The site is syndicated by many others on the web and when a new story is out, the server kneels down. With a pentium 4 dual core cpu running at 2.8 Ghz and 1 Gb of ram, it seems unheard of to me to have these type of performance issues with a 2500 nodes site. I've spent days trying to reconfigure/re-install modules and the core setup, including doing a clean install and importing all the data into the new database.
One other thing that I suspect it might be causing trouble is that mysql by default sets the default collation and character set as latin1_swedish_ci. It therefore needs to convert to and from UTF8 in order to insert and retrieve data from the database. Then again for a 2500 pages site it shouldn't be much of a problem I reckon.. However I will re-create the database using utf8.
I am totally stuck basically and also at 6 (gmt) in the morning tomorrow my flight to Greece takes off, so I won't be able to answer quickly from that time. But anyone who has any ideas that might help solve my problems would be greatly appreciated. The site is expected to have much much more traffic during the tournament it covers, so solving this issue now is crucial.
Also I am holding the upgrade to 4.7 until a stable release is out, as this is a very crucial project for me. The url is http://www.worldcuplatest.com, although I don't think you can make much by visiting it. The server slows down when we publish a new story, as loads of robots grab our xml feed and many people come on the site in the first 15 minutes of the story getting posted.
Regards,
Pavlos Skoufis
Comments
pathauto
You should have enough memory.
The pathauto patch for 4.6 may not have been stress-tested. Can you try turning it off?
-----
Drupal ecommerce, at www.drupalecommerce.com is a new site written using language that Drupal beginners and intermediate users can understand. It has about 300 unfinished pages. 2 tutorials for views module under "Modules"
I just did... There isn't
I just did... There isn't much traffic at the site, but can see that CPU goes up to 98% again when I refresh the homepage.
the url aliasing patch is
the url aliasing patch is essential for 4.6 sites that have many paths. don't disable it. it is battle tested. i aqssume you did obvious stuff like enabling page cache and disabling non critical modules. after that you need to dive into the code and see what is consuming all that CPU. Consider using xdebug or other benchmarking tool.
Yep... tried to uninstall
Yep... tried to uninstall all the non-essential and some essential ones, like the taxonomy association which is used on about 100 category pages. My host are trying a mysql monitoring program and will come back to me later on. With or without cache the same thing happens. I also tried it by deleting the modules from the modules directory.
What kernel number are you
What kernel number are you using? You need 2.6...
Which version of apache? Ver2.0 has problems. Best to stick with 1.3...
Will check and come back to
Will check and come back to you on this, cause I am not sure...
2.6 Kernel, 2.0 Apache
2.6 Kernel, 2.0 Apache
Ask your ISP to install
Ask your ISP to install apache 1.3. During the last Canadian Federal election, our client site (ndp.ca) was struggling until we replaced 2.0 with 1.3. I don't know the details, but 2.0 isn't ready for prime time.
Unfortunately this is
Unfortunately this is impossible as it is not supported by Plesk (as I was told)..
Tuning apache may be your
Tuning apache may be your only option. I'm not a sys admin so no I have no concrete advise.
This discussion may offer some help:
http://wooga.drbacchus.com/wordpress/?p=844
Interesting read... But I am
Interesting read... But I am not that confident with doing that... I mean a few months back with around 800 nodes in the database and about 50 categories it was working like a treat. With Apache 2 and mysql 3.23.58.
Basically the problem is definitely mysql related. Some queries create server load.
Also
I remember some of the performance guys mentioning that switching the MySQL to use InnoDB, brief mention here: http://drupal.org/node/51263 you might search the development list archives for mention of that as well.
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide
I have to say thanks a
I have to say thanks a million to all of you for the quick responses!
Some Drupal settings to check
These are relatively simple, but if you do not pay attention to them they could cause the slowness:
- Are you using caching? If you enable caching, Drupal willnot have to run all the SQL calls every time that a page is requested (especially for anonymous visitors who are essentially asking for static content)
- As a tempporary fix, you can enable the Throttle module (comes with Drupal core) and cap the less important modules to throttle at a certain % so that the server can run fast for the basic/important functions and only compromise users asking for highly custom and mySQL intensive content. You could also use throttle on a continuing basis to zero-in on the trouble-make and really give it low priority so that it only works when the server load is low.
- If you have the banner module running, remember to enable caching for it, otherwise I have seem it make a server crawl
If my leads are valuable, you can get faster responses from me by using the contact us form on our website (link below)
I am also the sole go-to guy for the Drupal apps so I know what it feels like. You can ask me any questions you may need opinion on.
-----
iDonny - Web CMS Development, Design, and Web Marketing Advice
Thanks for the tips, but I
Thanks for the tips, but I have already tried those. Very frustrating...
Slow Query Logging
If you suspect one installed module uses an unoptimized query and want to find out that specific query, it is possible to do so by enabling MySQL's Slow Query Log. This can be extremely helpful for identifiying queries that don't use indexes, but requires a (temporary) change of the MySQL server configuration. Since the log grows very fast, this option should be used for a very short time only on a production server, say 10 - 15 minutes.
You can get more information here:
http://dev.mysql.com/doc/refman/4.1/en/slow-query-log.html
(I'm talking about the --log-queries-not-using-indexes (4.1+) option here.)
Another question is, if you get your hoster to enable this log on a shared environment, since this will log per server, not per customer, AFAIR.
EDIT: Of yourse you could as well log a dump of your site on a development server instead of production...
Good luck!
--
Stefan M. Kudwien
unleashedmind.com
-Stefan
Thanks for the tip Stefan...
Thanks for the tip Stefan... Will do that to see what is causing it... Generally during high load times I can see that the node pages load kinda quick as compared to the homepage and the category pages which take considerably longer. I am like 99% sure that the problem lies when there are queries involved which go through the entire node/url_alias tables.
You may also want to install
You may also want to install the devel module. I believe it has some tools that can help you identify query's run and page generation times as well. It may be that you have a bad SQL query somewhere.
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide
Great tool! Basically there
Great tool!
Basically there are errors in the configuration and Steven thanks so much for pointing that out.
I am very puzzled here. There are 2 queries which deal with the cache table that take more than 5.5 seconds to load. They are also huge queries and from what I can see it they take more than 5.5 seconds each to load.
The one starts like:
UPDATE cache SET data = 'a:3:{s:10:\"path index\";a:534:{s:0:\"\";s:4:\"1075\";s:16:\"admin/aggregator\";s:3:\"116\";s:26:\"admin/aggregator/edit/feed\";i:-3;s:30:\"admin/aggregator/edit/category\";i:-4;s:23:\"admin/aggregator/remove\";i:-5;s:23:\"admin/aggregator/update\";i:-6;s:21:\"admin/aggregator/list\";i:-7;s:25:\"admin/aggregator/add/feed\";i:-8;s:29:\"admin/aggregator/add/category\";i:-9;s:10:\"aggregator\";s:3:\"117\";s:18:\"aggregator/sources\";s:3:\"118\";s:21:\"aggregator/categories\";s:3:\"119\";s:20:\"aggregator/sources/2\";s:3:\"162\";s:25:\"aggregator/sources/2/view\";i:-14;s:31:\"aggregator/sources/2/categorize\";i:-15;s:30:\"aggregator/sources/2/configure\";i:-16;s:20:\"aggregator/sources/1\";s:3:\"161\";s:25:\"aggregator/sources/1/view\";i:-18;s:31:\"aggregator/sources/1/categorize\";i:-19;s:30:\"aggregator/sources/1/configure\";i:-20;s:20:\"aggregator/sources/3\";s:3:\"163\";s:25:\"aggregator/sources/3/view\";i:-22;s:31:\"aggregator/sources/3/categorize\";i:-23;s:30:\"aggregator/sources/3/configure\";i:-24;s:20:\"aggregator/sources/4\";s:3:\"164\";s:25:\"aggregator/sources/4/view\";i:-26;s:31:\"aggregator/sources/4/categorize\";i:-27;s:30:\"aggregator/sources/4/configure\";i:-28;s:23:\"aggregator/categories/1\";s:3:\"160\";s:28:\"aggregator/categories/1/view\";i:-30;s:34:\"aggregator/categories/1/categorize\";i:-31;s:33:\"aggregator/categories/1/configure\";i:-32;s:15:\"aggregator/opml\";i:-33;s:9:\"atom/feed\";i:-34;s:11:\"admin/block\";s:1:\"2\";s:16:\"admin/block/list\";i:-36;s:21:\"admin/block/configure\";i:-37;s:18:\"admin/block/delete\";i:-38;s:15:\"admin/block/add\";i:-39;s:21:\"admin/logs/useragents\";s:4:\"1055\";s:30:\"admin/logs/useragents/browsers\";s:4:\"1056\";s:30:\"admin/logs/useragents/crawlers\";s:4:\"1057\";s:13:\"admin/comment\";s:1:\"3\";s:18:\"admin/comment/edit\";i:-44;s:20:\"admin/comment/delete\";i:-45;s:18:\"admin/comment/list\";i:-46;s:23:\"admin/comment/configure\";i:-47;s:22:\"admin/comment/list/new\";i:-48;s:27:\"admin/comment/list/approval\";i:-49;s:32:\"admin/comment/configure/settings\";i:-50;s:30:\"admin/comment/configure/matrix\";i:-51;s:34:\"admin/comment/configure/thresholds\";i:-52;s:29:\"admin/comment/configure/roles\";i:-53;s:29:\"admin/comment/configure/votes\";i:-54;s:12:\"comment/edit\";i:-55;s:7:\"comment\";i:-56;s:9:\"delicious\";s:4:\"1151\";s:13:\"delicious/tag\";i:-58;s:14:\"delicious/user\";i:-59;s:24:\"admin/settings/delicious\";s:4:\"1153\";s:15:\"admin/delicious\";s:4:\"1152\";s:20:\"admin/delicious/view\";i:-62;s:19:\"admin/delicious/add\";i:-63;s:20:\"admin/delicious/edit\";i:-64;s:16:\"user/1/delicious\";i:-65;s:17:\"devel/cache/clear\";s:4:\"1165\";s:14:\"devel/variable\";s:4:\"1166\";s:12:\"devel/switch\";i:-68;s:8:\"feedback\";s:1:\"4\";s:13:\"admin/filters\";s:1:\"5\";s:20:\"admin/filters/delete\";i:-71;s:11:\"filter/tips\";s:1:\"6\";s:16:\"admin/flexiblock\";s:3:\"122\";s:21:\"admin/flexiblock/list\";i:-74;s:22:\"admin/flexiblock/debug\";i:-75;s:7:\"forward\";i:-76;s:13:\"admin/forward\";s:4:\"1159\";s:9:\"gmapmacro\";s:4:\"1073\";s:8:\"gsitemap\";i:-79;s:14:\"node/add/image\";s:1:\"8\";s:5:\"image\";s:1:\"9\";s:10:\"image/view\";i:-82;s:11:\"admin/image\";s:2:\"10\";s:16:\"admin/image/list\";i:-84;s:15:\"admin/image/add\";i:-85;s:14:\"img_assist/add\";i:-86;s:14:\"img_assist/gen\";i:-87;s:15:\"img_assist/load\";i:-88;s:20:\"img_assist/add/image\";i:-89;s:20:\"admin/settings/legal\";s:3:\"125\";s:13:\"node/add/mail\";s:3:\"126\";s:7:\"members\";s:3:\"127\";s:10:\"admin/menu\";s:2:\"15\";s:20:\"admin/menu/item/edit\";i:-94;s:21:\"admin/menu/item/reset\";i:-95;s:23:\"admin/menu/item/disable\";i:-96;s:22:\"admin/menu/item/delete\";i:-97;s:15:\"admin/menu/list\";i:-98;s:19:\"admin/menu/menu/add\";i:-99;s:19:\"admin/menu/item/add\";i:-100;s:16:\"admin/menu/reset\";i:-101;s:10:\"admin/node\";s:2:\"16\";s:17:\"admin/node/action\";i:-103;s:19:\"admin/node/overview\";i:-104;s:20:\"admin/node/configure\";i:-105;s:29:\"admin/node/configure/settings\";i:-106;s:26:\"admin/node/configure/types\";i:-107;s:4:\"node\";s:2:\"17\";s:8:\"node/add\";s:2:\"18\";s:13:\"node/add/page\";s:2:\"19\";s:10:\"admin/path\";s:2:\"20\";s:15:\"admin/path/edit\";i:-112;s:17:\"admin/path/delete\";i:-113;s:15:\"admin/path/list\";i:-114;s:14:\"admin/path/add\";i:-115;s:7:\"profile\";s:3:\"130\";s:22:\"admin/settings/profile\";s:3:\"131\";s:26:\"admin/settings/profile/add\";i:-118;s:27:\"admin/settings/profile/edit\";i:-119;s:29:\"admin/settings/profile/delete\";i:-120;s:35:\"profile_pages/profile_national_team\";i:-121;s:26:\"profile_pages/profile_club\";i:-122;s:26:\"profile_pages/profile_name\";i:-123;s:29:\"profile_pages/profile_surname\";i:-124;s:25:\"profile_pages/profile_url\";i:-125;s:12:\"admin/sanity\";s:4:\"1149\";s:19:\"node/add/simplenews\";s:4:\"1032\";s:16:\"admin/simplenews\";s:4:\"1033\";s:21:\"admin/simplenews/sent\";i:-129;s:23:\"admin/simplenews/outbox\";i:-130;s:22:\"admin/simplenews/types\";i:-131;s:27:\"admin/simplenews/types/list\";i:-132;s:26:\"admin/simplenews/types/add\";i:-133;s:22:\"admin/simplenews/users\";i:-134;s:27:\"admin/simplenews/users/list\";i:-135;s:26:\"admin/simplenews/users/add\";i:-136;s:29:\"admin/simplenews/users/export\";i:-137;s:25:\"admin/simplenews/settings\";i:-138;s:33:\"admin/simplenews/settings/general\";i:-139;s:18:\"newsletter/confirm\";i:-140;s:24:\"newsletter/subscriptions\";i:-141;s:8:\"sitemenu\";s:2:\"24\";s:23:\"admin/comment/list/spam\";i:-143;s:20:\"admin/node/list/spam\";i:-144;s:10:\"admin/spam\";s:4:\"1127\";s:15:\"admin/spam/logs\";i:-146;s:19:\"admin/spam/comments\";i:-147;s:15:\"admin/spam/node\";i:-148;s:17:\"admin/spam/custom\";i:-149;s:14:\"admin/spam/url\";i:-150;s:21:\"admin/spam/logs/entry\";i:-151;s:4:\"spam\";i:-152;s:15:\"admin/logs/hits\";s:2:\"25\";s:16:\"admin/logs/pages\";s:2:\"26\";s:16:\"admin/logs/users\";s:2:\"27\";s:20:\"admin/logs/referrers\";s:2:\"28\";s:17:\"admin/logs/access\";i:-157;s:14:\"node/add/story\";s:2:\"29\";s:13:\"subscriptions\";s:4:\"1141\";s:19:\"admin/subscriptions\";s:4:\"1142\";s:12:\"system/files\";i:-161;s:11:\"system/test\";i:-162;s:5:\"admin\";s:2:\"30\";s:12:\"admin/themes\";s:2:\"31\";s:19:\"admin/themes/select\";i:-165;s:21:\"admin/themes/settings\";i:-166;s:28:\"admin/themes/settings/global\";i:-167;s:32:\"admin/themes/settings/bluemarine\";i:-168;s:36:\"admin/themes/settings/box_cleanslate\";i:-169;s:30:\"admin/themes/settings/box_grey\";i:-170;s:31:\"admin/themes/settings/chameleon\";i:-171;s:28:\"admin/themes/settings/marvin\";i:-172;s:32:\"admin/themes/settings/pushbutton\";i:-173;s:14:\"admin/settings\";s:2:\"32\";s:22:\"admin/settings/adsense\";s:3:\"133\";s:25:\"admin/settings/aggregator\";s:3:\"134\";s:23:\"admin/settings/browscap\";s:4:\"1023\";s:20:\"admin/settings/devel\";s:4:\"1167\";s:23:\"admin/settings/feedback\";s:2:\"33\";s:22:\"admin/settings/forward\";s:4:\"1028\";s:19:\"admin/settings/gmap\";s:4:\"1074\";s:23:\"admin/settings/gsitemap\";s:4:\"1029\";s:18:\"admin/settings/hof\";s:4:\"1030\";s:20:\"admin/settings/image\";s:2:\"34\";s:25:\"admin/settings/img_assist\";s:2:\"35\";s:19:\"admin/settings/mail\";s:3:\"139\";s:22:\"admin/settings/members\";s:3:\"140\";s:24:\"admin/settings/nodewords\";s:2:\"37\";s:25:\"admin/settings/page_title\";s:4:\"1164\";s:28:\"admin/settings/service_links\";s:4:\"1154\";s:24:\"admin/settings/shortcuts\";s:4:\"1145\";s:23:\"admin/settings/sitemenu\";s:2:\"40\";s:19:\"admin/settings/spam\";s:4:\"1128\";s:25:\"admin/settings/spam_surbl\";s:4:\"1163\";s:25:\"admin/settings/statistics\";s:2:\"41\";s:32:\"admin/settings/statistics_filter\";s:2:\"42\";s:28:\"admin/settings/subscriptions\";s:4:\"1143\";s:31:\"admin/settings/taxonomy_browser\";s:2:\"43\";s:29:\"admin/settings/taxonomy_dhtml\";s:2:\"45\";s:29:\"admin/settings/taxonomy_theme\";s:2:\"47\";s:23:\"admin/settings/throttle\";s:3:\"143\";s:22:\"admin/settings/urllist\";s:4:\"1150\";s:22:\"admin/settings/webform\";s:3:\"144\";s:23:\"admin/settings/xtracker\";s:4:\"1157\";s:13:\"admin/modules\";s:2:\"49\";s:14:\"admin/taxonomy\";s:2:\"50\";s:19:\"admin/taxonomy/list\";i:-208;s:29:\"admin/taxonomy/add/vocabulary\";i:-209;s:30:\"admin/taxonomy/edit/vocabulary\";i:-210;s:33:\"admin/taxonomy/preview/vocabulary\";i:-211;s:23:\"admin/taxonomy/add/term\";i:-212;s:24:\"admin/taxonomy/edit/term\";i:-213;s:13:\"taxonomy/term\";i:-214;s:20:\"admin/taxonomy_assoc\";s:2:\"51\";s:25:\"admin/taxonomy_assoc/edit\";i:-216;s:27:\"admin/taxonomy_assoc/delete\";i:-217;s:25:\"admin/taxonomy_assoc/list\";i:-218;s:24:\"admin/taxonomy_assoc/add\";i:-219;s:16:\"taxonomy_browser\";s:2:\"53\";s:14:\"taxonomy_dhtml\";s:2:\"54\";s:9:\"trackback\";i:-222;s:15:\"admin/trackback\";s:4:\"1155\";s:20:\"admin/trackback/edit\";i:-224;s:20:\"admin/trackback/list\";i:-225;s:25:\"admin/trackback/configure\";i:-226;s:24:\"admin/trackback/list/new\";i:-227;s:29:\"admin/trackback/list/approval\";i:-228;s:34:\"admin/trackback/configure/settings\";i:-229;s:25:\"admin/trackback/list/spam\";i:-230;s:7:\"urllist\";i:-231;s:4:\"user\";i:-232;s:10:\"user/login\";i:-233;s:13:\"user/register\";i:-234;s:13:\"user/password\";i:-235;s:9:\"user/help\";i:-236;s:10:\"admin/user\";s:3:\"112\";s:15:\"admin/user/list\";i:-238;s:17:\"admin/user/create\";i:-239;s:20:\"admin/user/configure\";i:-240;s:12:\"admin/access\";s:3:\"113\";s:24:\"admin/access/permissions\";i:-242;s:18:\"admin/access/roles\";i:-243;s:23:\"admin/access/roles/edit\";i:-244;s:18:\"admin/access/rules\";i:-245;s:23:\"admin/access/rules/list\";i:-246;s:22:\"admin/access/rules/add\";i:-247;s:24:\"admin/access/rules/check\";i:-248;s:23:\"admin/access/rules/edit\";i:-249;s:25:\"admin/access/rules/delete\";i:-250;s:6:\"user/1\";i:-251;s:6:\"logout\";s:3:\"114\";s:10:\"admin/logs\";s:3:\"115\";s:16:\"admin/logs/event\";i:-254;s:16:\"node/add/webform\";s:3:\"151\";s:12:\"webform/done\";i:-256;s:15:\"webform/upgrade\";i:-257;s:7:\"webform\";s:3:\"152\";s:18:\"admin/logs/summary\";s:4:\"1050\";s:16:\"admin/logs/usage\";s:4:\"1051\";s:8:\"xtracker\";s:4:\"1158\";s:12:\"xtracker/all\";i:-262;s:17:\"xtracker/tid/1073\";i:-263;s:17:\"xtracker/tid/1066\";i:-264;s:23:\"xtracker/tid/1067448598\";i:-265;s:17:\"xtracker/tid/1067\";i:-266;s:17:\"xtracker/tid/1071\";i:-267;s:17:\"xtracker/tid/1068\";i:-268;s:17:\"xtracker/tid/1069\";i:-269;s:17:\"xtracker/tid/1070\";i:-270;s:17:\"xtracker/tid/1072\";i:-271;s:23:\"xtracker/tid/1067448545\";i:-272;s:23:\"xtracker/tid/1067448543\";i:-273;s:17:\"xtracker/tid/1041\";i:-274;s:17:\"xtracker/tid/1035\";i:-275;s:17:\"xtracker/tid/1042\";i:-276;s:17:\"xtracker/tid/1033\";i:-277;s:17:\"xtracker/tid/1046\";i:-278;s:17:\"xtracker/tid/1049\";i:-279;s:17:\"xtracker/tid/1056\";i:-280;s:17:\"xtracker/tid/1043\";i:-281;s:17:\"xtracker/tid/1044\";i:-282;s:17:\"xtracker/tid/1045\";i:-283;s:17:\"xtracker/tid/1051\";i:-284;s:17:\"xtracker/tid/1036\";i:-285;s:17:\"xtracker/tid/1062\";i:-286;s:17:\"xtracker/tid/1037\";i:-287;s:17:\"xtracker/tid/1058\";i:-288;s:17:\"xtracker/tid/1038\";i:-289;s:17:\"xtracker/tid/1048\";i:-290;s:17:\"xtracker/tid/1061\";i:-291;s:17:\"xtracker/tid/1034\";i:-292;s:17:\"xtracker/tid/1032\";i:-293;s:17:\"xtracker/tid/1063\";i:-294;s:23:\"xtracker/tid/1067448548\";i:-295;s:17:\"xtracker/tid/1060\";i:-296;s:17:\"xtracker/tid/1055\";i:-297;s:17:\"xtracker/tid/1052\";i:-298;s:17:\"xtracker/tid/1249\";i:-299;s:17:\"xtracker/tid/1225\";i:-300;s:17:\"xtracker/tid/1226\";i:-301;s:17:\"xtracker/tid/1227\";i:-302;s:17:\"xtracker/tid/1228\";i:-303;s:17:\"xtracker/tid/1229\";i:-304;s:17:\"xtracker/tid/1230\";i:-305;s:17:\"xtracker/tid/1231\";i:-306;s:17:\"xtracker/tid/1253\";i:-307;s:17:\"xtracker/tid/1224\";i:-308;s:17:\"xtracker/tid/1215\";i:-309;s:17:\"xtracker/tid/1216\";i:-310;s:17:\"xtracker/tid/1217\";i:-311;s:17:\"xtracker/tid/1218\";i:-312;s:17:\"xtracker/tid/1220\";i:-313;s:17:\"xtracker/tid/1221\";i:-314;s:17:\"xtracker/tid/1222\";i:-315;s:17:\"xtracker/tid/1223\";i:-316;s:17:\"xtracker/tid/1232\";i:-317;s:17:\"xtracker/tid/1233\";i:-318;s:17:\"xtracker/tid/1240\";i:-319;s:17:\"xtracker/tid/1241\";i:-320;s:17:\"xtracker/tid/1242\";i:-321;s:17:\"xtracker/tid/1244\";i:-322;s:17:\"xtracker/tid/1245\";i:-323;s:17:\"xtracker/tid/1246\";i:-324;s:17:\"xtracker/tid/1247\";i:-325;s:17:\"xtracker/tid/1248\";i:-326;s:17:\"xtracker/tid/1239\";i:-327;s:17:\"xtracker/tid/1238\";i:-328;s:17:\"xtracker/tid/1264\";i:-329;s:17:\"xtracker/tid/1251\";i:-330;s:17:\"xtracker/tid/1234\";i:-331;s:17:\"xtracker/tid/1250\";i:-332;s:17:\"xtracker/tid/1235\";i:-333;s:17:\"xtracker/tid/1236\";i:-334;s:17:\"xtracker/tid/1237\";i:-335;s:17:\"xtracker/tid/1243\";i:-336;s:17:\"xtracker/tid/1252\";i:-337;s:17:\"xtracker/tid/1254\";i:-338;s:17:\"xtracker/tid/1313\";i:-339;s:17:\"xtracker/tid/1298\";i:-340;s:17:\"xtracker/tid/1297\";i:-341;s:17:\"xtracker/tid/1296\";i:-342;s:17:\"xtracker/tid/1295\";i:-343;s:17:\"xtracker/tid/1294\";i:-344;s:17:\"xtracker/tid/1293\";i:-345;s:17:\"xtracker/tid/1292\";i:-346;s:17:\"xtracker/tid/1291\";i:-347;s:17:\"xtracker/tid/1290\";i:-348;s:17:\"xtracker/tid/1289\";i:-349;s:17:\"xtracker/tid/1287\";i:-350;s:17:\"xtracker/tid/1299\";i:-351;s:17:\"xtracker/tid/1300\";i:-352;s:17:\"xtracker/tid/1301\";i:-353;s:17:\"xtracker/tid/1312\";i:-354;s:17:\"xtracker/tid/1311\";i:-355;s:17:\"xtracker/tid/1310\";i:-356;s:17:\"xtracker/tid/1309\";i:-357;s:17:\"xtracker/tid/1308\";i:-358;s:17:\"xtracker/tid/1307\";i:-359;s:17:\"xtracker/tid/1306\";i:-360;s:17:\"xtracker/tid/1305\";i:-361;s:17:\"xtracker/tid/1304\";i:-362;s:17:\"xtracker/tid/1303\";i:-363;s:17:\"xtracker/tid/1302\";i:-364;s:17:\"xtracker/tid/1288\";i:-365;s:17:\"xtracker/tid/1285\";i:-366;s:17:\"xtracker/tid/1284\";i:-367;s:17:\"xtracker/tid/1267\";i:-368;s:17:\"xtracker/tid/1266\";i:-369;s:17:\"xtracker/tid/1265\";i:-370;s:17:\"xtracker/tid/1263\";i:-371;s:17:\"xtracker/tid/1262\";i:-372;s:17:\"xtracker/tid/1261\";i:-373;s:17:\"xtracker/tid/1260\";i:-374;s:17:\"xtracker/tid/1259\";i:-375;s:17:\"xtracker/tid/1258\";i:-376;s:17:\"xtracker/tid/1257\";i:-377;s:17:\"xtracker/tid/1256\";i:-378;s:17:\"xtracker/tid/1268\";i:-379;s:17:\"xtracker/tid/1270\";i:-380;s:17:\"xtracker/tid/1271\";i:-381;s:17:\"xtracker/tid/1283\";i:-382;s:17:\"xtracker/tid/1282\";i:-383;s:17:\"xtracker/tid/1281\";i:-384;s:17:\"xtracker/tid/1280\";i:-385;s:17:\"xtracker/tid/1279\";i:-386;s:17:\"xtracker/tid/1278\";i:-387;s:17:\"xtracker/tid/1276\";i:-388;s:17:\"xtracker/tid/1275\";i:-389;s:17:\"xtracker/tid/1274\";i:-390;s:17:\"xtracker/tid/1273\";i:-391;s:17:\"xtracker/tid/1272\";i:-392;s:17:\"xtracker/tid/1255\";i:-393;s:23:\"xtracker/tid/1067448550\";i:-394;s:23:\"xtracker/tid/1067448588\";i:-395;s:23:\"xtracker/tid/1067448604\";i:-396;s:23:\"xtracker/tid/1067448586\";i:-397;s:23:\"xtracker/tid/1067448584\";i:-398;s:23:\"xtracker/tid/1067448583\";i:-399;s:23:\"xtracker/tid/1067448582\";i:-400;s:23:\"xtracker/tid/1067448581\";i:-401;s:23:\"xtracker/tid/1067448580\";i:-402;s:23:\"xtracker/tid/1067448579\";i:-403;s:23:\"xtracker/tid/1067448589\";i:-404;s:23:\"xtracker/tid/1067448590\";i:-405;s:23:\"xtracker/tid/1067448591\";i:-406;s:23:\"xtracker/tid/1067448549\";i:-407;s:23:\"xtracker/tid/1067448554\";i:-408;s:23:\"xtracker/tid/1067448603\";i:-409;s:23:\"xtracker/tid/1067448601\";i:-410;s:23:\"xtracker/tid/1067448600\";i:-411;s:23:\"xtracker/tid/1067448599\";i:-412;s:23:\"xtracker/tid/1067448597\";i:-413;s:23:\"xtracker/tid/1067448596\";i:-414;s:23:\"xtracker/tid/1067448593\";i:-415;s:23:\"xtracker/tid/1067448578\";i:-416;s:23:\"xtracker/tid/1067448576\";i:-417;s:23:\"xtracker/tid/1067448560\";i:-418;s:23:\"xtracker/tid/1067448559\";i:-419;s:23:\"xtracker/tid/1067448558\";i:-420;s:23:\"xtracker/tid/1067448557\";i:-421;s:23:\"xtracker/tid/1067448556\";i:-422;s:23:\"xtracker/tid/1067448555\";i:-423;s:17:\"xtracker/tid/1010\";i:-424;s:17:\"xtracker/tid/1011\";i:-425;s:17:\"xtracker/tid/1013\";i:-426;s:23:\"xtracker/tid/1067448562\";i:-427;s:23:\"xtracker/tid/1067448563\";i:-428;s:23:\"xtracker/tid/1067448566\";i:-429;s:23:\"xtracker/tid/1067448575\";i:-430;s:23:\"xtracker/tid/1067448574\";i:-431;s:23:\"xtracker/tid/1067448573\";i:-432;s:23:\"xtracker/tid/1067448572\";i:-433;s:23:\"xtracker/tid/1067448571\";i:-434;s:23:\"xtracker/tid/1067448570\";i:-435;s:23:\"xtracker/tid/1067448568\";i:-436;s:23:\"xtracker/tid/1067448567\";i:-437;s:23:\"xtracker/tid/1067448565\";i:-438;s:17:\"xtracker/tid/1012\";i:-439;s:23:\"xtracker/tid/1067448551\";i:-440;s:17:\"xtracker/tid/1214\";i:-441;s:17:\"xtracker/tid/1202\";i:-442;s:17:\"xtracker/tid/1201\";i:-443;s:17:\"xtracker/tid/1200\";i:-444;s:17:\"xtracker/tid/1199\";i:-445;s:17:\"xtracker/tid/1198\";i:-446;s:17:\"xtracker/tid/1197\";i:-447;s:17:\"xtracker/tid/1191\";i:-448;s:17:\"xtracker/tid/1190\";i:-449;s:17:\"xtracker/tid/1189\";i:-450;s:17:\"xtracker/tid/1203\";i:-451;s:17:\"xtracker/tid/1204\";i:-452;s:17:\"xtracker/tid/1213\";i:-453;s:17:\"xtracker/tid/1212\";i:-454;s:17:\"xtracker/tid/1211\";i:-455;s:17:\"xtracker/tid/1210\";i:-456;s:17:\"xtracker/tid/1209\";i:-457;s:17:\"xtracker/tid/1208\";i:-458;s:17:\"xtracker/tid/1207\";i:-459;s:17:\"xtracker/tid/1206\";i:-460;s:17:\"xtracker/tid/1205\";i:-461;s:17:\"xtracker/tid/1188\";i:-462;s:17:\"xtracker/tid/1187\";i:-463;s:17:\"xtracker/tid/1186\";i:-464;s:17:\"xtracker/tid/1054\";i:-465;s:17:\"xtracker/tid/1053\";i:-466;s:17:\"xtracker/tid/1050\";i:-467;s:17:\"xtracker/tid/1047\";i:-468;s:17:\"xtracker/tid/1040\";i:-469;s:17:\"xtracker/tid/1039\";i:-470;s:17:\"xtracker/tid/1015\";i:-471;s:23:\"xtracker/tid/1067448544\";i:-472;s:23:\"xtracker/tid/1067448546\";i:-473;s:23:\"xtracker/tid/1067448552\";i:-474;s:17:\"xtracker/tid/1057\";i:-475;s:17:\"xtracker/tid/1059\";i:-476;s:17:\"xtracker/tid/1181\";i:-477;s:17:\"xtracker/tid/1180\";i:-478;s:17:\"xtracker/tid/1179\";i:-479;s:17:\"xtracker/tid/1106\";i:-480;s:17:\"xtracker/tid/1105\";i:-481;s:17:\"xtracker/tid/1104\";i:-482;s:17:\"xtracker/tid/1078\";i:-483;s:17:\"xtracker/tid/1076\";i:-484;s:17:\"xtracker/tid/1075\";i:-485;s:17:\"xtracker/tid/1192\";i:-486;s:17:\"xtracker/tid/1009\";i:-487;s:17:\"xtracker/tid/1014\";i:-488;s:14:\"xtracker/uid/1\";i:-489;s:24:\"taxonomy/term/1067448598\";s:4:\"1076\";s:18:\"taxonomy/term/1066\";s:4:\"1077\";s:18:\"taxonomy/term/1067\";s:4:\"1078\";s:18:\"taxonomy/term/1072\";s:4:\"1079\";s:18:\"taxonomy/term/1068\";s:4:\"1080\";s:18:\"taxonomy/term/1069\";s:4:\"1081\";s:18:\"taxonomy/term/1070\";s:4:\"1082\";s:18:\"taxonomy/term/1071\";s:4:\"1083\";s:18:\"taxonomy/term/1073\";s:4:\"1084\";s:18:\"taxonomy/term/1043\";s:4:\"1085\";s:18:\"taxonomy/term/1036\";s:4:\"1086\";s:18:\"taxonomy/term/1052\";s:4:\"1087\";s:18:\"taxonomy/term/1040\";s:4:\"1088\";s:18:\"taxonomy/term/1041\";s:4:\"1089\";s:18:\"taxonomy/term/1051\";s:4:\"1090\";s:18:\"taxonomy/term/1057\";s:4:\"1091\";s:18:\"taxonomy/term/1060\";s:4:\"1092\";s:18:\"taxonomy/term/1033\";s:4:\"1093\";s:18:\"taxonomy/term/1037\";s:4:\"1094\";s:18:\"taxonomy/term/1055\";s:4:\"1095\";s:18:\"taxonomy/term/1050\";s:4:\"1096\";s:18:\"taxonomy/term/1049\";s:4:\"1097\";s:18:\"taxonomy/term/1045\";s:4:\"1098\";s:18:\"taxonomy/term/1032\";s:4:\"1099\";s:18:\"taxonomy/term/1053\";s:4:\"1100\";s:18:\"taxonomy/term/1046\";s:4:\"1101\";s:18:\"taxonomy/term/1044\";s:4:\"1102\";s:18:\"taxonomy/term/1063\";s:4:\"1103\";s:18:\"taxonomy/term/1039\";s:4:\"1104\";s:18:\"taxonomy/term/1035\";s:4:\"1105\";s:18:\"taxonomy/term/1038\";s:4:\"1106\";s:18:\"taxonomy/term/1034\";s:4:\"1107\";s:18:\"taxonomy/term/1047\";s:4:\"1108\";s:18:\"taxonomy/term/1042\";s:4:\"1109\";s:18:\"taxonomy/term/1058\";s:4:\"1110\";s:18:\"taxonomy/term/1048\";s:4:\"1111\";s:18:\"taxonomy/term/1059\";s:4:\"1112\";s:18:\"taxonomy/term/1056\";s:4:\"1113\";s:18:\"taxonomy/term/1062\";s:4:\"1114\";s:18:\"taxonomy/term/1061\";s:4:\"1115\";s:18:\"taxonomy/term/1054\";s:4:\"1116\";s:26:\"deals/worldcuppublications\";s:4:\"1117\";s:18:\"taxonomy/term/1076\";s:4:\"1118\";s:24:\"taxonomy/term/1067448601\";s:4:\"1119\";s:18:\"taxonomy/term/1075\";s:4:\"1120\";s:24:\"taxonomy/term/1067448546\";s:4:\"1121\";}s:5:\"items\";a:549:{i:0;a:5:{s:4:\"path\";s:0:\"\";s:5:\"title\";s:0:\"\";s:4:\"type\";i:1;s:3:\"pid\";i:1;s:8:\"children\";a:2:{i:0;i:1;i:1;i:1075;}}i:1;a:7:{s:3:\"pid\";i:0;s:4:\"path\";s:0:\"\";s:5:\"title\";s:10:\"Navigation\";s:6:\"weight\";i:-50;s:6:\"access\";b:1;s:4:\"type\";i:3;s:8:\"children\";a:49:{i:0;i:-34;i:1;i:-56;i:2;i:-68;i:3;i:-76;i:4;i:-79;i:5;i:-86;i:6;i:-87;i:7;i:-88;i:8;i:-121;i:9;i:-122;i:10;i:-123;i:11;i:-124;i:12;i:-125;i:13;i:-140;i:14;i:-141;i:15;i:-152;i:16;i:-161;i:17;i:-162;i:18;i:-214;i:19;i:-222;i:20;i:-231;i:21;i:-232;i:22;i:4;i:23;i:6;i:24;i:9;i:25;i:11;i:26;i:17;i:27;i:24;i:28;i:30;i:29;i:53;i:30;i:54;i:31;i:61;i:32;i:114;i:33;i:117;i:34;i:120;i:35;i:123;i:36;i:127;i:37;i:130;i:38;i:152;i:39;i:155;i:40;i:156;i:41;i:1026;i:42;i:1034;i:43;i:1073;i:44;i:1141;i:45;i:1151;i:46;i:1158;i:47;i:1165;i:48;i:1166;}}i:-3;a:7:{s:4:\"path\";s:26:\"admin/aggregator/edit/feed\";s:5:\"title\";s:9:\"edit feed\";s:8:\"callback\";s:26:......It is a really huge query which is strange to have running with cache disabled. I mean really huge..... just the first line in my browser I copied here...
The next one starts like:
INSERT INTO cache (cid, data, created, expire, headers) VALUES ('menu:1:en', 'a:3:{s:10:\"path index\";a:534:{s:0:\"\";s:4:\"1075\";s:16:\"admin/aggregator\";s:3:\"116\";s:26:\"admin/aggregator/edit/feed\";i:-3;s:30:\"admin/aggregator/edit/category\";i:-4;s:23:\"admin/aggregator/remove\";i:-5;s:23:\"admin/aggregator/update\";i:-6;s:21:\"admin/aggregator/list\";i:-7;s:25:\"admin/aggregator/add/feed\";i:-8;s:29:\"admin/aggregator/add/category\";i:-9;s:10:\"aggregator\";s:3:\"117\";s:18:\"aggregator/sources\";s:3:\"118\";s:21:\"aggregator/categories\";s:3:\"119\";s:20:\"aggregator/sources/2\";s:3:\"162\";s:25:\"aggregator/sources/2/view\";i:-14;s:31:\"aggregator/sources/2/categorize\";i:-15;s:30:\"aggregator/sources/2/configure\";i:-16;s:20:\"aggregator/sources/1\";s:3:\"161\";s:25:\"aggregator/sources/1/view\";i:-18;s:31:\"aggregator/sources/1/categorize\";i:-19;s:30:\"aggregator/sources/1/configure\";i:-20;s:20:\"aggregator/sources/3\";s:3:\"163\";s:25:\"aggregator/sources/3/view\";i:-22;s:31:\"aggregator/sources/3/categorize\";i:-23;s:30:\"aggregator/sources/3/configure\";i:-24;s:20:\"aggregator/sources/4\";s:3:\"164\";s:25:\"aggregator/sources/4/view\";i:-26;s:31:\"aggregator/sources/4/categorize\";i:-27;s:30:\"aggregator/sources/4/configure\";i:-28;s:23:\"aggregator/categories/1\";s:3:\"160\";s:28:\"aggregator/categories/1/view\";i:-30;s:34:\"aggregator/categories/1/categorize\";i:-31;s:33:\"aggregator/categories/1/configure\";i:-32;s:15:\"aggregator/opml\";i:-33;s:9:\"atom/feed\";i:-34;s:11:\"admin/block\";s:1:\"2\";s:16:\"admin/block/list\";i:-36;s:21:\"admin/block/configure\";i:-37;s:18:\"admin/block/delete\";i:-38;s:15:\"admin/block/add\";i:-39;s:21:\"admin/logs/useragents\";s:4:\"1055\";s:30:\"admin/logs/useragents/browsers\";s:4:\"1056\";s:30:\"admin/logs/useragents/crawlers\";s:4:\"1057\";s:13:\"admin/comment\";s:1:\"3\";s:18:\"admin/comment/edit\";i:-44;s:20:\"admin/comment/delete\";i:-45;s:18:\"admin/comment/list\";i:-46;s:23:\"admin/comment/configure\";i:-47;s:22:\"admin/comment/list/new\";i:-48;s:27:\"admin/comment/list/approval\";i:-49;s:32:\"admin/comment/configure/settings\";i:-50;s:30:\"admin/comment/configure/matrix\";i:-51;s:34:\"admin/comment/configure/thresholds\";i:-52;s:29:\"admin/comment/configure/roles\";i:-53;s:29:\"admin/comment/configure/votes\";i:-54;s:12:\"comment/edit\";i:-55;s:7:\"comment\";i:-56;s:9:\"delicious\";s:4:\"1151\";s:13:\"delicious/tag\";i:-58;s:14:\"delicious/user\";i:-59;s:24:\"admin/settings/delicious\";s:4:\"1153\";s:15:\"admin/delicious\";s:4:\"1152\";s:20:\"admin/delicious/view\";i:-62;s:19:\"admin/delicious/add\";i:-63;s:20:\"admin/delicious/edit\";i:-64;s:16:\"user/1/delicious\";i:-65;s:17:\"devel/cache/clear\";s:4:\"1165\";s:14:\"devel/variable\";s:4:\"1166\";s:12:\"devel/switch\";i:-68;s:8:\"feedback\";s:1:\"4\";s:13:\"admin/filters\";s:1:\"5\";s:20:\"admin/filters/delete\";i:-71;s:11:\"filter/tips\";s:1:\"6\";s:16:\"admin/flexiblock\";s:3:\"122\";s:21:\"admin/flexiblock/list\";i:-74;s:22:\"admin/flexiblock/debug\";i:-75;s:7:\"forward\";i:-76;s:13:\"admin/forward\";s:4:\"1159\";s:9:\"gmapmacro\";s:4:\"1073\";s:8:\"gsitemap\";i:-79;s:14:\"node/add/image\";s:1:\"8\";s:5:\"image\";s:1:\"9\";s:10:\"image/view\";i:-82;s:11:\"admin/image\";s:2:\"10\";s:16:\"admin/image/list\";i:-84;s:15:\"admin/image/add\";i:-85;s:14:\"img_assist/add\";i:-86;s:14:\"img_assist/gen\";i:-87;s:15:\"img_assist/load\";i:-88;s:20:\"img_assist/add/image\";i:-89;s:20:\"admin/settings/legal\";s:3:\"125\";s:13:\"node/add/mail\";s:3:\"126\";s:7:\"members\";s:3:\"127\";s:10:\"admin/menu\";s:2:\"15\";s:20:\"admin/menu/item/edit\";i:-94;s:21:\"admin/menu/item/reset\";i:-95;s:23:\"admin/menu/item/disable\";i:-96;s:22:\"admin/menu/item/delete\";i:-97;s:15:\"admin/menu/list\";i:-98;s:19:\"admin/menu/menu/add\";i:-99;s:19:\"admin/menu/item/add\";i:-100;s:16:\"admin/menu/reset\";i:-101;s:10:\"admin/node\";s:2:\"16\";s:17:\"admin/node/action\";i:-103;s:19:\"admin/node/overview\";i:-104;s:20:\"admin/node/configure\";i:-105;s:29:\"admin/node/configure/settings\";i:-106;s:26:\"admin/node/configure/types\";i:-107;s:4:\"node\";s:2:\"17\";s:8:\"node/add\";s:2:\"18\";s:13:\"node/add/page\";s:2:\"19\";s:10:\"admin/path\";s:2:\"20\";s:15:\"admin/path/edit\";i:-112;s:17:\"admin/path/delete\";i:-113;s:15:\"admin/path/list\";i:-114;s:14:\"admin/path/add\";i:-115;s:7:\"profile\";s:3:\"130\";s:22:\"admin/settings/profile\";s:3:\"131\";s:26:\"admin/settings/profile/add\";i:-118;s:27:\"admin/settings/profile/edit\";i:-119;s:29:\"admin/settings/profile/delete\";i:-120;s:35:\"profile_pages/profile_national_team\";i:-121;s:26:\"profile_pages/profile_club\";i:-122;s:26:\"profile_pages/profile_name\";i:-123;s:29:\"profile_pages/profile_surname\";i:-124;s:25:\"profile_pages/profile_url\";i:-125;s:12:\"admin/sanity\";s:4:\"1149\";s:19:\"node/add/simplenews\";s:4:\"1032\";s:16:\"admin/simplenews\";s:4:\"1033\";s:21:\"admin/simplenews/sent\";i:-129;s:23:\"admin/simplenews/outbox\";i:-130;s:22:\"admin/simplenews/types\";i:-131;s:27:\"admin/simplenews/types/list\";i:-132;s:26:\"admin/simplenews/types/add\";i:-133;s:22:\"admin/simplenews/users\";i:-134;s:27:\"admin/simplenews/users/list\";i:-135;s:26:\"admin/simplenews/users/add\";i:-136;s:29:\"admin/simplenews/users/export\";i:-137;s:25:\"admin/simplenews/settings\";i:-138;s:33:\"admin/simplenews/settings/general\";i:-139;s:18:\"newsletter/confirm\";i:-140;s:24:\"newsletter/subscriptions\";i:-141;s:8:\"sitemenu\";s:2:\"24\";s:23:\"admin/comment/list/spam\";i:-143;s:20:\"admin/node/list/spam\";i:-144;s:10:\"admin/spam\";s:4:\"1127\";s:15:\"admin/spam/logs\";i:-146;s:19:\"admin/spam/comments\";i:-147;s:15:\"admin/spam/node\";i:-148;s:17:\"admin/spam/custom\";i:-149;s:14:\"admin/spam/url\";i:-150;s:21:\"admin/spam/logs/entry\";i:-151;s:4:\"spam\";i:-152;s:15:\"admin/logs/hits\";s:2:\"25\";s:16:\"admin/logs/pages\";s:2:\"26\";s:16:\"admin/logs/users\";s:2:\"27\";s:20:\"admin/logs/referrers\";s:2:\"28\";s:17:\"admin/logs/access\";i:-157;s:14:\"node/add/story\";s:2:\"29\";s:13:\"subscriptions\";s:4:\"1141\";s:19:\"admin/subscriptions\";s:4:\"1142\";s:12:\"system/files\";i:-161;s:11:\"system/test\";i:-162;s:5:\"admin\";s:2:\"30\";s:12:\"admin/themes\";s:2:\"31\";s:19:\"admin/themes/select\";i:-165;s:21:\"admin/themes/settings\";i:-166;s:28:\"admin/themes/settings/global\";i:-167;s:32:\"admin/themes/settings/bluemarine\";i:-168;s:36:\"admin/themes/settings/box_cleanslate\";i:-169;s:30:\"admin/themes/settings/box_grey\";i:-170;s:31:\"admin/themes/settings/chameleon\";i:-171;s:28:\"admin/themes/settings/marvin\";i:-172;s:32:\"admin/themes/settings/pushbutton\";i:-173;s:14:\"admin/settings\";s:2:\"32\";s:22:\"admin/settings/adsense\";s:3:\"133\";s:25:\"admin/settings/aggregator\";s:3:\"134\";s:23:\"admin/settings/browscap\";s:4:\"1023\";s:20:\"admin/settings/devel\";s:4:\"1167\";s:23:\"admin/settings/feedback\";s:2:\"33\";s:22:\"admin/settings/forward\";s:4:\"1028\";s:19:\"admin/settings/gmap\";s:4:\"1074\";s:23:\"admin/settings/gsitemap\";s:4:\"1029\";s:18:\"admin/settings/hof\";s:4:\"1030\";s:20:\"admin/settings/image\";s:2:\"34\";s:25:\"admin/settings/img_assist\";s:2:\"35\";s:19:\"admin/settings/mail\";s:3:\"139\";s:22:\"admin/settings/members\";s:3:\"140\";s:24:\"admin/settings/nodewords\";s:2:\"37\";s:25:\"admin/settings/page_title\";s:4:\"1164\";s:28:\"admin/settings/service_links\";s:4:\"1154\";s:24:\"admin/settings/shortcuts\";s:4:\"1145\";s:23:\"admin/settings/sitemenu\";s:2:\"40\";s:19:\"admin/settings/spam\";s:4:\"1128\";s:25:\"admin/settings/spam_surbl\";s:4:\"1163\";s:25:\"admin/settings/statistics\";s:2:\"41\";s:32:\"admin/settings/statistics_filter\";s:2:\"42\";s:28:\"admin/settings/subscriptions\";s:4:\"1143\";s:31:\"admin/settings/taxonomy_browser\";s:2:\"43\";s:29:\"admin/settings/taxonomy_dhtml\";s:2:\"45\";s:29:\"admin/settings/taxonomy_theme\";s:2:\"47\";s:23:\"admin/settings/throttle\";s:3:\"143\";s:22:\"admin/settings/urllist\";s:4:\"1150\";s:22:\"admin/settings/webform\";s:3:\"144\";s:23:\"admin/settings/xtracker\";s:4:\"1157\";s:13:\"admin/modules\";s:2:\"49\";s:14:\"admin/taxonomy\";s:2:\"50\";s:19:\"admin/taxonomy/list\";i:-208;s:29:\"admin/taxonomy/add/vocabulary\";i:-209;s:30:\"admin/taxonomy/edit/vocabulary\";i:-210;s:33:\"admin/taxonomy/preview/vocabulary\";i:-211;s:23:\"admin/taxonomy/add/term\";i:-212;s:24:\"admin/taxonomy/edit/term\";i:-213;s:13:\"taxonomy/term\";i:-214;s:20:\"admin/taxonomy_assoc\";s:2:\"51\";s:25:\"admin/taxonomy_assoc/edit\";i:-216;s:27:\"admin/taxonomy_assoc/delete\";i:-217;s:25:\"admin/taxonomy_assoc/list\";i:-218;s:24:\"admin/taxonomy_assoc/add\";i:-219;s:16:\"taxonomy_browser\";s:2:\"53\";s:14:\"taxonomy_dhtml\";s:2:\"54\";s:9:\"trackback\";i:-222;s:15:\"admin/trackback\";s:4:\"1155\";s:20:\"admin/trackback/edit\";i:-224;s:20:\"admin/trackback/list\";i:-225;s:25:\"admin/trackback/configure\";i:-226;s:24:\"admin/trackback/list/new\";i:-227;s:29:\"admin/trackback/list/approval\";i:-228;s:34:\"admin/trackback/configure/settings\";i:-229;s:25:\"admin/trackback/list/spam\";i:-230;s:7:\"urllist\";i:-231;s:4:\"user\";i:-232;s:10:\"user/login\";i:-233;s:13:\"user/register\";i:-234;s:13:\"user/password\";i:-235;s:9:\"user/help\";i:-236;s:10:\"admin/user\";s:3:\"112\";s:15:\"admin/user/list\";i:-238;s:17:\"admin/user/create\";i:-239;s:20:\"admin/user/configure\";i:-240;s:12:\"admin/access\";s:3:\"113\";s:24:\"admin/access/permissions\";i:-242;s:18:\"admin/access/roles\";i:-243;s:23:\"admin/access/roles/edit\";i:-244;s:18:\"admin/access/rules\";i:-245;s:23:\"admin/access/rules/list\";i:-246;s:22:\"admin/access/rules/add\";i:-247;s:24:\"admin/access/rules/check\";i:-248;s:23:\"admin/access/rules/edit\";i:-249;s:25:\"admin/access/rules/delete\";i:-250;s:6:\"user/1\";i:-251;s:6:\"logout\";s:3:\"114\";s:10:\"admin/logs\";s:3:\"115\";s:16:\"admin/logs/event\";i:-254;s:16:\"node/add/webform\";s:3:\"151\";s:12:\"webform/done\";i:-256;s:15:\"webform/upgrade\";i:-257;s:7:\"webform\";s:3:\"152\";s:18:\"admin/logs/summary\";s:4:\"1050\";s:16:\"admin/logs/usage\";s:4:\"1051\";s:8:\"xtracker\";s:4:\"1158\";s:12:\"xtracker/all\";i:-262;s:17:\"xtracker/tid/1073\";i:-263;s:17:\"xtracker/tid/1066\";i:-264;s:23:\"xtracker/tid/1067448598\";i:-265;s:17:\"xtracker/tid/1067\";i:-266;s:17:\"xtracker/tid/1071\";i:-267;s:17:\"xtracker/tid/1068\";i:-268;s:17:\"xtracker/tid/1069\";i:-269;s:17:\"xtracker/tid/1070\";i:-270;s:17:\"xtracker/tid/1072\";i:-271;s:23:\"xtracker/tid/1067448545\";i:-272;s:23:\"xtracker/tid/1067448543\";i:-273;s:17:\"xtracker/tid/1041\";i:-274;s:17:\"xtracker/tid/1035\";i:-275;s:17:\"xtracker/tid/1042\";i:-276;s:17:\"xtracker/tid/1033\";i:-277;s:17:\"xtracker/tid/1046\";i:-278;s:17:\"xtracker/tid/1049\";i:-279;s:17:\"xtracker/tid/1056\";i:-280;s:17:\"xtracker/tid/1043\";i:-281;s:17:\"xtracker/tid/1044\";i:-282;s:17:\"xtracker/tid/1045\";i:-283;s:17:\"xtracker/tid/1051\";i:-284;s:17:\"xtracker/tid/1036\";i:-285;s:17:\"xtracker/tid/1062\";i:-286;s:17:\"xtracker/tid/1037\";i:-287;s:17:\"xtracker/tid/1058\";i:-288;s:17:\"xtracker/tid/1038\";i:-289;s:17:\"xtracker/tid/1048\";i:-290;s:17:\"xtracker/tid/1061\";i:-291;s:17:\"xtracker/tid/1034\";i:-292;s:17:\"xtracker/tid/1032\";i:-293;s:17:\"xtracker/tid/1063\";i:-294;s:23:\"xtracker/tid/1067448548\";i:-295;s:17:\"xtracker/tid/1060\";i:-296;s:17:\"xtracker/tid/1055\";i:-297;s:17:\"xtracker/tid/1052\";i:-298;s:17:\"xtracker/tid/1249\";i:-299;s:17:\"xtracker/tid/1225\";i:-300;s:17:\"xtracker/tid/1226\";i:-301;s:17:\"xtracker/tid/1227\";i:-302;s:17:\"xtracker/tid/1228\";i:-303;s:17:\"xtracker/tid/1229\";i:-304;s:17:\"xtracker/tid/1230\";i:-305;s:17:\"xtracker/tid/1231\";i:-306;s:17:\"xtracker/tid/1253\";i:-307;s:17:\"xtracker/tid/1224\";i:-308;s:17:\"xtracker/tid/1215\";i:-309;s:17:\"xtracker/tid/1216\";i:-310;s:17:\"xtracker/tid/1217\";i:-311;s:17:\"xtracker/tid/1218\";i:-312;s:17:\"xtracker/tid/1220\";i:-313;s:17:\"xtracker/tid/1221\";i:-314;s:17:\"xtracker/tid/1222\";i:-315;s:17:\"xtracker/tid/1223\";i:-316;s:17:\"xtracker/tid/1232\";i:-317;s:17:\"xtracker/tid/1233\";i:-318;s:17:\"xtracker/tid/1240\";i:-319;s:17:\"xtracker/tid/1241\";i:-320;s:17:\"xtracker/tid/1242\";i:-321;s:17:\"xtracker/tid/1244\";i:-322;s:17:\"xtracker/tid/1245\";i:-323;s:17:\"xtracker/tid/1246\";i:-324;s:17:\"xtracker/tid/1247\";i:-325;s:17:\"xtracker/tid/1248\";i:-326;s:17:\"xtracker/tid/1239\";i:-327;s:17:\"xtracker/tid/1238\";i:-328;s:17:\"xtracker/tid/1264\";i:-329;s:17:\"xtracker/tid/1251\";i:-330;s:17:\"xtracker/tid/1234\";i:-331;s:17:\"xtracker/tid/1250\";i:-332;s:17:\"xtracker/tid/1235\";i:-333;s:17:\"xtracker/tid/1236\";i:-334;s:17:\"xtracker/tid/1237\";i:-335;s:17:\"xtracker/tid/1243\";i:-336;s:17:\"xtracker/tid/1252\";i:-337;s:17:\"xtracker/tid/1254\";i:-338;s:17:\"xtracker/tid/1313\";i:-339;s:17:\"xtracker/tid/1298\";i:-340;s:17:\"xtracker/tid/1297\";i:-341;s:17:\"xtracker/tid/1296\";i:-342;s:17:\"xtracker/tid/1295\";i:-343;s:17:\"xtracker/tid/1294\";i:-344;s:17:\"xtracker/tid/1293\";i:-345;s:17:\"xtracker/tid/1292\";i:-346;s:17:\"xtracker/tid/1291\";i:-347;s:17:\"xtracker/tid/1290\";i:-348;s:17:\"xtracker/tid/1289\";i:-349;s:17:\"xtracker/tid/1287\";i:-350;s:17:\"xtracker/tid/1299\";i:-351;s:17:\"xtracker/tid/1300\";i:-352;s:17:\"xtracker/tid/1301\";i:-353;s:17:\"xtracker/tid/1312\";i:-354;s:17:\"xtracker/tid/1311\";i:-355;s:17:\"xtracker/tid/1310\";i:-356;s:17:\"xtracker/tid/1309\";i:-357;s:17:\"xtracker/tid/1308\";i:-358;s:17:\"xtracker/tid/1307\";i:-359;s:17:\"xtracker/tid/1306\";i:-360;s:17:\"xtracker/tid/1305\";i:-361;s:17:\"xtracker/tid/1304\";i:-362;s:17:\"xtracker/tid/1303\";i:-363;s:17:\"xtracker/tid/1302\";i:-364;s:17:\"xtracker/tid/1288\";i:-365;s:17:\"xtracker/tid/1285\";i:-366;s:17:\"xtracker/tid/1284\";i:-367;s:17:\"xtracker/tid/1267\";i:-368;s:17:\"xtracker/tid/1266\";i:-369;s:17:\"xtracker/tid/1265\";i:-370;s:17:\"xtracker/tid/1263\";i:-371;s:17:\"xtracker/tid/1262\";i:-372;s:17:\"xtracker/tid/1261\";i:-373;s:17:\"xtracker/tid/1260\";i:-374;s:17:\"xtracker/tid/1259\";i:-375;s:17:\"xtracker/tid/1258\";i:-376;s:17:\"xtracker/tid/1257\";i:-377;s:17:\"xtracker/tid/1256\";i:-378;s:17:\"xtracker/tid/1268\";i:-379;s:17:\"xtracker/tid/1270\";i:-380;s:17:\"xtracker/tid/1271\";i:-381;s:17:\"xtracker/tid/1283\";i:-382;s:17:\"xtracker/tid/1282\";i:-383;s:17:\"xtracker/tid/1281\";i:-384;s:17:\"xtracker/tid/1280\";i:-385;s:17:\"xtracker/tid/1279\";i:-386;s:17:\"xtracker/tid/1278\";i:-387;s:17:\"xtracker/tid/1276\";i:-388;s:17:\"xtracker/tid/1275\";i:-389;s:17:\"xtracker/tid/1274\";i:-390;s:17:\"xtracker/tid/1273\";i:-391;s:17:\"xtracker/tid/1272\";i:-392;s:17:\"xtracker/tid/1255\";i:-393;s:23:\"xtracker/tid/1067448550\";i:-394;s:23:\"xtracker/tid/1067448588\";i:-395;s:23:\"xtracker/tid/1067448604\";i:-396;s:23:\"xtracker/tid/1067448586\";i:-397;s:23:\"xtracker/tid/1067448584\";i:-398;s:23:\"xtracker/tid/1067448583\";i:-399;s:23:\"xtracker/tid/1067448582\";i:-400;s:23:\"xtracker/tid/1067448581\";i:-401;s:23:\"xtracker/tid/1067448580\";i:-402;s:23:\"xtracker/tid/1067448579\";i:-403;s:23:\"xtracker/tid/1067448589\";i:-404;s:23:\"xtracker/tid/1067448590\";i:-405;s:23:\"xtracker/tid/1067448591\";i:-406;s:23:\"xtracker/tid/1067448549\";i:-407;s:23:\"xtracker/tid/1067448554\";i:-408;s:23:\"xtracker/tid/1067448603\";i:-409;s:23:\"xtracker/tid/1067448601\";i:-410;s:23:\"xtracker/tid/1067448600\";i:-411;s:23:\"xtracker/tid/1067448599\";i:-412;s:23:\"xtracker/tid/1067448597\";i:-413;s:23:\"xtracker/tid/1067448596\";i:-414;s:23:\"xtracker/tid/1067448593\";i:-415;s:23:\"xtracker/tid/1067448578\";i:-416;s:23:\"xtracker/tid/1067448576\";i:-417;s:23:\"xtracker/tid/1067448560\";i:-418;s:23:\"xtracker/tid/1067448559\";i:-419;s:23:\"xtracker/tid/1067448558\";i:-420;s:23:\"xtracker/tid/1067448557\";i:-421;s:23:\"xtracker/tid/1067448556\";i:-422;s:23:\"xtracker/tid/1067448555\";i:-423;s:17:\"xtracker/tid/1010\";i:-424;s:17:\"xtracker/tid/1011\";i:-425;s:17:\"xtracker/tid/1013\";i:-426;s:23:\"xtracker/tid/1067448562\";i:-427;s:23:\"xtracker/tid/1067448563\";i:-428;s:23:\"xtracker/tid/1067448566\";i:-429;s:23:\"xtracker/tid/1067448575\";i:-430;s:23:\"xtracker/tid/1067448574\";i:-431;s:23:\"xtracker/tid/1067448573\";i:-432;s:23:\"xtracker/tid/1067448572\";i:-433;s:23:\"xtracker/tid/1067448571\";i:-434;s:23:\"xtracker/tid/1067448570\";i:-435;s:23:\"xtracker/tid/1067448568\";i:-436;s:23:\"xtracker/tid/1067448567\";i:-437;s:23:\"xtracker/tid/1067448565\";i:-438;s:17:\"xtracker/tid/1012\";i:-439;s:23:\"xtracker/tid/1067448551\";i:-440;s:17:\"xtracker/tid/1214\";i:-441;s:17:\"xtracker/tid/1202\";i:-442;s:17:\"xtracker/tid/1201\";i:-443;s:17:\"xtracker/tid/1200\";i:-444;s:17:\"xtracker/tid/1199\";i:-445;s:17:\"xtracker/tid/1198\";i:-446;s:17:\"xtracker/tid/1197\";i:-447;s:17:\"xtracker/tid/1191\";i:-448;s:17:\"xtracker/tid/1190\";i:-449;s:17:\"xtracker/tid/1189\";i:-450;s:17:\"xtracker/tid/1203\";i:-451;s:17:\"xtracker/tid/1204\";i:-452;s:17:\"xtracker/tid/1213\";i:-453;s:17:\"xtracker/tid/1212\";i:-454;s:17:\"xtracker/tid/1211\";i:-455;s:17:\"xtracker/tid/1210\";i:-456;s:17:\"xtracker/tid/1209\";i:-457;s:17:\"xtracker/tid/1208\";i:-458;s:17:\"xtracker/tid/1207\";i:-459;s:17:\"xtracker/tid/1206\";i:-460;s:17:\"xtracker/tid/1205\";i:-461;s:17:\"xtracker/tid/1188\";i:-462;s:17:\"xtracker/tid/1187\";i:-463;s:17:\"xtracker/tid/1186\";i:-464;s:17:\"xtracker/tid/1054\";i:-465;s:17:\"xtracker/tid/1053\";i:-466;s:17:\"xtracker/tid/1050\";i:-467;s:17:\"xtracker/tid/1047\";i:-468;s:17:\"xtracker/tid/1040\";i:-469;s:17:\"xtracker/tid/1039\";i:-470;s:17:\"xtracker/tid/1015\";i:-471;s:23:\"xtracker/tid/1067448544\";i:-472;s:23:\"xtracker/tid/1067448546\";i:-473;s:23:\"xtracker/tid/1067448552\";i:-474;s:17:\"xtracker/tid/1057\";i:-475;s:17:\"xtracker/tid/1059\";i:-476;s:17:\"xtracker/tid/1181\";i:-477;s:17:\"xtracker/tid/1180\";i:-478;s:17:\"xtracker/tid/1179\";i:-479;s:17:\"xtracker/tid/1106\";i:-480;s:17:\"xtracker/tid/1105\";i:-481;s:17:\"xtracker/tid/1104\";i:-482;s:17:\"xtracker/tid/1078\";i:-483;s:17:\"xtracker/tid/1076\";i:-484;s:17:\"xtracker/tid/1075\";i:-485;s:17:\"xtracker/tid/1192\";i:-486;s:17:\"xtracker/tid/1009\";i:-487;s:17:\"xtracker/tid/1014\";i:-488;s:14:\"xtracker/uid/1\";i:-489;s:24:\"taxonomy/term/1067448598\";s:4:\"1076\";s:18:\"taxonomy/term/1066\";s:4:\"1077\";s:18:\"taxonomy/term/1067\";s:4:\"1078\";s:18:\"taxonomy/term/1072\";s:4:\"1079\";s:18:\"taxonomy/term/1068\";s:4:\"1080\";s:18:\"taxonomy/term/1069\";s:4:\"1081\";s:18:\"taxonomy/term/1070\";s:4:\"1082\";s:18:\"taxonomy/term/1071\";s:4:\"1083\";s:18:\"taxonomy/term/1073\";s:4:\"1084\";s:18:\"taxonomy/term/1043\";s:4:\"1085\";s:18:\"taxonomy/term/1036\";s:4:\"1086\";s:18:\"taxonomy/term/1052\";s:4:\"1087\";s:18:\"taxonomy/term/1040\";s:4:\"1088\";s:18:\"taxonomy/term/1041\";s:4:\"1089\";s:18:\"taxonomy/term/1051\";s:4:\"1090\";s:18:\"taxonomy/term/1057\";s:4:\"1091\";s:18:\"taxonomy/term/1060\";s:4:\"1092\";s:18:\"taxonomy/term/1033\";s:4:\"1093\";s:18:\"taxonomy/term/1037\";s:4:\"1094\";s:18:\"taxonomy/term/1055\";s:4:\"1095\";s:18:\"taxonomy/term/1050\";s:4:\"1096\";s:18:\"taxonomy/term/1049\";s:4:\"1097\";s:18:\"taxonomy/term/1045\";s:4:\"1098\";s:18:\"taxonomy/term/1032\";s:4:\"1099\";s:18:\"taxonomy/term/1053\";s:4:\"1100\";s:18:\"taxonomy/term/1046\";s:4:\"1101\";s:18:\"taxonomy/term/1044\";s:4:\"1102\";s:18:\"taxonomy/term/1063\";s:4:\"1103\";s:18:\"taxonomy/term/1039\";s:4:\"1104\";s:18:\"taxonomy/term/1035\";s:4:\"1105\";s:18:\"taxonomy/term/1038\";s:4:\"1106\";s:18:\"taxonomy/term/1034\";s:4:\"1107\";s:18:\"taxonomy/term/1047\";s:4:\"1108\";s:18:\"taxonomy/term/1042\";s:4:\"1109\";s:18:\"taxonomy/term/1058\";s:4:\"1110\";s:18:\"taxonomy/term/1048\";s:4:\"1111\";s:18:\"taxonomy/term/1059\";s:4:\"1112\";s:18:\"taxonomy/term/1056\";s:4:\"1113\";s:18:\"taxonomy/term/1062\";s:4:\"1114\";s:18:\"taxonomy/term/1061\";s:4:\"1115\";s:18:\"taxonomy/term/1054\";s:4:\"1116\";s:26:\"deals/worldcuppublications\";s:4:\"1117\";s:18:\"taxonomy/term/1076\";s:4:\"1118\";s:24:\"taxonomy/term/1067448601\";s:4:\"1119\";s:18:\"taxonomy/term/1075\";s:4:\"1120\";s:24:\"taxonomy/term/1067448546\";s:4:\"1121\";}s:5:\"items\";a:549:{i:0;a:5:{s:4:\"path\";s:0:\"\";s:5:\"title\";s:0:\"\";s:4:\"type\";i:1;s:3:\"pid\";i:1;s:8:\"children\";a:2:{i:0;i:1;i:1;i:1075;}}i:1;a:7:{s:3:\"pid\";i:0;s:4:\"path\";s:0:\"\";s:5:\"title\";s:10:\"Navigation\";s:6:\"weight\";i:-50;s:6:\"access\";b:1;s:4:\"type\";i:3;s:8:\"children\";a:49:{i:0;i:-34;i:1;i:-56;i:2;i:-68;i:3;i:-76;i:4;i:-79;i:5;i:-86;i:6;i:-87;i:7;i:-88;i:8;i:-121;i:9;i:-122;i:10;i:-123;i:11;i:-124;i:12;i:-125;i:13;i:-140;i:14;i:-141;i:15;i:-152;i:16;i:-161;i:17;i:-162;i:18;i:-214;i:19;i:-222;i:20;i:-231;i:21;i:-232;i:22;i:4;i:23;i:6;i:24;i:9;i:25;i:11;i:26;i:17;i:27;i:24;i:28;i:30;i:29;i:53;i:30;i:54;i:31;i:61;i:32;i:114;i:33;i:117;i:34;i:120;i:35;i:123;i:36;i:127;i:37;i:130;i:38;i:152;i:39;i:155;i:40;i:156;i:41;i:1026;i:42;i:1034;i:43;i:1073;i:44;i:1141;i:45;i:1151;i:46;i:1158;i:47;i:1165;i:48;i:1166;}}i:-3;a:7:{s:4:\"path\";s:26:\"admin/aggregator/edit/feed\";s:5:\"title\";s:9:\"edit feed\";s:8:\"c......Also there seem to be errors in my installation as there are more than 5 queries which run twice.
Thanks very much again.... This is what happens when there's only 2 people behind a kinda big project... Will try to figure out why these two queries run as obviously they consume the cpu.
I will point out that I am
I will point out that I am not a performance expert with Apache or php, however, I have seen mention of issues with 'some' php caching setups (on the php side) so if you are using one of those with your php installs something else to seach for by name.
Also, even with Drupal caching turned off, if I recall there is still some caching going on. Someone will correct me if I am wrong.
One of the big drives from 4.6 to 4.7 was optimizing queries. That occured between 4.5 and 4.6 as well but each Drupal version has architecture stuff that folks learn on and introduce changes.
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain
-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide
Things Improved
Basically I emptied all the non essential tables like cache, sessions, accesslog, badbehaviour (deleted it from the modules folder), and some other tables which I can't think of right now.
It proves to be the pathauto module that was causing this issue. I had applied the patch of comment 17 at http://drupal.org/node/43712, but it seems that my bookstrap.inc, common.inc and updates.inc were not patched for some reason. The index on the srs column of the url_alias table was created fine though when first applied the patch.
Comment #23 in the above thread fixed the lag I was having and now the site works a treat... We even published an article and all went smooth! I feel SO relieved about this, as I have been through every module in my modules folder.
However, this still has not ended my troubles, as now I am getting something like 60 queries to the url_alias table for each and every pageview. My flight is in 5 hours and still have not packed... Will keep you guys updated from tomorrow night or whenever I get the chance to look at the site config again.
Thanks for the help !! After days of constant fiddling around I managed to sort something temporary out... even before my flight...
I'll drink to you guys and especially to Marandb and Matt Westgate.
Regards,
Pavlos
(Subscribing to this thread)
(Subscribing to this thread)
Concluding On The Issue
Hello to all,
I've been so busy lately that I haven't even managed to look at this page for ages. I noticed it while searching for things on the forums. Since it may help others, here is what I have found so far on modules and settings (4.6) that consume a lot of CPU on a relatively busy site (at times).
1 - Bad Behaviour Module: This creates a huge CPU overload. If I remember well (it's been a few weeks since I disabled that) it checks all IP addresses against the session or access_log table. For a news website, this creates a major load as when a story gets published a lot of robots and visitors hit the server simultaneously and sometimes experienced several thousand visitors within 5 minutes of a story getting published.
2 - Statistics Module: Let's face it... It is highly addictive. If you have this module enabled, it logs each and every user agent's access. For small sites this is fine to have, but 3000 hits simultaneously will make mysql to melt. If you run several Drupal sites, a dedicated server just for this module will be required.
3 - Cronjobs: I am not an experienced programmer so I am not sure exactly which tasks run during cronruns. It seems that if the server gets many hits and the cron runs, I need to restart the system to make mysql available again. So now that I've got 3000 hits the server seems able to cope, IF and only IF a cron run is not scheduled during the high loads time. I set cron runs to over an hour during busy times on the server and frequently later.
4 - URL Aliases / Pathauto: Now that really tricky... After the site got over 2000 aliases in the url_alias table things started to become problematic. I applied the patch (don't have the link with me now) that is for the URL alias index, it kinda sorted the cpu usage but still it is too much. I am starting to regret using this. Don't know how 4.7 handles with that, but it seems to me that if you have many links to inner pages on your template for which the server needs to grab the alias one by one from the url_aliases table it ends up running over 400 select queries on that table for each and every page my visitors see.
(tried to explain it as nicely as possible... forgive my greeklish.... I speak England very best some times!!)
5 - Other Modules: When your site gets really busy, the advice here is to go through and disable all modules/filters/etc. which you don't need. In the case of unused modules I would delete them from my modules folder as well.
6 - Watchdog: This mysql table if you forget about it it can get quite huge. Mine had over 170,000 rows at some point, which was a direct result of some url and architectural changes on the site (getting 404s from search engines). Even though this table probably is not used that much by the system, apart from recording errors and stuff. But just in case, check it every month to see how big it is. If you happen to visit the /admin page and at the same time there is high load on the server, this can also cause mysql timeouts which in some cases my mysql 4.1.18 needs a restart to start functioning again.
7 - Sessions mysql table quiz: How many rows are in your sessions table today?
I think it is worth every now and then emptying this table... The only abnormality I've noticed is that it logs me out.
-.
I think this pretty much covers what I have found so far. I am totally busy and might have forgotten some things. If I remember something I'll post a reply below. Sorry for replying so late and sorry for replying to an old thread, but it shows up on many searches I did so I thought it would be worth publishing my findings here so that others who might run into the same issues find out information.
Regards,
Pavlos
thank you
Pavlos,
this is a great list. Thank you for taking the time to write this thoughtful summary.
Drupal ecommerce, at http://www.drupalecommerce.com
http://www.drupalecommerce.com/troubleshooting
http://www.drupalecommerce.com/modulesexplained
http://www.drupalecommerce.com/47vs46
http://www.drupalecommerce.com/howto
Architectural issues?
Thanks for the wonderful summary!
I'm wondering if this is in fact an architectural issue -- for example, bad behavior. Would this be better done outside Drupal, for example? My cPanel has an IP banning feature that would seem to substitute for it. Same deal with statistics.
It's wonderful to do everything in drupal... But that doesn't mean that we have to!
Sure Thing
But it would still use the same amount of server resources. If you have the devel module enabled and see the queries bad_behaviour sends are very heavy for the database. It checks the ip address of the visitor against the sessions table. Now if your site has over 1000 sessions initiated within say 10 seconds, you will understand my point about bad_behaviour.
As for doing it manually for every IP address, it is not exactly the solution when you have to ban at least 10 of them daily. The spam module does a good job actually.
Adding on to the conversation here, the 4.7 release seems to have stabilised my site on very high load times. The mysql server does not melt from the load and the pages don't take ages to load. Traffic has kept increasing by several thousands each week and the server seems to be coping fine.
I could not figure out why I had all those problems with 4.6. Probably because it was an installation done about a year ago, while I was learning the Drupal basics.
Bookmarking...
And saying thanks. My situation is also the "Very big project, very small IT group", so I can really empathize. Thanks for letting us learn from the experience.
where is it now
If your traffic has increased by several thousands each week, where is it now? that's quite impressive. congratulations.
How are you paying for this? I can hardly imagine that the ads can cover the costs and your time, which must be quite expensive. If the ads generate that much revenue it would be very useful to know. thank you.
Depends on Traffic
I am not allowed to reveal figures (ask Google why), but it does cover our costs (when there is traffic).
We are running the site on a complex network with several servers supporting it. It simply could not cope with the load being on a 2.8Ghz dual-core with 2 Gb Ram and our host had to figure out a totally different solution. Depends on the fuss that our stories generate on the various forums/news sites/etc. that our headlines circulate..
Imagine all this just for the 2 minutes after a new story gets published. It knocked the server down and mysql would crash each time from too many requests and sometimes had to do a full server restart to get it back up (until the next story)...
Thanks to Drupal, costs are relatively low to develop, operate and maintain such a website, even though I am the only one behind the job. I think that is the key to our business model, and at least 55,000 other Drupalers out there.
Sorry for the late reply, I had just so many things to do and had no time to look at drupal.org...
Server Config
Pavlos,
You mention that your dual xeon couldn't cope (was this 2 dual core or 1 dual core?). Would you share what configuration ended up skinning this cat? Front-end/back-end split? Any other mysql-specific config stuff that you had done?
Thanks.
Hello First of all, thanks
Hello
First of all, thanks for your conclusions. I'm trying to migrate a high-traffic site to drupal. i have to use pathauto for obvious reasons. i'm sure you and most other people have to, too. what did you do to make-up the performance hit of pathauto? what do you or any other expert advises how to best minimize this?
Thanks
Pathauto
No worries...
The thing is that pathauto is an unavoidable module... I thought that this was the main cause of my cpu usage problems but it is not (unless you use the unpatched 4.6 pathauto...
Generally my (humble) opinion is to avoid third-party modules as much as possible, especially the bad behaviour.
could that be related to the taxonomy static cache mechanism ?
I run in similar problems if you have a lot of terms within the same vocabulary (taxonomy module) or a lot of category within the same container (category module) this might be the reason see
http://drupal.org/node/71612
This is purely hypothetic indeed.
Too many categories
That issue is about a lot of categories indeed. I have about 350, which is nothing like 10,000...
The thing is that unless you experience over 500 unique hits (mainly from people trying to load one story) in a single minute, you probably won't have a problem (talking about this thread).
Hello First of all, thanks
Hello
First of all, thanks for your conclusions. I'm trying to migrate a high-traffic site to drupal. i have to use pathauto for obvious reasons. i'm sure you and most other people have to, too. what did you do to make-up the performance hit of pathauto? what do you or any other expert advises how to best minimize this?
edit: how did you append suffix (.html) to content node?
Thanks
Another thing to look for
I found out that if you have a customized front page, AND have nodes marked as 'promote' ( but have say just 3 nodes on the front page ) Drupal will generate queries for all those nodes.
This might be too obvious
But just in case...since I didn't see it mentioned...MySQL query cache can really help a lot for often made queries, which I guess pathauto would generate. I did a lot of stress testing on a few projects and amongst other things used the MySQL admin tools to monitor effects - the impact of the query cache was huge, especially considering that all one has to do is to switch it on.
not everyone has access to
not everyone has access to that switch. shared hosting users for example.
Of course
It would actually be beneficial to the hosting service as well, as it takes a lot of strain from the DB server and requires literally no setup or maintenance. Depending on the type of service, it might be worth asking whether this is enabled and if not, why not.
Plus pavlos, the original initiator of this thread, seems to have complete control over the hosting environment, which is a big bonus. Even getting Drupal to run properly in an environment you have no control over can be a nightmare - while on a testing server it's a matter of minutes if the setup is right...