Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Files
F11195677
Dispatch getCandidateClients possible alternative
No One
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Authored By
Addshore
Dec 5 2017, 4:09 PM
2017-12-05 16:09:49 (UTC+0)
Size
1 KB
Referenced Files
None
Subscribers
None
Dispatch getCandidateClients possible alternative
View Options
(
/*This is essentially the query that is being run currently*/
SELECT
chd_site,
(SELECT max( change_id ) as maxid FROM wb_changes) as max,
chd_seen,
chd_touched,
change_time,
((SELECT max( change_id ) as maxid FROM wb_changes) - chd_seen) as lagChanges,
(DATE_FORMAT(NOW(),'%Y%m%d%H%i%s') - change_time) as lagTime,
'current' as query
FROM wb_changes_dispatch
LEFT JOIN wb_changes ON chd_seen = change_id
WHERE
(
chd_touched < DATE_FORMAT(NOW(),'%Y%m%d%H%i%s') - 25/*CHANGEMEdispatchInterval*/
OR ( (SELECT max( change_id ) as maxid FROM wb_changes) - chd_seen ) > 420/*CHANGEMEbatchSize*/
)
AND ( chd_seen < (SELECT max( change_id ) as maxid FROM wb_changes) )
AND ( chd_disabled = 0 )
ORDER BY chd_seen ASC
LIMIT 5/*CHANGEMErandomness*/
)
UNION ALL
(
/*This is a query with the ORDERBY modified*/
SELECT
chd_site,
(SELECT max( change_id ) as maxid FROM wb_changes) as max,
chd_seen,
chd_touched,
change_time,
((SELECT max( change_id ) as maxid FROM wb_changes) - chd_seen) as lagChanges,
(DATE_FORMAT(NOW(),'%Y%m%d%H%i%s') - change_time) as lagTime,
'new' as query
FROM wb_changes_dispatch
LEFT JOIN wb_changes ON chd_seen = change_id
WHERE
(
chd_touched < DATE_FORMAT(NOW(),'%Y%m%d%H%i%s') - 25/*CHANGEMEdispatchInterval*/
OR ( (SELECT max( change_id ) as maxid FROM wb_changes) - chd_seen ) > 420/*CHANGEMEbatchSize*/
)
AND ( chd_seen < (SELECT max( change_id ) as maxid FROM wb_changes) )
AND ( chd_disabled = 0 )
ORDER BY lagTime DESC/*order by the lag time...*/
LIMIT 5/*CHANGEMErandomness*/
);
File Metadata
Details
Attached
Mime Type
text/plain; charset=utf-8
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
5156740
Default Alt Text
Dispatch getCandidateClients possible alternative (1 KB)
Attached To
Mode
P6430 Dispatch getCandidateClients possible alternative
Attached
Detach File
Event Timeline
Log In to Comment