Ladsgroup added a comment.
In T68025#5678019 <https://phabricator.wikimedia.org/T68025#5678019>, @Addshore wrote: > I just created a basic dashboard with these metrics. > https://grafana.wikimedia.org/d/pwq8ZIxWk/large-site-db-tables > Is there anything else we want to add (given our discussions last week?) I would say we should add size and not just the number of rows. There's a big refactor of revision table being deployed that will free up lots of space and that's what matters. Getting size of tables should be pretty easy. Do you want to put it in WMDE analytics refinery? SELECT table_schema, table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES WHERE table_schema in ('wikidatawiki', 'commonswiki') order by (data_length + index_length) desc; TASK DETAIL https://phabricator.wikimedia.org/T68025 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup Cc: Ladsgroup, Reedy, ArielGlenn, Liuxinyu970226, GoranSMilovanovic, Addshore, jcrespo, Ricordisamoa, hoo, Aklapper, daniel, JanZerebecki, Lydia_Pintscher, Iflorez, darthmon_wmde, DannyS712, Nandana, Lahi, Gq86, QZanden, Marostegui, LawExplorer, Minhnv-2809, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
