Sample Header Ad - 728x90

show detail processlist like at mariadb on maxscale

0 votes
1 answer
544 views
on mariadb when i need check what are query is running or sleep on mariadb instance. i can see with SHOW PROCESSLIST or select * information_schema.processlist. But after mariadb join and client connect to maxscale i can't see processlist like SHOW PROCESSLIST or select * information_schema.processlist any advice ? maxscale configuration [maxscale] threads=auto max_auth_errors_until_block=0 admin_host=192.168.101.107 admin_port=8989 admin_enabled=1 Edit. I already update paramater at maxscale configuration [maxscale] threads=auto max_auth_errors_until_block=0 admin_host=192.168.101.107 admin_port=8989 admin_enabled=1 retain_last_statements=20 dump_last_statements=on_error query already show from command maxctrl show sessions but there is query from last execution on each session. and i can't see the different like sleep or still running when i run command SHOW PROCESSLIST on mariadb. enter image description here
Asked by febry (57 rep)
Jun 17, 2020, 03:57 AM
Last activity: Jun 23, 2025, 04:09 AM