#import the relevant libraries 
import os
import pymysql
import pandas as pd

#establish the connection to the mysql database
host = "192.168.88.187"
port = "3306"
user = "backblaze"
password = "Testing.2023"
database = "backblaze_ml"

conn = pymysql.connect(
    host=host,
    port=int(3306),
    user=user,
    passwd=password,
    db=database,
    charset='utf8mb4')

#take a look at the data
sqldf = pd.read_sql_query("select model, count(model), count(smart_5_raw),count(smart_160_raw),count(smart_161_raw),count(smart_163_raw),count(smart_164_raw),count(smart_165_raw),count(smart_166_raw),count(smart_167_raw),count(smart_168_raw),count(smart_169_raw),count(smart_183_raw),count(smart_184_raw),count(smart_187_raw),count(smart_188_raw),count(smart_189_raw),count(smart_191_raw),count(smart_192_raw),count(smart_193_raw),count(smart_194_raw),count(smart_195_raw),count(smart_196_raw),count(smart_197_raw),count(smart_198_raw),count(smart_199_raw),count(smart_200_raw),count(smart_234_raw),count(smart_235_raw),count(smart_240_raw),count(smart_241_raw),count(smart_242_raw),count(smart_245_raw),count(smart_246_raw),count(smart_247_raw),count(smart_248_raw),count(smart_250_raw) from drive_stats group by model", conn)
sqldf

	model	count(model)	count(smart_5_raw)	count(smart_160_raw)	count(smart_161_raw)	count(smart_163_raw)	count(smart_164_raw)	count(smart_165_raw)	count(smart_166_raw)	count(smart_167_raw)	...	count(smart_234_raw)	count(smart_235_raw)	count(smart_240_raw)	count(smart_241_raw)	count(smart_242_raw)	count(smart_245_raw)	count(smart_246_raw)	count(smart_247_raw)	count(smart_248_raw)	count(smart_250_raw)
0	CT250MX500SSD1	1535	1532	0	0	0	0	0	0	0	...	0	0	0	0	0	0	1532	1532	1532	0
1	HGST HDS5C4040ALE630	2044	2043	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
2	HGST HDS724040ALE640	1224	1224	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
3	HGST HMS5C4040ALE640	225761	225732	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
4	HGST HMS5C4040BLE640	405986	405960	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
5	HGST HUH721212ALE600	12251	12251	0	0	0	0	0	0	0	...	0	0	0	12233	12233	0	0	0	0	0
6	HGST HUH721212ALE604	49135	49075	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
7	HGST HUH721212ALN604	269502	269458	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
8	HGST HUH728080ALE600	42974	42971	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
9	HGST HUH728080ALE604	744	744	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
10	HGST HUS726040ALE610	5778	5776	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
11	Hitachi HDS5C3030ALA630	107608	107608	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
12	Hitachi HDS5C4040ALE630	51121	51121	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
13	Hitachi HDS722020ALA330	150211	150211	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
14	Hitachi HDS723020BLA642	1011	1011	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
15	Hitachi HDS723030ALA640	53008	53008	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
16	Hitachi HDS723030BLE640	812	812	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
17	HP SSD S700 250GB	4938	4896	4896	4896	4896	4896	4896	4896	4896	...	0	0	0	4896	4896	4896	0	0	0	0
18	MTFDDAV240TCB	3036	3036	0	0	0	0	0	0	0	...	0	0	0	0	0	3036	0	0	0	0
19	MTFDDAV240TDU	273	273	0	0	0	0	0	0	0	...	0	273	0	273	0	273	0	273	273	0
20	SAMSUNG HD154UI	188	188	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
21	Samsung SSD 850 EVO 1TB	234	234	0	0	0	0	0	0	0	...	0	234	0	234	0	0	0	0	0	0
22	Seagate BarraCuda 120 SSD ZA250CM10003	6156	0	0	0	0	0	0	0	0	...	1575	6155	0	6155	6155	0	0	0	0	0
23	Seagate BarraCuda SSD ZA2000CM10002	912	0	0	0	0	0	0	0	0	...	0	912	0	912	912	0	0	0	0	0
24	Seagate BarraCuda SSD ZA250CM10002	13982	0	0	0	0	0	0	0	0	...	0	13982	0	13982	13982	0	0	0	0	0
25	Seagate BarraCuda SSD ZA500CM10002	1487	0	0	0	0	0	0	0	0	...	0	1487	0	1487	1487	0	0	0	0	0
26	Seagate SSD	2099	0	0	0	0	0	0	0	0	...	0	2099	0	2099	2099	0	0	0	0	0
27	SSDSCKKB480G8R	19	19	0	0	0	0	0	0	0	...	19	19	0	19	19	19	0	0	0	0
28	ST10000NM001G	602	602	0	0	0	0	0	0	0	...	0	0	602	602	602	0	0	0	0	0
29	ST10000NM0086	169723	169692	0	0	0	0	0	0	0	...	0	0	169692	169692	169692	0	0	0	0	0
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
93	WDC WD1600AAJS	14771	14771	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
94	WDC WD1600BPVT	2494	2494	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
95	WDC WD20EFRX	3639	3639	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
96	WDC WD2500AAJB	279	279	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
97	WDC WD2500AAJS	1778	1778	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
98	WDC WD2500BPVT	289	289	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
99	WDC WD2500JB	39	39	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
100	WDC WD30EFRX	64614	64614	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
101	WDC WD30EZRS	419	419	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
102	WDC WD30EZRX	3799	3799	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
103	WDC WD3200AAJB	759	759	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
104	WDC WD3200AAJS	891	891	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
105	WDC WD3200BEKT	782	782	0	0	0	0	0	0	0	...	0	0	782	782	782	0	0	0	0	0
106	WDC WD3200BEKX	1787	1787	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
107	WDC WD40EFRX	3106	3106	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
108	WDC WD5000BPKT	7634	7634	0	0	0	0	0	0	0	...	0	0	7634	7634	7634	0	0	0	0	0
109	WDC WD5000LPCX	4874	4874	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
110	WDC WD5000LPVX	149438	149438	0	0	0	0	0	0	0	...	0	0	39506	0	0	0	0	0	0	0
111	WDC WD5002ABYS	1916	1916	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
112	WDC WD60EFRX	41381	41381	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
113	WDC WD800AAJB	4355	4355	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
114	WDC WD800AAJS	11373	11373	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
115	WDC WD800BB	5887	5887	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
116	WDC WD800JB	4758	4758	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
117	WDC WD800JD	763	763	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
118	WDC WD800LB	759	759	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
119	WDC WDS250G2B0A	527	525	0	0	0	0	525	525	525	...	525	0	0	525	525	0	0	0	0	0
120	WDC WUH721414ALE6L4	20903	20872	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0
121	WDC WUH721816ALE6L0	1318	1317	0	0	0	0	0	0	0	...	0	0	0	1317	1317	0	0	0	0	0
122	WDC WUH721816ALE6L4	1522	1518	0	0	0	0	0	0	0	...	0	0	0	0	0	0	0	0	0	0

123 rows × 37 columns

Looking at each of the attributes we find the following: smart_160_raw, smart_161_raw, smart_163_raw, smart_164_raw - only apply to HP SSD S700 250GB smart_5_raw applies to all but the seagate SSDs

smart_165_raw see below - only to SSDs

mysql> select model, count(model) from drive_stats where smart_165_raw is not null group by model;

+-------------------------+--------------+
| model                   | count(model) |
+-------------------------+--------------+
| HP SSD S700 250GB       |         4896 |
| WD Blue SA510 2.5 250GB |           20 |
| WDC  WDS250G2B0A        |            5 |
| WDC WDS250G2B0A         |          525 |
+-------------------------+--------------+
4 rows in set (53.75 sec)

same for 166 , see below

mysql> select model, count(model) from drive_stats where smart_166_raw is not null group by model;

+-------------------------+--------------+
| model                   | count(model) |
+-------------------------+--------------+
| HP SSD S700 250GB       |         4896 |
| WD Blue SA510 2.5 250GB |           20 |
| WDC  WDS250G2B0A        |            5 |
| WDC WDS250G2B0A         |          525 |
+-------------------------+--------------+
4 rows in set (50.20 sec)

same for 167

mysql> select model, count(model) from drive_stats where smart_167_raw is not null group by model;

+-------------------------+--------------+
| model                   | count(model) |
+-------------------------+--------------+
| HP SSD S700 250GB       |         4896 |
| WD Blue SA510 2.5 250GB |           20 |
| WDC  WDS250G2B0A        |            5 |
| WDC WDS250G2B0A         |          525 |
+-------------------------+--------------+
4 rows in set (53.24 sec)

168 again for SSDs

mysql> select model, count(model) from drive_stats where smart_168_raw is not null group by model;
+----------------------------------------+--------------+
| model                                  | count(model) |
+----------------------------------------+--------------+
| HP SSD S700 250GB                      |         4896 |
| Seagate BarraCuda 120 SSD ZA250CM10003 |         6155 |
| Seagate BarraCuda SSD ZA2000CM10002    |          912 |
| Seagate BarraCuda SSD ZA250CM10002     |        13982 |
| Seagate BarraCuda SSD ZA500CM10002     |         1487 |
| Seagate SSD                            |         2099 |
| WD Blue SA510 2.5 250GB                |           20 |
| WDC  WDS250G2B0A                       |            5 |
| WDC WDS250G2B0A                        |          525 |
+----------------------------------------+--------------+
9 rows in set (55.66 sec)

169

mysql> select model, count(model) from drive_stats where smart_169_raw is not null group by model;

+-------------------------+--------------+
| model                   | count(model) |
+-------------------------+--------------+
| HP SSD S700 250GB       |         4896 |
| WD Blue SA510 2.5 250GB |           20 |
| WDC  WDS250G2B0A        |            5 |
| WDC WDS250G2B0A         |          525 |
+-------------------------+--------------+
4 rows in set (55.74 sec)

183 applies to 23 models , ssds and hdds

mysql> select model, count(model) from drive_stats where smart_183_raw is not null group by model;


