Integration

MySQL and MariaDB

Row operations, threads, buffer pool, locks, temporary tables and the error log.

Category: Databases
How data is sent: Logthread Agent
Runs on: Linux
Status: Beta

How it works#

Answer a few questions. They only fill in the setup steps. Nothing on this page connects to your servers: Logthread never reaches into your network.
Run one command on the MySQL and MariaDB machine. The next page shows the command with this connector's ingest key filled in. It downloads the Logthread Agent from downloads.logthread.com and installs it as a service (Linux, as root with sudo). No other download. If the agent cannot run on that machine, run it on one that can reach MySQL and MariaDB over your private network and set the server below.
Data arrives. Everything is collected inside your environment. It is sent over outbound HTTPS (port 443) to ingest.logthread.com. Nothing is opened to the internet: no inbound ports, VPN or public access to your servers. The connection page shows what has arrived and turns Active with the first record.

What you answer#

Question	Answer	Notes
Server (optional)	Text	host:port the agent reads from, on your network. Leave empty when it runs on the same machine.
Log file (optional)	Text	Default: /var/log/mysql/error.log.
Labels (optional)	Text	For Fleet and filtering, for example env=prod.
Manage this agent from Fleet	Yes or no	Change its configuration from Logthread later without logging in to the host. Default: `Yes`.

Setup#

These are the steps for the default answers. In the app, they follow your answers, and the connector's ingest key replaces YOUR_INGEST_KEY.

Step 1. Create a monitoring user. Status counters and performance_schema only: no access to your tables. Put a strong password in the first line.

In the mysql client, as an admin:

CREATE USER 'logthread_agent'@'localhost' IDENTIFIED BY '<a strong password>';
GRANT PROCESS, REPLICATION CLIENT, SELECT ON performance_schema.* TO 'logthread_agent'@'localhost';
-- PROCESS and REPLICATION CLIENT are global privileges:
GRANT PROCESS, REPLICATION CLIENT ON *.* TO 'logthread_agent'@'localhost';

Step 2. Install the Logthread Agent. On the database host: it installs the agent with the MySQL and Linux host profiles. It asks for the password (hidden, not kept in your shell history) and writes it to a file only root can read.

curl -sSL https://downloads.logthread.com/agent/install.sh | sudo sh -s -- \
  --key YOUR_INGEST_KEY --profiles linux-host,mysql --fleet
printf 'Password of logthread_agent: '; stty -echo; read -r LT_PASSWORD; stty echo; echo
sudo tee -a /etc/logthread-agent/agent.env >/dev/null <<EOF
LOGTHREAD_MYSQL_ENDPOINT=localhost:3306
LOGTHREAD_MYSQL_USER=logthread_agent
LOGTHREAD_MYSQL_PASSWORD=$LT_PASSWORD
EOF
unset LT_PASSWORD
sudo systemctl restart logthread-agent

Step 3. Wait for data. Metrics arrive within a minute; the error log as MySQL writes to it. MariaDB works the same way.

Check that it works#

The connection page under Integrations counts what has arrived and turns Active with the first record. In Explore, search service:mysql.

Then add#

Each is one click on the connection page and opens with your data, so you can check it before saving.

Dashboard: MySQL: Row operations, threads, buffer pool, locks and waits, and error log lines.
Parser: mysql-error (Pipelines → Library)
Alert: MySQL errors: service:mysql severity:(error|fatal), at least 5 in 10 minutes

Set it up under Integrations in the app, or from an AI agent with MCP (add_integration). All integrations: Integrations guide. Next: find what it sends in Explore and live tail.