Help:Tool Labs/Database: Revision history

14 July 2017

• curprev 18:4718:47, 14 July 2017‎ imported>BryanDavis‎ 37 bytes −25,240‎ BryanDavis moved page Help:Tool Labs/Database to Help:Toolforge/Database: phab:T168480 rebranding

28 May 2017

• curprev 10:0810:08, 28 May 2017‎ imported>Merlijn van Deen‎ 25,277 bytes +31‎ +see also MySQL queries

19 May 2017

• curprev 22:1422:14, 19 May 2017‎ imported>BryanDavis‎ 25,246 bytes −93‎ Use $HOME consistently

16 May 2017

• curprev 22:0622:06, 16 May 2017‎ imported>Kaldari‎ 25,339 bytes −23‎ →‎MySQL Workbench: no need to collapse this, it isn't very lengthy, and collapse it makes it easy to overlook and assume it doesn't exist

11 April 2017

• curprev 13:3213:32, 11 April 2017‎ imported>Jcrespo‎ 25,362 bytes +127‎ →‎Connection handling policy: clarifying this applies to tools too, as it has started to create issues there too :-/

27 January 2017

• curprev 19:5019:50, 27 January 2017‎ imported>Tim Landscheidt‎ 25,235 bytes +294‎ →‎Identifying lag: Document how to query directly the replication lag for a particular wiki.

7 January 2017

• curprev 17:0617:06, 7 January 2017‎ imported>Nemo bis‎ 24,941 bytes 0‎ →‎Redacted tables: typo

6 December 2016

• curprev 16:3816:38, 6 December 2016‎ imported>Tim Landscheidt‎ 24,941 bytes +65‎ →‎Unused tables: Add a link to mw:Manual:MediaWiki architecture#Database and text storage.

5 December 2016

• curprev 22:4322:43, 5 December 2016‎ imported>Tim Landscheidt‎ 24,876 bytes −176‎ →‎Replica database schema (tables and indexes): AFAIUI, the text table simply does not exist on Wikimedia; instead, revision contents are kept in an External Store. CMIIW.

29 November 2016

• curprev 03:4503:45, 29 November 2016‎ imported>BryanDavis‎ m 25,052 bytes +235‎ →‎Redacted tables: if -> of

2 November 2016

• curprev 18:2218:22, 2 November 2016‎ imported>G‎ 24,817 bytes +1,065‎ →‎Connecting with...

23 September 2016

• curprev 07:0007:00, 23 September 2016‎ imported>Vladis13‎ 23,752 bytes +187‎ →‎Connecting to the database replicas from your own computer

3 September 2016

• curprev 21:2221:22, 3 September 2016‎ imported>BryanDavis‎ 23,565 bytes +10‎ →‎=: Remove stray h3 start

27 July 2016

• curprev 16:0016:00, 27 July 2016‎ imported>BryanDavis‎ 23,555 bytes +680‎ →‎Naming conventions: explain naming with a bit more detail; change formatting conventions
• curprev 00:3000:30, 27 July 2016‎ imported>Samwilson‎ 22,875 bytes +32‎ →‎Steps to create a user database on tools.labsdb: Make into a proper OL — harder to read when editing, but easier to read when reading.

22 July 2016

• curprev 17:0217:02, 22 July 2016‎ imported>BryanDavis‎ 22,843 bytes +143‎ →‎Steps to create a user database on the replica servers: emphasize that user tables can and will disappear

18 July 2016

• curprev 08:0808:08, 18 July 2016‎ imported>Ilya‎ m 22,700 bytes −12‎ →‎Connecting to the database replicas from your own computer

4 July 2016

• curprev 10:1210:12, 4 July 2016‎ imported>Merlijn van Deen‎ 22,712 bytes +185‎ →‎Replica database schema (tables and indexes): + unused tables

29 June 2016

• curprev 17:4317:43, 29 June 2016‎ imported>BryanDavis‎ 22,527 bytes +143‎ →‎Privileges on the database: Highlight "_p"

21 June 2016

• curprev 15:4815:48, 21 June 2016‎ imported>BryanDavis‎ 22,384 bytes +1,061‎ →‎Connection handling policy: wordsmithing

8 June 2016

• curprev 22:3022:30, 8 June 2016‎ imported>BryanDavis‎ 21,323 bytes +25‎ →‎Steps to setup SSH tunneling for testing a tool labs application which makes use of tool labs databases on your own computer

12 May 2016

