Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P5915
(An Untitled Masterwork)
Active
Public
Actions
Authored by
•
Mattflaschen-WMF
on Aug 24 2017, 7:02 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F9168374:
Aug 24 2017, 7:08 PM
2017-08-24 19:08:58 (UTC+0)
F9168352:
Aug 24 2017, 7:02 PM
2017-08-24 19:02:59 (UTC+0)
F9168350:
Aug 24 2017, 7:02 PM
2017-08-24 19:02:19 (UTC+0)
Subscribers
None
mysql
:
wikiadmin
@
db1093
[
ruwiki
]
>
EXPLAIN
SELECT
rc_id
,
rc_timestamp
,
rc_user
,
rc_user_text
,
rc_namespace
,
rc_title
,
rc_comment
,
rc_minor
,
rc_bot
,
rc_new
,
rc_cur_id
,
rc_this_oldid
,
rc_last_oldid
,
rc_type
,
rc_source
,
rc_patrolled
,
rc_ip
,
rc_old_len
,
rc_new_len
,
rc_deleted
,
rc_logid
,
rc_log_type
,
rc_log_action
,
rc_params
,
wl_notificationtimestamp
,
page_latest
FROM
`
recentchanges
`
INNER
JOIN
`
watchlist
`
ON
(
wl_user
=
'529055'
AND
(
wl_namespace
=
rc_namespace
)
AND
(
wl_title
=
rc_title
))
LEFT
JOIN
`
page
`
ON
((
rc_cur_id
=
page_id
))
WHERE
(
rc_type
!=
'6'
)
AND
(
rc_source
!=
'wb'
)
AND
(
rc_timestamp
>
'20170716043245'
)
AND
((
rc_type
!=
3
)
OR
((
rc_deleted
&
1
)
!=
1
))
ORDER
BY
rc_timestamp
DESC
LIMIT
1000
\
G
***************************
1
.
row
***************************
id
:
1
select_type
:
SIMPLE
table
:
watchlist
type
:
ref
possible_keys
:
wl_user
,
namespace_title
,
wl_user_notificationtimestamp
key
:
wl_user
key_len
:
4
ref
:
const
rows
:
138546
Extra
:
Using
temporary
;
Using
filesort
***************************
2
.
row
***************************
id
:
1
select_type
:
SIMPLE
table
:
recentchanges
type
:
ref
possible_keys
:
rc_timestamp
,
rc_namespace_title
,
rc_ns_usertext
,
tmp_3
,
rc_name_type_patrolled_timestamp
key
:
rc_namespace_title
key_len
:
261
ref
:
ruwiki
.
watchlist
.
wl_namespace
,
ruwiki
.
watchlist
.
wl_title
rows
:
13
Extra
:
Using
where
***************************
3
.
row
***************************
id
:
1
select_type
:
SIMPLE
table
:
page
type
:
eq_ref
possible_keys
:
PRIMARY
key
:
PRIMARY
key_len
:
4
ref
:
ruwiki
.
recentchanges
.
rc_cur_id
rows
:
1
Extra
:
3
rows
in
set
(
0
.
00
sec
)
Event Timeline
•
Mattflaschen-WMF
created this paste.
Aug 24 2017, 7:02 PM
2017-08-24 19:02:19 (UTC+0)
•
Mattflaschen-WMF
edited the content of this paste.
(Show Details)
•
Mattflaschen-WMF
edited the content of this paste.
(Show Details)
Aug 24 2017, 7:08 PM
2017-08-24 19:08:58 (UTC+0)
•
Mattflaschen-WMF
mentioned this in
T171027: "Read timeout is reached" DBQueryError when trying to load specific users' watchlists (with +1000 articles) on several wikis
.
Log In to Comment