status -> processes - show only active doesn't work #12732

Closed
paveldvorak5 opened this Issue Nov 24, 2016 · 2 comments

Projects

None yet

2 participants

@paveldvorak5

Steps to reproduce

  1. check show only active on process page

Expected behaviour

show running / non sleeping queries

Actual behaviour

only this query is shown
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE state = "executing" ORDER BY State DESC

Server configuration

Operating system:
debian jessie
Web server:

Database:
5.7.15-log - MySQL Community Server
PHP version:
7
phpMyAdmin version:
4.6.4

Client configuration

Browser:
chrome
Operating system:
windows

@nijel
Member
nijel commented Dec 7, 2016

Are you sure there are other running queries in that time? The query seems perfectly okay to list executing queries...

@nijel nijel added the question label Dec 7, 2016
@nijel nijel self-assigned this Dec 7, 2016
@paveldvorak5

i'm almost sure because there's usualy 5-40 queries running

@nijel nijel added bug and removed question labels Jan 20, 2017
@nijel nijel added this to the 4.6.6 milestone Jan 20, 2017
@nijel nijel added a commit that closed this issue Jan 20, 2017
@nijel nijel Fixed filtering for active processes
There are dozen of process states when executing the query, we can't
filter just for one of them. Let's rather exclude those without state
and are idling.

See also http://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html

Fixes #12732

Signed-off-by: Michal Čihař <michal@cihar.com>
593f71d
@nijel nijel closed this in 593f71d Jan 20, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment