[Wikidata-bugs] [Maniphest] [Commented On] T221615: Make a test instance in cloud VPS to test new term store
Lucas_Werkmeister_WMDE added a comment. I started putting together some documentation for the instance at https://wikitech.wikimedia.org/wiki/Nova_Resource:Wikidata-dev/wikidata-new-wbterm, feel free to expand. TASK DETAIL https://phabricator.wikimedia.org/T221615 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup, Lucas_Werkmeister_WMDE Cc: Lucas_Werkmeister_WMDE, alaa_wmde, Aklapper, Ladsgroup, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Wikidata-bugs, aude, Lydia_Pintscher, JeroenDeDauw, Mbch331 ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T221615: Make a test instance in cloud VPS to test new term store
Ladsgroup added a comment. Some data about the node: | name| CPUs | HDD | RAM | | wikidata-new-wbterm | 8| 160GB | 16GB | | Current size: root@wikidata-new-wbterm:/var/lib/mysql/termwiki# ls -Ssh | head total 15G 9.4G wb_terms.ibd 1.3G text.ibd 535M searchindex.MYD 505M objectcache.ibd 431M searchindex.MYI 405M wb_changes.ibd 353M logging.ibd 301M recentchanges.ibd 185M revision.ibd wb_terms number of rows: MariaDB [termwiki]> select count(*) from wb_terms; +--+ | count(*) | +--+ | 16599826 | +--+ 1 row in set (4.96 sec) The data is roughly 1% of production but in matter of reads it's nothing compared to prod so I still would be careful. TASK DETAIL https://phabricator.wikimedia.org/T221615 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup Cc: alaa_wmde, Aklapper, Ladsgroup, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Wikidata-bugs, aude, Lydia_Pintscher, JeroenDeDauw, Mbch331 ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T221615: Make a test instance in cloud VPS to test new term store
Ladsgroup added a comment. Running scripts on it to explode it: root@wikidata-new-wbterm:/var/lib/mysql/termwiki# ls -Ssh | head total 485M 165M wb_terms.ibd 41M job.ibd 33M text.ibd 31M logging.ibd 27M recentchanges.ibd 27M wb_changes.ibd 20M revision.ibd 19M objectcache.ibd 18M page_props.ibd TASK DETAIL https://phabricator.wikimedia.org/T221615 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup Cc: alaa_wmde, Aklapper, Ladsgroup, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Wikidata-bugs, aude, Lydia_Pintscher, JeroenDeDauw, Mbch331 ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
[Wikidata-bugs] [Maniphest] [Commented On] T221615: Make a test instance in cloud VPS to test new term store
Ladsgroup added a comment. - Node: wikidata-new-wbterm.eqiad.wmflabs - Public interface: https://wikidata-termstore.wmflabs.org/index.php/Item:Q112 TASK DETAIL https://phabricator.wikimedia.org/T221615 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Ladsgroup Cc: alaa_wmde, Aklapper, Ladsgroup, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Wikidata-bugs, aude, Lydia_Pintscher, JeroenDeDauw, Mbch331 ___ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs