maria-discuss team mailing list archive

[Justin Swanhart <greenlion@xxxxxxxxx>]

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:
https://github.com/greenlion/ps_history

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@xxxxxxxxx> 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@xxxxxxxxxxxx>:
>
>> 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@xxxxxxxxx>:
>>
>>> 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@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~maria-discuss
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>