Skip to content

Latest commit

 

History

History
85 lines (63 loc) · 3.03 KB

README.md

File metadata and controls

85 lines (63 loc) · 3.03 KB
Raw

go-check

go-check is a lightweight CLI tool built in Go to test and benchmark concurrent MySQL connections. It allows you to specify the number of threads (goroutines) that connect to a MySQL server and hold the connections open for a specified duration, simulating concurrent load on the database. This is useful for testing the performance, stability, and connection handling capacity of MySQL instances.

Features

  • Connects to a MySQL server using multiple concurrent connections (threads).
  • Allows you to configure the number of threads and the duration for which connections should be kept alive.
  • Supports reading MySQL credentials from the ~/.my.cnf file, simplifying authentication.
  • Logs connection lifecycle, indicating when connections are established and closed.

Use Cases

  • Stress Testing: Evaluate the MySQL server's ability to handle concurrent connections under different loads.
  • Performance Benchmarking: Identify connection bottlenecks and timeouts when multiple clients are connected.
  • Testing Connection Limits: Experiment with thread counts to discover the maximum number of connections your MySQL instance can handle reliably.

Installation

First, clone the repository and navigate to the project directory:

git clone https://github.com/ChaosHour/go-check.git
cd go-check

Credentials from ~/.my.cnf

Using Credentials from ~/.my.cnf If you have your MySQL credentials stored in a ~/.my.cnf file, go-check can automatically read them. Your ~/.my.cnf file should look something like this:

[client]
user = your_mysql_user
password = your_mysql_password
host = 127.0.0.1

Running the Tool

./go-check -host=192.x.x.x -database=sbtest -threads=10 -duration=60

Goroutine 2: Connected to MySQL. Keeping connection alive for 60 seconds...
Goroutine 8: Connected to MySQL. Keeping connection alive for 60 seconds...
Goroutine 6: Connected to MySQL. Keeping connection alive for 60 seconds...
Goroutine 9: Connected to MySQL. Keeping connection alive for 60 seconds...
Goroutine 0: Connected to MySQL. Keeping connection alive for 60 seconds...
Goroutine 4: Connected to MySQL. Keeping connection alive for 60 seconds...
Goroutine 3: Connected to MySQL. Keeping connection alive for 60 seconds...
Goroutine 1: Connected to MySQL. Keeping connection alive for 60 seconds...
Goroutine 5: Connected to MySQL. Keeping connection alive for 60 seconds...
Goroutine 7: Connected to MySQL. Keeping connection alive for 60 seconds...
Goroutine 2: Closing connection.
Goroutine 9: Closing connection.
Goroutine 8: Closing connection.
Goroutine 6: Closing connection.
Goroutine 0: Closing connection.
Goroutine 3: Closing connection.
Goroutine 4: Closing connection.
Goroutine 1: Closing connection.
Goroutine 5: Closing connection.
Goroutine 7: Closing connection.
All 10 connections closed.

To Build

To build:

go build -o go-check

or one of the following:

FreeBSD:
env GOOS=freebsd GOARCH=amd64 go build .

On Mac:
env GOOS=darwin GOARCH=amd64 go build .

Linux:
env GOOS=linux GOARCH=amd64 go build .