From: Mr.Z-man <mrzmanwikimail@gmail.com>

Date: Sun, 31 Oct 2010 18:57:17

The globaluser table in the centralauth database contains all global accounts.

 
mysql> SELECT COUNT(*) FROM globaluser;
+----------+
| COUNT(*) |
+----------+
|  8259190 |
+----------+
1 row in set (2 min 36.09 sec)

https://wiki.toolserver.org/view/Database_schema/Global#Globaluser_table

From: Paolo Massa <massa@fbk.eu>

Date: Tue, 02 Nov 2010 10:42:03

Thanks a lot Mr.Z-man!!!

I have a doubt, I checked at http://en.wikipedia.org/wiki/Special:Statistics and currently there are 13,331,812 users in en.wikipedia (which is the one with most registered users, I guess).

The doubt is the following. Is it possible that ~8 millions out of ~13 millions users opted in for unified login? I believe this is not the case.

So maybe the reason for 8259190 users in Globaluser_table is that users end up there automatically (since a certain date, possibly)?

Probably the fields of Globaluser_table (such as gu_registration, gu_registration and gu_home_db for example) and localuser_table (such as lu_name and lu_attached_timestamp) are useful.

May I ask you to run a query to get some records from these tables to get a better idea of what they are used for? You can use my account "Phauly" for posting results of queries.

I checked at https://wiki.toolserver.org/view/Database_schema (and also the diagram at https://wiki.toolserver.org/view/Media:Mediawiki-database-schema.png ) but there is no mention I could find of these global tables.

From: Paolo Massa <massa@fbk.eu>

Date: Tue, 02 Nov 2010 10:43:10

The previous comment explains the additional info I might benefit from. Thanks!

From: Paolo Massa <massa@fbk.eu>

Date: Tue, 02 Nov 2010 10:53:06

The code of the script at http://toolserver.org/~vvv/sulutil.php might give an idea of the tables involved and their values.

I also found some mentions of the values involved at http://svn.wikimedia.org/viewvc/mediawiki/trunk/extensions/CentralAuth/evil-plans.txt?view=markup but this is not very clear to me. The old CentralAuth plugin (see http://www.marefa.org/extensions/CentralAuth/central-auth.sql ) had a gu_enabled_method field with enum('opt-in', 'batch', 'auto', 'admin') but I don't find this field in the current tables.

Anyone can help?

Thanks!!!

This bug was imported as RESOLVED. The original assignee has therefore not been
set, and the original reporters/responders have not been added as CC, to
prevent bugspam.

If you re-open this bug, please consider adding these people to the CC list:
Original assignee: (none)
CC list: