On 29 November 2012 19:40, imacat wrote:
> 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
On 29 November 2012 19:36, TJ Frazier wrote:
> 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 d
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 b
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 have
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 list
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 chec
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"
select/jo
On Thu, Nov 29, 2012 at 3:29 PM, Rob Weir wrote:
> On Thu, Nov 29, 2012 at 9:17 AM, janI 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 account
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 wrote:
> On Thu, Nov 29, 2012 at 9:17 AM, janI wrote:
> > Yes I locked it hard down, on request from the community...
On Thu, Nov 29, 2012 at 9:17 AM, janI 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) have got cha
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) have got changed
rights and I cannot see to what...so either a syso
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 i
12 matches
Mail list logo
