Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(49)

Issue 27047003: Precache tracking database (Closed)

Created:
7 years, 2 months ago by sclittle
Modified:
7 years ago
CC:
chromium-reviews, cbentzel+watch_chromium.org
Base URL:
https://chromium.googlesource.com/chromium/src.git@precache
Visibility:
Public.

Description

Metrics database for tracking precache statistics. BUG=306185, 309216 Committed: https://src.chromium.org/viewvc/chrome?view=rev&revision=238824

Patch Set 1 #

Patch Set 2 : General fixes, added tests, and moved PrecacheManager into component #

Total comments: 60

Patch Set 3 : Addressed comments #

Total comments: 4

Patch Set 4 : Moved MostVisitedURLsProvider into chrome/browser/precache #

Total comments: 41

Patch Set 5 : Addressed comments #

Total comments: 17

Patch Set 6 : Addressed comments #

Patch Set 7 : Added field trials #

Total comments: 31

Patch Set 8 : Reduced CL down to just the PrecacheDatabase #

Total comments: 19

Patch Set 9 : Addressed comments #

Total comments: 6

Patch Set 10 : Addressed comments #

Total comments: 38

Patch Set 11 : Addressed comments #

Total comments: 2

Patch Set 12 : Addressed comments #

Total comments: 12

Patch Set 13 : Changed to report metrics per-resource, and addressed comments #

Total comments: 8

Patch Set 14 : Addressed comments #

Total comments: 2

Patch Set 15 : Addressed comments #

Patch Set 16 : Updated histogram comments to indicate that metrics are logged in bytes, not KB #

Patch Set 17 : Changed components_tests.gyp to depend on precache_core target instead of precache target #

Unified diffs Side-by-side diffs Delta from patch set Stats (+935 lines, -11 lines) Patch
M components/components_tests.gyp View 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 2 chunks +2 lines, -1 line 0 comments Download
M components/precache.gypi View 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 2 chunks +4 lines, -10 lines 0 comments Download
M components/precache/core/DEPS View 1 chunk +1 line, -0 lines 0 comments Download
A components/precache/core/precache_database.h View 1 2 3 4 5 6 7 8 9 10 11 12 1 chunk +79 lines, -0 lines 0 comments Download
A components/precache/core/precache_database.cc View 1 2 3 4 5 6 7 8 9 10 11 12 13 1 chunk +165 lines, -0 lines 0 comments Download
A components/precache/core/precache_database_unittest.cc View 1 2 3 4 5 6 7 8 9 10 11 12 13 1 chunk +388 lines, -0 lines 0 comments Download
A components/precache/core/precache_url_table.h View 1 2 3 4 5 6 7 8 9 10 11 12 1 chunk +61 lines, -0 lines 0 comments Download
A components/precache/core/precache_url_table.cc View 1 2 3 4 5 6 7 8 9 10 11 12 13 1 chunk +90 lines, -0 lines 0 comments Download
A components/precache/core/precache_url_table_unittest.cc View 1 2 3 4 5 6 7 8 9 1 chunk +116 lines, -0 lines 0 comments Download
M tools/metrics/histograms/histograms.xml View 2 chunks +29 lines, -0 lines 0 comments Download

Messages

