On 11/28/2012 16:48, janI wrote:
This is my final sql script for location old users without contributions,
can someone please verify the script ?
The script only collect user_id, user_name, user_registration in the table
xmaint_uids.
It is running right now, and once finished (in the morning
On Thu, Nov 29, 2012 at 9:17 AM, janI j...@apache.org wrote:
Yes I locked it hard down, on request from the communityI had to use
the big knife to be fast.
I am looking into how to open for sysop, but my concern is that at least 2
spam accounts (Or more correctly 2 that fit the pattern)
You might be very right, the user that changed the rights is created back
in 2007, and is by the way one of user destined for deletion.
Jan.
On 29 November 2012 15:29, Rob Weir robw...@apache.org wrote:
On Thu, Nov 29, 2012 at 9:17 AM, janI j...@apache.org wrote:
Yes I locked it hard down,
On Thu, Nov 29, 2012 at 3:29 PM, Rob Weir robw...@apache.org wrote:
On Thu, Nov 29, 2012 at 9:17 AM, janI j...@apache.org wrote:
Yes I locked it hard down, on request from the communityI had to use
the big knife to be fast.
I am looking into how to open for sysop, but my concern is that
Except the fact that the table logging has relative huge holes in it, and I
do not know if it has something to do with the different moves.
However this does not really bother me, what bothers me more is that the
ooo-wiki VM is so weak (compared to my notebook) that a lot of my special
On 29/11/2012 janI wrote:
ooo-wiki VM is so weak (compared to my notebook) that a lot of my special
select/join statements timed out...and the just because I have a simple
where clause where user_id in (select user_id from wiki_maint_uids)
I only had a quick look yesterday and I cannot check
Thanks I did not know that LEFT JOIN and JOIN has different speeds on inodb
tables. I made the fast fix, and split xmaint_uids into smaller tables, and
is running now.
BUT I am dead nervous of deleting wrong data !! so the review in general
would be nice.
I have also decided to post the user
On 11/29/2012 13:19, janI wrote:
Thanks I did not know that LEFT JOIN and JOIN has different speeds on inodb
tables. I made the fast fix, and split xmaint_uids into smaller tables, and
is running now.
BUT I am dead nervous of deleting wrong data !! so the review in general
would be nice.
I
Jan,
On 01.11.30 02:19am, janI said:
Thanks I did not know that LEFT JOIN and JOIN has different speeds on inodb
tables. I made the fast fix, and split xmaint_uids into smaller tables, and
is running now.
BUT I am dead nervous of deleting wrong data !! so the review in general
would be