Comments (4)
The traffic tab is highly specific to Stack Exchange - we have syslog forwarding to an inserter service on a SQL box that's doing locally batched bulk inserted into a schema with daily tables, these then do rollups we look at from the traffic tab perspective (it's just way too much data otherwise - 100m+ rows a day). Releasing that whole toolchain isn't a priority since I imagine the overlap of people who use HAProxy and SQL Server, and want to eat a license and a lot of storage on logs is pretty small.
However, we are also working on storing logs in logstash backed by elasticsearch - that we can simply document as the toolchain is already out there. If/when we move to that internally for traffic rollups, Opserver will have the code for it.
from opserver.
@NickCraver any change you could post the raw schema somewhere (i.e. a gist or whatever)? We're curious about exactly what data you persist, and when/how it gets aggregated.
We're not interested in the mechanics of handling/parsing/etc. the log messages, or the code to write to the database; that stuff is pretty straightforward. It's the relational schema we're looking for.
from opserver.
@jdaigle There were a lot of changes in motion and I never got back to this - the main table Opserver pulls from is just the aggregate and not the per-hit daily tables. It shifted a bit but here's the current form:
CREATE TABLE [dbo].[Log_Summary_Daily](
[CreationDate] [date] NOT NULL,
[Host] [varchar](50) NOT NULL,
[Server] [varchar](20) NOT NULL,
[ResponseCode] [smallint] NOT NULL,
[RouteName] [varchar](70) NULL,
[Hits] [int] NULL,
[Tq] [bigint] NULL,
[Tw] [bigint] NULL,
[Tc] [bigint] NULL,
[Tr] [bigint] NULL,
[Tt] [bigint] NULL,
[Bytes] [bigint] NULL,
[IsPageView] [bit] NOT NULL,
[SqlCount] [bigint] NULL,
[SqlDurationMs] [bigint] NULL,
[AspNetDurationMs] [bigint] NULL,
[RedisCount] [bigint] NULL,
[RedisDurationMs] [bigint] NULL,
[HttpCount] [bigint] NULL,
[HttpDurationMs] [bigint] NULL,
[TagEngineCount] [bigint] NULL,
[TagEngineDurationMs] [bigint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Log_Summary_Daily] ADD CONSTRAINT [DF_Log_Summary_Daily_IsPageView] DEFAULT ((0)) FOR [IsPageView]
Now, that being the case, it's still not tenable for use at our scale. We outgrew it. I've removed the traffic tab in Opserver for several reasons, but the main driver was the old layout didn't really work anymore and it was the last remnants relying on the Microsoft charting library. I plan for it to return with 2 changes: a new more usable layout and all SVG graphics (everything in overhaul
is SVG now).
I'll update this issue when I get time to bring it back, likely after a master merge takes place.
from opserver.
Can you post a screenshot of the traffic interface?
Thanks
from opserver.
Related Issues (20)
- Please help to explain perNodeSettings
- DashboardSettings - Node grouping per application
- Setup non-admin user account for WMI provider
- Cluster with multiple instances
- Docker "No security provider was found!" HOT 1
- Dashboard: Fix network speed to use proper unit
- Update nugets build errors on Opserver ASP HOT 5
- Config / Default folder missing in build HOT 2
- Additional filtering in exceptions view HOT 2
- System.NullReferenceException When Oncall Schedule Doesn't Have User HOT 1
- Redis: "An invalid IP address was specified." for master node HOT 1
- Issue With OIDC Authentication
- CPU Utilization and charts not showing in IIS deployment HOT 1
- Build badge was not updated HOT 1
- Minor typo in AsynchronousCommit HOT 4
- AG Cluster Info not displaying on SQL Dashboard HOT 12
- Enhancement : Additional Metrics for Web Servers
- Error: could not deserialize access token. Expected digit
- Incorrect OIDC RedirectURL generated for instance behind reverse proxy
- Any plans about upgrade to .NET 8
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from opserver.