{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "18170001", "metadata": {}, "outputs": [], "source": [ "import numpy as np\n", "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "\n", "from IPython.display import display, HTML\n", "\n", "base_folder = \"../\"" ] }, { "cell_type": "markdown", "id": "422f4d05", "metadata": {}, "source": [ "## Topologies" ] }, { "cell_type": "code", "execution_count": 2, "id": "a2d05361", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Topology name: multi\n" ] }, { "data": { "text/html": [ "
| \n", " | ClusterID | \n", "ClusterName | \n", "Cores | \n", "Speed | \n", "Memory | \n", "numberOfHosts | \n", "memoryCapacityPerHost | \n", "coreCountPerHost | \n", "
|---|---|---|---|---|---|---|---|---|
| 0 | \n", "A01 | \n", "A01 | \n", "32 | \n", "3.20 | \n", "2048 | \n", "1 | \n", "256 | \n", "32 | \n", "
| 1 | \n", "B01 | \n", "B01 | \n", "48 | \n", "2.93 | \n", "1256 | \n", "6 | \n", "64 | \n", "8 | \n", "
| 2 | \n", "C01 | \n", "C01 | \n", "32 | \n", "3.20 | \n", "2048 | \n", "2 | \n", "128 | \n", "16 | \n", "
| \n", " | ClusterID | \n", "ClusterName | \n", "Cores | \n", "Speed | \n", "Memory | \n", "numberOfHosts | \n", "memoryCapacityPerHost | \n", "coreCountPerHost | \n", "
|---|---|---|---|---|---|---|---|---|
| 0 | \n", "A01 | \n", "A01 | \n", "8 | \n", "1 | \n", "100 | \n", "1 | \n", "100 | \n", "8 | \n", "
| \n", " | id | \n", "timestamp | \n", "duration | \n", "cpu_count | \n", "cpu_usage | \n", "
|---|---|---|---|---|---|
| 0 | \n", "0 | \n", "2024-02-02 | \n", "86400000 | \n", "1 | \n", "1000.0 | \n", "
| 1 | \n", "1 | \n", "2024-02-02 | \n", "86400000 | \n", "1 | \n", "1000.0 | \n", "
| 2 | \n", "2 | \n", "2024-02-02 | \n", "86400000 | \n", "1 | \n", "1000.0 | \n", "
| 3 | \n", "3 | \n", "2024-02-02 | \n", "86400000 | \n", "1 | \n", "1000.0 | \n", "
| 4 | \n", "4 | \n", "2024-02-02 | \n", "86400000 | \n", "1 | \n", "1000.0 | \n", "
| \n", " | id | \n", "start_time | \n", "stop_time | \n", "cpu_count | \n", "cpu_capacity | \n", "mem_capacity | \n", "
|---|---|---|---|---|---|---|
| 0 | \n", "0 | \n", "2024-02-01 | \n", "2024-02-02 | \n", "1 | \n", "1000.0 | \n", "100000 | \n", "
| 1 | \n", "1 | \n", "2024-02-01 | \n", "2024-02-02 | \n", "1 | \n", "1000.0 | \n", "100000 | \n", "
| 2 | \n", "2 | \n", "2024-02-01 | \n", "2024-02-02 | \n", "1 | \n", "1000.0 | \n", "100000 | \n", "
| 3 | \n", "3 | \n", "2024-02-01 | \n", "2024-02-02 | \n", "1 | \n", "1000.0 | \n", "100000 | \n", "
| 4 | \n", "4 | \n", "2024-02-01 | \n", "2024-02-02 | \n", "1 | \n", "1000.0 | \n", "100000 | \n", "
| \n", " | timestamp | \n", "server_id | \n", "host_id | \n", "mem_capacity | \n", "cpu_count | \n", "cpu_limit | \n", "cpu_time_active | \n", "cpu_time_idle | \n", "cpu_time_steal | \n", "cpu_time_lost | \n", "uptime | \n", "downtime | \n", "provision_time | \n", "boot_time | \n", "absolute_timestamp | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1970-01-01 00:05:00+00:00 | \n", "b'\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x06\\xc4]\\x1... | \n", "b'\\xe2 \\xa89{\\x1d\\xcd\\xaf\\x00\\x00\\x00\\x00\\x00\\... | \n", "181 | \n", "1 | \n", "25600.0 | \n", "0 | \n", "2624 | \n", "0 | \n", "0 | \n", "300000 | \n", "0 | \n", "1970-01-01 00:00:00+00:00 | \n", "1970-01-01 00:00:00+00:00 | \n", "2013-08-12 13:35:46+00:00 | \n", "
| 1 | \n", "1970-01-01 00:05:00+00:00 | \n", "b'\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x1b9\\x89jQ\\... | \n", "b'\\xe2 \\xa89{\\x1d\\xcd\\xaf\\x00\\x00\\x00\\x00\\x00\\... | \n", "260 | \n", "1 | \n", "25600.0 | \n", "0 | \n", "2624 | \n", "0 | \n", "0 | \n", "300000 | \n", "0 | \n", "1970-01-01 00:00:00+00:00 | \n", "1970-01-01 00:00:00+00:00 | \n", "2013-08-12 13:35:46+00:00 | \n", "
| 2 | \n", "1970-01-01 00:05:00+00:00 | \n", "b'\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00,\\x82\\x9a\\xb... | \n", "b'\\xe2 \\xa89{\\x1d\\xcd\\xaf\\x00\\x00\\x00\\x00\\x00\\... | \n", "250 | \n", "1 | \n", "25600.0 | \n", "2 | \n", "2622 | \n", "0 | \n", "0 | \n", "300000 | \n", "0 | \n", "1970-01-01 00:00:00+00:00 | \n", "1970-01-01 00:00:00+00:00 | \n", "2013-08-12 13:35:46+00:00 | \n", "
| 3 | \n", "1970-01-01 00:05:00+00:00 | \n", "b'\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00>\\xe5x\\x90A\\... | \n", "b'\\xe2 \\xa89{\\x1d\\xcd\\xaf\\x00\\x00\\x00\\x00\\x00\\... | \n", "125 | \n", "1 | \n", "25600.0 | \n", "0 | \n", "2624 | \n", "0 | \n", "0 | \n", "300000 | \n", "0 | \n", "1970-01-01 00:00:00+00:00 | \n", "1970-01-01 00:00:00+00:00 | \n", "2013-08-12 13:35:46+00:00 | \n", "
| 4 | \n", "1970-01-01 00:05:00+00:00 | \n", "b'\\x00\\x00\\x00\\x00\\x00\\x00\\x00\\x00e~\\xec\\xdd<\\... | \n", "b'\\xe2 \\xa89{\\x1d\\xcd\\xaf\\x00\\x00\\x00\\x00\\x00\\... | \n", "157 | \n", "1 | \n", "25600.0 | \n", "2 | \n", "2951 | \n", "0 | \n", "0 | \n", "300000 | \n", "0 | \n", "1970-01-01 00:00:00+00:00 | \n", "1970-01-01 00:00:00+00:00 | \n", "2013-08-12 13:35:46+00:00 | \n", "
| \n", " | timestamp | \n", "hosts_up | \n", "hosts_down | \n", "servers_pending | \n", "servers_active | \n", "attempts_success | \n", "attempts_failure | \n", "attempts_error | \n", "
|---|---|---|---|---|---|---|---|---|
| 0 | \n", "300000 | \n", "2 | \n", "0 | \n", "0 | \n", "10 | \n", "10 | \n", "0 | \n", "0 | \n", "
| 1 | \n", "600000 | \n", "2 | \n", "0 | \n", "0 | \n", "10 | \n", "10 | \n", "0 | \n", "0 | \n", "
| 2 | \n", "900000 | \n", "2 | \n", "0 | \n", "0 | \n", "10 | \n", "10 | \n", "0 | \n", "0 | \n", "
| 3 | \n", "1200000 | \n", "2 | \n", "0 | \n", "0 | \n", "10 | \n", "10 | \n", "0 | \n", "0 | \n", "
| 4 | \n", "1500000 | \n", "2 | \n", "0 | \n", "0 | \n", "10 | \n", "10 | \n", "0 | \n", "0 | \n", "
| \n", " | timestamp | \n", "host_id | \n", "cpu_count | \n", "mem_capacity | \n", "guests_terminated | \n", "guests_running | \n", "guests_error | \n", "guests_invalid | \n", "cpu_limit | \n", "cpu_usage | \n", "... | \n", "cpu_utilization | \n", "cpu_time_active | \n", "cpu_time_idle | \n", "cpu_time_steal | \n", "cpu_time_lost | \n", "power_draw | \n", "energy_usage | \n", "uptime | \n", "downtime | \n", "boot_time | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "300000 | \n", "e220a839-7b1d-cdaf-0000-000000000000 | \n", "6 | \n", "100000 | \n", "0 | \n", "5 | \n", "0 | \n", "0 | \n", "8000.0 | \n", "5000.0 | \n", "... | \n", "0.625 | \n", "1125002 | \n", "674998 | \n", "18 | \n", "0 | \n", "325.0 | \n", "97500.075 | \n", "300000 | \n", "0 | \n", "0 | \n", "
| 1 | \n", "300000 | \n", "6e789e6a-a1b9-65f4-0000-000000000001 | \n", "4 | \n", "100000 | \n", "0 | \n", "5 | \n", "0 | \n", "0 | \n", "4000.0 | \n", "4000.0 | \n", "... | \n", "1.000 | \n", "1200000 | \n", "0 | \n", "300011 | \n", "0 | \n", "400.0 | \n", "120000.000 | \n", "300000 | \n", "0 | \n", "0 | \n", "
| 2 | \n", "600000 | \n", "e220a839-7b1d-cdaf-0000-000000000000 | \n", "6 | \n", "100000 | \n", "0 | \n", "5 | \n", "0 | \n", "0 | \n", "8000.0 | \n", "5000.0 | \n", "... | \n", "0.625 | \n", "1125000 | \n", "675000 | \n", "0 | \n", "0 | \n", "325.0 | \n", "97500.000 | \n", "300000 | \n", "0 | \n", "0 | \n", "
| 3 | \n", "600000 | \n", "6e789e6a-a1b9-65f4-0000-000000000001 | \n", "4 | \n", "100000 | \n", "0 | \n", "5 | \n", "0 | \n", "0 | \n", "4000.0 | \n", "4000.0 | \n", "... | \n", "1.000 | \n", "1200000 | \n", "0 | \n", "300000 | \n", "0 | \n", "400.0 | \n", "120000.000 | \n", "300000 | \n", "0 | \n", "0 | \n", "
| 4 | \n", "900000 | \n", "e220a839-7b1d-cdaf-0000-000000000000 | \n", "6 | \n", "100000 | \n", "0 | \n", "5 | \n", "0 | \n", "0 | \n", "8000.0 | \n", "5000.0 | \n", "... | \n", "0.625 | \n", "1125000 | \n", "675000 | \n", "0 | \n", "0 | \n", "325.0 | \n", "97500.000 | \n", "300000 | \n", "0 | \n", "0 | \n", "
5 rows × 21 columns
\n", "