Skip to content

Instantly share code, notes, and snippets.

@macbre

macbre/backend.tsv

Last active January 8, 2018 09:07
Show Gist options
  • Save macbre/0e176d667f79ab1124b85e3a389c7df8 to your computer and use it in GitHub Desktop.
Save macbre/0e176d667f79ab1124b85e3a389c7df8 to your computer and use it in GitHub Desktop.
Download ZIP
Backend tables data flow
Raw
backend.tsv
We can make this file beautiful and searchable if this error is corrected: Illegal quoting in line 1.
# Query digest for "events_local_users" table, found 1995 queries
backend:events_local_users.pl events_local_users.pl:651 (INSERT) specials:events_local_users 0.98 job, median time: 1107.85 ms, count: 93800
backend:events_local_users.pl events_local_users.pl:646 (DELETE) specials:events_local_users 1.00 job, median time: 731.80 ms, count: 95500
backend:events_local_users.pl events_local_users.pl:699 (DELETE) specials:events_local_users 0.01 job, median time: 1072.79 ms, count: 900
specials:events_local_users getUsersForGroup WikiaApiQueryAllUsers 0.01 ap, median time: 211.94 ms, count: 1400
specials:events_local_users getTopEditors WikiService 0.02 ap, median time: 144.91 ms, count: 1500
specials:events_local_users events_local_users.pl:223 (SELECT) backend:events_local_users.pl 0.03 job, median time: 55.10 ms, count: 3300
backend:events_local_users.pl events_local_users.pl:646 (DELETE) specials:events_local_users 0.00 task, median time: 652.29 ms, count: 100
specials:events_local_users getTopWikisFromDb FavoriteWikisModel 0.00 ap, median time: 36.30 ms, count: 400
specials:events_local_users events_local_users.pl:582 (SELECT) backend:events_local_users.pl 0.03 job, median time: 0.30 ms, count: 2600
# Query digest for "multilookup" table, found 111 queries
backend:MultiLookup.pm MultiLookup.pm:71 (INSERT) specials:multilookup 1.00 job, median time: 1205.40 ms, count: 11100
# Query digest for "city_used_tags" table, found 9 queries
stats:city_used_tags execute WikiaApiTagsReport 1.00 ap, median time: 29.80 ms, count: 800
stats:city_used_tags getGalleryPageCount Wikia\Tasks\Tasks\GalleryCachePurgeTask 0.12 task, median time: 69.28 ms, count: 100
# Query digest for "phalanx_stats" table, found 9 queries
backend:phalanx_stats.pl phalanx_stats.pl:158 (INSERT) specials:phalanx_stats 1.00 job, median time: 1119.40 ms, count: 900
# Query digest for "stats" database, found 3468 queries
backend:Events.pm Events.pm:478 (INSERT) stats:events 1.00 job, median time: 1012.80 ms, count: 331900
stats:events getEventsInfo WikiaApiQueryLastEditors 0.00 ap, median time: 909.01 ms, count: 1000
stats:events editsByNsAll Editcount 0.00 ap, median time: 583.49 ms, count: 400
stats:events getDailyEdits QuickStatsController 0.00 ap, median time: 130.06 ms, count: 1400
stats:events getUserActivity LookupContribsCore 0.00 ap, median time: 118.30 ms, count: 300
stats:events getDailyEdits FounderEmails 0.01 cron, median time: 53.91 ms, count: 3900
stats:city_used_tags execute WikiaApiTagsReport 0.00 ap, median time: 55.86 ms, count: 800
backend:DirtyEvents.pm DirtyEvents.pm:155 (INSERT) stats:scribe_log 0.01 staging, median time: 17.69 ms, count: 4100
stats:city_used_tags {closure} {closure} 0.00 ap, median time: 47.99 ms, count: 500
backend:Log.pm Log.pm:92 (UPDATE) stats:script_log 0.00 staging, median time: 126.86 ms, count: 400
noreptemp:script_log Log.pm:108 (SELECT) backend:Log.pm 0.00 staging, median time: 25.11 ms, count: 500
stats:city_used_tags getGenDate TagsReportPage 0.00 ap, median time: 45.70 ms, count: 100
noreptemp:script_log Log.pm:108 (SELECT) backend:Log.pm 0.00 staging, median time: 2.22 ms, count: 100
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment