span8
span4
Hi,
我正在研究评估FME服务器实例容量的方法,以及服务器上常规的CPU/RAM容量,我对特定于应用程序的度量很感兴趣。
In particular does anyone have a workbench/tool that will query an FME server 2015 repository and report the max number of engines running in a defined time period,比如说每小时。(I'm interested in the concurrency of engines,so I can reduce the chance of queuing,particuarly when I have active time dependant jobs.)
如果任何一个有任何其他的统计收集工作台,I'd be interested in them too.我有一些可以查询存储库并计算出每个工作台的一些统计信息,平均/最大运行时间,success/fail counts that sort of stuff.
Thanks in advance,
尼克
Here is an example of some of the things we are doing (this is a couple of years old now),如果有兴趣的话。
https://www.webmaps.co.nz/fmeserver/Reporting/20160719.html
工作台非常难看(不推荐使用的谷歌图表需要丑陋的解决方法)。but you can have the workbench.
if only I didn't cost me £100K and 18 months worth of effort to get my IT supplier to update our software.(it costs £30K and 6 months to update the desktop install!)
Looking forward to experminting with FME cloud
I managed to track down the work I did before on this and got the answers I needed.
The SQL to do this is actually quite tricky and complex (or at least mine was),所以我想出了b计划,它非常适合我的面向空间的头部,所以我想我会分享这个方法,因为工作台很容易被敲坏。
1) get all the records from the fme_job_hostory table.
2) for each record convert (or copy and convert) the start and end time to epoch seconds (%s in dateformatter)
3)使用x设置y为0的开始时间和结束时间epoch秒将每个功能转换为一行
4) generate a baseline by using the summarystatistics to get the min start time and max end time,then generating a line.(you need this to get the times when sever isn't doing anything)
5) use the lineonlineoverlayer to intersect all the lines - the 'overlaps' attribute now contains the number of engines running at any time,您可以使用长度计算器返回这个并发持续的秒数。(remember to subtract the baseline from the overlaps count)
6) I then output this to excel,using a 'state_changed' date/time which I got by using the coordinate extractor to get the first point of each intersected line,then converting the epoch seconds to a normal date/time using python (why won't the dateformatter do this btw?)
7)在Excel中有点透视表的魔力,然后给我一些很好的图表,显示了每小时的峰值并发性。每日并发峰值等
Thanks for the quick reply david_r,
I'm looking forward to seeing the new version,然而,我要花一段时间(几年)才能为我们当前版本的FME服务器的升级提供资金。
对,I'm querying the repository (oracle in our case) for some of the workbench stats I refer to,which works well.
获得每小时最大并发引擎数比我想象的要复杂得多,so was wondering whether anyone had already done this?
(the real bad news is that I think I DID work this out!我记得我经常为它挠头,but I can't find my work!so looking for a shortcut really.)
FME Server 2016.1及更高版本具有新的仪表板功能,您可以激活它(默认情况下禁用)。it will give you some out-of-the-box statistics such as average run times,等。你可以在这里找到一些有关它的信息.
如果你有一个旧版本的FME服务器或者你需要一些更具体的东西,your best bet is to query the PostgreSQL repository database,where you will find all the details about all the jobs (queued,running and finished/failed).使用这些表,很容易做出非常有针对性的报告和统计数据,such as the examples you mention.
Connection details for the PostgreSQL instance can be found here:https://knowledge.亚搏在线safe.com/questions/21761/connecting-to-fme-server-postgresql-database-repos.html
© 2019 亚搏在线Safe Software Inc |Legal