Orabbix:"Another way to monitor Oracle reloaded"

[shimas]

Orabbix supports oracle 11g right?

Then strange things happening in my Zabbix 2.0.4 + Orabbix 1.2.3 setup.

Everything works good with oracle 10g databases, but when I try to monitor 11g somehow values from Orabbix are not passed to Zabbix.

I have turned ON debug mode in Orabbix and I see in log file that it receives values:

[pool-1-thread-2] DEBUG Orabbix - I'm going to return 9 for query fis_litas on database=fis
[pool-1-thread-2] DEBUG Orabbix - Item retrieved 60 on database fis
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item archive value 0
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item audit value none
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item dbfilesize value 41823502336
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item dbsize value 14840430592
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item dbblockgets value 153963228
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item dbconsistentgets value 952567798
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item dbhitratio value 56.87541598133191432085520212064980092117
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item dbphysicalread value 477186902
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item hitratio_body value 99.58156460052985352396382983381866748407
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item hitratio_sqlarea value 96.43192249780939404151425844101922872529
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item hitratio_table_proc value 97.70550711852542604476556450781611454845
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item lio_current_read value 153963228
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item locks value none
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item maxprocs value 150
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item maxsession value 248
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item miss_latch value 13188292
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pga_aggregate_target value 132.0
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pga value 248.4
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item phio_datafile_reads value 462456674
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item phio_datafile_writes value 1293435
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item phio_redo_writes value 2779391
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pinhitratio_body value 99.93808485283146725189718994797781656383
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pinhitratio_sqlarea value 99.40312375228364595052672121064855194712
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pinhitratio_table-proc value 98.62243241375883500041076031578979445007
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pinhitratio_trigger value 99.83897602159386703031338575354139203012
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pool_dict_cache value 0
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pool_free_mem value 12.72
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pool_lib_cache value 0
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pool_misc value 135.28
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pool_sql_area value 0
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item procnum value 64
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item session_active value 6
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item session_inactive value 30
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item session value 61
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item session_system value 25
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item sga_buffer_cache value 88
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item sga_fixed value 1.28
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item sga_java_pool value 4
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item sga_large_pool value 4
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item sga_log_buffer value 5.85
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item sga_shared_pool value 135.28
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item tbl_space_forpost1 value none
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item tbl_space_forpost2 value none
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item userconn value 33
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item waits_controfileio value 19581484
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item waits_directpath_read value 34495421
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item waits_file_io value 0
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item waits_latch value 19581484
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item waits_logwrite value 2779969
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item waits_multiblock_read value 788568
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item waits_singleblock_read value 6551319
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item hitratio_trigger value 98.86710283041727659885216571567036111305
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item lio_block_changes value 114324398
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item lio_consistent_read value 952568077
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item waits_other value 42752627
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item waits_sqlnet value 4814701
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item users_locked value none
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item uptime value 3017513
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item invalid_obj value 0
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item fis_litas value 9


But they not appear in Zabbix system. Any clues what might be wrong?

[shimas]

Orabbix supports oracle 11g right?

Then strange things happening in my Zabbix 2.0.4 + Orabbix 1.2.3 setup.

Everything works good with oracle 10g databases, but when I try to monitor 11g somehow values from Orabbix are not passed to Zabbix.

I have turned ON debug mode in Orabbix and I see in log file that it receives values:

[pool-1-thread-2] DEBUG Orabbix - I'm going to return 9 for query fis_litas on database=fis
[pool-1-thread-2] DEBUG Orabbix - Item retrieved 60 on database fis
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item archive value 0
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item audit value none
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item dbfilesize value 41823502336
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item dbsize value 14840430592
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item dbblockgets value 153963228
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item dbconsistentgets value 952567798
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item dbhitratio value 56.87541598133191432085520212064980092117
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item dbphysicalread value 477186902
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item hitratio_body value 99.58156460052985352396382983381866748407
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item hitratio_sqlarea value 96.43192249780939404151425844101922872529
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item hitratio_table_proc value 97.70550711852542604476556450781611454845
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item lio_current_read value 153963228
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item locks value none
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item maxprocs value 150
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item maxsession value 248
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item miss_latch value 13188292
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pga_aggregate_target value 132.0
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pga value 248.4
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item phio_datafile_reads value 462456674
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item phio_datafile_writes value 1293435
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item phio_redo_writes value 2779391
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pinhitratio_body value 99.93808485283146725189718994797781656383
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pinhitratio_sqlarea value 99.40312375228364595052672121064855194712
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pinhitratio_table-proc value 98.62243241375883500041076031578979445007
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pinhitratio_trigger value 99.83897602159386703031338575354139203012
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pool_dict_cache value 0
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pool_free_mem value 12.72
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pool_lib_cache value 0
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pool_misc value 135.28
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item pool_sql_area value 0
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item procnum value 64
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item session_active value 6
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item session_inactive value 30
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item session value 61
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item session_system value 25
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item sga_buffer_cache value 88
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item sga_fixed value 1.28
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item sga_java_pool value 4
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item sga_large_pool value 4
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item sga_log_buffer value 5.85
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item sga_shared_pool value 135.28
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item tbl_space_forpost1 value none
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item tbl_space_forpost2 value none
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item userconn value 33
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item waits_controfileio value 19581484
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item waits_directpath_read value 34495421
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item waits_file_io value 0
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item waits_latch value 19581484
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item waits_logwrite value 2779969
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item waits_multiblock_read value 788568
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item waits_singleblock_read value 6551319
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item hitratio_trigger value 98.86710283041727659885216571567036111305
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item lio_block_changes value 114324398
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item lio_consistent_read value 952568077
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item waits_other value 42752627
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item waits_sqlnet value 4814701
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item users_locked value none
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item uptime value 3017513
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item invalid_obj value 0
[pool-1-thread-2] DEBUG Orabbix - dbname fis sending item fis_litas value 9


But they not appear in Zabbix system. Any clues what might be wrong?

Update:
The problem was that oracle_sid was different from the hostname + oracle_sid id was used on another host.

Lesson is not to use "Visible names"

[mfric]

cutting query results

Hello,

I did not found much about ExpandColumnsList but if i understand it can somehow cut the results to columns.

My questions are : How is row and column interpreted (with ' ' -space or is here some delimiter?) and is there some way to do something like this? :

queryname.Query="sql statement"
queryname_column1=queryname.ExpandColumnsList[1]


I would really like to know how to achieve this (and if its possible to do ) because i have resulted long string and this would be most elegant way for me.

Otherwise i can query it more times or write it to file with cron for example and then cut it using userparameters.

But is it possible to achieve something i am trying?

Thanks a lot

[TBom]

Several Values in return (Top5 SQL)

Maybe my question goes to the same direction like the last post.

I want an Item which shows me the last Top5 SQL Statemens.
The SQL query returns 5 rows and 3 Columns.
Can I dislay it in a better human readable format in Zabbix - maybe if I add in the SQL ',' or Line Break Ascii codes?

In Zabbix I configured the item as a log item - it doesn't matter if I use plain text or log - the output is still unreadable.

[bramyeni]

additional zabbix component i added

HI my name is Bram, i am senior oracle DBA work at sydney airport australia.. we have implemented zabbix and also orabbix, because there's a lot of limitation on orabbix i re-write orabbix but still some of the simple function we use orabbix..

i incorporate discovery in my java program so anyone can use discovery in zabbix, this is very usefull for tablespace usage, wait events, library cache, etc..

i started this because we use oracle e-business suite 11.5.9 which has more than 30tablespaces, if we add this tablespace manually this will take so much time.. therefore i managed to create my own plugin for zabbix, i also modify so not zabbix that does it but cron jobs.. because if i rely on zabbix to query the database sometime if the database is too slow zabbix will be upset and return no value..

i cron it so it can query 20-30 databases at one time, and in the database it only requires user which has read-only privilege which is "select any table" privilege..

i use external script in zabbix, so zabbix run this script but this script only read the output file.. i also make a flag, if this flag is turned on the result also spool to out directory which produce more visibility of the database stats this is useful for tuning excercise...

i am still tidying up this.. and havent had a time to create a documentation yet..

cheers

[njdattler]

dbsize and dbfilesize

The default Orabbix template has a graph for dbsize vs dbfilesize, which have corresponding items in the "items" list. Unfortunately those 2 keys, "dbsize" and "dbfilesize" are not present in the query.props file, by default.

Does anyone know what needs to be added to that file in order to get some data back for those values, and graph it?

[dalle]

The default Orabbix template has a graph for dbsize vs dbfilesize, which have corresponding items in the "items" list. Unfortunately those 2 keys, "dbsize" and "dbfilesize" are not present in the query.props file, by default.