• curprev 07:2807:28, 12 May 2016‎ imported>Nemo bis‎ 21,298 bytes +50‎ →‎Identifying lag: https://tools.wmflabs.org/replag/

4 May 2016

• curprev 15:5315:53, 4 May 2016‎ imported>BryanDavis‎ 21,248 bytes +1,876‎ →‎Connecting to the database replicas from your own computer: Try to give more friendly description of how ssh tunneling works

27 April 2016

• curprev 00:1300:13, 27 April 2016‎ imported>Tim Landscheidt‎ m 19,372 bytes +925‎ →‎Database schema (tables and indexes): Fix typo.

8 April 2016

• curprev 17:4817:48, 8 April 2016‎ imported>Niharika29‎ 18,447 bytes +325‎ →‎Connecting to the database replicas

29 March 2016

• curprev 21:1421:14, 29 March 2016‎ imported>Merlijn van Deen‎ 18,122 bytes −186‎ →‎Steps to create a user database on the replica servers

16 March 2016

• curprev 16:0816:08, 16 March 2016‎ imported>Tim Landscheidt‎ 18,308 bytes −16‎ →‎Steps to create a user database on tools-db

16 February 2016

• curprev 21:4921:49, 16 February 2016‎ imported>Kaldari‎ 18,324 bytes +142‎ →‎Creating new databases: adding important note

15 February 2016

• curprev 12:3712:37, 15 February 2016‎ imported>Merlijn van Deen‎ 18,182 bytes +340‎ →‎Steps to create a user database on the replica servers: + caveats of replica databases

3 February 2016

• curprev 06:1006:10, 3 February 2016‎ imported>BryanDavis‎ 17,842 bytes +23‎ Wrap nav in <noinclude>

29 January 2016

• curprev 06:0306:03, 29 January 2016‎ imported>BryanDavis‎ 17,819 bytes +28‎ Add {{Template:Tool Labs nav}}

28 January 2016

• curprev 00:4000:40, 28 January 2016‎ imported>Yuvipanda‎ 17,791 bytes 0‎ →‎Configuring MySQL Workbench

23 January 2016

• curprev 14:2714:27, 23 January 2016‎ imported>Dalba‎ 17,791 bytes +332‎ add a section named Redacted tables (thanks to <gifti> that explained this for me in IRC)

31 December 2015

• curprev 12:5812:58, 31 December 2015‎ imported>Merlijn van Deen‎ 17,459 bytes +112‎ Users should have a replica.my.cnf file.

30 December 2015

• curprev 16:1316:13, 30 December 2015‎ imported>Zhuyifei1999‎ m 17,347 bytes −9‎ Lab accounts no longer have access to replica without a tool account after the eqiad migration

25 November 2015

• curprev 20:3020:30, 25 November 2015‎ imported>Jcrespo‎ m 17,356 bytes +2,069‎ →‎Identifying lag

24 November 2015

• curprev 13:4913:49, 24 November 2015‎ imported>Jcrespo‎ 15,287 bytes +181‎ →‎Privileges on the database: with grant option will not apply to all accounts

13 November 2015

• curprev 09:5709:57, 13 November 2015‎ imported>Merlijn van Deen‎ 15,106 bytes −115‎ →‎Naming conventions: remove /etc/hosts reference, insert quarry link instead

5 November 2015

• curprev 11:0611:06, 5 November 2015‎ imported>Alexandros Kosiaris‎ 15,221 bytes −10‎ →‎Configuring PGAdmin for OSM access

12 October 2015

• curprev 18:5918:59, 12 October 2015‎ imported>Merlijn van Deen‎ 15,231 bytes +231‎ →‎Creating new databases: add info on grants, fix username example

31 July 2015

• curprev 20:1920:19, 31 July 2015‎ imported>Nemo bis‎ 15,000 bytes −24‎ →‎Creating new databases: Remove annoying collapsing which makes the page jump and breaks the TOC

25 July 2015

• curprev 10:3010:30, 25 July 2015‎ imported>Avicennasis‎ m 15,024 bytes +2‎ →‎Example queries: bypass soft double-redirect

20 July 2015

• curprev 13:5513:55, 20 July 2015‎ imported>Nemo bis‎ 15,022 bytes +61‎ See mw:MySQL queries. Add yours!

23 June 2015

• curprev 21:3121:31, 23 June 2015‎ imported>Guillom‎ 14,961 bytes +171‎ update information on metadata database

11 June 2015

• curprev 18:3518:35, 11 June 2015‎ imported>Merlijn van Deen‎ 14,790 bytes +14,790‎ →‎Creating new databases