SQLmeter

S

SQLmeter: High-Performance SQL Query Measurement Tool

Description:
SQLmeter is a powerful utility designed to measure and analyze the performance of SQL queries within MySQL databases. With a focus on accuracy and detailed reporting, SQLmeter captures essential statistics such as execution time, number of rows returned, and query hashes. This makes it an invaluable tool for database administrators, developers, and performance engineers who need to optimize query performance in real-time environments.

SQLmeter currently supports MySQL databases, with upcoming support for Oracle, SQL-Server, Postgres, Clickhouse, CockroachDB, and more.

Windows (ARM)sqlmeter_arm.exe.zip
Windows (x64)sqlmeter_x64.exe.zip
Windows (x86)sqlmeter_x86.exe.zip
Mac OS (ARM)sqlmeter_osx_arm.zip
Mac OS (x64)sqlmeter_osx_x64.zip
Linux/FreeBSD (ARM)sqlmeter_nix_arm.zip
Linux/FreeBSD (x64)sqlmeter_nix_x64.zip
Linux/FreeBSD (x86)sqlmeter_nix_x86.zip

How to Use SQLmeter:

  1. Download and Setup:
  • Ensure Go is installed on your system.
  • Download the SQLmeter source code and compile it using Go.
  • The utility will automatically look for a config.yaml file in its directory.
  1. Configuration:
  • Upon the first run, SQLmeter checks for the existence of a config.yaml file.
  • If the file is missing, SQLmeter will generate a default configuration file with settings for MySQL.
  • Customize config.yaml to match your MySQL database credentials and the SQL query you want to measure.
  1. Running SQLmeter:
  • Execute the compiled SQLmeter binary.
  • SQLmeter will print performance metrics, including execution time (in seconds), number of rows returned, query hash, and the transaction isolation level used.
  • Results will be saved in a CSV file named sqlmeter_<query_hash>_<date>.csv.
  1. Output:
  • The CSV file will contain detailed statistics about the query, including a header section that describes the server, database, query, and the start time of execution.
  1. Future Enhancements:
  • SQLmeter will soon support other popular databases like Oracle, SQL-Server, Postgres, Clickhouse, and CockroachDB, making it a versatile tool for database performance tuning across different platforms.

SQLmeter is your go-to tool for ensuring that your SQL queries perform at their best. Whether you’re diagnosing slow queries or fine-tuning your database, SQLmeter provides the insights you need to achieve optimal performance.