Does anyone know what needs to be added to that file in order to get some data back for those values, and graph it?

Hi Seem that I missed again those two items... use the following queries:
DBSize
SELECT sum( NVL(a.bytes/1024/1024/10 – NVL(f.bytes/1024/1024/10, 0), 0)) retvalue
FROM sys.dba_tablespaces d,
(SELECT tablespace_name, sum(bytes) bytes
FROM dba_data_files
GROUP BY tablespace_name) a,
(SELECT tablespace_name, sum(bytes) bytes
FROM dba_free_space
GROUP BY tablespace_name) f
WHERE d.tablespace_name = a.tablespace_name(+)
AND d.tablespace_name = f.tablespace_name(+)
AND NOT (d.extent_management like ‘LOCAL’ AND d.contents like ‘TEMPORARY’);

and DBFileSize
select sum(bytes/1024/1024/10) retvalue
FROM dba_data_files;


Cheers
Andrea

[dalle]

HI my name is Bram, i am senior oracle DBA work at sydney airport australia.. we have implemented zabbix and also orabbix, because there's a lot of limitation on orabbix i re-write orabbix but still some of the simple function we use orabbix..

i incorporate discovery in my java program so anyone can use discovery in zabbix, this is very usefull for tablespace usage, wait events, library cache, etc..

i started this because we use oracle e-business suite 11.5.9 which has more than 30tablespaces, if we add this tablespace manually this will take so much time.. therefore i managed to create my own plugin for zabbix, i also modify so not zabbix that does it but cron jobs.. because if i rely on zabbix to query the database sometime if the database is too slow zabbix will be upset and return no value..

i cron it so it can query 20-30 databases at one time, and in the database it only requires user which has read-only privilege which is "select any table" privilege..

i use external script in zabbix, so zabbix run this script but this script only read the output file.. i also make a flag, if this flag is turned on the result also spool to out directory which produce more visibility of the database stats this is useful for tuning excercise...

i am still tidying up this.. and havent had a time to create a documentation yet..

cheers

Hi Bram
Please feel free to write me directly on my mail account I will add your functionality or I can include them on the project (with your name of course).

Thank you to use Orabbix and thanks to let me know about your improvements!!!
Cheers

[sistemas.aquanima]

query error with 11G

Hi just installed Orabbix 1.2.3 over RHEL 6.3 Oracle 11G

All queries shows errors at log

ERROR Orabbix - Error on DBEnquiry on query=dbversion on database=DB1 Error returned is java.lang.IllegalArgumentException: null value for key 'dbversion'
WARN Orabbix - Error while executing ->hitratio_body- on database ->DB1- Exception received Closed Connection
ERROR Orabbix - Error on DBEnquiry on query=hitratio_body on database=DB1 Error returned is java.lang.IllegalArgumentException: null value for key 'hitratio_body'
WARN Orabbix - Error while executing ->hitratio_sqlarea- on database ->DB1- Exception received Closed Connection
ERROR Orabbix - Error on DBEnquiry on query=hitratio_sqlarea on database=DB1 Error returned is java.lang.IllegalArgumentException: null value for key 'hitratio_sqlarea'
WARN Orabbix - Error while executing ->hitratio_table_proc- on database ->DB1- Exception received Closed Connection
ERROR Orabbix - Error on DBEnquiry on query=hitratio_table_proc on database=DB1 Error returned is java.lang.IllegalArgumentException: null value for key 'hitratio_table_proc'
WARN Orabbix - Error while executing ->lio_current_read- on database ->DB1- Exception received Closed Connection
ERROR Orabbix - Error on DBEnquiry on query=lio_current_read on database=DB1 Error returned is java.lang.IllegalArgumentException: null value for key 'lio_current_read'
WARN Orabbix - Error while executing ->locks- on database ->DB1- Exception received Closed Connection
WARN Orabbix - Error while executing ->maxprocs- on database ->DB1- Exception received Closed Connection


Java version 1.6 at server I'm using the default query.props

Any help there?

[dalle]

Hi just installed Orabbix 1.2.3 over RHEL 6.3 Oracle 11G

All queries shows errors at log

