mysqldumpslow

  1. M

    Save BackUp File in specific location

    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'...
  2. Rob

    Using mysqldumpslow to read the mysql slow query log

    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...
Top