https://bugzilla.wikimedia.org/show_bug.cgi?id=37030
--- Comment #7 from Asher Feldman <[email protected]> 2012-08-01 19:30:39 UTC --- I was just tracking queries to the enwiki master from my ip address while browsing wikipedia as a logged out user. Loading https://en.wikipedia.org/wiki/The_Squire_of_Long_Hadley resulted in 19 Revision::newFromTitle SELECT queries to enwiki master, as follows. Repeated reloads result in the last three selects every time. I would guess that the first load required a parse, and that for this page there are three page_latest master queries for each pcache hit. SELECT /* Revision::newFromTitle 98.210.186.194 */ page_latest FROM `page` WHERE page_namespace = '10' AND page_title = 'Imdb_title' LIMIT 1 SELECT /* Revision::newFromTitle 98.210.186.194 */ page_latest FROM `page` WHERE page_namespace = '10' AND page_title = 'IMDb_title' LIMIT 1 SELECT /* Revision::newFromTitle 98.210.186.194 */ page_latest FROM `page` WHERE page_namespace = '10' AND page_title = 'CinemaoftheUK' LIMIT 1 SELECT /* Revision::newFromTitle 98.210.186.194 */ page_latest FROM `page` WHERE page_namespace = '10' AND page_title = 'Cinema_of_the_United_Kingdom' LIMIT 1 SELECT /* Revision::newFromTitle 98.210.186.194 */ page_latest FROM `page` WHERE page_namespace = '10' AND page_title = 'Navbox' LIMIT 1 SELECT /* Revision::newFromTitle 98.210.186.194 */ page_latest FROM `page` WHERE page_namespace = '10' AND page_title = 'Flagicon' LIMIT 1 SELECT /* Revision::newFromTitle 98.210.186.194 */ page_latest FROM `page` WHERE page_namespace = '10' AND page_title = 'Country_data_United_Kingdom' LIMIT 1 SELECT /* Revision::newFromTitle 98.210.186.194 */ page_latest FROM `page` WHERE page_namespace = '10' AND page_title = 'Flagicon/core' LIMIT 1 SELECT /* Revision::newFromTitle 98.210.186.194 */ page_latest FROM `page` WHERE page_namespace = '10' AND page_title = 'Navbar' LIMIT 1 SELECT /* Revision::newFromTitle 98.210.186.194 */ page_latest FROM `page` WHERE page_namespace = '10' AND page_title = 'Transclude' LIMIT 1 SELECT /* Revision::newFromTitle 98.210.186.194 */ page_latest FROM `page` WHERE page_namespace = '10' AND page_title = 'Navbox_subgroup' LIMIT 1 SELECT /* Revision::newFromTitle 98.210.186.194 */ page_latest FROM `page` WHERE page_namespace = '10' AND page_title = 'Icon' LIMIT 1 SELECT /* Revision::newFromTitle 98.210.186.194 */ page_latest FROM `page` WHERE page_namespace = '10' AND page_title = '!' LIMIT 1 SELECT /* Revision::newFromTitle 98.210.186.194 */ page_latest FROM `page` WHERE page_namespace = '10' AND page_title = 'Sinclair_Hill' LIMIT 1 SELECT /* Revision::newFromTitle 98.210.186.194 */ page_latest FROM `page` WHERE page_namespace = '10' AND page_title = '1920s-UK-film-stub' LIMIT 1 SELECT /* Revision::newFromTitle 98.210.186.194 */ page_latest FROM `page` WHERE page_namespace = '10' AND page_title = 'Asbox' LIMIT 1 SELECT /* Revision::newFromTitle 98.210.186.194 */ page_latest FROM `page` WHERE page_namespace = '8' AND page_title = 'Gadget-ReferenceTooltips.js' LIMIT 1 SELECT /* Revision::newFromTitle 98.210.186.194 */ page_latest FROM `page` WHERE page_namespace = '8' AND page_title = 'Gadget-DRN-wizard-loader.js' LIMIT 1 SELECT /* Revision::newFromTitle 98.210.186.194 */ page_latest FROM `page` WHERE page_namespace = '8' AND page_title = 'Common.js/secure_new.js' LIMIT 1 -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
