Addshore added a comment.
In T226093#5310687 <https://phabricator.wikimedia.org/T226093#5310687>, @ArielGlenn wrote: > I keep pretty decent tabs on wikidata growth, because of the dumps. I don't do that for commons entities because I can't even find the proper wikibase tables. I checked the wb_* tables on commonswiki and they all appear to be empty (?!) So all of the SDOC stuff just exists in the regular mediawiki page revision etc tables. > I can do some very rough numbers gathering by periodically getting the max slotid and the max revid, which would at least let us track those two trends. You don't by any chance track those two numbers already? We don't have any automatic tracking of these things yet. (see T68025 <https://phabricator.wikimedia.org/T68025> for some old thoughts) I'm doing periodic counting and putting the numbers on https://wikitech.wikimedia.org/wiki/WMDE/Wikidata/Growth#MediaInfo for the number of media info entities. The query for that number is: SELECT COUNT(DISTINCT rev_page) FROM commonswiki.revision INNER JOIN commonswiki.slots ON revision.rev_id = slots.slot_revision_id WHERE slots.slot_role_id = 2; > I think we'll have bots soon enough that help with the issue of adding captions for already uploaded files, and then you'll see huge growth in the number of slots. Yup > The captions are in a separate slot, right? The media info entity as a whole is in a different slot. So now commons pages will have at most 2 slots, 1 for wikitext, and one for everything media info. > It would be nice to be able to track the growth in the number of specific slots (depicts, caption, anything else on the short-to-mid-term horizon). Might be worth adding this to T68025 <https://phabricator.wikimedia.org/T68025> Tendril already has a report of # of rows in a table: https://tendril.wikimedia.org/report/table_status?host=db1081&schema=commonswiki&table=slots&engine=&data=&index= But doesn't track this over time, and also doesn't allow us to easily look into dimensions of a table such as # of rows for slot type in the slots table. TASK DETAIL https://phabricator.wikimedia.org/T226093 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Addshore Cc: Mholloway, Addshore, Ramsey-WMF, jcrespo, Yann, MarkTraceur, ArielGlenn, Aklapper, darthmon_wmde, Legado_Shulgin, Nandana, JKSTNK, thifranc, AndyTan, Davinaclare77, Qtn1293, Techguru.pc, Lahi, PDrouin-WMF, Gq86, E1presidente, Cparle, Anooprao, SandraF_WMF, GoranSMilovanovic, Lunewa, Th3d3v1ls, Hfbn0, QZanden, Tramullas, Acer, LawExplorer, Salgo60, Zppix, Silverfish, _jensen, rosalieper, Susannaanas, Wong128hk, gnosygnu, Jane023, Wikidata-bugs, Base, matthiasmullie, aude, Ricordisamoa, Wesalius, Lydia_Pintscher, Fabrice_Florin, Raymond, faidon, Steinsplitter, Mbch331, Jay8g, fgiunchedi
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
