# Fastcom-mysql

Fastcom-mysql is a Docker container that periodically runs the Fast.com command-line interface (CLI) to measure your internet connection's download and upload speeds, writing each result into a MySQL database table. It is open source and self-hosted, installable on Docker Hub and Unraid.

Canonical page: https://ourlocalhost.com/app/1956/fastcom-mysql

## Description

Fastcom-mysql is a Docker container that periodically runs the Fast.com command-line interface (CLI) to measure your internet connection's download and upload speeds, writing each result into a MySQL database table. It is designed for homelab and self-hosting users who want automated, recurring internet speed-test logging so they can chart and monitor connection performance over time. Every measurement is stored with a timestamp, a configurable probe label, and the download and upload values.

## Platform availability

Available on 1 of 10 platforms: Unraid.

## Health score

14/100 (Low), based on 4 of 4 factors.
- Maintained: 0 (last commit 1821 days ago)
- Popular: 0 (0 GitHub stars)
- Easy to install: 35 (1 install platform, install notes, Docker image)
- Light to run: 50 (2 GB minimum RAM)

## Links

- Docker Hub: https://hub.docker.com/r/simonjenny/fastcom-mysql/
- Unraid: https://ca.unraid.net/apps/fastcom-mysql-1xg8knt1c8qgk5?q=fastcom-mysql

## Common questions

### How do I set the interval between speed tests?

Set the SLEEP environment variable to the number of seconds between measures.

### How do I configure the MySQL connection?

Provide MYSQL_SERVER, MYSQL_USER, MYSQL_PASS, MYSQL_DATABASE, and MYSQL_TABLE as Docker environment variables.

### What MySQL table structure is required?

The table needs timestamp, loc varchar(50), download float, and upload float columns, with InnoDB, utf8mb4, and utf8mb4_bin collation.

### Where are the speed test results stored?

They are stored in a MySQL database as download and upload speeds with location metadata.

---
Source: Our Local Host (https://ourlocalhost.com/app/1956/fastcom-mysql), the self-hosted and open-source app directory.
