[MXS-774] MaxScale can add processlist function ? Created: 2016-06-17  Updated: 2020-06-12  Resolved: 2018-03-26

Status: Closed
Project: MariaDB MaxScale
Component/s: maxadmin
Affects Version/s: 1.4.3
Fix Version/s: N/A

Type: New Feature Priority: Major
Reporter: sysdljr Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: None
Environment:

CentOS 6.7, MaxScale 1.4.3, MariaDB 10.1.14

Issue Links:
Blocks
is blocked by MXS-3037 show detail processlist like at mariadb Closed

 Description   

HI, all
recently , we are testing maxscale 1.4.3 + mariadb galera cluster, maxscale's read write split function and privilege control is very good.
Make a small suggestion:
in mariadb show processlist , host column show all is Maxcale server's IP, if found some slow statement, it can's confirm the statement come from which ip.
present, we use method is install mysql sniff tools in MaxScale sever, capture the statement for the specified port, but it is more trouble.
In maxadmin, show sessions only can show Client Address, it can't show process id or process detail info, if can add mysql's id and info column of show processlist, It is very easy to analyze the source of the problem.
thanks.

 Comments   
Comment by markus makela [ 2017-03-20 ]

Add this to maxadmin, output server name and output of SHOW PROCESSLIST.

Comment by sysdljr [ 2017-03-20 ]

OK, Thank you reply.

Comment by febriyant [ 2020-06-12 ]

hi can explain more detail about this, or you mean is like this

[maxadmin]
type=service
router=cli
show processlist

at /etc/maxscale.cnf ?

Comment by markus makela [ 2020-06-12 ]

This was never implemented.

Generated at Thu Feb 08 04:01:50 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.