On Sun, Aug 1, 2010 at 6:24 PM, Aryeh Gregor <[email protected]> wrote: > That won't work, because it won't count users whose settings are all > default. However, we can tell who's switched because user_options > will be empty.
SELECT COUNT(*) FROM user WHERE user_options = ''; SELECT COUNT(*) FROM user; +----------+ | COUNT(*) | +----------+ | 3491404 | +----------+ 1 row in set (10 min 20.11 sec) +----------+ | COUNT(*) | +----------+ | 12822573 | +----------+ 1 row in set (7 min 47.87 sec) I.e., only about a quarter of users have been ported to user_properties. Why wasn't a conversion script run here? _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
