Public Virtuoso Instance Analysis -- INI Files and DB Metadata

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	System name	Measurement Unit	OpenLink Software company website	URIBurner	DBpedia	Virtuoso Demo instance	actual LOD Cloud Cache (per Node, except Triple Count)	proposed LOD Cloud Cache (per Node, except Triple Count)	Uniprot (as of 2022_02)	EBI-EBML	Virtuoso hosted Wikidata	BSBM 500 Billion Triple Dataset Hosted on the LOD2 Knowledge Store Cluster	https://sparql.uniprot.org/sparql

2
3	Binary and Plugins in Use
4	Virtuoso Binary Size	GB	0.05	0.05	0.05	0.05	0.05	0.05	0.05	0.05	0	0
5	Language Plugins	GB	2.00	2.00	2.00	2.00	2.00	2.00	0	0	0	0
6	I18N Encoding Tables	GB	0.01	0.01	0.01	0.01	0.01	0.01	0.01	0.01	0	0
7	Big Plugins (GIS, etc.)	GB	0.02	0.02	0.02	0.02	0.02	0	0	0	0	0
8	Avg. Plugin Data per Connection	GB	0.01	0.01	0.01	0.01	0.01	0	0	0	0	0
9	size of virtuoso.db								5.8TB			18TB	4 TB
10	RDF Statements (Triples)	Count	19,842,025	418,081,988	1,405,520,836	138,116,912	35,579,533,064	45,213,511,037	105,599,220,030	2,832,367,042	11,857,528,152	500,000,000,000	86,000,000,000
11
12	INI Settings and Load
13	Max Buffers	Count	2,720,000	34,989,173	4,000,000	200,000	16,500,000	25,000,000	30,785,509	6,800,000	30,000,000	120,000,000
14	Max Dirty Buffers	Count	2,000,000	2,600,000	3,000,000	160,000	12,375,000	15,000,000	23,089,131	5,200,000	10,000,000	96,000,000
15	Average Bytes per Buffer	Count	8,700	8,700	8,700	8,700	8,700	8,700	8,700	8,700	8,700	8,700
16	Max Connections	Count	150	250	100	35	120	120	128	40	50	100
17	Complex SPARQL OLAP Share	Count	1	1	1	1	1	1	1	1	1	1
18	SQL Server Threads	Count	50	200	0	0	20	20	128	10	50	100
19	HTTP Server Threads	Count	100	50	100	35	100	100		10	50	40
20	AsyncQueueMaxThreads	Count	10	30	48	10	50	50	128	10		24
21	Main Thread Size	Count	140,000	140,000	140,000	140,000	140,000	140,000	140,000	140,000	140,000	140,000
22	Server Thread Size	Count	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000	60,000
23	Future Thread Size	Count	140,000	140,000	140,000	140,000	140,000	140,000	140,000	140,000	140,000	140,000
24	HTTP Thread Size	Count	280,000	280,000	280,000	280,000	280,000	280,000	280,000	280,000	280,000	280,000
25	MaxMemPoolSize	Count	200,000,000	200,000,000	200,000,000	200,000,000	400,000,000	400,000,000	134,217,728	200000000		40,000,000
26	MaxQueryMem		167,772,160	2,147,483,648	524,288,000	209,715,200	32,212,254,720	32,212,254,720	170,000,000,000	8,589,934,592		30,000,000,000
27	Typical Checkpoint Interval	Minutes	60	120	600	60	60	60	60	-1		60
28
29	Hardware
30	OS Memory (GB)	GB	32	384	64	15	384	384	512	128	384	3,072
31	CPUs (sockets)		4	2	8	2	2	2	2		2	1
32	Cores per CPU		1	6	1	6	6	6	32		6	8
33	Threads per Core		1	2	1	2	2	2	2		2	2
34	Logical Processors (machines * threads * cores * CPUs)		4	24	8	24	24	24	128		24	192
35	No of Stripe Disks		1	3	4	1	4	4	1	N/A	4	4
36	Write Speed of Stripe Disk	MB/s	100	100	100	100	100	100	100	N/A	100	100
37	Seek Time of Stripe Disk	ms	3	3	3	3	3	3	3	N/A	3	3
38	Disks per Controller		1	1	1	1	1	1	3	N/A	3	3
39	Controller Throughput	MB/s	600	600	600	600	600	600	600	N/A	600	600
40
41	Memory Estimate
42	Static Code Footprint	GB	2.08	2.08	2.08	2.08	2.08	2	0			0
43	Maximum Possible Stacks	GB	0.04	0.05	0.04	0.01	0.04	0	0	0		0
44	Allocated Buffers	GB	22.04	283.50	32.41	1.62	133.69	203	249	55	243	972
45	Avg. Connection Activities	GB	0.51	5.47	0.67	0.13	36.45	36	203	3		28
46	Total Avg. Server Footprint	GB	24.67	291.09	35.20	3.84	172.26	241	452	58	243	1,000
47	OS Memory Reserve	GB	6.23	80.08	9.16	0.46	88.12	134	164	36		641
48	Avg. “Formally” Free Memory	GB	7.33	92.91	28.80	380.16	211.74	143	60	70	128	2,072
49	Avg. “Really” Free Memory	GB	1.11	12.82	19.64	379.70	123.62	9	-105	33	128	1,431
50
51	UPS Estimate
52	Pessimistic Avg. Write per Disk	MB/s	72.25	72.25	72.25	72.25	72.25	72	72			72
53	Pessimistic Avg. Write per Controller	MB/s	72.25	72.25	72.25	72.25	72.25	72	208			72
54	Pessimistic Avg. Write Total	MB/s	72.25	207.60	72.25	274.57	274.57	275	74			95
55	Dirty Buffers to Write when Yellow	GB	15.27	19.84	22.90	1.23	94.42	114	176			732
56	Pessimistic Min. Yellow to Red Time	s	216.36	97.88	324.48	4.58	352.15	427	2,429			7,919
57	Dirty Buffers to Write at Red Time	GB	0.92	0.27	0.21	0.00	9.24	14	119			1,611
58	Pessimistic Min. Red Time	s	68.99	33.99	38.77	30.02	133.33	182	4,946			52,284
59	Total Battery Time if Yellow is 75%	s	380.46	175.83	484.34	46.13	647.30	812	9,834			80,270
60	Total Battery Time if Yellow is 85%	s	335.70	155.14	427.36	40.70	571.15	716	8,677			70,827
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100