Skip to content

Instantly share code, notes, and snippets.

@marctrem
Last active May 8, 2018 06:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save marctrem/cad6c4c0cf29d1468308cc5409d308ad to your computer and use it in GitHub Desktop.
Save marctrem/cad6c4c0cf29d1468308cc5409d308ad to your computer and use it in GitHub Desktop.
fdb> status details
Using cluster file `/etc/foundationdb/fdb.cluster'.
Configuration:
Redundancy mode - single
Storage engine - ssd-2
Coordinators - 1
Cluster:
FoundationDB processes - 9
Machines - 2
Memory availability - 3.2 GB per process on machine with least available
>>>>> (WARNING: 4.0 GB recommended) <<<<<
Fault Tolerance - 0 machines
Server time - 05/07/18 21:56:24
Data:
Replication health - Healthy
Moving data - 0.000 GB
Sum of key-value sizes - 0 MB
Disk space used - 0 MB
Operating space:
Storage server - 153.6 GB free on most full server
Log server - 153.6 GB free on most full server
Workload:
Read rate - 15 Hz
Write rate - 0 Hz
Transactions started - 5 Hz
Transactions committed - 0 Hz
Conflict rate - 0 Hz
Backup and DR:
Running backups - 0
Running DRs - 0
Process performance details:
172.17.0.2:4500 ( 2% cpu; 5% machine; 0.000 Gbps; 0% disk IO; 0.4 GB / 3.2 GB RAM )
172.17.0.2:4501 ( 1% cpu; 5% machine; 0.000 Gbps; 0% disk IO; 0.2 GB / 3.2 GB RAM )
172.17.0.2:4502 ( 2% cpu; 5% machine; 0.000 Gbps; 0% disk IO; 0.4 GB / 3.2 GB RAM )
172.17.0.2:4503 ( 2% cpu; 5% machine; 0.000 Gbps; 0% disk IO; 0.2 GB / 3.2 GB RAM )
172.17.0.2:4504 ( 1% cpu; 5% machine; 0.000 Gbps; 0% disk IO; 0.2 GB / 3.2 GB RAM )
172.17.0.3:4501 ( 3% cpu; 6% machine; 0.000 Gbps; 0% disk IO; 0.3 GB / 4.0 GB RAM )
172.17.0.3:4502 ( 6% cpu; 6% machine; 0.000 Gbps; 0% disk IO; 0.3 GB / 4.0 GB RAM )
172.17.0.3:4503 ( 2% cpu; 6% machine; 0.000 Gbps; 0% disk IO; 0.3 GB / 4.0 GB RAM )
172.17.0.3:4504 ( 2% cpu; 6% machine; 0.000 Gbps; 0% disk IO; 0.2 GB / 4.0 GB RAM )
Coordination servers:
172.17.0.3:4501 (reachable)
Client time: 05/07/18 21:56:24
{
"client": {
"cluster_file": {
"path": "/etc/foundationdb/fdb.cluster",
"up_to_date": true
},
"coordinators": {
"coordinators": [
{
"address": "172.17.0.3:4501",
"reachable": true
}
],
"quorum_reachable": true
},
"database_status": {
"available": true,
"healthy": true
},
"messages": [],
"timestamp": 1525735351
},
"cluster": {
"clients": {
"count": 0
},
"cluster_controller_timestamp": 1525735351,
"configuration": {
"coordinators_count": 1,
"excluded_servers": [],
"redundancy": {
"factor": "single"
},
"storage_engine": "ssd-2",
"storage_policy": "1",
"tlog_policy": "1"
},
"data": {
"average_partition_size_bytes": 400000,
"least_operating_space_bytes_log_server": 153264077619,
"least_operating_space_bytes_storage_server": 153264077616,
"moving_data": {
"in_flight_bytes": 0,
"in_queue_bytes": 0,
"total_written_bytes": 0
},
"partitions_count": 1,
"state": {
"healthy": true,
"name": "healthy"
},
"total_disk_used_bytes": 431232,
"total_kv_size_bytes": 0
},
"database_available": true,
"database_locked": false,
"fault_tolerance": {
"max_machine_failures_without_losing_availability": 0,
"max_machine_failures_without_losing_data": 0
},
"generation": 2,
"incompatible_connections": [],
"latency_probe": {
"batch_priority_transaction_start_seconds": 0.00028252601623535156,
"commit_seconds": 0.021840572357177734,
"immediate_priority_transaction_start_seconds": 0.00046539306640625005,
"read_seconds": 0.00013637542724609375,
"transaction_start_seconds": 0.00030636787414550776
},
"layers": {
"_valid": true,
"backup": {
"blob_recent_io": {
"bytes_per_second": 0,
"bytes_sent": 0,
"requests_failed": 0,
"requests_successful": 0
},
"instances": {
"9509192f49ea90b1af3f69aaa7172868": {
"blob_stats": {
"recent": {
"bytes_per_second": 0,
"bytes_sent": 0,
"requests_failed": 0,
"requests_successful": 0
},
"total": {
"bytes_sent": 0,
"requests_failed": 0,
"requests_successful": 0
}
},
"configured_workers": 20,
"id": "9509192f49ea90b1af3f69aaa7172868",
"last_updated": 1525735334.0532782,
"main_thread_cpu_seconds": 40.318362,
"memory_usage": 112070656,
"process_cpu_seconds": 41.183431999999996,
"resident_size": 12197888,
"version": "5.1.7"
},
"f2420dcf0b926d86734322399dc1aaa6": {
"blob_stats": {
"recent": {
"bytes_per_second": 0,
"bytes_sent": 0,
"requests_failed": 0,
"requests_successful": 0
},
"total": {
"bytes_sent": 0,
"requests_failed": 0,
"requests_successful": 0
}
},
"configured_workers": 20,
"id": "f2420dcf0b926d86734322399dc1aaa6",
"last_updated": 1525735325.0570498,
"main_thread_cpu_seconds": 40.47883099999999,
"memory_usage": 112009216,
"process_cpu_seconds": 41.385606,
"resident_size": 12120064,
"version": "5.1.7"
}
},
"instances_running": 2,
"last_updated": 1525735334.0532782,
"paused": false,
"tags": {},
"total_workers": 40
}
},
"machines": {
"366a652476a85a58b83033a0ca0d6990": {
"address": "172.17.0.2",
"contributing_workers": 5,
"cpu": {
"logical_core_utilization": 0.05331548010711936
},
"excluded": false,
"locality": {
"machineid": "366a652476a85a58b83033a0ca0d6990",
"processid": "922fe3387785807148d4927228254ab7",
"zoneid": "366a652476a85a58b83033a0ca0d6990"
},
"machine_id": "366a652476a85a58b83033a0ca0d6990",
"memory": {
"committed_bytes": 810049536,
"free_bytes": 15944183808,
"total_bytes": 16754233344
},
"network": {
"megabits_received": {
"hz": 0.3334810000000001
},
"megabits_sent": {
"hz": 0.451857
},
"tcp_segments_retransmitted": {
"hz": 0
}
}
},
"ba5a49ef4a9c47ca9828c62d8ed6a599": {
"address": "172.17.0.3",
"contributing_workers": 4,
"cpu": {
"logical_core_utilization": 0.05300004599917201
},
"excluded": false,
"locality": {
"machineid": "ba5a49ef4a9c47ca9828c62d8ed6a599",
"processid": "3698b3864fd3bb24f7a6d99f6db98be6",
"zoneid": "ba5a49ef4a9c47ca9828c62d8ed6a599"
},
"machine_id": "ba5a49ef4a9c47ca9828c62d8ed6a599",
"memory": {
"committed_bytes": 810115072,
"free_bytes": 15944118272,
"total_bytes": 16754233344
},
"network": {
"megabits_received": {
"hz": 0.45460900000000004
},
"megabits_sent": {
"hz": 0.336781
},
"tcp_segments_retransmitted": {
"hz": 0
}
}
}
},
"messages": [],
"processes": {
"1dad0335861fc045418e5e8cd60a381e": {
"address": "172.17.0.2:4503",
"class_source": "command_line",
"class_type": "unset",
"command_line": "/usr/sbin/fdbserver --cluster_file=/etc/foundationdb/fdb.cluster --datadir=/var/lib/foundationdb/data/4503 --listen_address=public --logdir=/var/log/foundationdb --public_address=auto:4503",
"cpu": {
"usage_cores": 0.021906205688297608
},
"disk": {
"busy": 0,
"free_bytes": 165490552832,
"reads": {
"counter": 0,
"hz": 0,
"sectors": 0
},
"total_bytes": 244529823744,
"writes": {
"counter": 0,
"hz": 0,
"sectors": 0
}
},
"excluded": false,
"fault_domain": "366a652476a85a58b83033a0ca0d6990",
"locality": {
"machineid": "366a652476a85a58b83033a0ca0d6990",
"processid": "1dad0335861fc045418e5e8cd60a381e",
"zoneid": "366a652476a85a58b83033a0ca0d6990"
},
"machine_id": "366a652476a85a58b83033a0ca0d6990",
"memory": {
"available_bytes": 3480766054,
"limit_bytes": 8589934592,
"used_bytes": 208359424
},
"messages": [],
"network": {
"connection_errors": {
"hz": 0
},
"connections_closed": {
"hz": 0
},
"connections_established": {
"hz": 0
},
"current_connections": 10,
"megabits_received": {
"hz": 0.0278907
},
"megabits_sent": {
"hz": 0.0434488
}
},
"roles": [
{
"id": "46c8a90549e78dd7",
"role": "proxy"
},
{
"data_version": 5470200255,
"data_version_lag": 0,
"durable_bytes": {
"counter": 1370,
"hz": 0,
"roughness": 0
},
"finished_queries": {
"counter": 0,
"hz": 0,
"roughness": 0
},
"id": "b5ec76edca21984c",
"input_bytes": {
"counter": 1370,
"hz": 0,
"roughness": 0
},
"kvstore_available_bytes": 165490577408,
"kvstore_free_bytes": 165490577408,
"kvstore_total_bytes": 244529823744,
"kvstore_used_bytes": 20536,
"query_queue_max": 0,
"role": "storage",
"stored_bytes": 0
}
],
"uptime_seconds": 5520.09,
"version": "5.1.7"
},
"31461b9940ab93fe7b8d8786076336d6": {
"address": "172.17.0.2:4504",
"class_source": "command_line",
"class_type": "unset",
"command_line": "/usr/sbin/fdbserver --cluster_file=/etc/foundationdb/fdb.cluster --datadir=/var/lib/foundationdb/data/4504 --listen_address=public --logdir=/var/log/foundationdb --public_address=auto:4504",
"cpu": {
"usage_cores": 0.012676997168045313
},
"disk": {
"busy": 0,
"free_bytes": 165490552832,
"reads": {
"counter": 0,
"hz": 0,
"sectors": 0
},
"total_bytes": 244529823744,
"writes": {
"counter": 0,
"hz": 0,
"sectors": 0
}
},
"excluded": false,
"fault_domain": "366a652476a85a58b83033a0ca0d6990",
"locality": {
"machineid": "366a652476a85a58b83033a0ca0d6990",
"processid": "31461b9940ab93fe7b8d8786076336d6",
"zoneid": "366a652476a85a58b83033a0ca0d6990"
},
"machine_id": "366a652476a85a58b83033a0ca0d6990",
"memory": {
"available_bytes": 3480766054,
"limit_bytes": 8589934592,
"used_bytes": 207818752
},
"messages": [],
"network": {
"connection_errors": {
"hz": 0
},
"connections_closed": {
"hz": 0
},
"connections_established": {
"hz": 0
},
"current_connections": 7,
"megabits_received": {
"hz": 0.0170493
},
"megabits_sent": {
"hz": 0.0222428
}
},
"roles": [
{
"data_version": 5470200255,
"data_version_lag": 0,
"durable_bytes": {
"counter": 1370,
"hz": 0,
"roughness": 0
},
"finished_queries": {
"counter": 0,
"hz": 0,
"roughness": 0
},
"id": "82452dc77b43e423",
"input_bytes": {
"counter": 1370,
"hz": 0,
"roughness": 0
},
"kvstore_available_bytes": 165490577408,
"kvstore_free_bytes": 165490577408,
"kvstore_total_bytes": 244529823744,
"kvstore_used_bytes": 20536,
"query_queue_max": 0,
"role": "storage",
"stored_bytes": 0
},
{
"id": "3bf11cbd46640712",
"role": "resolver"
}
],
"uptime_seconds": 5520.09,
"version": "5.1.7"
},
"3698b3864fd3bb24f7a6d99f6db98be6": {
"address": "172.17.0.3:4501",
"class_source": "command_line",
"class_type": "unset",
"command_line": "/usr/sbin/fdbserver --cluster_file=/etc/foundationdb/fdb.cluster --datadir=/var/lib/foundationdb/data/4501 --listen_address=public --logdir=/var/log/foundationdb --public_address=auto:4501",
"cpu": {
"usage_cores": 0.027811899385811054
},
"disk": {
"busy": 0,
"free_bytes": 165490606080,
"reads": {
"counter": 0,
"hz": 0,
"sectors": 0
},
"total_bytes": 244529823744,
"writes": {
"counter": 0,
"hz": 0,
"sectors": 0
}
},
"excluded": false,
"fault_domain": "ba5a49ef4a9c47ca9828c62d8ed6a599",
"locality": {
"machineid": "ba5a49ef4a9c47ca9828c62d8ed6a599",
"processid": "3698b3864fd3bb24f7a6d99f6db98be6",
"zoneid": "ba5a49ef4a9c47ca9828c62d8ed6a599"
},
"machine_id": "ba5a49ef4a9c47ca9828c62d8ed6a599",
"memory": {
"available_bytes": 4288335872,
"limit_bytes": 8589934592,
"used_bytes": 276320256
},
"messages": [],
"network": {
"connection_errors": {
"hz": 0
},
"connections_closed": {
"hz": 0
},
"connections_established": {
"hz": 0
},
"current_connections": 11,
"megabits_received": {
"hz": 0.0634837
},
"megabits_sent": {
"hz": 0.06464200000000002
}
},
"roles": [
{
"id": "3ee48052a28cd463",
"role": "cluster_controller"
},
{
"data_version": 5470322608,
"data_version_lag": 0,
"durable_bytes": {
"counter": 1370,
"hz": 0,
"roughness": 0
},
"finished_queries": {
"counter": 0,
"hz": 0,
"roughness": 0
},
"id": "d6004c9e341659ca",
"input_bytes": {
"counter": 1370,
"hz": 0,
"roughness": 0
},
"kvstore_available_bytes": 165490573312,
"kvstore_free_bytes": 165490573312,
"kvstore_total_bytes": 244529823744,
"kvstore_used_bytes": 20536,
"query_queue_max": 0,
"role": "storage",
"stored_bytes": 0
}
],
"uptime_seconds": 5510.09,
"version": "5.1.7"
},
"37d913d3b349dcae24092f904ed7f517": {
"address": "172.17.0.2:4501",
"class_source": "command_line",
"class_type": "unset",
"command_line": "/usr/sbin/fdbserver --cluster_file=/etc/foundationdb/fdb.cluster --datadir=/var/lib/foundationdb/data/4501 --listen_address=public --logdir=/var/log/foundationdb --public_address=auto:4501",
"cpu": {
"usage_cores": 0.012615322462905814
},
"disk": {
"busy": 0,
"free_bytes": 165490552832,
"reads": {
"counter": 0,
"hz": 0,
"sectors": 0
},
"total_bytes": 244529823744,
"writes": {
"counter": 0,
"hz": 0,
"sectors": 0
}
},
"excluded": false,
"fault_domain": "366a652476a85a58b83033a0ca0d6990",
"locality": {
"machineid": "366a652476a85a58b83033a0ca0d6990",
"processid": "37d913d3b349dcae24092f904ed7f517",
"zoneid": "366a652476a85a58b83033a0ca0d6990"
},
"machine_id": "366a652476a85a58b83033a0ca0d6990",
"memory": {
"available_bytes": 3480766054,
"limit_bytes": 8589934592,
"used_bytes": 207872000
},
"messages": [],
"network": {
"connection_errors": {
"hz": 0
},
"connections_closed": {
"hz": 0
},
"connections_established": {
"hz": 0
},
"current_connections": 7,
"megabits_received": {
"hz": 0.0140205
},
"megabits_sent": {
"hz": 0.0208907
}
},
"roles": [
{
"data_version": 5470363663,
"data_version_lag": 0,
"durable_bytes": {
"counter": 1370,
"hz": 0,
"roughness": 0
},
"finished_queries": {
"counter": 0,
"hz": 0,
"roughness": 0
},
"id": "b44684e2f5db96d4",
"input_bytes": {
"counter": 1370,
"hz": 0,
"roughness": 0
},
"kvstore_available_bytes": 165490573312,
"kvstore_free_bytes": 165490573312,
"kvstore_total_bytes": 244529823744,
"kvstore_used_bytes": 20536,
"query_queue_max": 0,
"role": "storage",
"stored_bytes": 0
}
],
"uptime_seconds": 5520.09,
"version": "5.1.7"
},
"7599f81fbd48b13644a49b53d9fab5a1": {
"address": "172.17.0.3:4503",
"class_source": "command_line",
"class_type": "unset",
"command_line": "/usr/sbin/fdbserver --cluster_file=/etc/foundationdb/fdb.cluster --datadir=/var/lib/foundationdb/data/4503 --listen_address=public --logdir=/var/log/foundationdb --public_address=auto:4503",
"cpu": {
"usage_cores": 0.022060226434112713
},
"disk": {
"busy": 0,
"free_bytes": 165490606080,
"reads": {
"counter": 0,
"hz": 0,
"sectors": 0
},
"total_bytes": 244529823744,
"writes": {
"counter": 0,
"hz": 0,
"sectors": 0
}
},
"excluded": false,
"fault_domain": "ba5a49ef4a9c47ca9828c62d8ed6a599",
"locality": {
"machineid": "ba5a49ef4a9c47ca9828c62d8ed6a599",
"processid": "7599f81fbd48b13644a49b53d9fab5a1",
"zoneid": "ba5a49ef4a9c47ca9828c62d8ed6a599"
},
"machine_id": "ba5a49ef4a9c47ca9828c62d8ed6a599",
"memory": {
"available_bytes": 4288335872,
"limit_bytes": 8589934592,
"used_bytes": 366063616
},
"messages": [],
"network": {
"connection_errors": {
"hz": 0
},
"connections_closed": {
"hz": 0
},
"connections_established": {
"hz": 0
},
"current_connections": 8,
"megabits_received": {
"hz": 0.035143100000000004
},
"megabits_sent": {
"hz": 0.037770200000000004
}
},
"roles": [
{
"data_version": 5469831021,
"durable_bytes": {
"counter": 1479927,
"hz": 190.597,
"roughness": 183.503
},
"id": "25633acb7914426c",
"input_bytes": {
"counter": 1479927,
"hz": 183.197,
"roughness": 113.585
},
"kvstore_available_bytes": 165490593792,
"kvstore_free_bytes": 165490593792,
"kvstore_total_bytes": 244529823744,
"kvstore_used_bytes": 143728,
"queue_disk_available_bytes": 165490593792,
"queue_disk_free_bytes": 165490593792,
"queue_disk_total_bytes": 244529823744,
"queue_disk_used_bytes": 520192,
"role": "log"
},
{
"data_version": 5470363663,
"data_version_lag": 0,
"durable_bytes": {
"counter": 1370,
"hz": 0,
"roughness": 0
},
"finished_queries": {
"counter": 0,
"hz": 0,
"roughness": 0
},
"id": "644991b7734eedbb",
"input_bytes": {
"counter": 1370,
"hz": 0,
"roughness": 0
},
"kvstore_available_bytes": 165490573312,
"kvstore_free_bytes": 165490573312,
"kvstore_total_bytes": 244529823744,
"kvstore_used_bytes": 20536,
"query_queue_max": 0,
"role": "storage",
"stored_bytes": 0
}
],
"uptime_seconds": 5510.09,
"version": "5.1.7"
},
"79387a3cbe063c4cbb49a3457b993f0e": {
"address": "172.17.0.3:4504",
"class_source": "command_line",
"class_type": "unset",
"command_line": "/usr/sbin/fdbserver --cluster_file=/etc/foundationdb/fdb.cluster --datadir=/var/lib/foundationdb/data/4504 --listen_address=public --logdir=/var/log/foundationdb --public_address=auto:4504",
"cpu": {
"usage_cores": 0.02181065102958353
},
"disk": {
"busy": 0,
"free_bytes": 165490606080,
"reads": {
"counter": 0,
"hz": 0,
"sectors": 0
},
"total_bytes": 244529823744,
"writes": {
"counter": 0,
"hz": 0,
"sectors": 0
}
},
"excluded": false,
"fault_domain": "ba5a49ef4a9c47ca9828c62d8ed6a599",
"locality": {
"machineid": "ba5a49ef4a9c47ca9828c62d8ed6a599",
"processid": "79387a3cbe063c4cbb49a3457b993f0e",
"zoneid": "ba5a49ef4a9c47ca9828c62d8ed6a599"
},
"machine_id": "ba5a49ef4a9c47ca9828c62d8ed6a599",
"memory": {
"available_bytes": 4288335872,
"limit_bytes": 8589934592,
"used_bytes": 208371712
},
"messages": [],
"network": {
"connection_errors": {
"hz": 0
},
"connections_closed": {
"hz": 0
},
"connections_established": {
"hz": 0
},
"current_connections": 11,
"megabits_received": {
"hz": 0.0296235
},
"megabits_sent": {
"hz": 0.046037600000000005
}
},
"roles": [
{
"id": "8af3fa82581bf9ef",
"role": "proxy"
},
{
"data_version": 5470322608,
"data_version_lag": 0,
"durable_bytes": {
"counter": 1370,
"hz": 0,
"roughness": 0
},
"finished_queries": {
"counter": 0,
"hz": 0,
"roughness": 0
},
"id": "236742d7ea68e446",
"input_bytes": {
"counter": 1370,
"hz": 0,
"roughness": 0
},
"kvstore_available_bytes": 165490573312,
"kvstore_free_bytes": 165490573312,
"kvstore_total_bytes": 244529823744,
"kvstore_used_bytes": 20536,
"query_queue_max": 0,
"role": "storage",
"stored_bytes": 0
}
],
"uptime_seconds": 5510.09,
"version": "5.1.7"
},
"922fe3387785807148d4927228254ab7": {
"address": "172.17.0.2:4500",
"class_source": "command_line",
"class_type": "unset",
"command_line": "/usr/sbin/fdbserver --cluster_file=/etc/foundationdb/fdb.cluster --datadir=/var/lib/foundationdb/data/4500 --listen_address=public --logdir=/var/log/foundationdb --public_address=auto:4500",
"cpu": {
"usage_cores": 0.022003067981592114
},
"disk": {
"busy": 0,
"free_bytes": 165490552832,
"reads": {
"counter": 0,
"hz": 0,
"sectors": 0
},
"total_bytes": 244529823744,
"writes": {
"counter": 0,
"hz": 0,
"sectors": 0
}
},
"excluded": false,
"fault_domain": "366a652476a85a58b83033a0ca0d6990",
"locality": {
"machineid": "366a652476a85a58b83033a0ca0d6990",
"processid": "922fe3387785807148d4927228254ab7",
"zoneid": "366a652476a85a58b83033a0ca0d6990"
},
"machine_id": "366a652476a85a58b83033a0ca0d6990",
"memory": {
"available_bytes": 3480766054,
"limit_bytes": 8589934592,
"used_bytes": 410497024
},
"messages": [],
"network": {
"connection_errors": {
"hz": 0
},
"connections_closed": {
"hz": 0
},
"connections_established": {
"hz": 0
},
"current_connections": 10,
"megabits_received": {
"hz": 0.027063900000000002
},
"megabits_sent": {
"hz": 0.0425502
}
},
"roles": [
{
"id": "24e47dee7c568fff",
"role": "proxy"
},
{
"data_version": 5470200255,
"data_version_lag": 0,
"durable_bytes": {
"counter": 1370,
"hz": 0,
"roughness": 0
},
"finished_queries": {
"counter": 0,
"hz": 0,
"roughness": 0
},
"id": "ca15384b91fc9673",
"input_bytes": {
"counter": 1370,
"hz": 0,
"roughness": 0
},
"kvstore_available_bytes": 165490577408,
"kvstore_free_bytes": 165490577408,
"kvstore_total_bytes": 244529823744,
"kvstore_used_bytes": 20536,
"query_queue_max": 0,
"role": "storage",
"stored_bytes": 0
}
],
"uptime_seconds": 5520.15,
"version": "5.1.7"
},
"e7640a5d534b79166f246be2a2456fce": {
"address": "172.17.0.3:4502",
"class_source": "command_line",
"class_type": "unset",
"command_line": "/usr/sbin/fdbserver --cluster_file=/etc/foundationdb/fdb.cluster --datadir=/var/lib/foundationdb/data/4502 --listen_address=public --logdir=/var/log/foundationdb --public_address=auto:4502",
"cpu": {
"usage_cores": 0.05592230524311611
},
"disk": {
"busy": 0,
"free_bytes": 165490606080,
"reads": {
"counter": 0,
"hz": 0,
"sectors": 0
},
"total_bytes": 244529823744,
"writes": {
"counter": 0,
"hz": 0,
"sectors": 0
}
},
"excluded": false,
"fault_domain": "ba5a49ef4a9c47ca9828c62d8ed6a599",
"locality": {
"machineid": "ba5a49ef4a9c47ca9828c62d8ed6a599",
"processid": "e7640a5d534b79166f246be2a2456fce",
"zoneid": "ba5a49ef4a9c47ca9828c62d8ed6a599"
},
"machine_id": "ba5a49ef4a9c47ca9828c62d8ed6a599",
"memory": {
"available_bytes": 4288335872,
"limit_bytes": 8589934592,
"used_bytes": 358469632
},
"messages": [],
"network": {
"connection_errors": {
"hz": 0
},
"connections_closed": {
"hz": 0
},
"connections_established": {
"hz": 0
},
"current_connections": 11,
"megabits_received": {
"hz": 0.20145300000000002
},
"megabits_sent": {
"hz": 0.0848594
}
},
"roles": [
{
"id": "4f5677e576a12739",
"role": "master"
},
{
"data_version": 5469831021,
"durable_bytes": {
"counter": 318,
"hz": 0,
"roughness": 0
},
"id": "36d798cbfa41c8da",
"input_bytes": {
"counter": 318,
"hz": 0,
"roughness": 0
},
"kvstore_available_bytes": 165490593792,
"kvstore_free_bytes": 165490593792,
"kvstore_total_bytes": 244529823744,
"kvstore_used_bytes": 20536,
"queue_disk_available_bytes": 165490593792,
"queue_disk_free_bytes": 165490593792,
"queue_disk_total_bytes": 244529823744,
"queue_disk_used_bytes": 96464896,
"role": "log"
},
{
"data_version": 5470200255,
"data_version_lag": 0,
"durable_bytes": {
"counter": 1370,
"hz": 0,
"roughness": 0
},
"finished_queries": {
"counter": 0,
"hz": 0,
"roughness": 0
},
"id": "4448b82c2a176eb6",
"input_bytes": {
"counter": 1370,
"hz": 0,
"roughness": 0
},
"kvstore_available_bytes": 165490577408,
"kvstore_free_bytes": 165490577408,
"kvstore_total_bytes": 244529823744,
"kvstore_used_bytes": 20536,
"query_queue_max": 0,
"role": "storage",
"stored_bytes": 0
}
],
"uptime_seconds": 5510.09,
"version": "5.1.7"
},
"fc96747cfaa41113eed487d055b9772f": {
"address": "172.17.0.2:4502",
"class_source": "command_line",
"class_type": "unset",
"command_line": "/usr/sbin/fdbserver --cluster_file=/etc/foundationdb/fdb.cluster --datadir=/var/lib/foundationdb/data/4502 --listen_address=public --logdir=/var/log/foundationdb --public_address=auto:4502",
"cpu": {
"usage_cores": 0.023196982454315826
},
"disk": {
"busy": 0,
"free_bytes": 165490552832,
"reads": {
"counter": 0,
"hz": 0,
"sectors": 0
},
"total_bytes": 244529823744,
"writes": {
"counter": 0,
"hz": 0,
"sectors": 0
}
},
"excluded": false,
"fault_domain": "366a652476a85a58b83033a0ca0d6990",
"locality": {
"machineid": "366a652476a85a58b83033a0ca0d6990",
"processid": "fc96747cfaa41113eed487d055b9772f",
"zoneid": "366a652476a85a58b83033a0ca0d6990"
},
"machine_id": "366a652476a85a58b83033a0ca0d6990",
"memory": {
"available_bytes": 3480766054,
"limit_bytes": 8589934592,
"used_bytes": 425099264
},
"messages": [],
"network": {
"connection_errors": {
"hz": 0
},
"connections_closed": {
"hz": 0
},
"connections_established": {
"hz": 0
},
"current_connections": 10,
"megabits_received": {
"hz": 0.0508231
},
"megabits_sent": {
"hz": 0.0958383
}
},
"roles": [
{
"data_version": 5469831021,
"durable_bytes": {
"counter": 318,
"hz": 0,
"roughness": 0
},
"id": "529cfce905769c68",
"input_bytes": {
"counter": 318,
"hz": 0,
"roughness": 0
},
"kvstore_available_bytes": 165490593792,
"kvstore_free_bytes": 165490593792,
"kvstore_total_bytes": 244529823744,
"kvstore_used_bytes": 20536,
"queue_disk_available_bytes": 165490593792,
"queue_disk_free_bytes": 165490593792,
"queue_disk_total_bytes": 244529823744,
"queue_disk_used_bytes": 96464896,
"role": "log"
},
{
"data_version": 5469831021,
"data_version_lag": 0,
"durable_bytes": {
"counter": 2326836,
"hz": 0,
"roughness": 0
},
"finished_queries": {
"counter": 81251,
"hz": 13.5999,
"roughness": 8.43057
},
"id": "dcd32366725c8c8b",
"input_bytes": {
"counter": 2329354,
"hz": 503.597,
"roughness": 2783.22
},
"kvstore_available_bytes": 165490593792,
"kvstore_free_bytes": 165490593792,
"kvstore_total_bytes": 244529823744,
"kvstore_used_bytes": 82144,
"query_queue_max": 4,
"role": "storage",
"stored_bytes": 0
}
],
"uptime_seconds": 5520.09,
"version": "5.1.7"
}
},
"protocol_version": "fdb00a551040001",
"qos": {
"limiting_queue_bytes_storage_server": 2518,
"limiting_version_lag_storage_server": 0,
"performance_limited_by": {
"description": "The database is not being saturated by the workload.",
"name": "workload",
"reason_id": 4
},
"released_transactions_per_second": 3.38909,
"transactions_per_second_limit": 3705830,
"worst_queue_bytes_log_server": 238,
"worst_queue_bytes_storage_server": 2518,
"worst_version_lag_storage_server": 0
},
"recovery_state": {
"description": "Recovery complete.",
"name": "fully_recovered"
},
"workload": {
"bytes": {
"written": {
"counter": 293601,
"hz": 14.1998,
"roughness": 82.8388
}
},
"operations": {
"reads": {
"hz": 12.5256
},
"writes": {
"counter": 1434,
"hz": 0.39999300000000004,
"roughness": 2.33349
}
},
"transactions": {
"committed": {
"counter": 844,
"hz": 0.199997,
"roughness": 1.17752
},
"conflicted": {
"counter": 15,
"hz": 0,
"roughness": 0
},
"started": {
"counter": 24215,
"hz": 4.399927,
"roughness": 2.6838931610388084
}
}
}
}
}
cat /var/log/foundationdb/trace.172.017.000.003.4500.1525729
.1525729837.Bh9rVj.1.xml -n 20 /var/log/foundationdb/trace.172.017.000.003.4500
<Event Severity="10" Time="1525730337.912112" Type="MachineMetrics" Machine="172.17.0.3:4500" ID="0000000000000000" Elapsed="5.00008" MbpsSent="0.325187" MbpsReceived="0.44504" OutSegs="4464" RetransSegs="0" CPUSeconds="0.25851" TotalMemory="16754233344" CommittedMemory="789528576" AvailableMemory="15964704768" ZoneID="ba5a49ef4a9c47ca9828c62d8ed6a599" MachineID="ba5a49ef4a9c47ca9828c62d8ed6a599" logGroup="default" TrackLatestType="Original"/>
<Event Severity="30" Time="1525730342.912197" Type="DeviceNotFound" Machine="172.17.0.3:4500" ID="0000000000000000" Directory="/var/lib/foundationdb/data/4500" logGroup="default"/>
<Event Severity="10" Time="1525730342.912197" Type="MachineLoadDetail" Machine="172.17.0.3:4500" ID="0000000000000000" User="1147775" Nice="14147" System="1397379" Idle="157745474" IOWait="808977" IRQ="170101" SoftIRQ="436455" Steal="0" Guest="0" logGroup="default"/>
<Event Severity="10" Time="1525730342.912197" Type="ProcessMetrics" Machine="172.17.0.3:4500" ID="0000000000000000" Elapsed="5.00009" CPUSeconds="0.025055" MainThreadCPUSeconds="0.024186" UptimeSeconds="505.087" Memory="327540736" ResidentMemory="18329600" MbpsSent="0.00639189" MbpsReceived="0.00543191" DiskTotalBytes="244529823744" DiskFreeBytes="165779386368" DiskQueueDepth="0" DiskIdleSeconds="5.00009" DiskReads="0" DiskWrites="0" DiskReadsCount="0" DiskWritesCount="0" DiskWriteSectors="0" DiskReadSectors="0" FileWrites="0" FileReads="0" CacheReadBytes="0" CacheFinds="0" CacheWritesBlocked="0" CacheReadsBlocked="0" CachePageReadsMerged="0" CacheWrites="0" CacheReads="0" ZoneID="ba5a49ef4a9c47ca9828c62d8ed6a599" MachineID="ba5a49ef4a9c47ca9828c62d8ed6a599" AIO_SubmitCount="0" AIO_CollectCount="0" AIO_SubmitLagMS="0" AIO_DiskStallMS="0" N2_CantSleep="0" N2_WontSleep="0" N2_Yields="1" N2_YieldCalls="0" N2_YieldCallsTrue="0" N2_SlowTaskSignals="0" N2_YieldBigStack="0" N2_RunLoopIterations="374" N2_TimersExecuted="230" N2_TasksExecuted="375" N2_ASIOEventsProcessed="453" N2_ReadCalls="80" N2_WriteCalls="80" N2_ReadProbes="80" N2_WriteProbes="0" N2_PacketsRead="80" N2_PacketsGenerated="80" N2_WouldBlock="0" CurrentConnections="3" ConnectionsEstablished="0" ConnectionsClosed="0" ConnectionErrors="0" N2_SlowTask4M="1" logGroup="default" TrackLatestType="Original"/>
<Event Severity="10" Time="1525730342.912197" Type="MachineMetrics" Machine="172.17.0.3:4500" ID="0000000000000000" Elapsed="5.00009" MbpsSent="0.324918" MbpsReceived="0.446426" OutSegs="4403" RetransSegs="0" CPUSeconds="0.259745" TotalMemory="16754233344" CommittedMemory="789774336" AvailableMemory="15964459008" ZoneID="ba5a49ef4a9c47ca9828c62d8ed6a599" MachineID="ba5a49ef4a9c47ca9828c62d8ed6a599" logGroup="default" TrackLatestType="Original"/>
<Event Severity="10" Time="1525730344.365825" Type="SomewhatSlowRunLoopTop" Machine="172.17.0.3:4500" ID="0000000000000000" Elapsed="0.0265214" logGroup="default"/>
<Event Severity="30" Time="1525730347.912281" Type="DeviceNotFound" Machine="172.17.0.3:4500" ID="0000000000000000" Directory="/var/lib/foundationdb/data/4500" logGroup="default"/>
<Event Severity="10" Time="1525730347.912281" Type="MachineLoadDetail" Machine="172.17.0.3:4500" ID="0000000000000000" User="1147827" Nice="14147" System="1397457" Idle="157748264" IOWait="809025" IRQ="170110" SoftIRQ="436480" Steal="0" Guest="0" logGroup="default"/>
<Event Severity="10" Time="1525730347.912281" Type="ProcessMetrics" Machine="172.17.0.3:4500" ID="0000000000000000" Elapsed="5.00008" CPUSeconds="0.025063" MainThreadCPUSeconds="0.024224" UptimeSeconds="510.088" Memory="327540736" ResidentMemory="18329600" MbpsSent="0.00639189" MbpsReceived="0.00543191" DiskTotalBytes="244529823744" DiskFreeBytes="165779353600" DiskQueueDepth="0" DiskIdleSeconds="5.00008" DiskReads="0" DiskWrites="0" DiskReadsCount="0" DiskWritesCount="0" DiskWriteSectors="0" DiskReadSectors="0" FileWrites="0" FileReads="0" CacheReadBytes="0" CacheFinds="0" CacheWritesBlocked="0" CacheReadsBlocked="0" CachePageReadsMerged="0" CacheWrites="0" CacheReads="0" ZoneID="ba5a49ef4a9c47ca9828c62d8ed6a599" MachineID="ba5a49ef4a9c47ca9828c62d8ed6a599" AIO_SubmitCount="0" AIO_CollectCount="0" AIO_SubmitLagMS="0" AIO_DiskStallMS="0" N2_CantSleep="0" N2_WontSleep="0" N2_Yields="1" N2_YieldCalls="0" N2_YieldCallsTrue="0" N2_SlowTaskSignals="0" N2_YieldBigStack="0" N2_RunLoopIterations="376" N2_TimersExecuted="231" N2_TasksExecuted="376" N2_ASIOEventsProcessed="456" N2_ReadCalls="80" N2_WriteCalls="80" N2_ReadProbes="80" N2_WriteProbes="0" N2_PacketsRead="80" N2_PacketsGenerated="80" N2_WouldBlock="0" CurrentConnections="3" ConnectionsEstablished="0" ConnectionsClosed="0" ConnectionErrors="0" N2_SlowTask4M="1" logGroup="default" TrackLatestType="Original"/>
<Event Severity="10" Time="1525730347.912281" Type="MachineMetrics" Machine="172.17.0.3:4500" ID="0000000000000000" Elapsed="5.00008" MbpsSent="0.332449" MbpsReceived="0.453472" OutSegs="4519" RetransSegs="0" CPUSeconds="0.273156" TotalMemory="16754233344" CommittedMemory="789651456" AvailableMemory="15964581888" ZoneID="ba5a49ef4a9c47ca9828c62d8ed6a599" MachineID="ba5a49ef4a9c47ca9828c62d8ed6a599" logGroup="default" TrackLatestType="Original"/>
<Event Severity="10" Time="1525730349.440547" Type="SomewhatSlowRunLoopTop" Machine="172.17.0.3:4500" ID="0000000000000000" Elapsed="0.0746372" logGroup="default"/>
<Event Severity="30" Time="1525730352.912375" Type="DeviceNotFound" Machine="172.17.0.3:4500" ID="0000000000000000" Directory="/var/lib/foundationdb/data/4500" logGroup="default"/>
<Event Severity="10" Time="1525730352.912375" Type="MachineLoadDetail" Machine="172.17.0.3:4500" ID="0000000000000000" User="1147881" Nice="14147" System="1397530" Idle="157751064" IOWait="809066" IRQ="170119" SoftIRQ="436504" Steal="0" Guest="0" logGroup="default"/>
<Event Severity="10" Time="1525730352.912375" Type="ProcessMetrics" Machine="172.17.0.3:4500" ID="0000000000000000" Elapsed="5.00009" CPUSeconds="0.025233" MainThreadCPUSeconds="0.024488" UptimeSeconds="515.088" Memory="327540736" ResidentMemory="18329600" MbpsSent="0.00635188" MbpsReceived="0.0053551" DiskTotalBytes="244529823744" DiskFreeBytes="165779288064" DiskQueueDepth="0" DiskIdleSeconds="5.00009" DiskReads="0" DiskWrites="0" DiskReadsCount="0" DiskWritesCount="0" DiskWriteSectors="0" DiskReadSectors="0" FileWrites="0" FileReads="0" CacheReadBytes="0" CacheFinds="0" CacheWritesBlocked="0" CacheReadsBlocked="0" CachePageReadsMerged="0" CacheWrites="0" CacheReads="0" ZoneID="ba5a49ef4a9c47ca9828c62d8ed6a599" MachineID="ba5a49ef4a9c47ca9828c62d8ed6a599" AIO_SubmitCount="0" AIO_CollectCount="0" AIO_SubmitLagMS="0" AIO_DiskStallMS="0" N2_CantSleep="0" N2_WontSleep="0" N2_Yields="1" N2_YieldCalls="0" N2_YieldCallsTrue="0" N2_SlowTaskSignals="0" N2_YieldBigStack="0" N2_RunLoopIterations="371" N2_TimersExecuted="230" N2_TasksExecuted="374" N2_ASIOEventsProcessed="451" N2_ReadCalls="79" N2_WriteCalls="79" N2_ReadProbes="79" N2_WriteProbes="0" N2_PacketsRead="79" N2_PacketsGenerated="79" N2_WouldBlock="0" CurrentConnections="3" ConnectionsEstablished="0" ConnectionsClosed="0" ConnectionErrors="0" N2_SlowTask4M="1" logGroup="default" TrackLatestType="Original"/>
<Event Severity="10" Time="1525730352.912375" Type="MachineMetrics" Machine="172.17.0.3:4500" ID="0000000000000000" Elapsed="5.00009" MbpsSent="0.333144" MbpsReceived="0.449857" OutSegs="4496" RetransSegs="0" CPUSeconds="0.266583" TotalMemory="16754233344" CommittedMemory="789934080" AvailableMemory="15964299264" ZoneID="ba5a49ef4a9c47ca9828c62d8ed6a599" MachineID="ba5a49ef4a9c47ca9828c62d8ed6a599" logGroup="default" TrackLatestType="Original"/>
<Event Severity="30" Time="1525730357.912458" Type="DeviceNotFound" Machine="172.17.0.3:4500" ID="0000000000000000" Directory="/var/lib/foundationdb/data/4500" logGroup="default"/>
<Event Severity="10" Time="1525730357.912458" Type="MachineLoadDetail" Machine="172.17.0.3:4500" ID="0000000000000000" User="1147935" Nice="14148" System="1397612" Idle="157753877" IOWait="809099" IRQ="170128" SoftIRQ="436528" Steal="0" Guest="0" logGroup="default"/>
<Event Severity="10" Time="1525730357.912458" Type="ProcessMetrics" Machine="172.17.0.3:4500" ID="0000000000000000" Elapsed="5.00008" CPUSeconds="0.025245" MainThreadCPUSeconds="0.024329" UptimeSeconds="520.088" Memory="327540736" ResidentMemory="18329600" MbpsSent="0.00639189" MbpsReceived="0.00543191" DiskTotalBytes="244529823744" DiskFreeBytes="165779226624" DiskQueueDepth="0" DiskIdleSeconds="5.00008" DiskReads="0" DiskWrites="0" DiskReadsCount="0" DiskWritesCount="0" DiskWriteSectors="0" DiskReadSectors="0" FileWrites="0" FileReads="0" CacheReadBytes="0" CacheFinds="0" CacheWritesBlocked="0" CacheReadsBlocked="0" CachePageReadsMerged="0" CacheWrites="0" CacheReads="0" ZoneID="ba5a49ef4a9c47ca9828c62d8ed6a599" MachineID="ba5a49ef4a9c47ca9828c62d8ed6a599" AIO_SubmitCount="0" AIO_CollectCount="0" AIO_SubmitLagMS="0" AIO_DiskStallMS="0" N2_CantSleep="0" N2_WontSleep="0" N2_Yields="1" N2_YieldCalls="0" N2_YieldCallsTrue="0" N2_SlowTaskSignals="0" N2_YieldBigStack="0" N2_RunLoopIterations="376" N2_TimersExecuted="231" N2_TasksExecuted="376" N2_ASIOEventsProcessed="457" N2_ReadCalls="80" N2_WriteCalls="80" N2_ReadProbes="80" N2_WriteProbes="0" N2_PacketsRead="80" N2_PacketsGenerated="80" N2_WouldBlock="0" CurrentConnections="3" ConnectionsEstablished="0" ConnectionsClosed="0" ConnectionErrors="0" N2_SlowTask4M="1" logGroup="default" TrackLatestType="Original"/>
<Event Severity="10" Time="1525730357.912458" Type="MachineMetrics" Machine="172.17.0.3:4500" ID="0000000000000000" Elapsed="5.00008" MbpsSent="0.324126" MbpsReceived="0.442807" OutSegs="4430" RetransSegs="0" CPUSeconds="0.281835" TotalMemory="16754233344" CommittedMemory="789934080" AvailableMemory="15964299264" ZoneID="ba5a49ef4a9c47ca9828c62d8ed6a599" MachineID="ba5a49ef4a9c47ca9828c62d8ed6a599" logGroup="default" TrackLatestType="Original"/>
<Event Severity="10" Time="1525730358.138271" Type="SomewhatSlowRunLoopTop" Machine="172.17.0.3:4500" ID="0000000000000000" Elapsed="0.0559413" logGroup="default"/>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment