Displaying 2 results from an estimated 2 matches for "innodb_status".
2014 Nov 02
2
Re: KVM incremental backup using CBT
...sh.fifo
+ flush_and_wait
+ printf 'FLUSH TABLES WITH READ LOCK \G\n'
+ mysql -uroot -ppassword
+ read
++ echo 'SHOW STATUS LIKE "Key_blocks_not_flushed"'
++ mysql -uroot -ppassword
++ tail -1
++ cut -f 2
+ '[' 0 -gt 0 ']'
++ mktemp /tmp/mysql-flush.XXXXXX
+ INNODB_STATUS=/tmp/mysql-flush.eTdvA4
+ '[' 0 -ne 0 ']'
+ trap 'rm -f /tmp/mysql-flush.eTdvA4' SIGINT
+ :
+ printf 'SHOW ENGINE INNODB STATUS \G'
+ mysql -uroot -ppassword
++ grep 'Log sequence number' /tmp/mysql-flush.eTdvA4 tr -s ' '
++ cut '-d ' -f4
+ LO...
2014 Oct 29
2
Re: KVM incremental backup using CBT
On 10/29/2014 01:07 PM, Thomas Stein wrote:
> About the --quiesce option. Do i need to do something inside the vm? The most
> commonly would probably be a sql server running inside the vm. Do i need to
> tell the sql server something about the --quiesce option i use? I read this
> article here which suggests such a procedure. Okay, it's vmware, but... Is
> that right?
For