select from full process list where info mysql, processlist

1:
SELECT user, time, state, info FROM information_schema.processlist WHERE command != 'Sleep' ORDER BY time DESC, id\G
2:
SELECT * FROM information_schema.processlist WHERE command != 'Sleep' and time>1 and user != 'event_scheduler' ORDER BY time DESC, id\G
If the output prints:
select clock,ns,value from history_uint where itemid=263902 and clock <= 1627293571 and cloc k > 1626688771 order by clock desc limit 2

No comments: