PHPMem v2.0.1

Version
1.6.45
Uptime
17 days 5 hours 33 minutes 39 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
16 / 1 024 max
Total
208 972
Rejected
0
llm:694e01018ed87267c60c54682fe3bb9c74b894f2da76655516601487d13b8b1e
TTL 6 days 13 hours 1 minute 52 seconds Size 1,36KB Export
Edit
**Yes. The dataset has 12 exact duplicate rows, and possibly one near-duplicate.** - **Exact duplicates:** The table has 300 rows but only 288 distinct `User_ID` values, so 12 IDs appear more than once. All 12 repeated IDs appear exactly twice (U0055, U0059, U0085, U0104, U0116, U0138, U0151, U0188, U0244, U0254, U0279, U0280). - **Identical across all columns:** The check on all content columns also found 12 groups. Each repeated `User_ID` therefore has a second copy that matches on every content field, not just the ID. The profile-column check also gave 12 groups. - **Same load:** Each duplicated ID sits in a single ingestion batch and source file. These look like repeats within one load rather than re-ingestion of a later file. - **Possible near-duplicate:** Matching on demographics plus income alone gives 13 groups, one more than the 12 above. One pair of rows shares those fields but has a different `User_ID` or other content. It could be a coincidence or a re-keyed duplicate, and I did not inspect it. Removing the repeats leaves 288 unique users. Any averages or counts over the raw table currently give these 12 users double weight, a 4% inflation of the row count. Deduplicate on `User_ID` before analysing, for example with `SELECT DISTINCT *`.