Log Analyzer is freezing

SES · Post by **SES** » Wed Jan 28, 2015 7:26 am

Hello,

we are using Hostmonitor with ODBC logging in MySQL database.

When we load or test the ODBC source in Log Analyzer, Log Analyzer will freeze.

The database is greater than 50GB already. Is this a problem to Log Analyzer?
But the freeze occurs selecting only the last week in ODBC source, too.

We have emptied the database some time ago, after this it works for four days then it freezes again.

Have anyone a tip to fix this problem?
Is the size of the database a problem?

KS-Soft · Post by **KS-Soft** » Wed Jan 28, 2015 7:44 am

Log Analyzer version?
ODBC log settings (from ODBC Log Manager)?

Regards
Alex

SES · Post by **SES** » Wed Jan 28, 2015 8:48 am

It's version 5.86

The query from ODBC logs manager:

Code: Select all

select eventtime, testname, status, reply, testmethod, testid from hmlog where (eventtime>='01/25/2015') and (eventtime<='01/31/2015') order by testid, eventtime, testname, testmethod

Data source and field names are correct.
The eventtime field is of datatype datetime. Is this a problem?

KS-Soft · Post by **KS-Soft** » Wed Jan 28, 2015 8:57 am

No, should not be a problem.
Can you try the same SQL query in query browser? Execution time?

Regards
Alex

SES · Post by **SES** » Thu Jan 29, 2015 3:45 am

The query in browser takes a very long time.

At least the log analyzer works when I select the last day only, its nearly 1 Million data sets.

I guess the main problem is the large amount of data.

Is there any way to resolve this problem?
Can you suggest a strategy for logging and analyzing? Like logging every test (e.g. 1 minute) and deleting minutely tests after one day, deleting hourly tests after one week, and so on.
Is there a tool you can previously filter the required system and period of time easily and then query the SQL?

KS-Soft · Post by **KS-Soft** » Thu Jan 29, 2015 9:28 am

>Is there any way to resolve this problem?

It depends on your needs...

- may be you don't need SQL at all? HostMonitor may record data into text, HTML or DBF file and it can change log file on regular basis, e.g. every week or every month.

- or may be you just need to make some small changes like set correct field for index? do you use eventtime field for index?

- do you really need all test results for all test items? may be you can switch to Brief logging mode?

- may be Log Visualizer will be useful for you?
http://www.ks-soft.net/hostmon.eng/lv/index.htm

Regards
Alex

SES · Post by **SES** » Mon Feb 09, 2015 3:04 am

Thank you for your answers.

We'll try your suggestions.
But before we want to empty the SQL-Database, but want to save the history chart (from context menu) of each test. Is it stored separately and not from SQL-Database?

Thanks.

KS-Soft · Post by **KS-Soft** » Mon Feb 09, 2015 5:27 am

HostMonitor menu "History charts"? Its not related to ODBC, data stored in HML file

Regards
Alex

SES · Post by **SES** » Wed Feb 18, 2015 7:07 am

Yes from menu "History charts".

Where is the HML file located?

Thanks.

KS-Soft Europe · Post by **KS-Soft Europe** » Wed Feb 18, 2015 10:33 am

You may check full path to the HML file in HostMonitor title.
If you are using RCC, you may check .HML file name using menu File -> Properties.
Path to HML file is specified in hostmon.ini ("FileList" parameter).
Usually it is located in HostMonitor folder or c:\ProgramData\HostMonitor\ folder. However, it can be changed using menu File -> Save as..