Overview of Query Analysis Cases
General aggregation analysis
| Case Name | Description |
|---|---|
| Query the global distribution of clients | Query the global distribution of clients |
| Query the classification and PV trend of request methods | Query the classification and PV trend of request methods |
| Distribution of user agent requests by PV | Sort and analyze the number of PVs by user agent. |
| Query the daily consumption and trend prediction for this month | Sort and analyze the number of PVs by user agent. |
| Query the service consumption distribution of this month | Analyze the distribution of each service consumed this month. |
| Query the consumption of yesterday and comparison to that of last month | Analyze the distribution of each service consumed this month. |
NGINX log analysis
| Case Name | Description |
|---|---|
| Day-to-day comparison of PVs based on NGINX access logs | Compare the PVs of today with those of yesterday based on NGINX access logs. |
| Query the distribution of source IP addresses from NGINX logs | Analyze the distribution of source IP addresses. |
| Collect statistics on inbound and outbound NGINX traffic | Analyze the distribution of source IP addresses. |
| Query the top 10 addresses that access NGINX | Analyze top 10 addresses that access NGINX. |
| Predict PVs based on NGINX access logs | Analyze the predicted PVs based on NGINX access logs. |
| Query the PV trend and day-to-day comparison from NGINX access logs | Analyze the predicted PVs based on NGINX access logs. |
Tomcat web service analysis
| Case Name | Description |
|---|---|
| Analyze the trend of Tomcat request status | Analyze the trend of the number of Tomcat access requests in different states over time. |
| Distribution of Tomcat access requests by status and quantity over time | Distribution of Tomcat access requests by status and quantity over time] |
| Trend of PVs and UVs for Tomcat access over time | Analyze the trend of the PVs and unique visitors (UVs) of Tomcat access over time. |
| Query the number of Tomcat error requests and the comparison with that of last hour | Calculate the number of Tomcat error requests and compare it with that of last hour. |
| Query the top 10 URIs in Tomcat requests | Analyze top 10 URIs based on the number of Tomcat access requests. |
| Query the types and distribution of Tomcat clients | Analyze and query the types and number of clients that access Tomcat. |
| Collect statistics on inbound and outbound Tomcat traffic | Collect statistics on inbound and outbound Tomcat traffic |
| Query the proportions of Tomcat error requests | Analyze and query the types and number of clients that access Tomcat. |
| Analyze the proportion of Tomcat error requests | Analyze the proportion of Tomcat error requests. |
Alibaba Cloud CDN log analysis
| Case Name | Description |
|---|---|
| Alibaba Cloud CDN log analysis | Analyze the access logs of Alibaba Cloud CDN to generate a variety of operational data reports and analyze user access behavior. |
Aggregate function analysis
| Case Name | Description |
|---|---|
| Aggregate function analysis | Describe a variety of aggregate function and give analysis examples. |