+-------------------------+--------------+
| model                   | count(model) |
+-------------------------+--------------+
| CT250MX500SSD1          |         1532 |
| MTFDDAV240TDU           |          273 |
| SAMSUNG HD154UI         |           40 |
| Samsung SSD 850 EVO 1TB |          234 |
| ST1500DL003             |         8910 |
| ST2000DL001             |          286 |
| ST2000DL003             |          168 |
| ST2000DM001             |           98 |
| ST3000DM001             |       237085 |
| ST31500541AS            |        65257 |
| ST3160316AS             |        10818 |
| ST3160318AS             |        13426 |
| ST32000542AS            |         2332 |
| ST320005XXXX            |          511 |
| ST33000651AS            |         3626 |
| ST4000DM000             |      6030527 |
| ST4000DM001             |         2552 |
| ST4000DM004             |          322 |
| ST4000DM005             |         5942 |
| ST4000DX000             |        78285 |
| ST4000DX002             |         1153 |
| ST6000DX000             |        88951 |
| ST8000DM004             |         2822 |
+-------------------------+--------------+
23 rows in set (56.93 sec)

184 applies to 44 models

mysql> select model, count(model) from drive_stats where smart_184_raw is not null group by model;


+-------------------------+--------------+
| model                   | count(model) |
+-------------------------+--------------+
| CT250MX500SSD1          |         1532 |
| MTFDDAV240TDU           |          273 |
| SAMSUNG HD154UI         |           40 |
| SSDSCKKB480G8R          |           19 |
| ST10000NM0086           |       169692 |
| ST1500DL003             |         8910 |
| ST2000DL001             |          286 |
| ST2000DL003             |          168 |
| ST2000DM001             |           98 |
| ST2000VN000             |          874 |
| ST250LT007              |         3367 |
| ST3000DM001             |       237085 |
| ST31500341AS            |        23987 |
| ST31500541AS            |        65257 |
| ST3160316AS             |        10818 |
| ST3160318AS             |        13426 |
| ST32000542AS            |         2332 |
| ST320005XXXX            |          511 |
| ST320LT007              |        61957 |
| ST33000651AS            |         3626 |
| ST3500320AS             |          992 |
| ST4000DM000             |      6030527 |
| ST4000DM001             |         2552 |
| ST4000DM004             |          322 |
| ST4000DM005             |         5942 |
| ST4000DX000             |        78285 |
| ST4000DX002             |         1153 |
| ST500LM021              |         3964 |
| ST500LM030              |        62417 |
| ST6000DX000             |        88951 |
| ST8000DM002             |      1075431 |
| ST8000DM004             |         2822 |
| ST8000DM005             |          329 |
| ST8000NM0055            |      1550554 |
| ST9250315AS             |        16079 |
| ST9320325AS             |         2325 |
| WD Blue SA510 2.5 250GB |           20 |
| WDC  WDS250G2B0A        |            5 |
| WDC WD1600AAJS          |          930 |
| WDC WDS250G2B0A         |          525 |
+-------------------------+--------------+
40 rows in set (57.71 sec)

for 187 we have measurements from 50 drive models

mysql> select model, count(model) from drive_stats where smart_187_raw is not null group by model;

+-------------------------+--------------+
| model                   | count(model) |
+-------------------------+--------------+
| CT250MX500SSD1          |         1532 |
| SAMSUNG HD154UI         |           40 |
| Samsung SSD 850 EVO 1TB |          234 |
| ST10000NM001G           |          602 |
| ST10000NM0086           |       169692 |
| ST12000NM0007           |      1082500 |
| ST12000NM0008           |       630153 |
| ST12000NM001G           |       116200 |
| ST12000NM0117           |          613 |
| ST14000NM0018           |         1863 |
| ST14000NM001G           |       123595 |
| ST14000NM0138           |        81304 |
| ST1500DL003             |         8910 |
| ST16000NM001G           |        70465 |
| ST16000NM002J           |           84 |
| ST18000NM000J           |         1756 |
| ST2000DL001             |          286 |
| ST2000DL003             |          168 |
| ST2000DM001             |           98 |
| ST2000VN000             |          874 |
| ST250LT007              |         3367 |
| ST3000DM001             |       237085 |
| ST31500341AS            |        23987 |
| ST31500541AS            |        65257 |
| ST3160316AS             |        10818 |
| ST3160318AS             |        13426 |
| ST32000542AS            |         2332 |
| ST320005XXXX            |          511 |
| ST320LT007              |        61957 |
| ST33000651AS            |         3626 |
| ST3500320AS             |          992 |
| ST4000DM000             |      6030527 |
| ST4000DM001             |         2552 |
| ST4000DM004             |          322 |
| ST4000DM005             |         5942 |
| ST4000DX000             |        78285 |
| ST4000DX002             |         1153 |
| ST500LM021              |         3964 |
| ST500LM030              |        62417 |
| ST6000DX000             |        88951 |
| ST8000DM002             |      1075431 |
| ST8000DM004             |         2822 |
| ST8000DM005             |          329 |
| ST8000NM0055            |      1550554 |
| ST9250315AS             |        16079 |
| ST9320325AS             |         2325 |
| WD Blue SA510 2.5 250GB |           20 |
| WDC  WDS250G2B0A        |            5 |
| WDC WD1600AAJS          |          930 |
| WDC WDS250G2B0A         |          525 |
+-------------------------+--------------+
50 rows in set (58.38 sec)

mysql> 

188 has measurements from 49

mysql> select model, count(model) from drive_stats where smart_188_raw is not null group by model;


+-------------------------+--------------+
| model                   | count(model) |
+-------------------------+--------------+
| MTFDDAV240TDU           |          273 |
| SAMSUNG HD154UI         |           40 |
| ST10000NM001G           |          602 |
| ST10000NM0086           |       169692 |
| ST12000NM0007           |      1082500 |
| ST12000NM0008           |       630153 |
| ST12000NM001G           |       116200 |
| ST12000NM0117           |          613 |
| ST14000NM0018           |         1863 |
| ST14000NM001G           |       123595 |
| ST14000NM0138           |        81304 |
| ST1500DL003             |         8910 |
| ST16000NM001G           |        70465 |
| ST16000NM002J           |           84 |
| ST18000NM000J           |         1756 |
| ST2000DL001             |          286 |
| ST2000DL003             |          168 |
| ST2000DM001             |           98 |
| ST2000VN000             |          874 |
| ST250LT007              |         3367 |
| ST3000DM001             |       237085 |
| ST31500341AS            |        23987 |
| ST31500541AS            |        65257 |
| ST3160316AS             |        10818 |
| ST3160318AS             |        13426 |
| ST32000542AS            |         2332 |
| ST320005XXXX            |          511 |
| ST320LT007              |        61957 |
| ST33000651AS            |         3626 |
| ST3500320AS             |          992 |
| ST4000DM000             |      6030527 |
| ST4000DM001             |         2552 |
| ST4000DM004             |          322 |
| ST4000DM005             |         5942 |
| ST4000DX000             |        78285 |
| ST4000DX002             |         1153 |
| ST500LM021              |         3964 |
| ST500LM030              |        62417 |
| ST6000DX000             |        88951 |
| ST8000DM002             |      1075431 |
| ST8000DM004             |         2822 |
| ST8000DM005             |          329 |
| ST8000NM0055            |      1550554 |
| ST9250315AS             |        16079 |
| ST9320325AS             |         2325 |
| WD Blue SA510 2.5 250GB |           20 |
| WDC  WDS250G2B0A        |            5 |
| WDC WD1600AAJS          |          930 |
| WDC WDS250G2B0A         |          525 |
+-------------------------+--------------+
49 rows in set (1 min 2.17 sec)

189 from 32 models

mysql> select model, count(model) from drive_stats where smart_189_raw is not null group by model;

+---------------+--------------+
| model         | count(model) |
+---------------+--------------+
| ST10000NM0086 |       169692 |
| ST1500DL003   |         8910 |
| ST2000DL001   |          286 |
| ST2000DL003   |          168 |
| ST2000DM001   |           98 |
| ST2000VN000   |          874 |
| ST250LT007    |         3367 |
| ST3000DM001   |       237085 |
| ST31500341AS  |        23987 |
| ST31500541AS  |        65257 |
| ST3160316AS   |        10818 |
| ST3160318AS   |        13426 |
| ST32000542AS  |         2332 |
| ST320005XXXX  |          511 |
| ST320LT007    |        61957 |
| ST33000651AS  |         3626 |
| ST3500320AS   |          992 |
| ST4000DM000   |      6030527 |
| ST4000DM001   |         2552 |
| ST4000DM004   |          322 |
| ST4000DM005   |         5942 |
| ST4000DX000   |        78285 |
| ST4000DX002   |         1153 |
| ST500LM021    |         3964 |
| ST500LM030    |        62417 |
| ST6000DX000   |        88951 |
| ST8000DM002   |      1075431 |
| ST8000DM004   |         2822 |
| ST8000DM005   |          329 |
| ST8000NM0055  |      1550554 |
| ST9250315AS   |        16079 |
| ST9320325AS   |         2325 |
+---------------+--------------+
32 rows in set (1 min 1.06 sec)

191 from 40 models

mysql> select model, count(model) from drive_stats where smart_191_raw is not null group by model;


+---------------------+--------------+
| model               | count(model) |
+---------------------+--------------+
| ST10000NM0086       |       169692 |
| ST1500DL003         |         8910 |
| ST2000DL001         |          286 |
| ST2000DL003         |          168 |
| ST2000DM001         |           98 |
| ST2000VN000         |          874 |
| ST250LM004 HN       |        10855 |
| ST250LT007          |         3367 |
| ST3000DM001         |       237085 |
| ST320LT007          |        61957 |
| ST33000651AS        |         3626 |
| ST4000DM000         |      6030527 |
| ST4000DM001         |         2552 |
| ST4000DM004         |          322 |
| ST4000DM005         |         5942 |
| ST4000DX000         |        78285 |
| ST4000DX002         |         1153 |
| ST500LM012 HN       |       359396 |
| ST500LM021          |         3964 |
| ST500LM030          |        62417 |
| ST6000DX000         |        88951 |
| ST8000DM002         |      1075431 |
| ST8000DM004         |         2822 |
| ST8000DM005         |          329 |
| ST8000NM0055        |      1550554 |
| ST9250315AS         |        16079 |
| ST9320325AS         |         2325 |
| TOSHIBA HDWF180     |         3262 |
| TOSHIBA MD04ABA400V |        14496 |
| TOSHIBA MD04ABA500V |          443 |
| TOSHIBA MG07ACA14TA |       520136 |
| TOSHIBA MG08ACA16TA |         5718 |
| TOSHIBA MG08ACA16TE |        23669 |
| TOSHIBA MQ01ABF050  |       358938 |
| TOSHIBA MQ01ABF050M |       219765 |
| WDC WD1600BPVT      |         2494 |
| WDC WD2500BPVT      |          289 |
| WDC WD3200BEKT      |          782 |
| WDC WD5000BPKT      |         7634 |
| WDC WD5000LPVX      |        41689 |
+---------------------+--------------+
40 rows in set (53.30 sec)

192 from 100 models

mysql> select model, count(model) from drive_stats where smart_192_raw is not null group by model;
+----------------------------------------+--------------+
| model                                  | count(model) |
+----------------------------------------+--------------+
| HGST HDS5C4040ALE630                   |         2043 |
| HGST HDS724040ALE640                   |          990 |
| HGST HMS5C4040ALE640                   |       225725 |
| HGST HMS5C4040BLE640                   |       405960 |
| HGST HUH721212ALE600                   |        12251 |
| HGST HUH721212ALE604                   |        49075 |
| HGST HUH721212ALN604                   |       269458 |
| HGST HUH728080ALE600                   |        42971 |
| HGST HUH728080ALE604                   |          744 |
| HGST HUS726040ALE610                   |         5776 |
| Hitachi HDS5C3030ALA630                |        74609 |
| Hitachi HDS5C4040ALE630                |        34168 |
| Hitachi HDS722020ALA330                |        95505 |
| Hitachi HDS723020BLA642                |          649 |
| Hitachi HDS723030ALA640                |        36192 |
| Hitachi HDS723030BLE640                |          558 |
| HP SSD S700 250GB                      |         4896 |
| Seagate BarraCuda 120 SSD ZA250CM10003 |         6155 |
| Seagate BarraCuda SSD ZA2000CM10002    |          912 |
| Seagate BarraCuda SSD ZA250CM10002     |        13982 |
| Seagate BarraCuda SSD ZA500CM10002     |         1487 |
| Seagate SSD                            |         2099 |
| ST10000NM001G                          |          602 |
| ST10000NM0086                          |       169692 |
| ST12000NM0007                          |      1082500 |
| ST12000NM0008                          |       630153 |
| ST12000NM001G                          |       116200 |
| ST12000NM0117                          |          613 |
| ST14000NM0018                          |         1863 |
| ST14000NM001G                          |       123595 |
| ST14000NM0138                          |        81304 |
| ST1500DL003                            |         8910 |
| ST16000NM001G                          |        70465 |
| ST16000NM002J                          |           84 |
| ST18000NM000J                          |         1756 |
| ST2000DL001                            |          286 |
| ST2000DL003                            |          168 |
| ST2000DM001                            |           98 |
| ST2000VN000                            |          874 |
| ST250LM004 HN                          |        10855 |
| ST250LT007                             |         3367 |
| ST3000DM001                            |       237085 |
| ST320LT007                             |        61957 |
| ST33000651AS                           |         3626 |
| ST4000DM000                            |      6030527 |
| ST4000DM001                            |         2552 |
| ST4000DM004                            |          322 |
| ST4000DM005                            |         5942 |
| ST4000DX000                            |        78285 |
| ST4000DX002                            |         1153 |
| ST500LM012 HN                          |       359396 |
| ST500LM021                             |         3964 |
| ST500LM030                             |        62417 |
| ST6000DX000                            |        88951 |
| ST8000DM002                            |      1075431 |
| ST8000DM004                            |         2822 |
| ST8000DM005                            |          329 |
| ST8000NM0055                           |      1550554 |
| ST9250315AS                            |        16079 |
| ST9320325AS                            |         2325 |
| TOSHIBA DT01ACA300                     |         2192 |
| TOSHIBA HDWF180                        |         3262 |
| TOSHIBA MD04ABA400V                    |        14496 |
| TOSHIBA MD04ABA500V                    |          443 |
| TOSHIBA MG07ACA14TA                    |       520136 |
| TOSHIBA MG07ACA14TEY                   |         4412 |
| TOSHIBA MG08ACA16TA                    |         5718 |
| TOSHIBA MG08ACA16TE                    |        23669 |
| TOSHIBA MG08ACA16TEY                   |         9396 |
| TOSHIBA MQ01ABF050                     |       358938 |
| TOSHIBA MQ01ABF050M                    |       219765 |
| WDC  WUH721414ALE6L4                   |          305 |
| WDC  WUH721816ALE6L0                   |           34 |
| WDC  WUH721816ALE6L4                   |            8 |
| WDC WD10EACS                           |         1315 |
| WDC WD10EADS                           |        16271 |
| WDC WD10EADX                           |          996 |
| WDC WD1600AAJB                         |         3745 |
| WDC WD1600AAJS                         |        14771 |
| WDC WD1600BPVT                         |         2494 |
| WDC WD20EFRX                           |         3639 |
| WDC WD2500AAJB                         |          279 |
| WDC WD2500AAJS                         |         1778 |
| WDC WD2500BPVT                         |          289 |
| WDC WD30EFRX                           |        58856 |
| WDC WD3200AAJB                         |          759 |
| WDC WD3200AAJS                         |          891 |
| WDC WD3200BEKT                         |          782 |
| WDC WD3200BEKX                         |         1787 |
| WDC WD40EFRX                           |         3106 |
| WDC WD5000BPKT                         |         7634 |
| WDC WD5000LPCX                         |         4874 |
| WDC WD5000LPVX                         |       149438 |
| WDC WD5002ABYS                         |         1916 |
| WDC WD60EFRX                           |        41381 |
| WDC WD800AAJB                          |         4355 |
| WDC WD800AAJS                          |        11373 |
| WDC WUH721414ALE6L4                    |        20872 |
| WDC WUH721816ALE6L0                    |         1317 |
| WDC WUH721816ALE6L4                    |         1518 |
+----------------------------------------+--------------+
100 rows in set (1 min 0.88 sec)

193 from 92 models

mysql> select model, count(model) from drive_stats where smart_193_raw is not null group by model;
+-------------------------+--------------+
| model                   | count(model) |
+-------------------------+--------------+
| HGST HDS5C4040ALE630    |         2043 |
| HGST HDS724040ALE640    |          990 |
| HGST HMS5C4040ALE640    |       225725 |
| HGST HMS5C4040BLE640    |       405960 |
| HGST HUH721212ALE600    |        12251 |
| HGST HUH721212ALE604    |        49075 |
| HGST HUH721212ALN604    |       269458 |
| HGST HUH728080ALE600    |        42971 |
| HGST HUH728080ALE604    |          744 |
| HGST HUS726040ALE610    |         5776 |
| Hitachi HDS5C3030ALA630 |        74609 |
| Hitachi HDS5C4040ALE630 |        34168 |
| Hitachi HDS722020ALA330 |        95505 |
| Hitachi HDS723020BLA642 |          649 |
| Hitachi HDS723030ALA640 |        36192 |
| Hitachi HDS723030BLE640 |          558 |
| ST10000NM001G           |          602 |
| ST10000NM0086           |       169692 |
| ST12000NM0007           |      1082500 |
| ST12000NM0008           |       630153 |
| ST12000NM001G           |       116200 |
| ST12000NM0117           |          613 |
| ST14000NM0018           |         1863 |
| ST14000NM001G           |       123595 |
| ST14000NM0138           |        81304 |
| ST1500DL003             |         8910 |
| ST16000NM001G           |        70465 |
| ST16000NM002J           |           84 |
| ST18000NM000J           |         1756 |
| ST2000DL001             |          286 |
| ST2000DL003             |          168 |
| ST2000DM001             |           98 |
| ST2000VN000             |          874 |
| ST250LT007              |         3367 |
| ST3000DM001             |       237085 |
| ST320LT007              |        61957 |
| ST33000651AS            |         3626 |
| ST4000DM000             |      6030527 |
| ST4000DM001             |         2552 |
| ST4000DM004             |          322 |
| ST4000DM005             |         5942 |
| ST4000DX000             |        78285 |
| ST4000DX002             |         1153 |
| ST500LM021              |         3964 |
| ST500LM030              |        62417 |
| ST6000DX000             |        88951 |
| ST8000DM002             |      1075431 |
| ST8000DM004             |         2822 |
| ST8000DM005             |          329 |
| ST8000NM0055            |      1550554 |
| ST9250315AS             |        16079 |
| ST9320325AS             |         2325 |
| TOSHIBA DT01ACA300      |         2192 |
| TOSHIBA HDWF180         |         3262 |
| TOSHIBA MD04ABA400V     |        14496 |
| TOSHIBA MD04ABA500V     |          443 |
| TOSHIBA MG07ACA14TA     |       520136 |
| TOSHIBA MG07ACA14TEY    |         4412 |
| TOSHIBA MG08ACA16TA     |         5718 |
| TOSHIBA MG08ACA16TE     |        23669 |
| TOSHIBA MG08ACA16TEY    |         9396 |
| TOSHIBA MQ01ABF050      |       358938 |
| TOSHIBA MQ01ABF050M     |       219765 |
| WDC  WUH721414ALE6L4    |          305 |
| WDC  WUH721816ALE6L0    |           34 |
| WDC  WUH721816ALE6L4    |            8 |
| WDC WD10EACS            |         1315 |
| WDC WD10EADS            |        16271 |
| WDC WD10EADX            |          996 |
| WDC WD1600AAJB          |         3745 |
| WDC WD1600AAJS          |        14771 |
| WDC WD1600BPVT          |         2494 |
| WDC WD20EFRX            |         3639 |
| WDC WD2500AAJB          |          279 |
| WDC WD2500AAJS          |         1778 |
| WDC WD2500BPVT          |          289 |
| WDC WD30EFRX            |        58856 |
| WDC WD3200AAJB          |          759 |
| WDC WD3200AAJS          |          891 |
| WDC WD3200BEKT          |          782 |
| WDC WD3200BEKX          |         1787 |
| WDC WD40EFRX            |         3106 |
| WDC WD5000BPKT          |         7634 |
| WDC WD5000LPCX          |         4874 |
| WDC WD5000LPVX          |       149438 |
| WDC WD5002ABYS          |         1916 |
| WDC WD60EFRX            |        41381 |
| WDC WD800AAJB           |         4355 |
| WDC WD800AAJS           |        11373 |
| WDC WUH721414ALE6L4     |        20872 |
| WDC WUH721816ALE6L0     |         1317 |
| WDC WUH721816ALE6L4     |         1518 |
+-------------------------+--------------+
92 rows in set (1 min 4.29 sec)

194 from all but one (Samsung SSD 850 EVO 1TB)

mysql> select model, count(model) from drive_stats where smart_194_raw is not null group by model;

+----------------------------------------+--------------+
| model                                  | count(model) |
+----------------------------------------+--------------+
| CT250MX500SSD1                         |         1532 |
| HGST HDS5C4040ALE630                   |         2043 |
| HGST HDS724040ALE640                   |         1224 |
| HGST HMS5C4040ALE640                   |       225732 |
| HGST HMS5C4040BLE640                   |       405960 |
| HGST HUH721212ALE600                   |        12251 |
| HGST HUH721212ALE604                   |        49075 |
| HGST HUH721212ALN604                   |       269458 |
| HGST HUH728080ALE600                   |        42971 |
| HGST HUH728080ALE604                   |          744 |
| HGST HUS726040ALE610                   |         5776 |
| Hitachi HDS5C3030ALA630                |       107608 |
| Hitachi HDS5C4040ALE630                |        51121 |
| Hitachi HDS722020ALA330                |       150211 |
| Hitachi HDS723020BLA642                |         1011 |
| Hitachi HDS723030ALA640                |        53008 |
| Hitachi HDS723030BLE640                |          812 |
| HP SSD S700 250GB                      |         4896 |
| MTFDDAV240TCB                          |         3036 |
| MTFDDAV240TDU                          |          273 |
| SAMSUNG HD154UI                        |          188 |
| Seagate BarraCuda 120 SSD ZA250CM10003 |         6155 |
| Seagate BarraCuda SSD ZA2000CM10002    |          912 |
| Seagate BarraCuda SSD ZA250CM10002     |        13982 |
| Seagate BarraCuda SSD ZA500CM10002     |         1487 |
| Seagate SSD                            |         2099 |
| SSDSCKKB480G8R                         |           19 |
| ST10000NM001G                          |          602 |
| ST10000NM0086                          |       169692 |
| ST12000NM0007                          |      1082500 |
| ST12000NM0008                          |       630153 |
| ST12000NM001G                          |       116200 |
| ST12000NM0117                          |          613 |
| ST14000NM0018                          |         1863 |
| ST14000NM001G                          |       123595 |
| ST14000NM0138                          |        81304 |
| ST1500DL003                            |        20764 |
| ST16000NM001G                          |        70465 |
| ST16000NM002J                          |           84 |
| ST18000NM000J                          |         1756 |
| ST2000DL001                            |          646 |
| ST2000DL003                            |          659 |
| ST2000DM001                            |          352 |
| ST2000VN000                            |         1144 |
| ST250LM004 HN                          |        10855 |
| ST250LT007                             |         3367 |
| ST3000DM001                            |       634617 |
| ST31500341AS                           |        62501 |
| ST31500541AS                           |       143030 |
| ST3160316AS                            |        10818 |
| ST3160318AS                            |        13426 |
| ST32000542AS                           |         7072 |
| ST320005XXXX                           |         1972 |
| ST320LT007                             |        61957 |
| ST33000651AS                           |         9423 |
| ST3500320AS                            |          992 |
| ST4000DM000                            |      6148224 |
| ST4000DM001                            |         2552 |
| ST4000DM004                            |          322 |
| ST4000DM005                            |         5942 |
| ST4000DX000                            |        96280 |
| ST4000DX002                            |         1153 |
| ST500LM012 HN                          |       359396 |
| ST500LM021                             |         3964 |
| ST500LM030                             |        62417 |
| ST6000DX000                            |        88951 |
| ST8000DM002                            |      1075431 |
| ST8000DM004                            |         2822 |
| ST8000DM005                            |          329 |
| ST8000NM0055                           |      1550554 |
| ST9250315AS                            |        16079 |
| ST9320325AS                            |         2325 |
| TOSHIBA DT01ACA300                     |         3478 |
| TOSHIBA HDWF180                        |         3262 |
| TOSHIBA MD04ABA400V                    |        14496 |
| TOSHIBA MD04ABA500V                    |          443 |
| TOSHIBA MG07ACA14TA                    |       520136 |
| TOSHIBA MG07ACA14TEY                   |         4412 |
| TOSHIBA MG08ACA16TA                    |         5718 |
| TOSHIBA MG08ACA16TE                    |        23669 |
| TOSHIBA MG08ACA16TEY                   |         9396 |
| TOSHIBA MQ01ABF050                     |       358938 |
| TOSHIBA MQ01ABF050M                    |       219765 |
| WD Blue SA510 2.5 250GB                |           20 |
| WDC  WDS250G2B0A                       |            5 |
| WDC  WUH721414ALE6L4                   |          305 |
| WDC  WUH721816ALE6L0                   |           34 |
| WDC  WUH721816ALE6L4                   |            8 |
| WDC WD10EACS                           |         2983 |
| WDC WD10EADS                           |        29248 |
| WDC WD10EADX                           |         1533 |
| WDC WD1600AAJB                         |         3745 |
| WDC WD1600AAJS                         |        13841 |
| WDC WD1600BPVT                         |         2494 |
| WDC WD20EFRX                           |         3639 |
| WDC WD2500AAJB                         |          279 |
| WDC WD2500AAJS                         |         1778 |
| WDC WD2500BPVT                         |          289 |
| WDC WD2500JB                           |           39 |
| WDC WD30EFRX                           |        64614 |
| WDC WD30EZRS                           |          419 |
| WDC WD30EZRX                           |         3799 |
| WDC WD3200AAJB                         |          759 |
| WDC WD3200AAJS                         |          891 |
| WDC WD3200BEKT                         |          782 |
| WDC WD3200BEKX                         |         1787 |
| WDC WD40EFRX                           |         3106 |
| WDC WD5000BPKT                         |         7634 |
| WDC WD5000LPCX                         |         4874 |
| WDC WD5000LPVX                         |       149438 |
| WDC WD5002ABYS                         |         1916 |
| WDC WD60EFRX                           |        41381 |
| WDC WD800AAJB                          |         4355 |
| WDC WD800AAJS                          |        11373 |
| WDC WD800BB                            |         5887 |
| WDC WD800JB                            |         4758 |
| WDC WD800JD                            |          763 |
| WDC WD800LB                            |          759 |
| WDC WDS250G2B0A                        |          525 |
| WDC WUH721414ALE6L4                    |        20872 |
| WDC WUH721816ALE6L0                    |         1317 |
| WDC WUH721816ALE6L4                    |         1518 |
+----------------------------------------+--------------+
122 rows in set (1 min 2.31 sec)

195 from 39 models

mysql> select model, count(model) from drive_stats where smart_195_raw is not null group by model;
+-------------------------+--------------+
| model                   | count(model) |
+-------------------------+--------------+
| HP SSD S700 250GB       |         4896 |
| MTFDDAV240TCB           |         3036 |
| MTFDDAV240TDU           |          273 |
| SAMSUNG HD154UI         |           40 |
| Samsung SSD 850 EVO 1TB |          234 |
| SSDSCKKB480G8R          |           19 |
| ST10000NM0086           |       169692 |
| ST12000NM0007           |      1082500 |
| ST12000NM0008           |       630153 |
| ST12000NM0117           |          613 |
| ST14000NM0018           |         1863 |
| ST14000NM0138           |        81304 |
| ST1500DL003             |         8910 |
| ST2000DL001             |          286 |
| ST2000DL003             |          168 |
| ST250LM004 HN           |        10855 |
| ST250LT007              |         3367 |
| ST3000DM001             |         6710 |
| ST31500341AS            |        23987 |
| ST31500541AS            |        65257 |
| ST3160316AS             |        10818 |
| ST3160318AS             |        13426 |
| ST32000542AS            |         2332 |
| ST320005XXXX            |          511 |
| ST320LT007              |        61957 |
| ST33000651AS            |         3626 |
| ST3500320AS             |          992 |
| ST4000DM001             |         2552 |
| ST4000DM004             |          322 |
| ST4000DX000             |        78285 |
| ST4000DX002             |         1153 |
| ST500LM012 HN           |       359396 |
| ST6000DX000             |        88951 |
| ST8000DM002             |      1075431 |
| ST8000DM004             |         2822 |
| ST8000DM005             |          329 |
| ST8000NM0055            |      1550554 |
| ST9250315AS             |        16079 |
| ST9320325AS             |         2325 |
+-------------------------+--------------+
39 rows in set (54.54 sec)

196 from 67 models

mysql> select model, count(model) from drive_stats where smart_196_raw is not null group by model;
+-------------------------+--------------+
| model                   | count(model) |
+-------------------------+--------------+
| CT250MX500SSD1          |         1532 |
| HGST HDS5C4040ALE630    |         2043 |
| HGST HDS724040ALE640    |          990 |
| HGST HMS5C4040ALE640    |       225725 |
| HGST HMS5C4040BLE640    |       405960 |
| HGST HUH721212ALE600    |        12251 |
| HGST HUH721212ALE604    |        49075 |
| HGST HUH721212ALN604    |       269458 |
| HGST HUH728080ALE600    |        42971 |
| HGST HUH728080ALE604    |          744 |
| HGST HUS726040ALE610    |         5776 |
| Hitachi HDS5C3030ALA630 |        74609 |
| Hitachi HDS5C4040ALE630 |        34168 |
| Hitachi HDS722020ALA330 |        95505 |
| Hitachi HDS723020BLA642 |          649 |
| Hitachi HDS723030ALA640 |        36192 |
| Hitachi HDS723030BLE640 |          558 |
| HP SSD S700 250GB       |         4896 |
| MTFDDAV240TDU           |          273 |
| SAMSUNG HD154UI         |           40 |
| ST250LM004 HN           |        10855 |
| ST500LM012 HN           |       359396 |
| TOSHIBA DT01ACA300      |         2192 |
| TOSHIBA HDWF180         |         3262 |
| TOSHIBA MD04ABA400V     |        14496 |
| TOSHIBA MD04ABA500V     |          443 |
| TOSHIBA MG07ACA14TA     |       520136 |
| TOSHIBA MG07ACA14TEY    |         4412 |
| TOSHIBA MG08ACA16TA     |         5718 |
| TOSHIBA MG08ACA16TE     |        23669 |
| TOSHIBA MG08ACA16TEY    |         9396 |
| TOSHIBA MQ01ABF050      |       358938 |
| TOSHIBA MQ01ABF050M     |       219765 |
| WDC  WUH721414ALE6L4    |          305 |
| WDC  WUH721816ALE6L0    |           34 |
| WDC  WUH721816ALE6L4    |            8 |
| WDC WD10EACS            |         1315 |
| WDC WD10EADS            |        16271 |
| WDC WD10EADX            |          996 |
| WDC WD1600AAJB          |         3745 |
| WDC WD1600AAJS          |        14771 |
| WDC WD1600BPVT          |         2494 |
| WDC WD20EFRX            |         3639 |
| WDC WD2500AAJB          |          279 |
| WDC WD2500AAJS          |         1778 |
| WDC WD2500BPVT          |          289 |
| WDC WD2500JB            |           39 |
| WDC WD30EFRX            |        58856 |
| WDC WD3200AAJB          |          759 |
| WDC WD3200AAJS          |          891 |
| WDC WD3200BEKT          |          782 |
| WDC WD3200BEKX          |         1787 |
| WDC WD40EFRX            |         3106 |
| WDC WD5000BPKT          |         7634 |
| WDC WD5000LPCX          |         4874 |
| WDC WD5000LPVX          |       149438 |
| WDC WD5002ABYS          |         1916 |
| WDC WD60EFRX            |        41381 |
| WDC WD800AAJB           |         4355 |
| WDC WD800AAJS           |        11373 |
| WDC WD800BB             |         5887 |
| WDC WD800JB             |         4758 |
| WDC WD800JD             |          763 |
| WDC WD800LB             |          759 |
| WDC WUH721414ALE6L4     |        20872 |
| WDC WUH721816ALE6L0     |         1317 |
| WDC WUH721816ALE6L4     |         1518 |
+-------------------------+--------------+
67 rows in set (52.73 sec)

197 from 110 models

mysql> select model, count(model) from drive_stats where smart_197_raw is not null group by model;

+-------------------------+--------------+
| model                   | count(model) |
+-------------------------+--------------+
| CT250MX500SSD1          |         1532 |
| HGST HDS5C4040ALE630    |         2043 |
| HGST HDS724040ALE640    |         1224 |
| HGST HMS5C4040ALE640    |       225732 |
| HGST HMS5C4040BLE640    |       405960 |
| HGST HUH721212ALE600    |        12251 |
| HGST HUH721212ALE604    |        49075 |
| HGST HUH721212ALN604    |       269458 |
| HGST HUH728080ALE600    |        42971 |
| HGST HUH728080ALE604    |          744 |
| HGST HUS726040ALE610    |         5776 |
| Hitachi HDS5C3030ALA630 |       107608 |
| Hitachi HDS5C4040ALE630 |        51121 |
| Hitachi HDS722020ALA330 |       150211 |
| Hitachi HDS723020BLA642 |         1011 |
| Hitachi HDS723030ALA640 |        53008 |
| Hitachi HDS723030BLE640 |          812 |
| HP SSD S700 250GB       |         4896 |
| SAMSUNG HD154UI         |          188 |
| SSDSCKKB480G8R          |           19 |
| ST10000NM001G           |          602 |
| ST10000NM0086           |       169692 |
| ST12000NM0007           |      1082500 |
| ST12000NM0008           |       630153 |
| ST12000NM001G           |       116200 |
| ST12000NM0117           |          613 |
| ST14000NM0018           |         1863 |
| ST14000NM001G           |       123595 |
| ST14000NM0138           |        81304 |
| ST1500DL003             |        20764 |
| ST16000NM001G           |        70465 |
| ST16000NM002J           |           84 |
| ST18000NM000J           |         1756 |
| ST2000DL001             |          646 |
| ST2000DL003             |          659 |
| ST2000DM001             |          352 |
| ST2000VN000             |         1144 |
| ST250LM004 HN           |        10855 |
| ST250LT007              |         3367 |
| ST3000DM001             |       634617 |
| ST31500341AS            |        62501 |
| ST31500541AS            |       143030 |
| ST3160316AS             |        10818 |
| ST3160318AS             |        13426 |
| ST32000542AS            |         7072 |
| ST320005XXXX            |         1972 |
| ST320LT007              |        61957 |
| ST33000651AS            |         9423 |
| ST3500320AS             |          992 |
| ST4000DM000             |      6148224 |
| ST4000DM001             |         2552 |
| ST4000DM004             |          322 |
| ST4000DM005             |         5942 |
| ST4000DX000             |        96280 |
| ST4000DX002             |         1153 |
| ST500LM012 HN           |       359396 |
| ST500LM021              |         3964 |
| ST500LM030              |        62417 |
| ST6000DX000             |        88951 |
| ST8000DM002             |      1075431 |
| ST8000DM004             |         2822 |
| ST8000DM005             |          329 |
| ST8000NM0055            |      1550554 |
| ST9250315AS             |        16079 |
| ST9320325AS             |         2325 |
| TOSHIBA DT01ACA300      |         3478 |
| TOSHIBA HDWF180         |         3262 |
| TOSHIBA MD04ABA400V     |        14496 |
| TOSHIBA MD04ABA500V     |          443 |
| TOSHIBA MG07ACA14TA     |       520136 |
| TOSHIBA MG08ACA16TA     |         5718 |
| TOSHIBA MG08ACA16TE     |        23669 |
| TOSHIBA MQ01ABF050      |       358938 |
| TOSHIBA MQ01ABF050M     |       219765 |
| WDC  WUH721414ALE6L4    |          305 |
| WDC  WUH721816ALE6L0    |           34 |
| WDC  WUH721816ALE6L4    |            8 |
| WDC WD10EACS            |         2983 |
| WDC WD10EADS            |        29248 |
| WDC WD10EADX            |         1533 |
| WDC WD1600AAJB          |         3745 |
| WDC WD1600AAJS          |        14771 |
| WDC WD1600BPVT          |         2494 |
| WDC WD20EFRX            |         3639 |
| WDC WD2500AAJB          |          279 |
| WDC WD2500AAJS          |         1778 |
| WDC WD2500BPVT          |          289 |
| WDC WD2500JB            |           39 |
| WDC WD30EFRX            |        64614 |
| WDC WD30EZRS            |          419 |
| WDC WD30EZRX            |         3799 |
| WDC WD3200AAJB          |          759 |
| WDC WD3200AAJS          |          891 |
| WDC WD3200BEKT          |          782 |
| WDC WD3200BEKX          |         1787 |
| WDC WD40EFRX            |         3106 |
| WDC WD5000BPKT          |         7634 |
| WDC WD5000LPCX          |         4874 |
| WDC WD5000LPVX          |       149438 |
| WDC WD5002ABYS          |         1916 |
| WDC WD60EFRX            |        41381 |
| WDC WD800AAJB           |         4355 |
| WDC WD800AAJS           |        11373 |
| WDC WD800BB             |         5887 |
| WDC WD800JB             |         4758 |
| WDC WD800JD             |          763 |
| WDC WD800LB             |          759 |
| WDC WUH721414ALE6L4     |        20872 |
| WDC WUH721816ALE6L0     |         1317 |
| WDC WUH721816ALE6L4     |         1518 |
+-------------------------+--------------+
110 rows in set (55.72 sec)

198 from 112 models

mysql> select model, count(model) from drive_stats where smart_198_raw is not null group by model;
+-------------------------+--------------+
| model                   | count(model) |
+-------------------------+--------------+
| CT250MX500SSD1          |         1532 |
| HGST HDS5C4040ALE630    |         2043 |
| HGST HDS724040ALE640    |          990 |
| HGST HMS5C4040ALE640    |       225725 |
| HGST HMS5C4040BLE640    |       405960 |
| HGST HUH721212ALE600    |        12251 |
| HGST HUH721212ALE604    |        49075 |
| HGST HUH721212ALN604    |       269458 |
| HGST HUH728080ALE600    |        42971 |
| HGST HUH728080ALE604    |          744 |
| HGST HUS726040ALE610    |         5776 |
| Hitachi HDS5C3030ALA630 |        74609 |
| Hitachi HDS5C4040ALE630 |        34168 |
| Hitachi HDS722020ALA330 |        95505 |
| Hitachi HDS723020BLA642 |          649 |
| Hitachi HDS723030ALA640 |        36192 |
| Hitachi HDS723030BLE640 |          558 |
| HP SSD S700 250GB       |         4896 |
| MTFDDAV240TCB           |         3036 |
| MTFDDAV240TDU           |          273 |
| SAMSUNG HD154UI         |           40 |
| SSDSCKKB480G8R          |           19 |
| ST10000NM001G           |          602 |
| ST10000NM0086           |       169692 |
| ST12000NM0007           |      1082500 |
| ST12000NM0008           |       630153 |
| ST12000NM001G           |       116200 |
| ST12000NM0117           |          613 |
| ST14000NM0018           |         1863 |
| ST14000NM001G           |       123595 |
| ST14000NM0138           |        81304 |
| ST1500DL003             |         8910 |
| ST16000NM001G           |        70465 |
| ST16000NM002J           |           84 |
| ST18000NM000J           |         1756 |
| ST2000DL001             |          286 |
| ST2000DL003             |          168 |
| ST2000DM001             |           98 |
| ST2000VN000             |          874 |
| ST250LM004 HN           |        10855 |
| ST250LT007              |         3367 |
| ST3000DM001             |       237085 |
| ST31500341AS            |        23987 |
| ST31500541AS            |        65257 |
| ST3160316AS             |        10818 |
| ST3160318AS             |        13426 |
| ST32000542AS            |         2332 |
| ST320005XXXX            |          511 |
| ST320LT007              |        61957 |
| ST33000651AS            |         3626 |
| ST3500320AS             |          992 |
| ST4000DM000             |      6030527 |
| ST4000DM001             |         2552 |
| ST4000DM004             |          322 |
| ST4000DM005             |         5942 |
| ST4000DX000             |        78285 |
| ST4000DX002             |         1153 |
| ST500LM012 HN           |       359396 |
| ST500LM021              |         3964 |
| ST500LM030              |        62417 |
| ST6000DX000             |        88951 |
| ST8000DM002             |      1075431 |
| ST8000DM004             |         2822 |
| ST8000DM005             |          329 |
| ST8000NM0055            |      1550554 |
| ST9250315AS             |        16079 |
| ST9320325AS             |         2325 |
| TOSHIBA DT01ACA300      |         2192 |
| TOSHIBA HDWF180         |         3262 |
| TOSHIBA MD04ABA400V     |        14496 |
| TOSHIBA MD04ABA500V     |          443 |
| TOSHIBA MG07ACA14TA     |       520136 |
| TOSHIBA MG07ACA14TEY    |         4412 |
| TOSHIBA MG08ACA16TA     |         5718 |
| TOSHIBA MG08ACA16TE     |        23669 |
| TOSHIBA MG08ACA16TEY    |         9396 |
| TOSHIBA MQ01ABF050      |       358938 |
| TOSHIBA MQ01ABF050M     |       219765 |
| WDC  WUH721414ALE6L4    |          305 |
| WDC  WUH721816ALE6L0    |           34 |
| WDC  WUH721816ALE6L4    |            8 |
| WDC WD10EACS            |         1315 |
| WDC WD10EADS            |        16271 |
| WDC WD10EADX            |          996 |
| WDC WD1600AAJB          |         3745 |
| WDC WD1600AAJS          |        14771 |
| WDC WD1600BPVT          |         2494 |
| WDC WD20EFRX            |         3639 |
| WDC WD2500AAJB          |          279 |
| WDC WD2500AAJS          |         1778 |
| WDC WD2500BPVT          |          289 |
| WDC WD2500JB            |           39 |
| WDC WD30EFRX            |        58856 |
| WDC WD3200AAJB          |          759 |
| WDC WD3200AAJS          |          891 |
| WDC WD3200BEKT          |          782 |
| WDC WD3200BEKX          |         1787 |
| WDC WD40EFRX            |         3106 |
| WDC WD5000BPKT          |         7634 |
| WDC WD5000LPCX          |         4874 |
| WDC WD5000LPVX          |       149438 |
| WDC WD5002ABYS          |         1916 |
| WDC WD60EFRX            |        41381 |
| WDC WD800AAJB           |         4355 |
| WDC WD800AAJS           |        11373 |
| WDC WD800BB             |         5887 |
| WDC WD800JB             |         4758 |
| WDC WD800JD             |          763 |
| WDC WD800LB             |          759 |
| WDC WUH721414ALE6L4     |        20872 |
| WDC WUH721816ALE6L0     |         1317 |
| WDC WUH721816ALE6L4     |         1518 |
+-------------------------+--------------+
112 rows in set (56.90 sec)

199 from 116 models

mysql> select model, count(model) from drive_stats where smart_199_raw is not null group by model;
+-------------------------+--------------+
| model                   | count(model) |
+-------------------------+--------------+
| CT250MX500SSD1          |         1532 |
| HGST HDS5C4040ALE630    |         2043 |
| HGST HDS724040ALE640    |          990 |
| HGST HMS5C4040ALE640    |       225725 |
| HGST HMS5C4040BLE640    |       405960 |
| HGST HUH721212ALE600    |        12251 |
| HGST HUH721212ALE604    |        49075 |
| HGST HUH721212ALN604    |       269458 |
| HGST HUH728080ALE600    |        42971 |
| HGST HUH728080ALE604    |          744 |
| HGST HUS726040ALE610    |         5776 |
| Hitachi HDS5C3030ALA630 |        74609 |
| Hitachi HDS5C4040ALE630 |        34168 |
| Hitachi HDS722020ALA330 |        95505 |
| Hitachi HDS723020BLA642 |          649 |
| Hitachi HDS723030ALA640 |        36192 |
| Hitachi HDS723030BLE640 |          558 |
| HP SSD S700 250GB       |         4896 |
| MTFDDAV240TCB           |         3036 |
| MTFDDAV240TDU           |          273 |
| SAMSUNG HD154UI         |           40 |
| Samsung SSD 850 EVO 1TB |          234 |
| SSDSCKKB480G8R          |           19 |
| ST10000NM001G           |          602 |
| ST10000NM0086           |       169692 |
| ST12000NM0007           |      1082500 |
| ST12000NM0008           |       630153 |
| ST12000NM001G           |       116200 |
| ST12000NM0117           |          613 |
| ST14000NM0018           |         1863 |
| ST14000NM001G           |       123595 |
| ST14000NM0138           |        81304 |
| ST1500DL003             |         8910 |
| ST16000NM001G           |        70465 |
| ST16000NM002J           |           84 |
| ST18000NM000J           |         1756 |
| ST2000DL001             |          286 |
| ST2000DL003             |          168 |
| ST2000DM001             |           98 |
| ST2000VN000             |          874 |
| ST250LM004 HN           |        10855 |
| ST250LT007              |         3367 |
| ST3000DM001             |       237085 |
| ST31500341AS            |        23987 |
| ST31500541AS            |        65257 |
| ST3160316AS             |        10818 |
| ST3160318AS             |        13426 |
| ST32000542AS            |         2332 |
| ST320005XXXX            |          511 |
| ST320LT007              |        61957 |
| ST33000651AS            |         3626 |
| ST3500320AS             |          992 |
| ST4000DM000             |      6030527 |
| ST4000DM001             |         2552 |
| ST4000DM004             |          322 |
| ST4000DM005             |         5942 |
| ST4000DX000             |        78285 |
| ST4000DX002             |         1153 |
| ST500LM012 HN           |       359396 |
| ST500LM021              |         3964 |
| ST500LM030              |        62417 |
| ST6000DX000             |        88951 |
| ST8000DM002             |      1075431 |
| ST8000DM004             |         2822 |
| ST8000DM005             |          329 |
| ST8000NM0055            |      1550554 |
| ST9250315AS             |        16079 |
| ST9320325AS             |         2325 |
| TOSHIBA DT01ACA300      |         2192 |
| TOSHIBA HDWF180         |         3262 |
| TOSHIBA MD04ABA400V     |        14496 |
| TOSHIBA MD04ABA500V     |          443 |
| TOSHIBA MG07ACA14TA     |       520136 |
| TOSHIBA MG07ACA14TEY    |         4412 |
| TOSHIBA MG08ACA16TA     |         5718 |
| TOSHIBA MG08ACA16TE     |        23669 |
| TOSHIBA MG08ACA16TEY    |         9396 |
| TOSHIBA MQ01ABF050      |       358938 |
| TOSHIBA MQ01ABF050M     |       219765 |
| WD Blue SA510 2.5 250GB |           20 |
| WDC  WDS250G2B0A        |            5 |
| WDC  WUH721414ALE6L4    |          305 |
| WDC  WUH721816ALE6L0    |           34 |
| WDC  WUH721816ALE6L4    |            8 |
| WDC WD10EACS            |         1315 |
| WDC WD10EADS            |        16271 |
| WDC WD10EADX            |          996 |
| WDC WD1600AAJB          |         3745 |
| WDC WD1600AAJS          |        14771 |
| WDC WD1600BPVT          |         2494 |
| WDC WD20EFRX            |         3639 |
| WDC WD2500AAJB          |          279 |
| WDC WD2500AAJS          |         1778 |
| WDC WD2500BPVT          |          289 |
| WDC WD2500JB            |           39 |
| WDC WD30EFRX            |        58856 |
| WDC WD3200AAJB          |          759 |
| WDC WD3200AAJS          |          891 |
| WDC WD3200BEKT          |          782 |
| WDC WD3200BEKX          |         1787 |
| WDC WD40EFRX            |         3106 |
| WDC WD5000BPKT          |         7634 |
| WDC WD5000LPCX          |         4874 |
| WDC WD5000LPVX          |       149438 |
| WDC WD5002ABYS          |         1916 |
| WDC WD60EFRX            |        41381 |
| WDC WD800AAJB           |         4355 |
| WDC WD800AAJS           |        11373 |
| WDC WD800BB             |         5887 |
| WDC WD800JB             |         4758 |
| WDC WD800JD             |          763 |
| WDC WD800LB             |          759 |
| WDC WDS250G2B0A         |          525 |
| WDC WUH721414ALE6L4     |        20872 |
| WDC WUH721816ALE6L0     |         1317 |
| WDC WUH721816ALE6L4     |         1518 |
+-------------------------+--------------+
116 rows in set (1 min 1.33 sec)

200 from 43 models

mysql> select model, count(model) from drive_stats where smart_200_raw is not null group by model;
+-----------------+--------------+
| model           | count(model) |
+-----------------+--------------+
| SAMSUNG HD154UI |           40 |
| ST10000NM001G   |          602 |
| ST10000NM0086   |       169692 |
| ST12000NM0007   |      1082500 |
| ST12000NM0008   |       630153 |
| ST12000NM001G   |       116200 |
| ST12000NM0117   |          613 |
| ST14000NM0018   |         1863 |
| ST14000NM001G   |       123595 |
| ST14000NM0138   |        81304 |
| ST16000NM001G   |        70465 |
| ST16000NM002J   |           84 |
| ST18000NM000J   |         1756 |
| ST250LM004 HN   |        10855 |
| ST500LM012 HN   |       359396 |
| WDC WD10EACS    |         1315 |
| WDC WD10EADS    |        16271 |
| WDC WD10EADX    |          996 |
| WDC WD1600AAJB  |         3745 |
| WDC WD1600AAJS  |        14771 |
| WDC WD1600BPVT  |         2494 |
| WDC WD20EFRX    |         3639 |
| WDC WD2500AAJB  |          279 |
| WDC WD2500AAJS  |         1778 |
| WDC WD2500BPVT  |          289 |
| WDC WD2500JB    |           39 |
| WDC WD30EFRX    |        58856 |
| WDC WD3200AAJB  |          759 |
| WDC WD3200AAJS  |          891 |
| WDC WD3200BEKT  |          782 |
| WDC WD3200BEKX  |         1787 |
| WDC WD40EFRX    |         3106 |
| WDC WD5000BPKT  |         7634 |
| WDC WD5000LPCX  |         4874 |
| WDC WD5000LPVX  |       149438 |
| WDC WD5002ABYS  |         1916 |
| WDC WD60EFRX    |        41381 |
| WDC WD800AAJB   |         4355 |
| WDC WD800AAJS   |        11373 |
| WDC WD800BB     |         5887 |
| WDC WD800JB     |         4758 |
| WDC WD800JD     |          763 |
| WDC WD800LB     |          759 |
+-----------------+--------------+
43 rows in set (1 min 0.52 sec)

234 from 5 ssds

select model, count(model) from drive_stats where smart_234_raw is not null group by model;

+----------------------------------------+--------------+
| model                                  | count(model) |
+----------------------------------------+--------------+
| Seagate BarraCuda 120 SSD ZA250CM10003 |         1575 |
| SSDSCKKB480G8R                         |           19 |
| WD Blue SA510 2.5 250GB                |           20 |
| WDC  WDS250G2B0A                       |            5 |
| WDC WDS250G2B0A                        |          525 |
+----------------------------------------+--------------+
5 rows in set (56.00 sec)

235 from 8 ssds

mysql> select model, count(model) from drive_stats where smart_235_raw is not null group by model;

+----------------------------------------+--------------+
| model                                  | count(model) |
+----------------------------------------+--------------+
| MTFDDAV240TDU                          |          273 |
| Samsung SSD 850 EVO 1TB                |          234 |
| Seagate BarraCuda 120 SSD ZA250CM10003 |         6155 |
| Seagate BarraCuda SSD ZA2000CM10002    |          912 |
| Seagate BarraCuda SSD ZA250CM10002     |        13982 |
| Seagate BarraCuda SSD ZA500CM10002     |         1487 |
| Seagate SSD                            |         2099 |
| SSDSCKKB480G8R                         |           19 |
+----------------------------------------+--------------+
8 rows in set (59.75 sec)

240 from 50 models

mysql> select model, count(model) from drive_stats where smart_240_raw is not null group by model;
+---------------------+--------------+
| model               | count(model) |
+---------------------+--------------+
| ST10000NM001G       |          602 |
| ST10000NM0086       |       169692 |
| ST12000NM0007       |      1082500 |
| ST12000NM0008       |       630153 |
| ST12000NM001G       |       116200 |
| ST12000NM0117       |          613 |
| ST14000NM0018       |         1863 |
| ST14000NM001G       |       123595 |
| ST14000NM0138       |        81304 |
| ST1500DL003         |         8910 |
| ST16000NM001G       |        70465 |
| ST16000NM002J       |           84 |
| ST18000NM000J       |         1756 |
| ST2000DL001         |          286 |
| ST2000DL003         |          168 |
| ST2000DM001         |           98 |
| ST250LT007          |         3367 |
| ST3000DM001         |       237085 |
| ST31500341AS        |        23987 |
| ST31500541AS        |        65257 |
| ST3160316AS         |        10818 |
| ST3160318AS         |        13426 |
| ST32000542AS        |         2332 |
| ST320005XXXX        |          511 |
| ST320LT007          |        61957 |
| ST33000651AS        |         3626 |
| ST4000DM000         |      6030527 |
| ST4000DM001         |         2552 |
| ST4000DM004         |          322 |
| ST4000DM005         |         5942 |
| ST4000DX000         |        78285 |
| ST4000DX002         |         1153 |
| ST500LM021          |         3964 |
| ST500LM030          |        62417 |
| ST6000DX000         |        88951 |
| ST8000DM002         |      1075431 |
| ST8000DM004         |         2822 |
| ST8000DM005         |          329 |
| ST8000NM0055        |      1550554 |
| TOSHIBA HDWF180     |         3262 |
| TOSHIBA MD04ABA400V |        14496 |
| TOSHIBA MD04ABA500V |          443 |
| TOSHIBA MG07ACA14TA |       520136 |
| TOSHIBA MG08ACA16TA |         5718 |
| TOSHIBA MG08ACA16TE |        23669 |
| TOSHIBA MQ01ABF050  |       358938 |
| TOSHIBA MQ01ABF050M |       219765 |
| WDC WD3200BEKT      |          782 |
| WDC WD5000BPKT      |         7634 |
| WDC WD5000LPVX      |        39506 |
+---------------------+--------------+
50 rows in set (1 min 1.95 sec)

241 from 58 models

mysql> select model, count(model) from drive_stats where smart_241_raw is not null group by model;

+----------------------------------------+--------------+
| model                                  | count(model) |
+----------------------------------------+--------------+
| HGST HUH721212ALE600                   |        12233 |
| HP SSD S700 250GB                      |         4896 |
| MTFDDAV240TDU                          |          273 |
| Samsung SSD 850 EVO 1TB                |          234 |
| Seagate BarraCuda 120 SSD ZA250CM10003 |         6155 |
| Seagate BarraCuda SSD ZA2000CM10002    |          912 |
| Seagate BarraCuda SSD ZA250CM10002     |        13982 |
| Seagate BarraCuda SSD ZA500CM10002     |         1487 |
| Seagate SSD                            |         2099 |
| SSDSCKKB480G8R                         |           19 |
| ST10000NM001G                          |          602 |
| ST10000NM0086                          |       169692 |
| ST12000NM0007                          |      1082500 |
| ST12000NM0008                          |       630153 |
| ST12000NM001G                          |       116200 |
| ST12000NM0117                          |          613 |
| ST14000NM0018                          |         1863 |
| ST14000NM001G                          |       123595 |
| ST14000NM0138                          |        81304 |
| ST1500DL003                            |         8910 |
| ST16000NM001G                          |        70465 |
| ST16000NM002J                          |           84 |
| ST18000NM000J                          |         1756 |
| ST2000DL001                            |          286 |
| ST2000DL003                            |          168 |
| ST2000DM001                            |           98 |
| ST250LT007                             |         3367 |
| ST3000DM001                            |       237085 |
| ST31500341AS                           |        23987 |
| ST31500541AS                           |        65257 |
| ST3160316AS                            |        10818 |
| ST3160318AS                            |        13426 |
| ST32000542AS                           |         2332 |
| ST320005XXXX                           |          511 |
| ST320LT007                             |        61957 |
| ST33000651AS                           |         3626 |
| ST4000DM000                            |      6030525 |
| ST4000DM001                            |         2552 |
| ST4000DM004                            |          322 |
| ST4000DM005                            |         5942 |
| ST4000DX000                            |        78285 |
| ST4000DX002                            |         1153 |
| ST500LM021                             |         3964 |
| ST500LM030                             |        62417 |
| ST6000DX000                            |        88951 |
| ST8000DM002                            |      1075431 |
| ST8000DM004                            |         2822 |
| ST8000DM005                            |          329 |
| ST8000NM0055                           |      1550554 |
| TOSHIBA MG07ACA14TEY                   |         4412 |
| TOSHIBA MG08ACA16TEY                   |         9396 |
| WD Blue SA510 2.5 250GB                |           20 |
| WDC  WDS250G2B0A                       |            5 |
| WDC  WUH721816ALE6L0                   |           34 |
| WDC WD3200BEKT                         |          782 |
| WDC WD5000BPKT                         |         7634 |
| WDC WDS250G2B0A                        |          525 |
| WDC WUH721816ALE6L0                    |         1317 |
+----------------------------------------+--------------+
58 rows in set (1 min 2.04 sec)

242 from 56 models

