CentOS 7

You can use maxctrl show sessions. We don't have SQL commands like SHOW PROCESSLIST.

but part of queries is empty. how i see like on show processlist on mariadb ?

I think if you add retain_last_statements=20 and dump_last_statements=on_error under the [maxsacle] section, it should show up. By default most of the time MaxScale doesn't keep the queries in memory while they're executed.

If possible, can you add the configuration you used to test this?

I already set that parameter.
and queries is already show.

so there is queries is still running or sleep ??

That is simply the list of queries that was executed.

I'll convert this into a feature request as there is no SHOW PROCESSLIST in MaxScale.

This should be possible to implement purely in MaxCtrl as the query tracking is already implemented in MaxScale as a part of retain_last_statements.

I created an initial patch on the MXS-3037 branch that adds the list queries command. The output of the command is as follows:

┌────┬─────────┬──────────────────┬──────────┬────────────────────────────────┐

│ Id │ User    │ Host             │ Duration │ Query                          │

├────┼─────────┼──────────────────┼──────────┼────────────────────────────────┤

│ 2  │ maxuser │ ::ffff:127.0.0.1 │ 1s       │ select sleep(10)               │

├────┼─────────┼──────────────────┼──────────┼────────────────────────────────┤

│ 1  │ maxuser │ ::ffff:127.0.0.1 │ 1s       │ select sleep(5), "hello world" │

└────┴─────────┴──────────────────┴──────────┴────────────────────────────────┘

This should be a small enough of an addition that it can go into 6.2. This is only a client-side change and requires no changes in MaxScale itself.