Thanks reply Lefranc. I think 2 git monitoring solution u mention that would be using SQL execute and caching i think ( i guess, my short program knowledge) MY idea is not "SQL access" , but " GATHER info IN Memory Structure on mysqld proces" example select * from performance_schem => cache => GUI/HTTP ( SQL Method) => i think bad pfs structure (sql_parse.cc, pfs.cc) => memcopy... ( => I WANT METHOD) => i think good. 2 soultion u mentioned is use Direct Access Memory or SQL execute ?? Thanks!! and sorry My short English grammer. 2015-02-12 20:48 GMT+09:00 Guillaume Lefranc <guillaume@adishatz.net>:
Hello Seung Hoon Yoo,
there are already some (experimental) tools which do that:
https://github.com/svaroqui/http_monitor is a plugin for MariaDB 10 which collects information based on information and performance schema https://github.com/sjmudd/pstop is a performance monitor top-like you can run as a command line UI
Best regards,
2015-02-12 12:36 GMT+01:00 Seung Hoon Yoo <sehyoo96@gmail.com>:
Hello,
i think about monitoring gui tool ( sure, monyog Nagius support mariadb) Mysql Enterprise Monitor is cool, but commercial ver and that is oracle haha
Anyway my idea first Performance schema info, that is store info in memory structure in source, so if during every 1 sec memcopy from performance schema to user-define structure and that information transfer out of mariadb by udp port etc..
So, until world in mysql / maria, their tool using proxy method or sql script thas will be some performance issue happen.
so Direct Mariadb memory Access Method is useful..
So.. mariadb.com has any plan GUI Monitoring tool? and how about my idea about gathering performance schema ( + information_schema etc) info in mysqld thread info( memory structure) ??
Thanks for reading!
p.s i am not used to english. ;)
LG CNS post architecture Team
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp