VPS Guide: Your Go-To for VPS, Ubuntu & Command Line Success

Check MySQL Slow Queries with tail on Ubuntu VPS

Category: Bash

Use tail—a log tool—in a Bash script on an Ubuntu VPS—script:

#!/bin/bash\ntail -n 100 /var/log/mysql/slow.log > slow_queries.log

On Hetzner run:

./slow.sh

—expect slow query logs Optimizes hosting database