← Back to team overview

maria-developers team mailing list archive

How to read of innodb_locks table by using low level interface?


Hi, Sergei

I'm developing a mariadb monitoring plugin type agent.


We're planning to contribute our monitoring solution for mariadb in one
or two months.


Our solution is consist of plugin type agent, APM Server and Dashboard.


Our plugin type agent collect data by using low level interface instead
of using query. 


I  can collect a information_schema.global_status and
performance_schema.event_xxxx_table for your help in the past.


By referencing the source of feedback.cc, I can collect data from
global_status using fill_stauts function.


I hava a question. I need to collect data from
information_schema.innodb_locks for lock monitoring. 


But I found that I must use trx_i_s_common_fill_table in i_s.cc for
reading of innodb_locks table and that fuction is static. so I only


that function by function pointer. 


Debugging source for many days, I guess that I must use  ST_SCHEMA
TABLE's fill_table member variable for  


pointing  to trx_i_s_common_fille_table function. 




But I don't know how to that.  I attemped in various ways for many
days. but I failed.


If possible. please let me know how to read data of
information_schema.innodb_locks using native api. 


Thanks in advance.









상기 메시지와 첨부화일 내에는 비밀정보가 포함되어 있을 수 있으며, 지정된 수신자에 한하여 조회 및 사용될 수 있습니다. 만약
송신자의 실수로 인하여 상기 메시지를 수신하였다면, 송신자에게 메시지를 반송해 주시고, 원본 메시지와 모든 사본을 폐기해 주시기
상기 메시지의 전체 또는 일부에 대해 무단 열람, 사용, 공개, 배포하는 것은 금지되어 있습니다.(주)LG CNS.
This message and its attachments may contain confidential information,
and they are intended to be viewed or used by only the individuals
specified in the message. If you have received this message in an error
from the sender, please contact the sender immediately to notify the
error and delete all of the message and its copies. It is prohibited to
view, use, make public and/or distribute part or whole of this message
without written permission.