{"id":37,"date":"2007-06-30T17:50:50","date_gmt":"2007-07-01T01:50:50","guid":{"rendered":"http:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/"},"modified":"2017-03-08T14:50:17","modified_gmt":"2017-03-08T22:50:17","slug":"download-counts-halted","status":"publish","type":"post","link":"https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/","title":{"rendered":"Download Counts Halted"},"content":{"rendered":"<p>The download controller was modified on Thursday to prepare for the release of the 1.5.0.12 -&gt; 2.0.0.4 major update.  During release cycles, AMO takes abnormally high load which sometimes causes interruptions in service.<\/p>\n<p>To avoid this situation we agreed to cache public download hits from the AMO install buttons.  This does two things:<\/p>\n<ul>\n<li>Relieve application load by allowing the hardware load balancer to cache file requests &#8212; which are ultimately redirects to releases.mozilla.org<\/li>\n<li>Relieve the database by not having constant inserts on the download table &#8212; which causes extra load because of indexes that were put on the table to make count updates work correctly<\/li>\n<\/ul>\n<p>The benefits can be seen below.  First, traffic for a web node:<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/people.mozilla.com\/~morgamic\/download-1.png\" alt=\"traffic for AMO\" height=\"213\" width=\"597\" \/><\/p>\n<p>Second, a CPU usage graph from the same node:<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/people.mozilla.com\/~morgamic\/download-2.png\" alt=\"cpu usage\" height=\"269\" width=\"597\" \/><\/p>\n<p>You can see the positive effect on load near noon on Wed.<\/p>\n<p>The status of download counts is tracked in <a href=\"https:\/\/bugzilla.mozilla.org\/show_bug.cgi?id=384084\" title=\"download count parser bug\">bug 384084<\/a>.  The plan is to create a background maintenance script that parses AMO logs via a cron job in off-peak hours.  Counts will be updated once a day.<\/p>\n<p>In addition to this, we are taking the opportunity to do a couple of things.  For our summer goals, we plan on improving statistics for developers by offering:<\/p>\n<ul>\n<li>Actual update ping counts in <a href=\"https:\/\/bugzilla.mozilla.org\/show_bug.cgi?id=384086\">bug 384086<br \/>\n<\/a><\/li>\n<li>An improved API for aggregating add-on statistics and integrating it into your blog or external sites<\/li>\n<\/ul>\n<p>We plan on resuming download counts early next week and update pings should be available by mid July.  Thanks for your patience as we make adjustments to accomodate server load, and have a great 4th of July!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The download controller was modified on Thursday to prepare for the release of the 1.5.0.12 -&gt; 2.0.0.4 major update. During release cycles, AMO takes abnormally high load which sometimes causes interruptions in service. To avoid this situation we agreed to &hellip; <a class=\"go\" href=\"https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/\">Continue reading<\/a><\/p>\n","protected":false},"author":24,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"coauthors":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Download Counts Halted - Mozilla Web Development<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mike Morgan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/\",\"url\":\"https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/\",\"name\":\"Download Counts Halted - Mozilla Web Development\",\"isPartOf\":{\"@id\":\"https:\/\/blog.mozilla.org\/webdev\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/people.mozilla.com\/~morgamic\/download-1.png\",\"datePublished\":\"2007-07-01T01:50:50+00:00\",\"dateModified\":\"2017-03-08T22:50:17+00:00\",\"author\":{\"@id\":\"https:\/\/blog.mozilla.org\/webdev\/#\/schema\/person\/373fd84922ef95d8d5171d1a72770d4f\"},\"breadcrumb\":{\"@id\":\"https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/#primaryimage\",\"url\":\"http:\/\/people.mozilla.com\/~morgamic\/download-1.png\",\"contentUrl\":\"http:\/\/people.mozilla.com\/~morgamic\/download-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/blog.mozilla.org\/webdev\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Download Counts Halted\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.mozilla.org\/webdev\/#website\",\"url\":\"https:\/\/blog.mozilla.org\/webdev\/\",\"name\":\"Mozilla Web Development\",\"description\":\"For make benefit of glorious tubes\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.mozilla.org\/webdev\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.mozilla.org\/webdev\/#\/schema\/person\/373fd84922ef95d8d5171d1a72770d4f\",\"name\":\"Mike Morgan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/blog.mozilla.org\/webdev\/#\/schema\/person\/image\/1d6151e93e27d281a7fc06534ee8eae0\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ff5890a3252cd74f006ee33360e71c76?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ff5890a3252cd74f006ee33360e71c76?s=96&d=mm&r=g\",\"caption\":\"Mike Morgan\"},\"description\":\"Mike Morgan is the former Director of Web Development for the Mozilla Corporation.\",\"url\":\"https:\/\/blog.mozilla.org\/webdev\/author\/morgamicmozillacom\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Download Counts Halted - Mozilla Web Development","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/","twitter_misc":{"Written by":"Mike Morgan","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/","url":"https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/","name":"Download Counts Halted - Mozilla Web Development","isPartOf":{"@id":"https:\/\/blog.mozilla.org\/webdev\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/#primaryimage"},"image":{"@id":"https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/#primaryimage"},"thumbnailUrl":"http:\/\/people.mozilla.com\/~morgamic\/download-1.png","datePublished":"2007-07-01T01:50:50+00:00","dateModified":"2017-03-08T22:50:17+00:00","author":{"@id":"https:\/\/blog.mozilla.org\/webdev\/#\/schema\/person\/373fd84922ef95d8d5171d1a72770d4f"},"breadcrumb":{"@id":"https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/#primaryimage","url":"http:\/\/people.mozilla.com\/~morgamic\/download-1.png","contentUrl":"http:\/\/people.mozilla.com\/~morgamic\/download-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/blog.mozilla.org\/webdev\/2007\/06\/30\/download-counts-halted\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blog.mozilla.org\/webdev\/"},{"@type":"ListItem","position":2,"name":"Download Counts Halted"}]},{"@type":"WebSite","@id":"https:\/\/blog.mozilla.org\/webdev\/#website","url":"https:\/\/blog.mozilla.org\/webdev\/","name":"Mozilla Web Development","description":"For make benefit of glorious tubes","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.mozilla.org\/webdev\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/blog.mozilla.org\/webdev\/#\/schema\/person\/373fd84922ef95d8d5171d1a72770d4f","name":"Mike Morgan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/blog.mozilla.org\/webdev\/#\/schema\/person\/image\/1d6151e93e27d281a7fc06534ee8eae0","url":"https:\/\/secure.gravatar.com\/avatar\/ff5890a3252cd74f006ee33360e71c76?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ff5890a3252cd74f006ee33360e71c76?s=96&d=mm&r=g","caption":"Mike Morgan"},"description":"Mike Morgan is the former Director of Web Development for the Mozilla Corporation.","url":"https:\/\/blog.mozilla.org\/webdev\/author\/morgamicmozillacom\/"}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/posts\/37"}],"collection":[{"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/users\/24"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/comments?post=37"}],"version-history":[{"count":0,"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/posts\/37\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/media?parent=37"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/categories?post=37"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/tags?post=37"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/blog.mozilla.org\/webdev\/wp-json\/wp\/v2\/coauthors?post=37"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}