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