Skip to content

Instantly share code, notes, and snippets.

@macbre

macbre/image_review.tsv

Created June 24, 2017 12:53
Show Gist options
  • Save macbre/29e4e18743b863540ada31d66af80eff to your computer and use it in GitHub Desktop.
Save macbre/29e4e18743b863540ada31d66af80eff to your computer and use it in GitHub Desktop.
Download ZIP
Old image review data flow
Raw
image_review.tsv
We can make this file beautiful and searchable if this error is corrected: Illegal quoting in line 1.
# Query digest for "image_review" table, found 7220 queries
dataware:image_review getImageReviewFiles UpdateImageReview 0.97 cron, median time: 38.70 ms, count: 322200
dataware:image_review isTop200 UpdateImageReview 1.00 cron, median time: 18.00 ms, count: 333400
Wikia\Tasks\Tasks\ImageReviewTask addToQueue dataware:image_review 0.04 task, median time: 86.19 ms, count: 11900
dataware:image_review isTop200 Wikia\Tasks\Tasks\ImageReviewTask 0.04 task, median time: 40.29 ms, count: 12700
UpdateImageReview updateDatawareFile dataware:image_review 0.05 cron, median time: 64.90 ms, count: 15600
dataware:image_review selectImagesForList ImageReviewDatabaseHelper 0.03 ap, median time: 57.70 ms, count: 9900
dataware:image_review countImagesByState ImageReviewDatabaseHelper 0.02 ap, median time: 48.80 ms, count: 5700
dataware:image_review refetchImageListByTimestamp ImageReviewHelper 0.01 ap, median time: 44.25 ms, count: 5000
ImageReviewHelper updateImageState dataware:image_review 0.01 ap, median time: 77.35 ms, count: 2000
ImageReviewHelper getImageList dataware:image_review 0.01 ap, median time: 36.31 ms, count: 1700
Wikia\Tasks\Tasks\ImageReviewTask deleteFromQueue dataware:image_review 0.00 task, median time: 81.71 ms, count: 900
dataware:image_review update_page.pl:345 (SELECT) backend:update_page.pl 0.00 job, median time: 45.06 ms, count: 400
backend:fiximagereview.pl fiximagereview.pl:123 (INSERT) dataware:image_review 0.00 cron, median time: 369.22 ms, count: 100
CloseWikiMaintenance doTableCleanup dataware:image_review 0.00 cron, median time: 21.22 ms, count: 300
dataware:image_review fiximagereview.pl:93 (SELECT) backend:fiximagereview.pl 0.00 cron, median time: 54.00 ms, count: 100
dataware:image_review fiximagereview.pl:93 (SELECT) backend:fiximagereview.pl 0.00 cron, median time: 1.00 ms, count: 100
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment