-1

I'm trying mysqldump right now with the following script, but I need to verify that there are no locks in the process. What could I add to the code to confirm whether or not there are locks?

Script input_mysql_bash_usuario.sh:

#!/bin/bash
i=1
# serão inseridos um milhão de dados
while [ $i -le 1000000 ]
do
    mysql -uroot -pzabbix -e \
    “INSERT INTO usuario(nome,telefone,email,aniversario) VALUES(‘cesar,’9999999’,’cesarsj@unipam.edu.br’,’1993-11-18’) mysql_bash
    i=$(( i +1 ))
done

shell> nohup ./input_mysql_bash_usuario.sh > ./saida.log &

mysqldump --u<user> -p<password> <database> --single-transaction | gzip -c  | cat > $(date +%Y-%m-%d-%H.%M.%S).sql.gz

I've tried before Percona XtraBackups 2.1.5, the package available in SlackBuils, but there were a lot of errors, I also saw that there is the Maria Backup, but it does not have on the MariaDb 10.0.37, which is from Slackware.

CESAR MURILO DA SILVA JUNIOR
  • 15
  • 1
  • 9

1 Answers1

0
BEGIN;
SELECT * FROM mysql_bash.usuario LIMIT 1 FOR UPDATE;
SELECT SLEEP(3600);  -- one hour; adjust as needed
COMMIT;

That might do the opposite of what you want -- namely verify that the dump can run even though you have a lock.

Rick James
  • 135,179
  • 13
  • 127
  • 222