Total messages: 54 (0 generated)
sclittle
I've written the code for the precache database. It still needs more unit tests, and ...
7 years, 2 months ago (2013-10-16 07:41:56 UTC) #1
bengr
On 2013/10/16 07:41:56, sclittle wrote: > I've written the code for the precache database. > ...
7 years, 2 months ago (2013-10-18 21:43:31 UTC) #2
sclittle
I've added tests and made a lot of general fixes. It's still a little rough, ...
7 years, 2 months ago (2013-10-23 05:34:25 UTC) #3
bengr
https://codereview.chromium.org/27047003/diff/24028/chrome/browser/DEPS File chrome/browser/DEPS (right): https://codereview.chromium.org/27047003/diff/24028/chrome/browser/DEPS#newcode16 chrome/browser/DEPS:16: "+components/precache", alphabetize. https://codereview.chromium.org/27047003/diff/24028/chrome/browser/history/most_visited_urls_provider.cc File chrome/browser/history/most_visited_urls_provider.cc (right): https://codereview.chromium.org/27047003/diff/24028/chrome/browser/history/most_visited_urls_provider.cc#newcode1 chrome/browser/history/most_visited_urls_provider.cc:1: // ...
7 years, 2 months ago (2013-10-23 19:03:36 UTC) #4
sclittle
https://codereview.chromium.org/27047003/diff/24028/chrome/browser/DEPS File chrome/browser/DEPS (right): https://codereview.chromium.org/27047003/diff/24028/chrome/browser/DEPS#newcode16 chrome/browser/DEPS:16: "+components/precache", On 2013/10/23 19:03:36, bengr1 wrote: > alphabetize. Done. ...
7 years, 2 months ago (2013-10-24 22:11:37 UTC) #5
sclittle
mmenke: components/precache/*, chrome_network_delegate joi: components_tests.gyp sky: chrome/browser/history/* jar: histograms.xml Thanks in advance!
7 years, 2 months ago (2013-10-25 01:10:36 UTC) #6
jar (doing other things)
Alexei for histograms.xml review
7 years, 2 months ago (2013-10-25 01:15:58 UTC) #7
Jói
components_tests.gypi LGTM
7 years, 1 month ago (2013-10-25 10:53:09 UTC) #8
mmenke
On 2013/10/25 10:53:09, Jói wrote: > components_tests.gypi LGTM I'm pretty loaded with reviews today, not ...
7 years, 1 month ago (2013-10-25 14:47:39 UTC) #9
sky
What do you need me to review?
7 years, 1 month ago (2013-10-28 14:13:34 UTC) #10
sclittle1
On Mon, Oct 28, 2013 at 7:13 AM, <sky@chromium.org> wrote: > What do you need ...
7 years, 1 month ago (2013-10-28 17:09:05 UTC) #11
sky
Is there a design doc or something you can point me at?
7 years, 1 month ago (2013-10-28 19:56:03 UTC) #12
sclittle
On 2013/10/28 19:56:03, sky wrote: > Is there a design doc or something you can ...
7 years, 1 month ago (2013-10-28 20:13:19 UTC) #13
sky
Thanks for the pointer. One more question, has this gone through eng review? It is ...
7 years, 1 month ago (2013-10-28 23:11:59 UTC) #14
sky
https://codereview.chromium.org/27047003/diff/174001/chrome/browser/history/most_visited_urls_provider.h File chrome/browser/history/most_visited_urls_provider.h (right): https://codereview.chromium.org/27047003/diff/174001/chrome/browser/history/most_visited_urls_provider.h#newcode18 chrome/browser/history/most_visited_urls_provider.h:18: class MostVisitedURLsProvider : public precache::URLListProvider { Is there a ...
7 years, 1 month ago (2013-10-28 23:14:16 UTC) #15
sclittle
On 2013/10/28 23:11:59, sky wrote: > Thanks for the pointer. > > One more question, ...
7 years, 1 month ago (2013-10-29 01:26:57 UTC) #16
sclittle
https://codereview.chromium.org/27047003/diff/174001/chrome/browser/history/most_visited_urls_provider.h File chrome/browser/history/most_visited_urls_provider.h (right): https://codereview.chromium.org/27047003/diff/174001/chrome/browser/history/most_visited_urls_provider.h#newcode18 chrome/browser/history/most_visited_urls_provider.h:18: class MostVisitedURLsProvider : public precache::URLListProvider { On 2013/10/28 23:14:16, ...
7 years, 1 month ago (2013-10-29 07:16:05 UTC) #17
sky
You've removed the changes from chrome/browser/history, so you no longer need me:) -sky As to ...
7 years, 1 month ago (2013-10-29 17:06:11 UTC) #18
mmenke
https://codereview.chromium.org/27047003/diff/444001/chrome/browser/net/chrome_network_delegate.cc File chrome/browser/net/chrome_network_delegate.cc (right): https://codereview.chromium.org/27047003/diff/444001/chrome/browser/net/chrome_network_delegate.cc#newcode43 chrome/browser/net/chrome_network_delegate.cc:43: #include "components/precache/core/precache_database.h" Here and for the other new code, ...
7 years, 1 month ago (2013-10-29 18:23:33 UTC) #19
sclittle
Thanks for the review, replies are below. https://codereview.chromium.org/27047003/diff/444001/chrome/browser/net/chrome_network_delegate.cc File chrome/browser/net/chrome_network_delegate.cc (right): https://codereview.chromium.org/27047003/diff/444001/chrome/browser/net/chrome_network_delegate.cc#newcode43 chrome/browser/net/chrome_network_delegate.cc:43: #include "components/precache/core/precache_database.h" ...
7 years, 1 month ago (2013-10-29 23:40:45 UTC) #20
mmenke
https://codereview.chromium.org/27047003/diff/444001/chrome/browser/net/chrome_network_delegate.cc File chrome/browser/net/chrome_network_delegate.cc (right): https://codereview.chromium.org/27047003/diff/444001/chrome/browser/net/chrome_network_delegate.cc#newcode43 chrome/browser/net/chrome_network_delegate.cc:43: #include "components/precache/core/precache_database.h" On 2013/10/29 23:40:45, sclittle wrote: > On ...
7 years, 1 month ago (2013-10-30 18:29:07 UTC) #21
sclittle
Thanks for the comments, replies are below. https://codereview.chromium.org/27047003/diff/444001/components/precache/core/precache_database.cc File components/precache/core/precache_database.cc (right): https://codereview.chromium.org/27047003/diff/444001/components/precache/core/precache_database.cc#newcode134 components/precache/core/precache_database.cc:134: // resource ...
7 years, 1 month ago (2013-10-30 20:29:48 UTC) #22
mmenke
I'll have more comments later today - sorry on the slow start, I was really ...
7 years, 1 month ago (2013-10-31 16:44:59 UTC) #23
cbentzel
Let's do a bit more of an eng review as sky@ suggested before tunneling in ...
7 years, 1 month ago (2013-10-31 17:03:41 UTC) #24
sclittle
I'm splitting this CL into multiple smaller CLs; this CL now only contains the metrics ...
7 years, 1 month ago (2013-11-06 01:51:41 UTC) #25
mmenke
[+davidben], who has agreed to take over the review from me.
7 years, 1 month ago (2013-11-06 16:12:41 UTC) #26
davidben
I'm actually not familiar with either our metrics or database code. But here're some stylistic ...
7 years, 1 month ago (2013-11-06 23:50:52 UTC) #27
sclittle
Thanks for the comments, replies below. https://codereview.chromium.org/27047003/diff/1084001/components/precache/core/precache_database.cc File components/precache/core/precache_database.cc (right): https://codereview.chromium.org/27047003/diff/1084001/components/precache/core/precache_database.cc#newcode72 components/precache/core/precache_database.cc:72: db_.reset(db.release()); On 2013/11/06 ...
7 years, 1 month ago (2013-11-09 01:07:57 UTC) #28
davidben
There's one test that's still using local time (via base::Time::FromString). You probably want to change ...
7 years, 1 month ago (2013-11-11 19:06:25 UTC) #29
Alexei Svitkine (slow)
https://codereview.chromium.org/27047003/diff/1234001/tools/metrics/histograms/histograms.xml File tools/metrics/histograms/histograms.xml (right): https://codereview.chromium.org/27047003/diff/1234001/tools/metrics/histograms/histograms.xml#newcode13471 tools/metrics/histograms/histograms.xml:13471: + The daily number of kilobytes that were downloaded ...
7 years, 1 month ago (2013-11-11 20:04:11 UTC) #30
sclittle
https://codereview.chromium.org/27047003/diff/1084001/components/precache/core/precache_database.cc File components/precache/core/precache_database.cc (right): https://codereview.chromium.org/27047003/diff/1084001/components/precache/core/precache_database.cc#newcode161 components/precache/core/precache_database.cc:161: precache_url_table_->DeleteURL(url); On 2013/11/11 19:06:26, David Benjamin wrote: > On ...
7 years, 1 month ago (2013-11-19 04:03:40 UTC) #31
sclittle
+shess: components/precache/core/DEPS, added "+sql" Thanks!
7 years, 1 month ago (2013-11-19 04:07:20 UTC) #32
Scott Hess - ex-Googler
As a general comment, as I've crawled through Chromium code fixing SQLite mis-uses, I have ...
7 years, 1 month ago (2013-11-19 18:47:47 UTC) #33
Scott Hess - ex-Googler
Also - are you planning for this to stick around for the long term? It ...
7 years, 1 month ago (2013-11-19 19:23:35 UTC) #34
sclittle
Thanks for the comments, replies are below. @shess: Regarding your comment about combining the database ...
7 years, 1 month ago (2013-11-19 23:27:09 UTC) #35
sclittle
Ping? My internship ends in a few weeks, and I have a bunch of CLs ...
7 years ago (2013-11-26 20:41:33 UTC) #36
jar (doing other things)
IMO, the histograms that you're gathering (at least based on the description) will be hard ...
7 years ago (2013-11-26 20:52:53 UTC) #37
sclittle
https://codereview.chromium.org/27047003/diff/1504001/tools/metrics/histograms/histograms.xml File tools/metrics/histograms/histograms.xml (right): https://codereview.chromium.org/27047003/diff/1504001/tools/metrics/histograms/histograms.xml#newcode13721 tools/metrics/histograms/histograms.xml:13721: + over 24 hour intervals, and can cover multiple ...
7 years ago (2013-11-26 22:22:28 UTC) #38
jar (doing other things)
On 2013/11/26 22:22:28, sclittle wrote: > https://codereview.chromium.org/27047003/diff/1504001/tools/metrics/histograms/histograms.xml > File tools/metrics/histograms/histograms.xml (right): > > https://codereview.chromium.org/27047003/diff/1504001/tools/metrics/histograms/histograms.xml#newcode13721 > ...
7 years ago (2013-11-26 23:40:54 UTC) #39
Scott Hess - ex-Googler
Sorry about the long delay. Feel free to ping earlier, either I'll be like "Oh, ...
7 years ago (2013-11-27 01:32:32 UTC) #40
sclittle
On 2013/11/26 23:40:54, jar wrote: > On 2013/11/26 22:22:28, sclittle wrote: > > > https://codereview.chromium.org/27047003/diff/1504001/tools/metrics/histograms/histograms.xml ...
7 years ago (2013-11-27 18:53:06 UTC) #41
jar (doing other things)
> Do you know if there's a way to get the median user's savings from ...
7 years ago (2013-11-28 01:00:45 UTC) #42
sclittle
On 2013/11/28 01:00:45, jar wrote: > > Do you know if there's a way to ...
7 years ago (2013-11-28 01:05:25 UTC) #43
sclittle
Thanks for the comments, replies are below. I've changed it to report metrics on a ...
7 years ago (2013-12-02 21:12:51 UTC) #44
Scott Hess - ex-Googler
LGTM, the only real change I want is stringprintf.h. The others are just suggestions. If ...
7 years ago (2013-12-03 20:55:36 UTC) #45
sclittle
jar or asvitkine, PTAL https://codereview.chromium.org/27047003/diff/1564001/components/precache/core/precache_database.cc File components/precache/core/precache_database.cc (right): https://codereview.chromium.org/27047003/diff/1564001/components/precache/core/precache_database.cc#newcode54 components/precache/core/precache_database.cc:54: transaction.Commit(); On 2013/12/03 20:55:38, shess ...
7 years ago (2013-12-04 19:07:09 UTC) #46
Scott Hess - ex-Googler
changes lgtm
7 years ago (2013-12-04 19:09:46 UTC) #47
Alexei Svitkine (slow)
histograms lgtm % comment https://codereview.chromium.org/27047003/diff/1584001/tools/metrics/histograms/histograms.xml File tools/metrics/histograms/histograms.xml (right): https://codereview.chromium.org/27047003/diff/1584001/tools/metrics/histograms/histograms.xml#newcode13880 tools/metrics/histograms/histograms.xml:13880: + fetches that were not ...
7 years ago (2013-12-04 19:11:49 UTC) #48
sclittle
https://codereview.chromium.org/27047003/diff/1584001/tools/metrics/histograms/histograms.xml File tools/metrics/histograms/histograms.xml (right): https://codereview.chromium.org/27047003/diff/1584001/tools/metrics/histograms/histograms.xml#newcode13880 tools/metrics/histograms/histograms.xml:13880: + fetches that were not motivated by precaching. On ...
7 years ago (2013-12-04 19:21:10 UTC) #49
commit-bot: I haz the power
CQ is trying da patch. Follow status at https://chromium-status.appspot.com/cq/sclittle@chromium.org/27047003/1604001
7 years ago (2013-12-04 19:25:13 UTC) #50
commit-bot: I haz the power
CQ is trying da patch. Follow status at https://chromium-status.appspot.com/cq/sclittle@chromium.org/27047003/1624001
7 years ago (2013-12-04 20:10:26 UTC) #51
commit-bot: I haz the power
Retried try job too often on ios_dbg_simulator for step(s) base_unittests, compile, content_unittests, crypto_unittests, net_unittests, sql_unittests, ...
7 years ago (2013-12-04 21:08:27 UTC) #52
commit-bot: I haz the power
CQ is trying da patch. Follow status at https://chromium-status.appspot.com/cq/sclittle@chromium.org/27047003/1644001
7 years ago (2013-12-04 21:41:30 UTC) #53
commit-bot: I haz the power
7 years ago (2013-12-05 00:12:31 UTC) #54
Message was sent while issue was closed.
Change committed as 238824

Powered by Google App Engine
This is Rietveld 408576698