PHPMem v2.0.1

Version
1.6.45
Uptime
7 days 7 hours 31 minutes 51 seconds

Memory

Total
512MB
Used
13,32MB (2.6%)
Free
498,68MB

Keys

Current
10 162
Total (since start)
11 092
Evictions
0
Reclaimed
157
Expired Unfetched
0
Evicted Unfetched
0

Connections

Current
3 / 1 024 max
Total
62 792
Rejected
0
llm:a7309c3c1273eba6b6a33e22a00491deb2d6c37546d1d4df0ddca6177bea4d9f
TTL 6 hours 44 minutes 35 seconds Size 1,72KB Export
Edit
### 5.1 Performance Posture The **boxing_matches** table operates at moderate scale with 387,427 bout records and demonstrates adequate performance for current analytical workloads. As a single-table dataset capturing fighter attributes, bout outcomes, and historical metadata, the structure supports straightforward queries without complex join overhead. However, the absence of indexing strategy documentation and the 64% completeness score suggest that query performance may degrade when filtering on sparsely populated fighter attributes—particularly reach, stance, or detailed record statistics—where null-value handling could force full table scans across nearly 400,000 rows. ### 5.2 Key Optimizations **No high-priority optimizations recommended at current data scale.** At 387,427 records, the dataset remains within the performance envelope of modern analytical platforms without requiring immediate infrastructure intervention. The single-table architecture eliminates referential integrity bottlenecks, and typical queries analyzing win predictors by weight class, era, or fighter attributes will execute efficiently under standard configurations. Business impact remains neutral: stakeholders exploring knockout patterns or competitive balance across divisions should experience acceptable response times for dashboard refreshes and ad-hoc analysis. Future optimization attention should shift to the data quality layer—addressing the 64% completeness gap will yield greater analytical value than premature indexing of a dataset that has not yet demonstrated performance constraints under production query loads.