Hi,

I think I'm missing something here, such as how would this data be formatted? You can't just copy row PFS data to a socket and expect to get any usable data. you'll need to reimplement a ton of PFS data to interpret the contents of the memory structure. The job of getting data out of the database and formatting it in a reasonable manner is, well, SQL and the well defined performance_schema table interface.

Select from the performance schema to get a snapshot of data for your tool. If you want to look at an effective capture strategy for a consistent view of the PFS, check out ps_history, and specifically the ps_history.collect() stored procedure:

I don't see why anyone would add an interface to MariaDB for a single specialized "montitoring" tool, unless you want to pay MariaDB to implement it, or you implement it yourself and contribute the plugin.

--Justin

On Thu, Feb 12, 2015 at 4:31 AM, Seung Hoon Yoo <sehyoo96@gmail.com> wrote:

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

_______________________________________________
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