29 Kasım 2021 Pazartesi

SHOW SLAVE STATUS

Örnek
Şöyle yaparız
SHOW SLAVE STATUS\G;
Açıklaması şöyle 
If you issue this statement using the mysql client, you can use a \G statement terminator rather than a semicolon to obtain a more readable vertical layout
Örnek
Şöyle yaparız
# You can also watch the data changing. Try…
watch –interval=1 –differences 'mysql -uuser -ppassword -e "show slave status\G"'


Hiç yorum yok:

Yorum Gönder

CREATE EVENT - Scheduled Task İçindir

Örnek Şöyle yaparız CREATE EVENT myevent     ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR     DO       UPDATE myschema.mytable SET myc...