Hello Neil,
I have seen that there is a connection from stat1002 to dbstore1002 which has now been running for **two** days.
Looks like the connection has been issued from your user:
The connection is established on port `49663` and it is owned by your userid:
This is the query:
```
select left(a.ar_timestamp, 6) as month, count(*) as deleted_creations from enwiki.archive a inner join ( select ar_title, min(ar_timestamp) as ar_timestamp from enwiki.archive group by ar_title ) b using (ar_title, ar_timestamp) where ar_namespace = 0 and ar_comment not like "%redir%" and ar_len > 100 group by left(a.ar_timestamp, 6)
MariaDB DBSTORE localhost log > explain select left(a.ar_timestamp, 6) as month, count(*) as deleted_creations from enwiki.archive a inner join ( select ar_title, min(ar_timestamp) as ar_timestamp from enwiki.archive group by ar_title ) b using (ar_title, ar_timestamp) where ar_namespace = 0 and ar_comment not like "%redir%" and ar_len > 100 group by left(a.ar_timestamp, 6)\G
*************************** 1. row ***************************
id: 1
select_type: PRIMARY
table: a
type: ref
possible_keys: name_title_timestamp,analytics_timestamp
key: name_title_timestamp
key_len: 4
ref: const
rows: 23110456
Extra: Using where; Using temporary; Using filesort
*************************** 2. row ***************************
id: 1
select_type: PRIMARY
table: <derived2>
type: hash_ALL
possible_keys: key0
key: #hash#key0
key_len: 274
ref: enwiki.a.ar_title,enwiki.a.ar_timestamp
rows: 54432647
Extra: Using join buffer (flat, BNLH join)
*************************** 3. row ***************************
id: 2
select_type: DERIVED
table: archive
type: index
possible_keys: NULL
key: name_title_timestamp
key_len: 277
ref: NULL
rows: 54432647
Extra: Using index; Using temporary; Using filesort
3 rows in set (0.00 sec)
```
I have killed this query.
```
MariaDB DBSTORE localhost log > kill 592144656;
Query OK, 0 rows affected (0.00 sec)
````
Would you be able to take a look and try to improve it?
Let me know if you need help with that.
I have added the tag Editing-Analysis but I am unsure if it is correct for this scenario, feel free to change it or let me know if you want me to.
Thanks
Manuel.