Hi there
I am pretty new in the Linux world. I am just setting up a MySQL Database and now I want to create an automatic backup job for all the databases.
I'm using the following script to create the backup:
#!/bin/bash
DATE=$(date +%d%m%Y-%H)
mysqldump -u backupuser -p'12345'...
The MySQL slow query log is one helpful tool that helps system administrators to determine which queries are taking a longer-than-normal time to run. The only thing is.. how to read it so it's helpful?
If you don't have the slow query log enabled yet, do that first: mysql enable slow query...