ERROR Orabbix - Error on DBEnquiry on query=dbversion on database=DB1 Error returned is java.lang.IllegalArgumentException: null value for key 'dbversion'
WARN Orabbix - Error while executing ->hitratio_body- on database ->DB1- Exception received Closed Connection
ERROR Orabbix - Error on DBEnquiry on query=hitratio_body on database=DB1 Error returned is java.lang.IllegalArgumentException: null value for key 'hitratio_body'
WARN Orabbix - Error while executing ->hitratio_sqlarea- on database ->DB1- Exception received Closed Connection
ERROR Orabbix - Error on DBEnquiry on query=hitratio_sqlarea on database=DB1 Error returned is java.lang.IllegalArgumentException: null value for key 'hitratio_sqlarea'
WARN Orabbix - Error while executing ->hitratio_table_proc- on database ->DB1- Exception received Closed Connection
ERROR Orabbix - Error on DBEnquiry on query=hitratio_table_proc on database=DB1 Error returned is java.lang.IllegalArgumentException: null value for key 'hitratio_table_proc'
WARN Orabbix - Error while executing ->lio_current_read- on database ->DB1- Exception received Closed Connection
ERROR Orabbix - Error on DBEnquiry on query=lio_current_read on database=DB1 Error returned is java.lang.IllegalArgumentException: null value for key 'lio_current_read'
WARN Orabbix - Error while executing ->locks- on database ->DB1- Exception received Closed Connection
WARN Orabbix - Error while executing ->maxprocs- on database ->DB1- Exception received Closed Connection


Java version 1.6 at server I'm using the default query.props

Any help there?

it seem that you have issues with the connection
maxprocs- on database ->DB1- Exception received Closed Connection
since inside the pool there aren't open connections
Try to do a connection using sqlplus from Orabbix server.

[sistemas.aquanima]

I'd made several changes, just found DB1 had several issues with the 11G code. DB2 & 3 connects but almost all test shows no data retrieved:

DEBUG Orabbix - Note: waits_other.NoDataFound null or not present null
DEBUG Orabbix - Note: waits_other.WhenNotAlive null or not present null
DEBUG Orabbix - Note: waits_other.RaceConditionQuery null or not present null
DEBUG Orabbix - Note: waits_other.RaceConditionValue null or not present null
DEBUG Orabbix - Note: waits_other.Period null or not present null
DEBUG Orabbix - Note: waits_other.ExcludeColumnsList error null
DEBUG Orabbix - Note: waits_other.RaceConditionQueryExcludeColumnsList error null

Some of the queries fails when the code is inserted into SQL Developer so it could be some issue in 11G 11.2.0.3?

[euska]

Hi,

I installed orabbix on my 2.0.9 zabbix server and i want to monitor my oracle 10 server which hosts 2 databases.
I configured the conf.props like that :

srv.Url=jdbc:oracle:thin:@srv.lan:1526:db1
srv.User=zabbix
srv.Password=zabbix

srv.Url=jdbc:oracle:thin:@srv.lan:1526:db2
srv.User=zabbix
srv.Password=zabbix

I want to get the databases sizes and free space. The query returns the sizes of the 2 db (db1 + db2).

How can i get the individual size ?

Thanks

[mfric]

Hi,

I installed orabbix on my 2.0.9 zabbix server and i want to monitor my oracle 10 server which hosts 2 databases.
I configured the conf.props like that :

srv.Url=jdbc:oracle:thin:@srv.lan:1526:db1
srv.User=zabbix
srv.Password=zabbix

srv.Url=jdbc:oracle:thin:@srv.lan:1526:db2
srv.User=zabbix
srv.Password=zabbix

I want to get the databases sizes and free space. The query returns the sizes of the 2 db (db1 + db2).

How can i get the individual size ?

Thanks

Hello,

I dont think there is any sum of actual size. each template is for each database. So there should not be any mathematical operations unless its not cluster database with 2 nodes. But anyway i dont think u could get something that is changed by zabbix.

Can you please post that query , i can check but mayber there is newer version of orabbix and i also made some changes to configuration.

And also can you get db size directly from db and compare results?

[euska]

Hello,

I dont think there is any sum of actual size. each template is for each database. So there should not be any mathematical operations unless its not cluster database with 2 nodes. But anyway i dont think u could get something that is changed by zabbix.

Can you please post that query , i can check but mayber there is newer version of orabbix and i also made some changes to configuration.

And also can you get db size directly from db and compare results?

I solved my problem by created one host / db in zabbix.

[mfric]

I solved my problem by created one host / db in zabbix.

yes thats what i was thinking about.