PHPMem v2.0.1

Version
1.6.45
Uptime
17 days 22 hours 26 minutes 5 seconds

Memory

Total
512MB
Used
12,72MB (2.48%)
Free
499,28MB

Keys

Current
14 060
Total (since start)
40 994
Evictions
0
Reclaimed
760
Expired Unfetched
0
Evicted Unfetched
0

Connections

Current
3 / 1 024 max
Total
242 172
Rejected
0
llm:ac48b2388238c17b46ad293a68bd44f11a5075f2b779be43014dcf433d95d9f0
TTL 4 days 7 hours 55 minutes 32 seconds Size 1,67KB Export
Edit
Using the profiler's "categorical" label, 18 columns qualify. The counts below are approximate distinct counts from the profiler (`approx_distinct_count`); the exact `distinct_count` field was empty. The result is shown in the rendered block above. **Low-cardinality true categories** - `Surface` has about 4 values in each of `raw_kaggle`, `return_kaggle` and `serve_kaggle`, which matches the four surfaces (hard, clay, grass, carpet). - `Rd` (round) has about 14 values in all three fact tables. - `return_kaggle.against` has about 1 value, so it is effectively constant and carries no information. - `players_tournament_man_.year` has about 24 values, covering the years 2002–2024. **Player names** - `Name` has about 491 values in `raw_kaggle`, `return_kaggle` and `serve_kaggle`. - This figure is approximate and looks high compared with the 462 rows in `players_man_`, so treat it as an estimate rather than an exact player count. **Numeric measures that the profiler tagged as categorical** - In `raw_kaggle`, `1SP` has about 189 values, `2SP` about 134, `vA` about 62, `Aces` about 54 and `DFs` about 29. - In `serve_kaggle`, `Bpsvd` has about 236 values and `Df%` about 231. - These are numeric statistics, not categories. `Bpsvd` and `Df%` are even stored as text. Treat them as measures, not dimensions. The highest-cardinality fields the profiler did not label categorical are `Tournament` (about 3,963), `Score` (about 10,386) and `against` (about 252,129 in `raw_kaggle` and `serve_kaggle`). They behave like identifiers or free text rather than categories.