mysql> select model, count(model) from drive_stats where smart_242_raw is not null group by model; +----------------------------------------+--------------+ | model | count(model) | +----------------------------------------+--------------+ | HGST HUH721212ALE600 | 12233 | | HP SSD S700 250GB | 4896 | | Seagate BarraCuda 120 SSD ZA250CM10003 | 6155 | | Seagate BarraCuda SSD ZA2000CM10002 | 912 | | Seagate BarraCuda SSD ZA250CM10002 | 13982 | | Seagate BarraCuda SSD ZA500CM10002 | 1487 | | Seagate SSD | 2099 | | SSDSCKKB480G8R | 19 | | ST10000NM001G | 602 | | ST10000NM0086 | 169692 | | ST12000NM0007 | 1082500 | | ST12000NM0008 | 630153 | | ST12000NM001G | 116200 | | ST12000NM0117 | 613 | | ST14000NM0018 | 1863 | | ST14000NM001G | 123595 | | ST14000NM0138 | 81304 | | ST1500DL003 | 8910 | | ST16000NM001G | 70465 | | ST16000NM002J | 84 | | ST18000NM000J | 1756 | | ST2000DL001 | 286 | | ST2000DL003 | 168 | | ST2000DM001 | 98 | | ST250LT007 | 3367 | | ST3000DM001 | 237085 | | ST31500341AS | 23987 | | ST31500541AS | 65257 | | ST3160316AS | 10818 | | ST3160318AS | 13426 | | ST32000542AS | 2332 | | ST320005XXXX | 511 | | ST320LT007 | 61957 | | ST33000651AS | 3626 | | ST4000DM000 | 6030525 | | ST4000DM001 | 2552 | | ST4000DM004 | 322 | | ST4000DM005 | 5942 | | ST4000DX000 | 78285 | | ST4000DX002 | 1153 | | ST500LM021 | 3964 | | ST500LM030 | 62417 | | ST6000DX000 | 88951 | | ST8000DM002 | 1075431 | | ST8000DM004 | 2822 | | ST8000DM005 | 329 | | ST8000NM0055 | 1550554 | | TOSHIBA MG07ACA14TEY | 4412 | | TOSHIBA MG08ACA16TEY | 9396 | | WD Blue SA510 2.5 250GB | 20 | | WDC WDS250G2B0A | 5 | | WDC WUH721816ALE6L0 | 34 | | WDC WD3200BEKT | 782 | | WDC WD5000BPKT | 7634 | | WDC WDS250G2B0A | 525 | | WDC WUH721816ALE6L0 | 1317 | +----------------------------------------+--------------+ 56 rows in set (56.33 sec) 245 from 4 ssds

mysql> select model, count(model) from drive_stats where smart_245_raw is not null group by model;
+-------------------+--------------+
| model             | count(model) |
+-------------------+--------------+
| HP SSD S700 250GB |         4896 |
| MTFDDAV240TCB     |         3036 |
| MTFDDAV240TDU     |          273 |
| SSDSCKKB480G8R    |           19 |
+-------------------+--------------+
4 rows in set (52.51 sec)

246 from one ssd model

mysql> select model, count(model) from drive_stats where smart_246_raw is not null group by model;
+----------------+--------------+
| model          | count(model) |
+----------------+--------------+
| CT250MX500SSD1 |         1532 |
+----------------+--------------+
1 row in set (53.19 sec)

247 from 2 ssds

mysql> select model, count(model) from drive_stats where smart_247_raw is not null group by model;


+----------------+--------------+
| model          | count(model) |
+----------------+--------------+
| CT250MX500SSD1 |         1532 |
| MTFDDAV240TDU  |          273 |
+----------------+--------------+
2 rows in set (50.77 sec)

248 from 2 ssd models

mysql> select model, count(model) from drive_stats where smart_248_raw is not null group by model;


+----------------+--------------+
| model          | count(model) |
+----------------+--------------+
| CT250MX500SSD1 |         1532 |
| MTFDDAV240TDU  |          273 |
+----------------+--------------+
2 rows in set (49.58 sec)

250 from 2 ssd models

mysql> select model, count(model) from drive_stats where smart_250_raw is not null group by model;
+------------+--------------+
| model      | count(model) |
+------------+--------------+
| ST250LT007 |         3367 |
| ST320LT007 |        61957 |
+------------+--------------+
2 rows in set (51.85 sec)

Backblaze have chosen:

    SMART 5: Reallocated_Sector_Count.
    SMART 187: Reported_Uncorrectable_Errors.
    SMART 188: Command_Timeout.
    SMART 197: Current_Pending_Sector_Count.
    SMART 198: Offline_Uncorrectable.

as the main attributes for their prediction model

I'm currently targetting HDDs so based on my number crunching sessions to date I see the following attributes as interesting:

5, 183, 184, 187, 188, 189, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 240, 241, 242

out of which

5, 192, 193, 194, 197, 198, 199 are reported by most failed drive models in the dataset

Let's see what these are:

5 - Reallocated Sector Count - Count of reallocated sectors. When the hard drive finds a read/write/verification error, it marks this sector as "reallocated" and transfers data to a special reserved area (spare area). This process is also known as remapping and "reallocated" sectors are called remaps. This is why, on modern hard disks, "bad blocks" cannot be found while testing the surface — all bad blocks are hidden in reallocated sectors. However, the more sectors that are reallocated, the more read/write speed will decrease. (this is an indicator of failure as these events point to data being written to bad blocks needing to be moved elsewhere on the disk - this attribute should be taken into account)

183 - SATA Downshifts - Indicates how often it was required to decrease the SATA transmission speed (from 6 Gbps to 3 or 1.5 Gbps, or from 3 Gbps to 1.5 Gbps) in order to transfer data successfully. If the attribute value is decreasing, try replacing the SATA cable. (this is a performance indicator - usually pointing to problems with the sata cable - can be safely disregarded)

184 - End To End Error - The number of data corruption occurrences in the internal disk cache. The malfunctions of the cache memory, indicated by this attribute, are fairly critical to the proper operation. (this is a problematic attribute in the sense that if there are cache errors it usually means there's going to be data errors however it does not mean that the drive has failed - one can safely disable the internal disk cache which will reduce performance but will still be able to use the drive - safe to disregard this attribute)

187 - Reported Uncerrectable Errors - The number of UNC errors, i.e. read errors which Error Correction Code (ECC) failed to recover. (this attribute is an indicator of failure and should be taken into account - usually translated into bad sectors but not always)

188 - Command Timeout - The number of operations which were interrupted due to HDD timeout. (this attribute is an indicator of failure and should be taken into account)

189 - High Fly Writes - The number of write errors caused by the fact that a write head was outside normal range of height above disk platter. (this is an indicator of failure as there's a fault in the physical layer of the drive - this attribute should be taken into account)

191 - G-Sense Error Rate - Frequency of mistakes as a result of impact loads (an indicator of disk stopping from working due to shock or vibration - in a datacenter this is highly unlikely , in a laptop perhaps very relevant - safe to disregard this attribute in the context of this dataset)

192 - Power Off Retract Count - Number of times the heads are loaded off the media. Heads can be unloaded without actually powering off. (or Emergency Retract Cycle count -Fujitsu) (This occurs in the even of unexpected power failure and does add to disk wear but not failure necessarily considering the dataset we're looking at comes from a datacenter where power is redundant - safe to disregard this attribute)

193 - Load Unload Cycle - Count of load/unload cycles into head landing zone position. (another definition I found is: The number of head movement cycles between the data zone and the head parking area or a dedicated unload ramp.The value counts down, typically from 100 to 0. The Raw value typically holds the actual number of cycles. This again is an indicator of performance / wear rather than failure so can be safely disregarded)

194 - Temperature - Current internal temperature. (This attribute is an indicator of performance / wear in the sense that the drive will not preform well if too hot or too cold which will add more wear to it however it does not mean that it will fail - there's also some literature covering experiments with "baking" drives in lab crafted ovens to increase wear and speed up time to failure - we can disregard this attribute)

195 - Hardware ECC Recovered - The number of errors which were corrected using Error Correction Code. (This attributed records the number of recovered errors - it is more like an indicator of performance rather than of failure however it depends how we define failure - if performance is too low one might decide to replace a drive with too many issues of this kind - we can disregard this attribute )

196 - Reallocation Event Count - Count of remap operations. The raw value of this attribute shows the total number of attempts to transfer data from reallocated sectors to a spare area. Both successful & unsuccessful attempts are counted. (this is an indicator of failure and should be taken into account however we need to check correlation with 197 and 198 as it looks like they are connected)

197 - Current Pending Sector Count - Number of "unstable" sectors (waiting to be remapped). If the unstable sector is subsequently written or read successfully, this value is decreased and the sector is not remapped. Read errors on the sector will not remap the sector, it will only be remapped on a failed write attempt. This can be problematic to test because cached writes will not remap the sector, only direct I/O writes to the disk. (this is an indicator of failure and should be taken into account)

198 - Uncorrectable Sector Count - The total number of uncorrectable errors when reading/writing a sector. A rise in the value of this attribute indicates defects of the disk surface and/or problems in the mechanical subsystem. (this is an indicator of failure and should be taken into account)

199 - Ultra DMA CRC Error Count - The number of errors in data transfer via the interface cable as determined by ICRC (Interface Cyclic Redundancy Check). (This is an indicator of failure however not of the disk itself but rather of the interface or data cable however it depends how we define a failure - this does not mean the disk has failed however maintenance needs to be performed to replace the interface cable so it is disruptive however the disk can be connected to different port / cable and still be used so not indicator of actual disk failure - we can disregard this attribute)

200 - Write Error Rate / Multi zone Error Rate - The total number of errors when writing a sector. (This attribute is an indicator of hardware failure but it depends on how we define a failure - write errors will affect performance as the data needs to be written to disk so when a failed write event occurs usually this means there's a bad sector and data needs to be placed elsewhere and while this happens the OS will report a timeout writing data or a write error however the disk can still be used even with reduced preformance)

240 - Head Flying Hours - Time while head is positioning (This represents the number of hours the head has spent over the data area rather than the parking area - in other words this is another wear indicator which is not an indicator of failure - it shows the head use lifespan so we can disregard this attribute)

241 - Total LBAs Written - The total number of 512-byte sectors written during the entire lifetime of the device. (It is true that Writes to disk add to disk wear over time however this is not an indicator of failure so we can disregard this attribute)

242 - Total LBAs Read - The total number of 512-byte sectors read during the entire lifetime of the device. (It is true that Reads from disk add to disk wear over time however this is not an indicator of failure so we can disregard this attribute)

My selection for the generic failure prediction model is as follows:

5 - Reallocated Sector Count

187 - Reported Uncerrectable Errors

188 - Command Timeout

189 - High Fly Writes

196 - Reallocation Event Count

197 - Current Pending Sector Count

198 - Uncorrectable Sector Count

and I will compare it with a model based on Backblaze's attribute selection to compare performance