PHPMem v2.0.1
Version
1.6.45
Uptime
7 days 5 hours 42 minutes 28 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
2 / 1 024 max
Total
61 047
Rejected
0
llm:f3ab048c51b421964db8ebb6f3e6df4f72ef603aae5e323ba953bcd8e06eeb93
Edit
```json
{
"classifications": [
{"column": "Name", "label": "primary_key", "confidence": 0.95, "reason": "293 distinct values out of 482 rows (60.8% distinct), zero nulls, appears to be the main identifier for supercomputers"},
{"column": "Status", "label": "none", "confidence": 1.0, "reason": "Only 1 distinct value, not a key"},
{"column": "Certainty", "label": "none", "confidence": 1.0, "reason": "Only 2 distinct values, categorical attribute"},
{"column": "Single cluster?", "label": "none", "confidence": 1.0, "reason": "Only 1 distinct value, boolean flag"},
{"column": "Max OP/s (log)", "label": "none", "confidence": 0.9, "reason": "239 distinct values but 4.6% nulls, computed metric not a key"},
{"column": "H100 equivalents", "label": "none", "confidence": 0.9, "reason": "Computed metric with nulls, not a key"},
{"column": "Chip type (primary)", "label": "none", "confidence": 1.0, "reason": "Only 36 distinct values, categorical attribute"},
{"column": "Chip quantity (primary)", "label": "none", "confidence": 0.9, "reason": "172 distinct values but 11.2% nulls, numeric attribute"},
{"column": "Country", "label": "none", "confidence": 1.0, "reason": "Only 37 distinct values, categorical attribute"},
{"column": "Owner", "label": "none", "confidence": 1.0, "reason": "131 distinct values, categorical attribute with repeating values"},
{"column": "First Operational Date", "label": "none", "confidence": 0.9, "reason": "219 distinct values but has nulls, temporal attribute"},
{"column": "Note", "label": "none", "confidence": 1.0, "reason": "Only 83 distinct values, text field"},
{"column": "Sector", "label": "none", "confidence": 1.0, "reason": "Only 4 distinct values, categorical attribute"},
{"column": "Power Capacity (MW)", "label": "none", "confidence": 0.9, "reason": "258 distinct values but 12.4% nulls, numeric metric"},
{"column": "Hardware Cost", "label": "none", "confidence": 0.9, "reason": "264 distinct values but 20.3% nulls, numeric metric"},
{"column": "Location", "label": "none", "confidence": 1.0, "reason": "149 distinct values, text attribute"},
{"column": "Users", "label": "none", "confidence": 1.0, "reason": "109 distinct values, categorical attribute"},
{"column": "Hardware note", "label": "none", "confidence": 1.0, "reason": "Only 40 distinct values, text field"},
{"column": "Quote", "label": "none", "confidence": 1.0, "reason": "199 distinct values, text field"},
{"column": "First Operational Date Note", "label": "none", "confidence": 1.0, "reason": "184 distinct values, text field"},
{"column": "Certainty Note", "label": "none", "confidence": 1.0, "reason": "Only 43 distinct values, text field"},
{"column": "Energy Efficiency (log)", "label": "none", "confidence": 0.9, "reason": "138 distinct values but 15.8% nulls, computed metric"},
{"column": "Builds Upon", "label": "foreign_key", "confidence": 0.85, "reason": "30 distinct values, references other supercomputer names in same table"},
{"column": "Superseded by", "label": "foreign_key", "confidence": 0.85, "reason": "30 distinct values, references other supercomputer names in same table"},
{"column": "Possible Duplicate", "label": "none", "confidence": 1.0, "reason": "Only 1 distinct value (empty), not used"},
{"column": "Possible Duplicate Of", "label": "none", "confidence": 1.0, "reason": "Only 1 distinct value (empty), not used"},
{"column": "Chip type (secondary)", "label": "none", "confidence": 1.0, "reason": "Only 11 distinct values, categorical attribute"},
{"column": "Chip quantity (secondary)", "label": "none", "confidence": 0.9, "reason": "Only 18 distinct values with 96.3% nulls, numeric attribute"},
{"column": "Total number of AI chips", "label": "none", "confidence": 0.9, "reason": "179 distinct values but 9.8% nulls, numeric metric"},
{"column": "GPU Supplier (primary)", "label": "none", "confidence": 1.0, "reason": "Only 10 distinct values, categorical attribute"},
{"column": "GPU supplier (secondary)", "label": "none", "confidence": 1.0, "reason": "Only 4 distinct values, categorical attribute"},
{"column": "Include in Standard Analysis", "label": "none", "confidence": 1.0, "reason": "Only 1 distinct value, boolean flag"},
{"column": "Exclude", "label": "none", "confidence": 1.0, "reason": "Only 1 distinct value (empty), not used"},
{"column": "Rank when first operational", "label": "none", "confidence": 0.9, "reason": "128 distinct values but 7.7% nulls, numeric attribute"},
{"column": "16-bit OP/s (log)", "label": "none", "confidence": 0.9, "reason": "237 distinct values but 8.3% nulls, computed metric"},
{"column": "Max OP/s", "label": "none", "confidence": 0.9, "reason": "241 distinct values but 4.6% nulls, numeric metric"},
{"column": "8-bit OP/s", "label": "none", "confidence": 0.9, "reason": "163 distinct values but 50.8% nulls, numeric metric"},
{"column": "16-bit OP/s", "label": "none", "confidence": 0.9, "reason": "239 distinct values but 8.3% nulls, numeric metric"},
{"column": "32-bit OP/s", "label": "none", "confidence": 0.9, "reason": "227 distinct values but 17.6% nulls, numeric metric"},
{"column": "Calculated Power Capacity (MW)", "label": "none", "confidence": 0.9, "reason": "248 distinct values but 13.5% nulls, computed metric"},
{"column": "Reported Power Capacity (MW)", "label": "none", "confidence": 0.9, "reason": "Only 76 distinct values with 83.4% nulls, numeric metric"},
{"column": "Energy Efficiency", "label": "none", "confidence": 0.9, "reason": "154 distinct values but 15.8% nulls, computed metric"},
{"column": "Calculated Cost", "label": "none", "confidence": 0.9, "reason": "264 distinct values but 20.3% nulls, computed metric"},
{"column": "Reported Cost", "label": "none", "confidence": 0.9, "reason": "Only 26 distinct values with 94.2% nulls, numeric metric"},
{"column": "Reported Cost (Inflation adjusted)", "label": "none", "confidence": 0.9, "reason": "Only 28 distinct values with 94.2% nulls, computed metric"},
{"column": "Cost Quote", "label": "none", "confidence": 1.0, "reason": "Only 28 distinct values, text field"},
{"column": "Noteworthy", "label": "none", "confidence": 1.0, "reason": "Only 1 distinct value with 98.1% nulls, boolean flag"},
{"column": "Decommissioned Date (if applicable)", "label": "none", "confidence": 1.0, "reason": "Only 1 distinct value (empty), not used"},
{"column": "Largest existing cluster when first operational", "label": "foreign_key", "confidence": 0.8, "reason": "17 distinct values, references other supercomputer names"},
{"column": "% of largest cluster when first operational", "label": "none", "confidence": 0.9, "reason": "235 distinct values but 7.7% nulls, computed metric"},
{"column": "Source 1", "label": "none", "confidence": 1.0, "reason": "253 distinct values, URL text field"},
{"column": "Source 2", "label": "none", "confidence": 1.0, "reason": "99 distinct values, URL text field"},
{"column": "Source 3", "label": "none", "confidence": 1.0, "reason": "40 distinct values, URL text field"},
{"column": "Source 4", "label": "none", "confidence": 1.0, "reason": "12 distinct values, URL text field"},
{"column": "Source 5", "label": "none", "confidence": 1.0, "reason": "4 distinct values, URL text field"},
{"column": "latitude", "label": "none", "confidence": 0.9, "reason": "144 distinct values but 4.8% nulls, geographic coordinate"},
{"column": "longitude", "label": "none", "confidence": 0.9, "reason": "144 distinct values but 4.8% nulls, geographic coordinate"}
]
}
```