project-lux / lux-marklogic

Code, issues, and resources related to LUX MarkLogic
Other
3 stars 2 forks source link

LUX Fronts Next Steps: Backend Usage Insights (from 1078) #39

Open gigamorph opened 7 months ago

gigamorph commented 7 months ago

Problem Description: The log analysis scripts produce TXT, JSON, and TSV files. Manually, TSV files are then saved as a spreadsheet and formatted. All charts are manually created. #1002 recommends seeking out a more polished solution that would enable the team to gain insights more efficiently. For instance, some such products would enable one to change the period and have all visuals immediately updated. This project’s scripts would have to be rerun and visuals recreated, manually. Start by finding out how far AWS can get us.

Expected Behavior/Solution: Describe the solution to the problem or the expected behavior.

Requirements: List of details required for the completion of the issue or requirements for the feature/bug. This can also include requirements that lie outside of the teams such as new design docs or clarification from an outside source.

Needed for promotion: If an item on the list is not needed, it should be crossed off but not removed.

UAT/LUX Examples:

Dependencies/Blocks:

Related Github Issues:

Related links:

~Wireframe/Mockup:~ ~Place wireframe/mockup for the proposed solution at end of ticket.~

roamye commented 3 months ago

@gigamorph & @xinjianguo -

From the old ticket ( https://git.yale.edu/lux-its/marklogic/issues/1078 ) it looks like this ticket should be in the 'In Progress' status once it answers the questions of:

I can format the ticket, but which one of you would be able to provide the information to move this ticket forward?

roamye commented 2 months ago

@xinjianguo - from the 7/3 ticket forming meeting it was noted that you will be the one to provide more information as you worked on this ticket.

xinjianguo commented 2 months ago

@roamye OK let me try to answer these questions:

The scope is limited to MarkLogic cluster usage. Solution is to use AWS CludWatch, Logs Insights.

It is tested via AWS CludWatch Dashboards.

Some example screen shots as follow:

CPU and network utilization Image

MarkLogic app server errors

Image

LUX top 10 long queries

Image

Hourly requests count

Image