PHPMem v2.0.1
Version
1.6.45
Uptime
18 days 4 hours 45 minutes 41 seconds
Memory
Total
512MB
Used
12,33MB (2.41%)
Free
499,67MB
Keys
Current
13 424
Total (since start)
40 994
Evictions
0
Reclaimed
762
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
2 / 1 024 max
Total
243 981
Rejected
0
llm:3d85e7ca467e01535b2c7a9c5b4ec8a251689ee5c502d61c10dc69fea7e8da95
Edit
<invoke name="query_sql">
<parameter name="sql">SELECT COUNT(*) n,
SUM(CASE WHEN SP IS NOT NULL AND "1SP"+"2SP">SP THEN 1 ELSE 0 END) sp_sum_gt_sp,
SUM(CASE WHEN SP IS NOT NULL AND "1SP"+"2SP"<SP THEN 1 ELSE 0 END) sp_sum_lt_sp,
SUM(CASE WHEN SP>TP THEN 1 ELSE 0 END) sp_gt_tp,
SUM(CASE WHEN Aces+DFs>SP THEN 1 ELSE 0 END) aces_dfs_gt_sp,
SUM(CASE WHEN SP=0 THEN 1 ELSE 0 END) sp_zero,
SUM(CASE WHEN Surface IS NULL OR TRIM(Surface)='' THEN 1 ELSE 0 END) surface_blank,
SUM(CASE WHEN Date LIKE '%‑%' THEN 1 ELSE 0 END) date_nonascii_hyphen,
SUM(CASE WHEN Date LIKE '%-%' THEN 1 ELSE 0 END) date_ascii_hyphen,
SUM(CASE WHEN Score LIKE '%nbsp%' THEN 1 ELSE 0 END) score_nbsp,
SUM(CASE WHEN Time='' OR Time IS NULL THEN 1 ELSE 0 END) time_blank,
SUM(CASE WHEN Rk IS NULL THEN 1 ELSE 0 END) rk_null,
SUM(CASE WHEN Rk>1500 THEN 1 ELSE 0 END) rk_gt_1500,
SUM(CASE WHEN Aces>40 THEN 1 ELSE 0 END) aces_gt_40,
SUM(CASE WHEN TP>300 THEN 1 ELSE 0 END) tp_gt_300
FROM raw.raw_kaggle</parameter>
<parameter name="purpose">Profile impossible values and format inconsistencies in raw_kaggle</parameter>
</invoke>